CREATE TABLE cat (
  ID int(2) NOT NULL auto_increment,
  cat text NOT NULL,
  type enum('normal','img','html', 'rss') NOT NULL default 'normal',
  place int(4) NOT NULL default '0',
  displayColumn int(1) NOT NULL default '1',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

CREATE TABLE link (
  ID int(5) NOT NULL auto_increment,
  text varchar(70) NOT NULL default '',
  url text NOT NULL,
  catID int(15) NOT NULL default '0',
  linkopen enum('_self','_blank') NOT NULL default '_self',
  visible enum('N','Y') NOT NULL default 'Y',
  PRIMARY KEY  (ID),
  KEY cat_ID (catID)
) TYPE=MyISAM;


CREATE TABLE log (
  ID int(11) NOT NULL auto_increment,
  logDate datetime NOT NULL default '0000-00-00 00:00:00',
  ip varchar(15) NOT NULL default '',
  agent text NOT NULL,
  ref text NOT NULL,
  linkID int(10) NOT NULL default '0',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

CREATE TABLE users (
  ID int(11) NOT NULL auto_increment,
  email text NOT NULL,
  username varchar(35) NOT NULL default '',
  md5pass varchar(32) NOT NULL default '',
  addCatPriv enum('N','Y') NOT NULL default 'Y',
  addLinkPriv enum('N','Y') NOT NULL default 'Y',
  delCatPriv enum('N','Y') NOT NULL default 'Y',
  delLinkPriv enum('N','Y') NOT NULL default 'Y',
  editLinkPriv enum('N','Y') NOT NULL default 'Y',
  moveCatPriv enum('N','Y') NOT NULL default 'Y',
  changeSettingsPriv enum('N','Y') NOT NULL default 'Y',
  manageUsersPriv enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;
INSERT INTO users VALUES (1, 'jpwaag@hotmail.com', 'linkpage', MD5('linkpage'), 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');
INSERT INTO users VALUES (2, 'norights', 'norights', MD5('norights'), 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');