14 lines
442 B
SQL
Executable File
14 lines
442 B
SQL
Executable File
CREATE TABLE IF NOT EXISTS unit (
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`dateCreated` datetime NOT NULL,
|
|
`lastModified` datetime NOT NULL,
|
|
`identifier` bigint(20) DEFAULT NULL,
|
|
`title` varchar(255) NOT NULL,
|
|
`version` int(4) NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `identifier` (`identifier`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2925 ;
|
|
|
|
ALTER TABLE role
|
|
ADD unit_id bigint(20) DEFAULT NULL;
|