From 4192b8ef8f010fd7ce97bd4aa78a697e849b1755 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Fri, 14 Dec 2012 14:13:28 +0000 Subject: [PATCH] Fix id->ext_id, moved SQL in right place --- install/tables.sql | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) diff --git a/install/tables.sql b/install/tables.sql index 7b1b3cb83a..6bb6c27f2b 100644 --- a/install/tables.sql +++ b/install/tables.sql @@ -65,6 +65,15 @@ CREATE TABLE `{?_MYSQL_PREFIX?}_config` ( PRIMARY KEY (`config`) ) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Configuration'; +DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_extensions`; +CREATE TABLE `{?_MYSQL_PREFIX?}_extensions` ( + `ext_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, + `ext_name` VARCHAR(255) NOT NULL DEFAULT '', + `ext_active` ENUM('Y','N') NOT NULL DEFAULT 'N', + `ext_version` VARCHAR(255) NOT NULL DEFAULT 'INVALID', + PRIMARY KEY (`ext_id`) +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Extension registry'; + DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_guest_menu`; CREATE TABLE `{?_MYSQL_PREFIX?}_guest_menu` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, @@ -187,15 +196,6 @@ CREATE TABLE `{?_MYSQL_PREFIX?}_task_system` ( PRIMARY KEY (`id`) ) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Task system'; -DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_extensions`; -CREATE TABLE `{?_MYSQL_PREFIX?}_extensions` ( - `ext_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, - `ext_name` VARCHAR(255) NOT NULL DEFAULT '', - `ext_active` ENUM('Y','N') NOT NULL DEFAULT 'N', - `ext_version` VARCHAR(255) NOT NULL DEFAULT 'INVALID', - PRIMARY KEY (`id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Extension registry'; - DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_jackpot`; CREATE TABLE `{?_MYSQL_PREFIX?}_jackpot` ( `ok` CHAR(2) NOT NULL DEFAULT 'ok', -- 2.39.5