https://gsbelarus.com/gs/wiki/index.php?action=history&feed=atom&title=WG_TBLCAL 2026-05-30T02:55:15Z История изменений этой страницы в вики MediaWiki 1.19.16 https://gsbelarus.com/gs/wiki/index.php?title=WG_TBLCAL&diff=5672&oldid=prev 2013-06-08T13:43:34Z

<p>Новая страница: «&lt;syntaxhighlight lang=&quot;SQL&quot;&gt; RECREATE TABLE wg_tblcal ( id dintkey, name dname, - ‎<span dir="auto"><span class="autocomment">працоўныя дні тыдня: </span> mon dboolean…»</span></p> <p><b>Новая страница</b></p><div>&lt;syntaxhighlight lang=&quot;SQL&quot;&gt;<br /> RECREATE TABLE wg_tblcal<br /> (<br /> id dintkey,<br /> name dname,<br /> <br /> /* працоўныя дні тыдня */<br /> mon dboolean_notnull DEFAULT 1,<br /> tue dboolean_notnull DEFAULT 1,<br /> wed dboolean_notnull DEFAULT 1,<br /> thu dboolean_notnull DEFAULT 1,<br /> fri dboolean_notnull DEFAULT 1,<br /> sat dboolean_notnull DEFAULT 0,<br /> sun dboolean_notnull DEFAULT 0,<br /> <br /> /*Праздничные дни по умолчанию нерабочие*/<br /> holidayiswork dboolean_notnull DEFAULT 0,<br /> <br /> /* інтэрвалы працоўнага часу */<br /> w1_offset dinteger DEFAULT 0,<br /> w1_start1 dtime_notnull DEFAULT '00:00:00',<br /> w1_end1 dtime_notnull DEFAULT '00:00:00',<br /> w1_start2 dtime_notnull DEFAULT '00:00:00',<br /> w1_end2 dtime_notnull DEFAULT '00:00:00',<br /> w1_start3 dtime_notnull DEFAULT '00:00:00',<br /> w1_end3 dtime_notnull DEFAULT '00:00:00',<br /> w1_start4 dtime_notnull DEFAULT '00:00:00',<br /> w1_end4 dtime_notnull DEFAULT '00:00:00',<br /> <br /> w2_offset dinteger DEFAULT 0,<br /> w2_start1 dtime_notnull DEFAULT '00:00:00',<br /> w2_end1 dtime_notnull DEFAULT '00:00:00',<br /> w2_start2 dtime_notnull DEFAULT '00:00:00',<br /> w2_end2 dtime_notnull DEFAULT '00:00:00',<br /> w2_start3 dtime_notnull DEFAULT '00:00:00',<br /> w2_end3 dtime_notnull DEFAULT '00:00:00',<br /> w2_start4 dtime_notnull DEFAULT '00:00:00',<br /> w2_end4 dtime_notnull DEFAULT '00:00:00',<br /> <br /> w3_offset dinteger DEFAULT 0,<br /> w3_start1 dtime_notnull DEFAULT '00:00:00',<br /> w3_end1 dtime_notnull DEFAULT '00:00:00',<br /> w3_start2 dtime_notnull DEFAULT '00:00:00',<br /> w3_end2 dtime_notnull DEFAULT '00:00:00',<br /> w3_start3 dtime_notnull DEFAULT '00:00:00',<br /> w3_end3 dtime_notnull DEFAULT '00:00:00',<br /> w3_start4 dtime_notnull DEFAULT '00:00:00',<br /> w3_end4 dtime_notnull DEFAULT '00:00:00',<br /> <br /> w4_offset dinteger DEFAULT 0,<br /> w4_start1 dtime_notnull DEFAULT '00:00:00',<br /> w4_end1 dtime_notnull DEFAULT '00:00:00',<br /> w4_start2 dtime_notnull DEFAULT '00:00:00',<br /> w4_end2 dtime_notnull DEFAULT '00:00:00',<br /> w4_start3 dtime_notnull DEFAULT '00:00:00',<br /> w4_end3 dtime_notnull DEFAULT '00:00:00',<br /> w4_start4 dtime_notnull DEFAULT '00:00:00',<br /> w4_end4 dtime_notnull DEFAULT '00:00:00',<br /> <br /> w5_offset dinteger DEFAULT 0,<br /> w5_start1 dtime_notnull DEFAULT '00:00:00',<br /> w5_end1 dtime_notnull DEFAULT '00:00:00',<br /> w5_start2 dtime_notnull DEFAULT '00:00:00',<br /> w5_end2 dtime_notnull DEFAULT '00:00:00',<br /> w5_start3 dtime_notnull DEFAULT '00:00:00',<br /> w5_end3 dtime_notnull DEFAULT '00:00:00',<br /> w5_start4 dtime_notnull DEFAULT '00:00:00',<br /> w5_end4 dtime_notnull DEFAULT '00:00:00',<br /> <br /> w6_offset dinteger DEFAULT 0,<br /> w6_start1 dtime_notnull DEFAULT '00:00:00',<br /> w6_end1 dtime_notnull DEFAULT '00:00:00',<br /> w6_start2 dtime_notnull DEFAULT '00:00:00',<br /> w6_end2 dtime_notnull DEFAULT '00:00:00',<br /> w6_start3 dtime_notnull DEFAULT '00:00:00',<br /> w6_end3 dtime_notnull DEFAULT '00:00:00',<br /> w6_start4 dtime_notnull DEFAULT '00:00:00',<br /> w6_end4 dtime_notnull DEFAULT '00:00:00',<br /> <br /> w7_offset dinteger DEFAULT 0,<br /> w7_start1 dtime_notnull DEFAULT '00:00:00',<br /> w7_end1 dtime_notnull DEFAULT '00:00:00',<br /> w7_start2 dtime_notnull DEFAULT '00:00:00',<br /> w7_end2 dtime_notnull DEFAULT '00:00:00',<br /> w7_start3 dtime_notnull DEFAULT '00:00:00',<br /> w7_end3 dtime_notnull DEFAULT '00:00:00',<br /> w7_start4 dtime_notnull DEFAULT '00:00:00',<br /> w7_end4 dtime_notnull DEFAULT '00:00:00',<br /> <br /> /* перад святочны дзень */<br /> w8_offset dinteger DEFAULT 0,<br /> w8_start1 dtime_notnull DEFAULT '00:00:00',<br /> w8_end1 dtime_notnull DEFAULT '00:00:00',<br /> w8_start2 dtime_notnull DEFAULT '00:00:00',<br /> w8_end2 dtime_notnull DEFAULT '00:00:00',<br /> w8_start3 dtime_notnull DEFAULT '00:00:00',<br /> w8_end3 dtime_notnull DEFAULT '00:00:00',<br /> w8_start4 dtime_notnull DEFAULT '00:00:00',<br /> w8_end4 dtime_notnull DEFAULT '00:00:00',<br /> <br /> editiondate deditiondate<br /> <br /> CONSTRAINT wg_pk_tblcal PRIMARY KEY (id)<br /> );<br /> &lt;/syntaxhighlight&gt;<br /> <br /> [[Category:База данных]]</div>

SYSDBA