-- MySQL dump 8.23
--
-- Host: localhost    Database: webliographer
---------------------------------------------------------
-- Server version	3.23.58

--
-- Table structure for table `focuses`
--

CREATE TABLE focuses (
  focuskey int(11) NOT NULL auto_increment,
  focusname varchar(30) NOT NULL default '',
  focusdescription text,
  viewkey int(11) NOT NULL default '0',
  userid varchar(30) NOT NULL default '',
  editor varchar(30) NOT NULL default '',
  edit_time timestamp(14) NOT NULL,
  create_time datetime NOT NULL default '0000-00-00 00:00:00',
  sharable int(11) default NULL,
  linktype varchar(12) NOT NULL default '',
  PRIMARY KEY  (focuskey),
  KEY k_viewkey (viewkey)
) TYPE=ISAM PACK_KEYS=1;

--
-- Table structure for table `focusmap`
--

CREATE TABLE focusmap (
  focusmapkey int(11) NOT NULL auto_increment,
  focuskey int(11) NOT NULL default '0',
  topickey int(11) NOT NULL default '0',
  viewkey int(11) NOT NULL default '0',
  userid char(30) NOT NULL default '',
  editor char(30) NOT NULL default '',
  edit_time timestamp(14) NOT NULL,
  create_time datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (focusmapkey),
  KEY k_focuskey (focuskey),
  KEY k_topickey (topickey),
  KEY k_viewkey (viewkey)
) TYPE=ISAM PACK_KEYS=1;

--
-- Table structure for table `permissions`
--

CREATE TABLE permissions (
  permissionkey int(11) NOT NULL auto_increment,
  userid char(30) NOT NULL default '',
  viewkey int(11) NOT NULL default '0',
  editor char(30) NOT NULL default '',
  edit_time timestamp(14) NOT NULL,
  create_time datetime NOT NULL default '0000-00-00 00:00:00',
  permission int(11) NOT NULL default '0',
  PRIMARY KEY  (permissionkey),
  KEY k_userid (userid(15)),
  KEY k_viewkey (viewkey)
) TYPE=ISAM PACK_KEYS=1;

--
-- Table structure for table `questions`
--

CREATE TABLE questions (
  questionkey int(11) NOT NULL auto_increment,
  userid varchar(30) NOT NULL default '',
  viewkey int(11) NOT NULL default '0',
  editor varchar(30) NOT NULL default '',
  edit_time timestamp(14) NOT NULL,
  create_time datetime default NULL,
  question varchar(60) default NULL,
  description text,
  sharable int(11) NOT NULL default '0',
  flag varchar(80) default NULL,
  PRIMARY KEY  (questionkey),
  KEY k_userid (userid(15)),
  KEY k_viewkey (viewkey),
  KEY k_sharable (sharable)
) TYPE=ISAM PACK_KEYS=1;

--
-- Table structure for table `reviews`
--

CREATE TABLE reviews (
  reviewkey int(11) NOT NULL auto_increment,
  urlkey int(11) NOT NULL default '0',
  viewkey int(11) NOT NULL default '0',
  userid varchar(30) NOT NULL default '',
  editor varchar(30) NOT NULL default '',
  edit_time timestamp(14) NOT NULL,
  create_time datetime NOT NULL default '0000-00-00 00:00:00',
  comment text,
  sharable int(11) NOT NULL default '0',
  reviewtype varchar(12) NOT NULL default '',
  PRIMARY KEY  (reviewkey),
  KEY k_urlkey (urlkey),
  KEY k_viewkey (viewkey),
  KEY k_userid (userid),
  KEY k_sharable (sharable)
) TYPE=ISAM PACK_KEYS=1;

--
-- Table structure for table `topicmap`
--

CREATE TABLE topicmap (
  topicmapkey int(11) NOT NULL auto_increment,
  topickey int(11) NOT NULL default '0',
  viewkey int(11) NOT NULL default '0',
  urlkey int(11) NOT NULL default '0',
  userid char(30) NOT NULL default '',
  editor char(30) NOT NULL default '',
  edit_time timestamp(14) NOT NULL,
  create_time datetime NOT NULL default '0000-00-00 00:00:00',
  linktype char(12) NOT NULL default '',
  recenthits int(11) NOT NULL default '0',
  totalhits int(11) NOT NULL default '0',
  PRIMARY KEY  (topicmapkey),
  KEY k_topickey (topickey),
  KEY k_viewkey (viewkey),
  KEY k_urlkey (urlkey)
) TYPE=ISAM PACK_KEYS=1;

--
-- Table structure for table `topics`
--

CREATE TABLE topics (
  topickey int(11) NOT NULL auto_increment,
  viewkey int(11) NOT NULL default '0',
  topic varchar(100) NOT NULL default '',
  userid varchar(30) NOT NULL default '',
  editor varchar(30) NOT NULL default '',
  edit_time timestamp(14) NOT NULL,
  create_time datetime NOT NULL default '0000-00-00 00:00:00',
  description varchar(255) NOT NULL default '',
  long_description text,
  sharable int(11) NOT NULL default '0',
  PRIMARY KEY  (topickey),
  KEY k_viewkey (viewkey),
  KEY k_topic (topic),
  KEY k_userid (userid(15)),
  KEY k_sharable (sharable)
) TYPE=ISAM PACK_KEYS=1;

--
-- Table structure for table `urls`
--

CREATE TABLE urls (
  urlkey int(11) NOT NULL auto_increment,
  userid varchar(30) NOT NULL default '',
  viewkey int(11) NOT NULL default '0',
  editor varchar(30) NOT NULL default '',
  edit_time timestamp(14) NOT NULL,
  create_time datetime NOT NULL default '0000-00-00 00:00:00',
  url varchar(128) NOT NULL default '',
  name varchar(20) NOT NULL default '',
  title varchar(60) NOT NULL default '',
  description text,
  sharable int(11) NOT NULL default '0',
  flag varchar(80) default NULL,
  PRIMARY KEY  (urlkey),
  KEY k_userid (userid(15)),
  KEY k_viewkey (viewkey),
  KEY k_sharable (sharable),
  FULLTEXT KEY url_index (url,name,title,description)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `users`
--

CREATE TABLE users (
  userkey int(11) NOT NULL auto_increment,
  userid varchar(30) NOT NULL default '',
  passwd varchar(16) NOT NULL default '',
  email varchar(80) NOT NULL default '',
  name varchar(80) NOT NULL default '',
  title varchar(20) default NULL,
  company varchar(80) default NULL,
  address varchar(80) default NULL,
  address2 varchar(80) default NULL,
  city varchar(30) default NULL,
  state varchar(10) default NULL,
  zip varchar(10) default NULL,
  country varchar(15) default NULL,
  phone varchar(20) default NULL,
  fax varchar(20) default NULL,
  home_phone varchar(20) default NULL,
  bio text,
  browser varchar(255) NOT NULL default '',
  url varchar(80) default NULL,
  created datetime NOT NULL default '0000-00-00 00:00:00',
  last timestamp(14) NOT NULL,
  admin int(11) default NULL,
  picture varchar(100) default NULL,
  PRIMARY KEY  (userkey),
  UNIQUE KEY k_userid (userid),
  KEY k_passwd (passwd)
) TYPE=ISAM PACK_KEYS=1;

--
-- Table structure for table `views`
--

CREATE TABLE views (
  viewkey int(11) NOT NULL auto_increment,
  base varchar(30) NOT NULL default '',
  viewname varchar(20) NOT NULL default '',
  default_permissions int(11) default NULL,
  local_permissions int(11) default NULL,
  user_permissions int(11) default NULL,
  local_email varchar(50) default NULL,
  local_ip varchar(50) default NULL,
  project varchar(60) default NULL,
  email_contact varchar(100) NOT NULL default '',
  userid varchar(30) NOT NULL default '',
  editor varchar(30) NOT NULL default '',
  edit_time timestamp(14) NOT NULL,
  create_time datetime default NULL,
  head text,
  focuskey int(11) default NULL,
  background varchar(130) default NULL,
  bgcolor varchar(6) default NULL,
  bodytags varchar(255) default NULL,
  prenav text,
  prehead text,
  shorthead text,
  foottop text,
  footbottom text,
  viewdescription text,
  custom text,
  PRIMARY KEY  (viewkey),
  UNIQUE KEY k_base (base)
) TYPE=ISAM PACK_KEYS=1;