Код:
MySQL [bgcrm]> show create table callboard_shift_user;
+----------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+----------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| callboard_shift_user | CREATE TABLE `callboard_shift_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`graph` int(11) NOT NULL,
`user` int(11) NOT NULL,
`group` int(11) NOT NULL,
`team` int(11) NOT NULL,
`date` date NOT NULL,
`shift` int(11) NOT NULL,
`work_type` int(11) NOT NULL,
`time_from` int(11) NOT NULL,
`time_to` int(11) NOT NULL,
`is_dynamic` bit(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `date` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+----------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+