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

Timestamp:

03/09/07 01:13:10 (3 years ago)

Author:

eevee

Message:

Merged all those dumper scripts into one slightly more intelligent one.
Fixed the order of tables in the dumps; was a problem with my version of MySQL. Also removed the AUTO_INCREMENT table option from the dumps.
Added some minor testing data for the base tables.

Files:

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

veekun/trunk/script/base.sql

@@ -3 +3 @@
 -- Host: localhost    Database: pokedex
 -- ------------------------------------------------------
--- Server version       5.0.24a-Debian_9-log
+-- Server version       5.0.27-community-nt
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@@ -29 +29 @@
   PRIMARY KEY  (id),
   KEY POSTID (postid)
-) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 --
@@ -46 +46 @@
   error text NOT NULL,
   PRIMARY KEY  (id)
-) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 --
@@ -59 +59 @@
   threadct int(10) unsigned NOT NULL default '0',
   postct int(10) unsigned NOT NULL default '0',
-  flags set('header') default NULL,
-  accessibility enum('normal','locked','archive','hidden') NOT NULL default 'normal',
+  flags set('locked','readonly','header') NOT NULL default '',
+  accessibility enum('normal','locked','archive','hidden') NOT NULL,
   blurb varchar(255) NOT NULL default '',
   PRIMARY KEY  (id)
-) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 --
@@ -88 +88 @@
   `name` tinytext NOT NULL,
   UNIQUE KEY id (id)
-) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 --
@@ -103 +103 @@
   message text NOT NULL,
   PRIMARY KEY  (id)
-) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 --
@@ -122 +122 @@
   KEY THREAD (threadid),
   KEY `USER` (userid)
-) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 --
@@ -151 +151 @@
   message text NOT NULL,
   PRIMARY KEY  (id)
-) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 --
@@ -171 +171 @@
   PRIMARY KEY  (id),
   KEY FORUMID (forumid)
-) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 --
@@ -214 +214 @@
   PRIMARY KEY  (id),
   UNIQUE KEY `NAME` (`name`)
-) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 
@@ -225 +225 @@
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
+-- Dump completed on 2007-03-09  7:00:25