· 7 years ago · Sep 22, 2018, 10:18 PM
1CREATE TABLE IF NOT EXISTS `sections` (
2 `id` int(11) NOT NULL,
3 `name` varchar(20) NOT NULL,
4 `priority` int(11) NOT NULL,
5 `show` tinyint(1) NOT NULL DEFAULT '0',
6 `displayname` varchar(50) NOT NULL
7) ENGINE=InnoDB DEFAULT CHARSET=latin1;
8
9 ALTER TABLE `sections` CHANGE `id` `id` INT( 11 ) NOT NULL AUTO_INCREMENT
10
11 #1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key