1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
CREATE TABLE `history` (
`hotel_id` varchar(16) NOT NULL,
`update_type` varchar(255) NOT NULL,
`code` varchar(255) DEFAULT NULL,
`affected_from` date DEFAULT NULL,
`affected_to` date DEFAULT NULL,
`submit_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`submit_ip` varchar(15) DEFAULT NULL,
`submit_user` varchar(255) DEFAULT NULL,
`id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `history`
ADD PRIMARY KEY (`id`) USING BTREE,
ADD KEY `update_type` (`update_type`),
ADD KEY `hotel_id` (`hotel_id`);
ALTER TABLE `history`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
|
