root/veekun/trunk/script/gallery.sql

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `creators`
--

DROP TABLE IF EXISTS creators;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE creators (
  id int(10) unsigned NOT NULL auto_increment,
  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;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `gallery`
--

DROP TABLE IF EXISTS gallery;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE gallery (
  id int(10) unsigned NOT NULL auto_increment,
  creatorid int(10) unsigned NOT NULL default '0',
  filename varchar(255) NOT NULL default '',
  uploaderid int(10) unsigned NOT NULL default '0',
  approverid int(10) unsigned NOT NULL default '0',
  `time` int(10) unsigned NOT NULL default '0',
  `hash` varchar(32) NOT NULL default '',
  title varchar(48) NOT NULL default '',
  description mediumtext NOT NULL,
  height smallint(5) unsigned NOT NULL default '0',
  width smallint(5) unsigned NOT NULL default '0',
  seriesid int(10) unsigned NOT NULL default '0',
  position tinyint(3) unsigned NOT NULL default '0',
  `type` enum('sketch','lineart','colored','story','oekaki') NOT NULL default 'sketch',
  PRIMARY KEY  (id),
  UNIQUE KEY filename (filename)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `gallery_keywords`
--

DROP TABLE IF EXISTS gallery_keywords;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE gallery_keywords (
  id int(10) unsigned NOT NULL auto_increment,
  keyword varchar(48) NOT NULL default '',
  category varchar(48) NOT NULL default '',
  description tinytext NOT NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY keyword (keyword)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `item_keywords`
--

DROP TABLE IF EXISTS item_keywords;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE item_keywords (
  itemid int(10) unsigned NOT NULL default '0',
  keywordid int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (itemid,keywordid),
  KEY itemid (itemid),
  KEY keywordid (keywordid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;