mirror of
https://github.com/dimitri/pgloader.git
synced 2025-08-07 23:07:00 +02:00
b7347a567c
At the moment it's a very manual process, and it might get automated someday. Meanwhile it's still useful to have. See #569 for an issue that got a test case added.
22 lines
675 B
SQL
Vendored
22 lines
675 B
SQL
Vendored
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;
|
|
|