Fix id->ext_id, moved SQL in right place

diff --git a/install/tables.sql b/install/tables.sql
index 7b1b3cb83a89e994d766c9b4dbbc3465410526fb..6bb6c27f2b0653531dd5244d9dfbd11051c0dba6 100644 (file)
--- 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';
 
   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,
 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';
 
   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',
 DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_jackpot`;
 CREATE TABLE `{?_MYSQL_PREFIX?}_jackpot` (
   `ok` CHAR(2) NOT NULL DEFAULT 'ok',