- Added manual deletion of sc_data entries when deleting a character (char-SQL)

- Updated main.sql to use pure MyISAM tables, removed all foreign keys.
- Added Jaguar's sql script to convert all tables to MyISAM. It's located in sql-files/convert_engine.sql
- Removed convert_guild_tables.sql as we don't use InnoDB anymore.


git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8722 54d463be-8e91-2dee-dedb-b68131a5f0ec

1 files changed, 18 insertions, 29 deletions

diff --git a/sql-files/main.sql b/sql-files/main.sql
index 17846b319..2edb747e3 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -82,7 +82,7 @@ CREATE TABLE `char` (
   KEY `account_id` (`account_id`),

   KEY `party_id` (`party_id`),

   KEY `guild_id` (`guild_id`)

-) TYPE=InnoDB AUTO_INCREMENT=150000; 

+) TYPE=MyISAM AUTO_INCREMENT=150000; 

 

 --

 -- Table structure for table `charlog`

@@ -156,9 +156,8 @@ CREATE TABLE `guild` (
   `emblem_data` blob,

   PRIMARY KEY  (`guild_id`,`char_id`),

   UNIQUE KEY `guild_id` (`guild_id`),

-  KEY `char_id` (`char_id`),

-  CONSTRAINT `guild_ibfk_1` FOREIGN KEY (`char_id`) REFERENCES `char` (`char_id`) ON DELETE CASCADE

-) TYPE=InnoDB;

+  KEY `char_id` (`char_id`)

+) TYPE=MyISAM;

 

 --

 -- Table structure for table `guild_alliance`

@@ -171,10 +170,8 @@ CREATE TABLE `guild_alliance` (
   `alliance_id` int(11) unsigned NOT NULL default '0',

   `name` varchar(24) NOT NULL default '',

   PRIMARY KEY  (`guild_id`,`alliance_id`),

-  KEY `alliance_id` (`alliance_id`),

-  CONSTRAINT `guild_alliance_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guild` (`guild_id`) ON DELETE CASCADE,

-  CONSTRAINT `guild_alliance_ibfk_2` FOREIGN KEY (`alliance_id`) REFERENCES `guild` (`guild_id`) ON DELETE CASCADE

-) TYPE=InnoDB;

+  KEY `alliance_id` (`alliance_id`)

+) TYPE=MyISAM;

 

 --

 -- Table structure for table `guild_castle`

@@ -226,9 +223,8 @@ CREATE TABLE `guild_expulsion` (
   `rsv1` int(11) unsigned NOT NULL default '0',

   `rsv2` int(11) unsigned NOT NULL default '0',

   `rsv3` int(11) unsigned NOT NULL default '0',

-  PRIMARY KEY  (`guild_id`,`name`),

-  CONSTRAINT `guild_expulsion_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guild` (`guild_id`) ON DELETE CASCADE

-) TYPE=InnoDB;

+  PRIMARY KEY  (`guild_id`,`name`)

+) TYPE=MyISAM;

 

 --

 -- Table structure for table `guild_member`

@@ -252,10 +248,8 @@ CREATE TABLE `guild_member` (
   `rsv2` int(11) unsigned NOT NULL default '0',

   `name` varchar(24) NOT NULL default '',

   PRIMARY KEY  (`guild_id`,`char_id`),

-  KEY `char_id` (`char_id`),

-  CONSTRAINT `guild_member_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guild` (`guild_id`) ON DELETE CASCADE,

-  CONSTRAINT `guild_member_ibfk_2` FOREIGN KEY (`char_id`) REFERENCES `char` (`char_id`) ON DELETE CASCADE

-) TYPE=InnoDB;

+  KEY `char_id` (`char_id`)

+) TYPE=MyISAM;

 

 --

 -- Table structure for table `guild_position`

@@ -269,9 +263,8 @@ CREATE TABLE `guild_position` (
   `mode` tinyint(11) unsigned NOT NULL default '0',

   `exp_mode` tinyint(11) unsigned NOT NULL default '0',

   PRIMARY KEY  (`guild_id`,`position`),

-  KEY `guild_id` (`guild_id`),

-  CONSTRAINT `guild_position_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guild` (`guild_id`) ON DELETE CASCADE

-) TYPE=InnoDB;

+  KEY `guild_id` (`guild_id`)

+) TYPE=MyISAM;

 

 --

 -- Table structure for table `guild_skill`

@@ -282,9 +275,8 @@ CREATE TABLE `guild_skill` (
   `guild_id` int(11) unsigned NOT NULL default '0',

   `id` smallint(11) unsigned NOT NULL default '0',

   `lv` tinyint(11) unsigned NOT NULL default '0',

-  PRIMARY KEY  (`guild_id`,`id`),

-  CONSTRAINT `guild_skill_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guild` (`guild_id`) ON DELETE CASCADE

-) TYPE=InnoDB;

+  PRIMARY KEY  (`guild_id`,`id`)

+) TYPE=MyISAM;

 

 --

 -- Table structure for table `guild_storage`

@@ -305,9 +297,8 @@ CREATE TABLE `guild_storage` (
   `card2` smallint(11) NOT NULL default '0',

   `card3` smallint(11) NOT NULL default '0',

   PRIMARY KEY  (`id`),

-  KEY `guild_id` (`guild_id`),

-  CONSTRAINT `guild_storage_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guild` (`guild_id`) ON DELETE CASCADE

-) TYPE=InnoDB;

+  KEY `guild_id` (`guild_id`)

+) TYPE=MyISAM;

 

 --

 -- Table structure for table `homunculus`

@@ -407,7 +398,7 @@ CREATE TABLE `login` (
   `state` int(11) unsigned NOT NULL default '0',

   PRIMARY KEY  (`account_id`),

   KEY `name` (`userid`)

-) TYPE=InnoDB AUTO_INCREMENT=2000000; 

+) TYPE=MyISAM AUTO_INCREMENT=2000000; 

 

 -- added standard accounts for servers, VERY INSECURE!!!

 -- inserted into the table called login which is above

@@ -442,10 +433,8 @@ CREATE TABLE `sc_data` (
   `val3` int(11) NOT NULL default '0',

   `val4` int(11) NOT NULL default '0',

   KEY (`account_id`),

-  KEY (`char_id`),

-  CONSTRAINT `scdata_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `login` (`account_id`) ON DELETE CASCADE,

-  CONSTRAINT `scdata_ibfk_2` FOREIGN KEY (`char_id`) REFERENCES `char` (`char_id`) ON DELETE CASCADE

-) TYPE=InnoDB;

+  KEY (`char_id`)

+) TYPE=MyISAM;

 

 --

 -- Table structure for table `loginlog`