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;