Show
Ignore:
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:
1 modified

Legend:

Unmodified
Added
Removed

  • veekun/trunk/script/gallery.sql

    r1 r41  
    33-- Host: localhost    Database: pokedex 
    44-- ------------------------------------------------------ 
    5 -- Server version       5.0.22-community-nt 
     5-- Server version       5.0.27-community-nt 
    66 
    77/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 
    … …  
    1717 
    1818-- 
    19 -- Table structure for table `gallerykeywords` 
     19-- Table structure for table `creators` 
    2020-- 
    2121 
    22 DROP TABLE IF EXISTS gallerykeywords; 
    23 CREATE TABLE gallerykeywords ( 
     22DROP TABLE IF EXISTS creators; 
     23CREATE TABLE creators ( 
    2424  id int(10) unsigned NOT NULL auto_increment, 
    25   keyword varchar(48) NOT NULL default '', 
    26   category varchar(48) NOT NULL default '', 
    27   description tinytext NOT NULL, 
     25  userid int(10) unsigned default NULL, 
     26  `name` varchar(20) default NULL, 
     27  itemct int(10) unsigned NOT NULL default '0', 
    2828  PRIMARY KEY  (id), 
    29   UNIQUE KEY keyword (keyword) 
     29  UNIQUE KEY userid (userid) 
    3030) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
    3131 
    … …  
    5555 
    5656-- 
     57-- Table structure for table `gallerykeywords` 
     58-- 
     59 
     60DROP TABLE IF EXISTS gallerykeywords; 
     61CREATE TABLE gallerykeywords ( 
     62  id int(10) unsigned NOT NULL auto_increment, 
     63  keyword varchar(48) NOT NULL default '', 
     64  category varchar(48) NOT NULL default '', 
     65  description tinytext NOT NULL, 
     66  PRIMARY KEY  (id), 
     67  UNIQUE KEY keyword (keyword) 
     68) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     69 
     70-- 
    5771-- Table structure for table `itemkeywords` 
    5872-- 
    … …  
    6680  KEY keywordid (keywordid) 
    6781) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
    68  
    69 -- 
    70 -- Table structure for table `creators` 
    71 -- 
    72  
    73 DROP TABLE IF EXISTS creators; 
    74 CREATE TABLE creators ( 
    75   id int(10) unsigned NOT NULL auto_increment, 
    76   userid int(10) unsigned default NULL, 
    77   `name` varchar(20) default NULL, 
    78   itemct int(10) unsigned NOT NULL default '0', 
    79   PRIMARY KEY  (id), 
    80   UNIQUE KEY userid (userid) 
    81 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
    8282/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; 
    8383 
    … …  
    9090/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 
    9191 
     92-- Dump completed on 2007-03-09  7:00:26