# phpMyAdmin MySQL-Dump
# version 2.3.3pl1
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Dec 18, 2003 at 08:30 AM
# Server version: 3.23.41
# PHP Version: 4.2.2
# Database : `codetransit_com`
# --------------------------------------------------------

#
# Table structure for table `accounts`
#

CREATE TABLE accounts (
  authorid int(11) NOT NULL auto_increment,
  dateadd varchar(255) NOT NULL default '',
  fullname varchar(255) NOT NULL default '',
  coname varchar(255) NOT NULL default '',
  username varchar(255) NOT NULL default '',
  password varchar(255) NOT NULL default '',
  phone varchar(255) NOT NULL default '',
  fax varchar(255) NOT NULL default '',
  email varchar(255) NOT NULL default '',
  homepage varchar(255) NOT NULL default '',
  subscribed varchar(10) NOT NULL default '',
  PRIMARY KEY  (authorid)
) TYPE=MyISAM COMMENT='Code Transit Developer Accounts';
# --------------------------------------------------------

#
# Table structure for table `categories`
#

CREATE TABLE categories (
  category_id int(4) NOT NULL auto_increment,
  category_cat int(4) NOT NULL default '0',
  category_name varchar(100) NOT NULL default '',
  category_header text,
  category_path varchar(255) NOT NULL default '',
  category_private char(1) NOT NULL default '',
  PRIMARY KEY  (category_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `comments`
#

CREATE TABLE comments (
  id tinyint(11) NOT NULL auto_increment,
  recordid varchar(11) NOT NULL default '',
  title varchar(100) NOT NULL default '',
  fullname varchar(100) NOT NULL default '',
  email varchar(100) NOT NULL default '',
  dateadd varchar(255) NOT NULL default '',
  recommend char(3) NOT NULL default '',
  approved char(3) NOT NULL default '',
  comments text NOT NULL,
  comments1 char(3) NOT NULL default '',
  comments2 char(3) NOT NULL default '',
  comments3 char(3) NOT NULL default '',
  comments4 char(3) NOT NULL default '',
  comments5 char(3) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM COMMENT='User Reviews';
# --------------------------------------------------------

#
# Table structure for table `scripts`
#

CREATE TABLE scripts (
  id int(11) NOT NULL auto_increment,
  category int(11) NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  download1 varchar(255) NOT NULL default '',
  download2 varchar(255) NOT NULL default '',
  download3 varchar(255) NOT NULL default '',
  version varchar(20) NOT NULL default '',
  license varchar(20) NOT NULL default '',
  size int(20) NOT NULL default '0',
  price decimal(6,2) NOT NULL default '0.00',
  homepage varchar(255) NOT NULL default '',
  sample varchar(255) NOT NULL default '',
  rating char(1) NOT NULL default '',
  editpick char(1) NOT NULL default '',
  shortdesc text NOT NULL,
  longdesc text NOT NULL,
  downloads int(11) NOT NULL default '0',
  buys int(11) NOT NULL default '0',
  totalrate int(11) default NULL,
  numvotes int(11) default NULL,
  dateadd int(11) default NULL,
  validated char(3) default NULL,
  recommended char(3) NOT NULL default 'no',
  recplace varchar(10) NOT NULL default '',
  recstart varchar(10) NOT NULL default '',
  recend varchar(10) NOT NULL default '',
  minrequirements text NOT NULL,
  triallimitations text NOT NULL,
  releasedate varchar(100) default NULL,
  keywords varchar(255) NOT NULL default '',
  techsupport varchar(255) NOT NULL default '',
  moreinfourl varchar(255) NOT NULL default '',
  orderurl varchar(255) NOT NULL default '',
  authorid varchar(25) NOT NULL default '',
  boxshot varchar(100) NOT NULL default '',
  win3x char(1) NOT NULL default '',
  win95 char(1) NOT NULL default '',
  win98 char(1) NOT NULL default '',
  winme char(1) NOT NULL default '',
  winnt char(1) NOT NULL default '',
  win2k char(1) NOT NULL default '',
  winxp char(1) NOT NULL default '',
  winall char(1) NOT NULL default '',
  unix char(1) NOT NULL default '',
  linux char(1) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY ft_type (license)
) TYPE=MyISAM;

