Changeset 406 for veekun/trunk/script/gallery.sql

Timestamp:

02/08/08 02:44:39 (2 years ago)

Author:

eevee

Message:

Database refactoring. Renamed columns and tables to be more consistent and more readable. (#58)

Files:

• veekun/trunk/script/gallery.sql (modified) (3 diffs)

veekun/trunk/script/gallery.sql

@@ -17 +17 @@
 CREATE TABLE creators (
   id int(10) unsigned NOT NULL auto_increment,
-  userid int(10) unsigned default NULL,
-  `name` varchar(20) default NULL,
-  itemct int(10) unsigned NOT NULL default '0',
-  PRIMARY KEY  (id),
-  UNIQUE KEY userid (userid)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+  user_id int(10) unsigned NOT NULL,
+  `name` varchar(32) NOT NULL,
+  item_count tinyint(3) unsigned default NULL,
+  PRIMARY KEY  (id)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 --
@@ -49 +48 @@
 
 --
--- Table structure for table `gallerykeywords`
+-- Table structure for table `gallery_keywords`
 --
 
-DROP TABLE IF EXISTS gallerykeywords;
-CREATE TABLE gallerykeywords (
+DROP TABLE IF EXISTS gallery_keywords;
+CREATE TABLE gallery_keywords (
   id int(10) unsigned NOT NULL auto_increment,
   keyword varchar(48) NOT NULL default '',
@@ -63 +62 @@
 
 --
--- Table structure for table `itemkeywords`
+-- Table structure for table `item_keywords`
 --
 
-DROP TABLE IF EXISTS itemkeywords;
-CREATE TABLE itemkeywords (
+DROP TABLE IF EXISTS item_keywords;
+CREATE TABLE item_keywords (
   itemid int(10) unsigned NOT NULL default '0',
   keywordid int(10) unsigned NOT NULL default '0',