Login   Register  
PHP Classes
elePHPant
Icontem

File: setup.mysql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Matthias Richter  >  phpMyCoCo  >  setup.mysql  >  Download  
File: setup.mysql
Role: ???
Content type: text/plain
Description: databse layout for phpmycoco
Class: phpMyCoCo
Author: By
Last change:
Date: 13 years ago
Size: 1,555 bytes
 

Contents

Class file image Download
# 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)
);