-- Database chema on 3 Sep 2002

CREATE TABLE article (
  page smallint(6) NOT NULL default '0',
  intro enum('y','n') NOT NULL default 'y',
  article text NOT NULL,
  PRIMARY KEY  (page)
) TYPE=MyISAM;


CREATE TABLE page (
  id smallint(6) NOT NULL auto_increment,
  parent smallint(6) default NULL,
  link char(1) binary NOT NULL default 'd',
  comments enum('form','link','hide') NOT NULL default 'form',
  related enum('y','n') NOT NULL default 'y',
  count int(11) NOT NULL default '0',
  author smallint(6) NOT NULL default '1',
  published date NOT NULL default '2002-06-01',
  updated date default NULL,
  uri varchar(100) default NULL,
  source char(1) binary NOT NULL default 'a',
  file varchar(100) default NULL,
  name varchar(20) default NULL,
  title varchar(100) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY uri (uri)
) TYPE=MyISAM;