https://gsbelarus.com:80/gs/wiki/index.php?action=history&feed=atom&title=WG_TBLCALDAY
WG TBLCALDAY - История изменений
2026-07-16T23:43:52Z
История изменений этой страницы в вики
MediaWiki 1.19.16
https://gsbelarus.com:80/gs/wiki/index.php?title=WG_TBLCALDAY&diff=5673&oldid=prev
SYSDBA: Новая страница: «<syntaxhighlight lang="SQL"> RECREATE TABLE wg_tblcalday ( id dintkey, tblcalkey dintkey, theday ddate_notnull, workday dboolean_notnull DEFA…»
2013-06-08T13:45:07Z
<p>Новая страница: «<syntaxhighlight lang="SQL"> RECREATE TABLE wg_tblcalday ( id dintkey, tblcalkey dintkey, theday ddate_notnull, workday dboolean_notnull DEFA…»</p>
<p><b>Новая страница</b></p><div><syntaxhighlight lang="SQL"><br />
RECREATE TABLE wg_tblcalday<br />
(<br />
id dintkey,<br />
tblcalkey dintkey,<br />
theday ddate_notnull,<br />
workday dboolean_notnull DEFAULT 1,<br />
wstart1 dtimestamp_notnull DEFAULT '1900-01-01 00:00:00',<br />
wend1 dtimestamp_notnull DEFAULT '1900-01-01 00:00:00',<br />
wstart2 dtimestamp_notnull DEFAULT '1900-01-01 00:00:00',<br />
wend2 dtimestamp_notnull DEFAULT '1900-01-01 00:00:00',<br />
wstart3 dtimestamp_notnull DEFAULT '1900-01-01 00:00:00',<br />
wend3 dtimestamp_notnull DEFAULT '1900-01-01 00:00:00',<br />
wstart4 dtimestamp_notnull DEFAULT '1900-01-01 00:00:00',<br />
wend4 dtimestamp_notnull DEFAULT '1900-01-01 00:00:00',<br />
<br />
editiondate deditiondate,<br />
<br />
WDURATION COMPUTED BY (G_M_ROUNDNN(((wend1 - wstart1) + (wend2 - wstart2) + (wend3 - wstart3) + (wend4 - wstart4))*24, 0.01)),<br />
<br />
dow COMPUTED BY (EXTRACT(weekday FROM theday)),<br />
<br />
CONSTRAINT wg_pk_tblcalday PRIMARY KEY (id),<br />
CONSTRAINT wg_fk_tblcalday_tblcal FOREIGN KEY (tblcalkey) REFERENCES wg_tblcal (id)<br />
ON UPDATE CASCADE<br />
ON DELETE CASCADE,<br />
CONSTRAINT wg_unq_tblcalday_1 UNIQUE (tblcalkey, theday),<br />
CONSTRAINT wg_chk_tblcalday_1 CHECK (wend1 >= wstart1),<br />
CONSTRAINT wg_chk_tblcalday_2 CHECK (wend2 >= wstart2),<br />
CONSTRAINT wg_chk_tblcalday_3 CHECK (wend3 >= wstart3),<br />
CONSTRAINT wg_chk_tblcalday_4 CHECK (wend4 >= wstart4),<br />
CONSTRAINT wg_chk_tblcalday_5 CHECK ((wstart2 = '1900-01-01 00:00:00') OR (wstart2 >= wend1)),<br />
CONSTRAINT wg_chk_tblcalday_6 CHECK ((wstart3 = '1900-01-01 00:00:00') OR (wstart3 >= wend2)),<br />
CONSTRAINT wg_chk_tblcalday_7 CHECK ((wstart4 = '1900-01-01 00:00:00') OR (wstart4 >= wend3))<br />
);<br />
</syntaxhighlight><br />
<br />
[[Category:База данных]]</div>
SYSDBA