Files
BeWoPlaner/Model/Changes_2019_06_07 Budget Tabelle erstellt.txt
2019-07-10 10:11:10 +02:00

16 lines
490 B
Plaintext

CREATE TABLE `budget` (
`Oid` bigint(19) PRIMARY KEY AUTO_INCREMENT,
`Tid` int(10) DEFAULT NULL,
`IsActive` tinyint(4) DEFAULT NULL,
`Notice` varchar(1024) DEFAULT NULL,
`InsTs` datetime DEFAULT NULL,
`InsUser` varchar(256) DEFAULT NULL,
`Version` bigint(19) DEFAULT NULL,
`UdpUser` varchar(256) DEFAULT NULL,
`SystemEntryID` int(10) DEFAULT NULL,
`Name` varchar(512) DEFAULT NULL,
`Betragshoehe` decimal(18,10) DEFAULT NULL
)ENGINE=InnoDB DEFAULT CHARSET=latin1;