Changeset 422 for veekun/trunk/script/base.sql

Timestamp:

03/18/08 20:06:19 (2 years ago)

Author:

eevee

Message:

Changed all MyISAM tables to InnoDB, and changed one last latin1 table to UTF-8. (#58)
Unbeknowst to me, InnoDB always sorts rows by primary key, so this diff is very large just from moving rows around. Sorry.

Files:

• veekun/trunk/script/base.sql (modified) (8 diffs)

veekun/trunk/script/base.sql

@@ -25 +25 @@
   PRIMARY KEY  (id),
   KEY POSTID USING BTREE (post_id)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
@@ -45 +45 @@
   error text NOT NULL,
   PRIMARY KEY  (id)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
@@ -81 +81 @@
   polarity enum('allow','deny') default NULL,
   PRIMARY KEY  USING BTREE (group_id,permission,scope)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
@@ -114 +114 @@
   message mediumtext NOT NULL,
   PRIMARY KEY  (id)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
@@ -153 +153 @@
   PRIMARY KEY  USING BTREE (id),
   KEY USER_ID USING BTREE (user_id)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
@@ -171 +171 @@
   content mediumtext NOT NULL,
   PRIMARY KEY  (id)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
@@ -226 +226 @@
   KEY user_id USING BTREE (user_id),
   KEY group_id USING BTREE (group_id)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
@@ -260 +260 @@
   PRIMARY KEY  (id),
   UNIQUE KEY `NAME` (`name`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;