Changeset 422 for veekun/trunk/script/gallery.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/gallery.sql (modified) (3 diffs)

veekun/trunk/script/gallery.sql

@@ -50 +50 @@
   PRIMARY KEY  (id),
   UNIQUE KEY filename (filename)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
@@ -67 +67 @@
   PRIMARY KEY  (id),
   UNIQUE KEY keyword (keyword)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
@@ -83 +83 @@
   KEY itemid (itemid),
   KEY keywordid (keywordid)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;