File: setup.mysql

# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost Database : coco

# --------------------------------------------------------
#
# Table structure for table 'coco_access'
#

CREATE TABLE coco_access (
   id int(10) unsigned zerofill NOT NULL auto_increment,
   browser varchar(64) NOT NULL,
   referer varchar(255) NOT NULL,
   ip varchar(16) NOT NULL,
   pageid int(10) unsigned zerofill DEFAULT '0000000000' NOT NULL,
   lasttime bigint(11),
   PRIMARY KEY (id),
   KEY pageid (pageid),
   KEY referer (referer),
   KEY ip (ip)
);


# --------------------------------------------------------
#
# Table structure for table 'coco_comment'
#

CREATE TABLE coco_comment (
   id int(10) unsigned zerofill NOT NULL auto_increment,
   pgid int(8) DEFAULT '0' NOT NULL,
   paid int(8) DEFAULT '0' NOT NULL,
   acid int(8) DEFAULT '0' NOT NULL,
   name varchar(64) NOT NULL,
   title varchar(64) NOT NULL,
   email varchar(64) NOT NULL,
   url varchar(64) NOT NULL,
   text text NOT NULL,
   replies enum('yes','no') DEFAULT 'no' NOT NULL,
   PRIMARY KEY (id),
   KEY pgid (pgid),
   KEY paid (paid),
   KEY acid (acid)
);


# --------------------------------------------------------
#
# Table structure for table 'coco_counter'
#

CREATE TABLE coco_counter (
   id int(10) unsigned zerofill NOT NULL auto_increment,
   name varchar(128) NOT NULL,
   hits int(8) DEFAULT '0' NOT NULL,
   comments int(4) DEFAULT '0' NOT NULL,
   description tinytext,
   PRIMARY KEY (id)
);