From 87bba91ccfbcc0945015ab9cf203dbc6d7843a0c Mon Sep 17 00:00:00 2001 From: oshri Date: Tue, 7 Feb 2017 15:24:33 +0200 Subject: [PATCH] fix bug at multipledb difine primary key and auto increment --- sql/5_0_0-to-5_0_1_upgrade.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/sql/5_0_0-to-5_0_1_upgrade.sql b/sql/5_0_0-to-5_0_1_upgrade.sql index 6c8a9f02c..7eab92b09 100644 --- a/sql/5_0_0-to-5_0_1_upgrade.sql +++ b/sql/5_0_0-to-5_0_1_upgrade.sql @@ -95,13 +95,14 @@ ALTER TABLE `list_options` ADD `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TI #IfNotTable multiple_db CREATE TABLE `multiple_db` ( - `id` int(11) NOT NULL, + `id` int(11) NOT NULL AUTO_INCREMENT, `namespace` varchar(255) NOT NULL, `username` varchar(255) NOT NULL, `password` text, `dbname` varchar(255) NOT NULL, `host` varchar(255) NOT NULL DEFAULT 'localhost', `port` smallint(4) NOT NULL DEFAULT '3306', - `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP + `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + PRIMARY KEY (id) ) ENGINE=InnoDB; #EndIf \ No newline at end of file -- 2.11.4.GIT