· 8 years ago · Jun 20, 2018, 05:24 PM
1CREATE TABLE IF NOT EXISTS `sold_objects` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `olduid` varchar(17) NOT NULL,
4 `newuid` varchar(17) NOT NULL,
5 `index_value` varchar(17) NOT NULL,
6 `object_classname` tinytext NOT NULL,
7 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
8 PRIMARY KEY (`id`)
9) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;