# phpMyAdmin MySQL-Dump
# version 2.3.3pl1
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Dec 20, 2002 at 11:47 PM
# Server version: 3.23.52
# PHP Version: 4.2.3
# Database : `comiccollection`
# --------------------------------------------------------

#
# Table structure for table `cc_comiclist`
#

DROP TABLE IF EXISTS `cc_comiclist`;
CREATE TABLE `cc_comiclist` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `access_string` text,
  `multi_access_string` text,
  `extract_rules` varchar(255) default NULL,
  `ext_list` varchar(255) default NULL,
  `auto_get` enum('yes','no') NOT NULL default 'yes',
  `system_type` enum('unix','case-insensitive') NOT NULL default 'unix',
  `attempt_order` enum('s','m','sm','ms','e') NOT NULL default 's',
  `inc` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `cc_images`
#

CREATE TABLE cc_images (
  id int(11) NOT NULL auto_increment,
  strip_id int(11) NOT NULL default '0',
  type enum('gif','jpg','png') NOT NULL default 'gif',
  local_order tinyint(4) NOT NULL default '0',
  width int(11) default NULL,
  height int(11) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id,strip_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `cc_strips`
#

CREATE TABLE cc_strips (
  id int(11) NOT NULL auto_increment,
  comic_id int(11) NOT NULL default '0',
  title varchar(127) default NULL,
  description varchar(255) default NULL,
  for_day date NOT NULL default '0000-00-00',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id,comic_id,for_day)
) TYPE=MyISAM;