Michal Buzik
a00994cd5c
Introduced a new SQL test resource under `tbfDBBackup.Tests` to support database testing scenarios involving procedures and history operations.
30 lines
2.4 KiB
SQL
30 lines
2.4 KiB
SQL
CREATE TABLE `procedure` (
|
|
`Id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`ItemNr` int(11) DEFAULT NULL,
|
|
`Name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`Description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`CreationUser` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`CreationTime` datetime DEFAULT NULL,
|
|
`LastChgUser` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`LastChgTime` datetime DEFAULT NULL,
|
|
`LongDescription` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`ProcedureState` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`Revision` int(11) DEFAULT NULL,
|
|
`PredecessorId` int(11) DEFAULT NULL,
|
|
`ObtainedByCopy` tinyint(1) DEFAULT NULL,
|
|
`MetersKind` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`Watermeters` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`ProtocolTitle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`Protected` tinyint(1) NOT NULL DEFAULT '0',
|
|
`MustBeComplete` tinyint(1) NOT NULL DEFAULT '0',
|
|
`ManualCtrlDisabled` tinyint(1) NOT NULL DEFAULT '0',
|
|
`DataEntry` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`ResultsPrinter` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`ResultsWriter` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`EventTriggers` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`TransitionStart` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`TransitionEnd` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`AltProcName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`AltProcPeriod` int(11) NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`Id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=4549 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |