root/veekun/trunk/script/gallery.sql @ 406

/*!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;
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;

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

DROP TABLE IF EXISTS gallery;
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 text 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=MyISAM DEFAULT CHARSET=latin1;

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

DROP TABLE IF EXISTS gallery_keywords;
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=MyISAM DEFAULT CHARSET=latin1;

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

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',
  PRIMARY KEY  (itemid,keywordid),
  KEY itemid (itemid),
  KEY keywordid (keywordid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!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 */;