21 lines
732 B
Plaintext
21 lines
732 B
Plaintext
CREATE TABLE IF NOT EXISTS `regelmaessigerdienst` (
|
|
`Oid` bigint NOT NULL AUTO_INCREMENT,
|
|
`Tid` int DEFAULT NULL,
|
|
`IsActive` tinyint DEFAULT NULL,
|
|
`Notice` varchar(1024) DEFAULT NULL,
|
|
`InsTs` datetime DEFAULT NULL,
|
|
`InsUser` varchar(256) DEFAULT NULL,
|
|
`Version` bigint DEFAULT NULL,
|
|
`UdpUser` varchar(256) DEFAULT NULL,
|
|
`SystemEntryID` int DEFAULT NULL,
|
|
`EmployeeOid` bigint DEFAULT NULL,
|
|
`WohnheimOid` bigint DEFAULT NULL,
|
|
`DienstOid` bigint DEFAULT NULL,
|
|
`Zeile` int DEFAULT NULL,
|
|
`Wochentag` varchar(256) DEFAULT NULL,
|
|
`Startzeit` varchar(256) DEFAULT NULL,
|
|
`Endzeit` varchar(256) DEFAULT NULL,
|
|
`DauerInStunden` double DEFAULT NULL,
|
|
PRIMARY KEY (`Oid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|