MyISAM/InnoDB support added

[mailer.git] / install / tables.sql

diff --git a/install/tables.sql b/install/tables.sql
index e6d64afe90e6a794a9baf791b9503345d20236b5..2903b2733d688c74c09b5d1994b5de31bf79eca6 100644 (file)
--- a/install/tables.sql
+++ b/install/tables.sql
@@ -7,7 +7,7 @@ CREATE TABLE `{!prefix!}admin_menu` (
   `sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
   `descr` BLOB NOT NULL,
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 DROP TABLE IF EXISTS `{!prefix!}admins`;
 CREATE TABLE `{!prefix!}admins` (
@@ -15,7 +15,7 @@ CREATE TABLE `{!prefix!}admins` (
   `login` VARCHAR(100) NOT NULL DEFAULT '',
   `password` VARCHAR(40) NOT NULL DEFAULT '',
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 DROP TABLE IF EXISTS `{!prefix!}cats`;
 CREATE TABLE `{!prefix!}cats` (
@@ -24,7 +24,7 @@ CREATE TABLE `{!prefix!}cats` (
   `visible` ENUM('Y','N') NOT NULL DEFAULT 'Y',
   `sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 DROP TABLE IF EXISTS `{!prefix!}config`;
 CREATE TABLE `{!prefix!}config` (
@@ -42,7 +42,7 @@ CREATE TABLE `{!prefix!}config` (
   `test_subj` ENUM('Y','N') NOT NULL DEFAULT 'Y',
   `autosend_active` ENUM('Y','N') NOT NULL DEFAULT 'N',
   PRIMARY KEY  (`config`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 INSERT INTO `{!prefix!}config` VALUES (0,5,2000,200,5,'Y','N','Y',86400,'Y',1000,'Y','N');
 
@@ -57,7 +57,7 @@ CREATE TABLE `{!prefix!}guest_menu` (
   `locked` ENUM('Y','N') NOT NULL DEFAULT 'Y',
   `counter` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 DROP TABLE IF EXISTS `{!prefix!}max_receive`;
 CREATE TABLE `{!prefix!}max_receive` (
@@ -65,7 +65,7 @@ CREATE TABLE `{!prefix!}max_receive` (
   `value` MEDIUMINT(9) NOT NULL DEFAULT 0,
   `comment` VARCHAR(255) NOT NULL DEFAULT '',
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 DROP TABLE IF EXISTS `{!prefix!}member_menu`;
 CREATE TABLE `{!prefix!}member_menu` (
@@ -78,7 +78,7 @@ CREATE TABLE `{!prefix!}member_menu` (
   `locked` ENUM('Y','N') NOT NULL DEFAULT 'Y',
   `counter` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 DROP TABLE IF EXISTS `{!prefix!}mod_reg`;
 CREATE TABLE `{!prefix!}mod_reg` (
@@ -91,7 +91,7 @@ CREATE TABLE `{!prefix!}mod_reg` (
   `mem_only` ENUM('Y','N') NOT NULL DEFAULT 'N',
   `clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 INSERT INTO `{!prefix!}mod_reg` VALUES (1,'admin','N','N','Y','','N',0);
 INSERT INTO `{!prefix!}mod_reg` VALUES (2,'index','N','N','N','','N',0);
@@ -109,7 +109,7 @@ CREATE TABLE `{!prefix!}payments` (
   `mail_title` VARCHAR(255) NOT NULL DEFAULT '',
   `price` FLOAT(5,5) UNSIGNED NOT NULL DEFAULT '0.00000',
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 DROP TABLE IF EXISTS `{!prefix!}pool`;
 CREATE TABLE `{!prefix!}pool` (
@@ -125,7 +125,7 @@ CREATE TABLE `{!prefix!}pool` (
   `target_send` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
   `cat_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 DROP TABLE IF EXISTS `{!prefix!}refbanner`;
 CREATE TABLE `{!prefix!}refbanner` (
@@ -135,7 +135,7 @@ CREATE TABLE `{!prefix!}refbanner` (
   `visible` ENUM('Y','N') NOT NULL DEFAULT 'Y',
   `counter` BIGINT(22) NOT NULL DEFAULT 0,
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 DROP TABLE IF EXISTS `{!prefix!}refdepths`;
 CREATE TABLE `{!prefix!}refdepths` (
@@ -143,7 +143,7 @@ CREATE TABLE `{!prefix!}refdepths` (
   `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
   `percents` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 INSERT INTO `{!prefix!}refdepths` VALUES (1,0,100);
 INSERT INTO `{!prefix!}refdepths` VALUES (2,1,30);
@@ -159,7 +159,7 @@ CREATE TABLE `{!prefix!}refsystem` (
   `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
   `counter` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 DROP TABLE IF EXISTS `{!prefix!}user_cats`;
 CREATE TABLE `{!prefix!}user_cats` (
@@ -167,7 +167,7 @@ CREATE TABLE `{!prefix!}user_cats` (
   `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
   `cat_id` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 DROP TABLE IF EXISTS `{!prefix!}user_data`;
 CREATE TABLE `{!prefix!}user_data` (
@@ -197,7 +197,7 @@ CREATE TABLE `{!prefix!}user_data` (
   `used_points` FLOAT(22,3) NOT NULL DEFAULT '0.000',
   `emails_sent` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
   PRIMARY KEY  (`userid`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 DROP TABLE IF EXISTS `{!prefix!}user_points`;
 CREATE TABLE `{!prefix!}user_points` (
@@ -206,7 +206,7 @@ CREATE TABLE `{!prefix!}user_points` (
   `ref_depth` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
   `points` FLOAT(22,3) NOT NULL DEFAULT '0.000',
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 ALTER TABLE `{!prefix!}config` ADD `max_send` TINYINT(3) UNSIGNED NOT NULL DEFAULT '100';
 ALTER TABLE `{!prefix!}config` ADD `url_blacklist` ENUM('Y','N') NOT NULL DEFAULT 'Y';
@@ -224,7 +224,7 @@ CREATE TABLE `{!prefix!}user_links` (
   `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
   `link_type` ENUM('NORMAL') NOT NULL DEFAULT 'NORMAL',
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 DROP TABLE IF EXISTS `{!prefix!}user_stats`;
 CREATE TABLE `{!prefix!}user_stats` (
@@ -240,7 +240,7 @@ CREATE TABLE `{!prefix!}user_stats` (
   `timestamp_sstart` VARCHAR(10) NOT NULL DEFAULT '',
   `timestamp_send` VARCHAR(10) NOT NULL DEFAULT '',
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 ALTER TABLE `{!prefix!}user_data` ADD `joined` VARCHAR(10) NOT NULL DEFAULT 0;
 ALTER TABLE `{!prefix!}config` ADD `last_update` VARCHAR(10) NOT NULL DEFAULT 0;
@@ -279,7 +279,7 @@ CREATE TABLE `{!prefix!}task_system` (
   `task_created` VARCHAR(10) NOT NULL DEFAULT 0,
   KEY (`assigned_admin`),
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 ALTER TABLE `{!prefix!}pool` ADD INDEX (`sender`);
 ALTER TABLE `{!prefix!}pool` ADD INDEX (`payment_id`);
@@ -312,14 +312,14 @@ CREATE TABLE `{!prefix!}extensions` (
   `ext_active` ENUM('Y','N') NOT NULL DEFAULT 'N',
   `ext_version` VARCHAR(255) NOT NULL DEFAULT 'INVALID',
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 DROP TABLE IF EXISTS `{!prefix!}jackpot`;
 CREATE TABLE `{!prefix!}jackpot` (
   `ok` CHAR(2) NOT NULL DEFAULT 'ok',
   `points` FLOAT(20,3) NOT NULL DEFAULT '0.000',
   PRIMARY KEY  (`ok`)
-) TYPE=MyISAM;
+) TYPE={!type!};
 
 ALTER TABLE `{!prefix!}config` ADD `activate_xchange` BIGINT(20) UNSIGNED NOT NULL DEFAULT 100;
 ALTER TABLE `{!prefix!}config` ADD `order_multi_page` ENUM('Y','N') NOT NULL DEFAULT 'Y';