TNTVNWy2

1CREATE TABLE IF NOT EXISTS `codelist_items_manage` (
2  `id` int(30) NOT NULL AUTO_INCREMENT,
3  `priority` int(5) DEFAULT NULL,
4  `status` int(11) DEFAULT NULL COMMENT 'codelist_id:38',
5  `name` varchar(255) DEFAULT NULL,
6  `active` tinyint(1) DEFAULT NULL,
7  `user_id` int(11) DEFAULT NULL,
8  `create_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
9  `modify_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
10  `create_by_user_id` int(11) DEFAULT NULL COMMENT 'This is User ID',
11  `create_by_role_id` int(11) DEFAULT NULL,
12  `modify_by_user_id` int(11) DEFAULT NULL COMMENT 'This is User ID',
13  `modify_by_role_id` int(11) DEFAULT NULL,
14  `controller` varchar(50) DEFAULT 'NULL',
15  `records_types_manage_id` int(11) DEFAULT NULL,
16  `active_till` date DEFAULT NULL,
17  `completed` tinyint(1) DEFAULT '0',
18  `hours` int(10) DEFAULT NULL,
19  PRIMARY KEY (`id`)
20) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;