0WkHkRaS

1PHP model (MySQL) design problem
2CREATE TABLE IF NOT EXISTS `Shift` (
3`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
4`accountId` smallint(6) unsigned NOT NULL,
5`grpId` smallint(6) unsigned NOT NULL,
6`locationId` smallint(6) unsigned NOT NULL,
7`unitId` smallint(6) unsigned NOT NULL,
8`shiftTypeId` smallint(6) unsigned NOT NULL,
9`startDate` date NOT NULL,
10`endDate` date NOT NULL,
11`needFlt` bit(1) NOT NULL DEFAULT b'1',
12`needBillet` bit(1) NOT NULL DEFAULT b'1',
13`fltArr` varchar(10) NOT NULL,
14`fltDep` varchar(10) NOT NULL,
15`fltArrMade` bit(1) NOT NULL DEFAULT b'0',
16`fltDepMade` bit(1) NOT NULL DEFAULT b'0',
17`billetArrMade` bit(1) NOT NULL DEFAULT b'0',
18`billetDepMade` bit(1) NOT NULL DEFAULT b'0',
19`FacilityId` smallint(6) unsigned NOT NULL,
20`FacilityWingId` mediumint(9) unsigned NOT NULL,
21`FacilityRoomId` int(11) unsigned NOT NULL,
22`comment` varchar(255) NOT NULL,
23`creation` datetime NOT NULL,
24`lastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
25`lastUpdateBy` mediumint(9) unsigned NOT NULL,
26PRIMARY KEY (`id`)
27) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;