-- $Id: database.4.1.mysql,v 1.5 2006/05/29 16:04:41 dries Exp $

-- (PK) - Primary key
-- (FK) - Foreign key -> Natural key
-- TBD - To be defined/determined/done.
-- 

--
-- Table structure for table 'access'
--
--
CREATE TABLE access (
  aid tinyint(10) NOT NULL auto_increment,        -- (PK)
  mask varchar(255) NOT NULL default '',          -- TBD
  type varchar(255) NOT NULL default '',          -- TBD
  status tinyint(2) NOT NULL default '0',         -- TBD enabled/disabled
  PRIMARY KEY (aid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'accesslog'
--

CREATE TABLE accesslog (
  aid int(10) NOT NULL auto_increment,             -- (PK)
  sid varchar(32) NOT NULL default '',             -- (FK) -> sessions.sid
  title varchar(255) default NULL,                 -- page title
  path varchar(255) default NULL,                  -- Drupal path/alias (URI)
  url varchar(255) default NULL,                   -- TBD
  hostname varchar(128) default NULL,              -- TBD
  uid int(10) unsigned default '0',                -- (FK) -> users.uid
  timer int(10) unsigned NOT NULL default '0',     -- page execution time
  timestamp int(11) unsigned NOT NULL default '0', -- TBD
  KEY accesslog_timestamp (timestamp),
  PRIMARY KEY (aid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'aggregator_category'
--

CREATE TABLE aggregator_category (
  cid int(10) NOT NULL auto_increment,             -- (PK)
  title varchar(255) NOT NULL default '',          -- TBD
  description longtext NOT NULL,                   -- TBD
  block tinyint(2) NOT NULL default '0',           -- TBD
  PRIMARY KEY (cid),
  UNIQUE KEY title (title)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'aggregator_category_feed'
--

CREATE TABLE aggregator_category_feed (
  fid int(10) NOT NULL default '0',                 -- (FK) -> aggregator_feed.fid
  cid int(10) NOT NULL default '0',                 -- (FK) -> aggregator_category.cid
  PRIMARY KEY (fid,cid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'aggregator_category_item'
--

CREATE TABLE aggregator_category_item (
  iid int(10) NOT NULL default '0',                 -- (FK) -> aggregator_item.iid
  cid int(10) NOT NULL default '0',                 -- (FK) -> aggregator_category.cid
  PRIMARY KEY (iid,cid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'aggregator_feed'
--

CREATE TABLE aggregator_feed (
  fid int(10) NOT NULL auto_increment,              -- (PK)
  title varchar(255) NOT NULL default '',           -- TBD
  url varchar(255) NOT NULL default '',             -- TBD
  refresh int(10) NOT NULL default '0',             -- seconds between updates of feed
  checked int(10) NOT NULL default '0',             -- TBD
  link varchar(255) NOT NULL default '',            -- feed url
  description longtext NOT NULL,                    -- TBD
  image longtext NOT NULL,                          -- TBD
  etag varchar(255) NOT NULL default '',            -- TBD
  modified int(10) NOT NULL default '0',            -- TBD
  block tinyint(2) NOT NULL default '0',            -- TBD
  PRIMARY KEY (fid),
  UNIQUE KEY link (url),
  UNIQUE KEY title (title)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'aggregator_item'
--

CREATE TABLE aggregator_item (
  iid int(10) NOT NULL auto_increment,              -- (PK)
  fid int(10) NOT NULL default '0',                 -- (FK) -> aggregator_feed.fid
  title varchar(255) NOT NULL default '',           -- TBD
  link varchar(255) NOT NULL default '',            -- TBD
  author varchar(255) NOT NULL default '',          -- TBD
  description longtext NOT NULL,                    -- TBD
  timestamp int(11) default NULL,                   -- TBD
  PRIMARY KEY (iid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'authmap'
--

CREATE TABLE authmap (
  aid int(10) unsigned NOT NULL auto_increment, -- (PK)
  uid int(10) NOT NULL default '0',             -- (FK) -> users.uid
  authname varchar(128) NOT NULL default '',    -- TBD
  module varchar(128) NOT NULL default '',      -- TBD
  PRIMARY KEY (aid),
  UNIQUE KEY authname (authname)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'blocks'
--

CREATE TABLE blocks (
  module varchar(64) DEFAULT '' NOT NULL,       -- TBD
  delta varchar(32) NOT NULL default '0',       -- TBD
  theme varchar(255) NOT NULL default '',       -- TBD
  status tinyint(2) DEFAULT '0' NOT NULL,       -- TBD
  weight tinyint(1) DEFAULT '0' NOT NULL,       -- TBD
  region varchar(64) DEFAULT 'left' NOT NULL,   -- which theme section block will appear in
  custom tinyint(2) DEFAULT '0' NOT NULL,       -- TBD
  throttle tinyint(1) DEFAULT '0' NOT NULL,     -- TBD
  visibility tinyint(1) DEFAULT '0' NOT NULL,   -- TBD
  pages text DEFAULT '' NOT NULL                -- TBD
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'book'
--

CREATE TABLE book (
  vid int(10) unsigned NOT NULL default '0',     -- (FK) -> node_revisions.vid
  nid int(10) unsigned NOT NULL default '0',     -- (FK) -> node.nid
  parent int(10) NOT NULL default '0',           -- (FK) -> book.nid (parent id)
  weight tinyint(3) NOT NULL default '0',        -- TBD
  PRIMARY KEY (vid),
  KEY nid (nid),
  KEY parent (parent)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'boxes'
--

CREATE TABLE boxes (
  bid tinyint(4) NOT NULL auto_increment,         -- (PK)
  title varchar(64) NOT NULL default '',          -- TBD
  body longtext,                                  -- TBD
  info varchar(128) NOT NULL default '',          -- (FK) -> filter_formats.format
  format int(4) NOT NULL default '0',             -- TBD
  PRIMARY KEY (bid),
  UNIQUE KEY info (info)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'cache'
--

CREATE TABLE cache (
  cid varchar(255) NOT NULL default '',           -- (PK)
  data longblob,                                  -- TBD
  expire int(11) NOT NULL default '0',            -- TBD
  created int(11) NOT NULL default '0',           -- TBD
  headers text,                                   -- TBD
  PRIMARY KEY (cid),
  INDEX expire (expire)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'comments'
--

CREATE TABLE comments (
  cid int(10) NOT NULL auto_increment,             -- (PK)
  pid int(10) NOT NULL default '0',                -- (FK) -> comments.cid (parent id)
  nid int(10) NOT NULL default '0',                -- (FK) -> node.nid
  uid int(10) NOT NULL default '0',                -- (FK) -> users.uid
  subject varchar(64) NOT NULL default '',         -- TBD
  comment longtext NOT NULL,                       -- TBD
  hostname varchar(128) NOT NULL default '',       -- TBD
  timestamp int(11) NOT NULL default '0',          -- TBD
  score mediumint(9) NOT NULL default '0',         -- TBD
  status tinyint(3) unsigned NOT NULL default '0', -- TBD
  format int(4) NOT NULL default '0',              -- TBD
  thread varchar(255) NOT NULL,                    -- TBD
  users longtext,                                  -- TBD
  name varchar(60) default NULL,                   -- TBD
  mail varchar(64) default NULL,                   -- TBD
  homepage varchar(255) default NULL,              -- TBD
  PRIMARY KEY (cid),
  KEY lid (nid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structre for table 'contact'
--

CREATE TABLE contact (
  cid int(10) unsigned NOT NULL auto_increment,     -- (PK)
  category varchar(255) NOT NULL default '',        -- TBD
  recipients longtext NOT NULL default '',          -- TBD
  reply longtext NOT NULL default '',               -- TBD
  weight tinyint(3) NOT NULL default '0',           -- TBD
  selected tinyint(1) NOT NULL default '0',         -- TBD
  PRIMARY KEY (cid),
  UNIQUE KEY category (category)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structre for table 'node_comment_statistics'
--

CREATE TABLE node_comment_statistics (
  nid int(10) unsigned NOT NULL auto_increment,         -- (FK) -> node.nid
  last_comment_timestamp int(11) NOT NULL default '0',  -- TBD
  last_comment_name varchar(60) default NULL,           -- TBD
  last_comment_uid int(10) NOT NULL default '0',        -- (FK) -> users.uid
  comment_count int(10) unsigned NOT NULL default '0',  -- TBD
  PRIMARY KEY (nid),
  KEY node_comment_timestamp (last_comment_timestamp)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'client'
--

CREATE TABLE client (
  cid int(10) unsigned NOT NULL auto_increment,   -- (PK)
  link varchar(255) NOT NULL default '',          -- TBD
  name varchar(128) NOT NULL default '',          -- TBD
  mail varchar(128) NOT NULL default '',          -- TBD
  slogan longtext NOT NULL,                       -- TBD
  mission longtext NOT NULL,                      -- TBD
  users int(10) NOT NULL default '0',             -- TBD
  nodes int(10) NOT NULL default '0',             -- TBD
  version varchar(35) NOT NULL default'',         -- TBD
  created int(11) NOT NULL default '0',           -- TBD
  changed int(11) NOT NULL default '0',           -- TBD
  PRIMARY KEY (cid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'client_system'
--

CREATE TABLE client_system (
  cid int(10) NOT NULL default '0',               -- (FK) -> client.cid
  name varchar(255) NOT NULL default '',          -- TBD
  type varchar(255) NOT NULL default '',          -- TBD
  PRIMARY KEY (cid,name)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'files'
--

CREATE TABLE files (
  fid int(10) unsigned NOT NULL default 0,        -- (PK)
  nid int(10) unsigned NOT NULL default 0,        -- (FK) -> node.nid
  filename varchar(255) NOT NULL default '',      -- TBD
  filepath varchar(255) NOT NULL default '',      -- TBD
  filemime varchar(255) NOT NULL default '',      -- TBD
  filesize int(10) unsigned NOT NULL default 0,   -- TBD
  PRIMARY KEY (fid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'file_revisions'
--

CREATE TABLE file_revisions (
  fid int(10) unsigned NOT NULL default 0,        -- (FK) -> files.fid
  vid int(10) unsigned NOT NULL default 0,        -- (PK) ???
  description varchar(255) NOT NULL default '',   -- revision log entry
  list tinyint(1) unsigned NOT NULL default 0,    -- TBD
  PRIMARY KEY (fid, vid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'filter_formats'
--

CREATE TABLE filter_formats (
  format int(4) NOT NULL auto_increment,          -- (PK)
  name varchar(255) NOT NULL default '',          -- TBD
  roles varchar(255) NOT NULL default '',         -- (FK list) -> role.rid
  cache tinyint(2) NOT NULL default '0',          -- TBD
  PRIMARY KEY (format),
  UNIQUE KEY (name)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'filters'
--

CREATE TABLE filters (
  format int(4) NOT NULL default '0',             -- (FK) -> filter_formats.format
  module varchar(64) NOT NULL default '',         -- TBD
  delta tinyint(2) DEFAULT '0' NOT NULL,          -- TBD
  weight tinyint(2) DEFAULT '0' NOT NULL,         -- TBD
  INDEX (weight)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'flood'
--

CREATE TABLE flood (
  event varchar(64) NOT NULL default '',          -- TBD
  hostname varchar(128) NOT NULL default '',      -- TBD
  timestamp int(11) NOT NULL default '0'          -- TBD
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'forum'
--

CREATE TABLE forum (
  nid int(10) unsigned NOT NULL default '0',      -- (FK) -> node.nid
  vid int(10) unsigned NOT NULL default '0',      -- (FK) -> node_revisions.vid
  tid int(10) unsigned NOT NULL default '0',      -- (FK) -> term_data.tid
  PRIMARY KEY (vid),
  KEY nid (nid),
  KEY tid (tid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'history'
--

CREATE TABLE history (
  uid int(10) NOT NULL default '0',               -- (FK) -> users.uid
  nid int(10) NOT NULL default '0',               -- (FK) -> node.nid
  timestamp int(11) NOT NULL default '0',         -- TBD
  PRIMARY KEY (uid,nid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'locales_meta'
--

CREATE TABLE locales_meta (
  locale varchar(12) NOT NULL default '',         -- Country code
  name varchar(64) NOT NULL default '',           -- Language name
  enabled int(2) NOT NULL default '0',            -- TBD
  isdefault int(2) NOT NULL default '0',          -- TBD
  plurals int(1) NOT NULL default '0',            -- TBD
  formula varchar(128) NOT NULL default '',       -- TBD
  PRIMARY KEY (locale)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'locales_source'
--

CREATE TABLE locales_source (
  lid int(11) NOT NULL auto_increment,            -- TBD
  location varchar(255) NOT NULL default '',      -- TBD
  source blob NOT NULL,                           -- TBD
  PRIMARY KEY (lid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'locales_target'
--

CREATE TABLE locales_target (
  lid int(11) NOT NULL default '0',               -- TBD
  translation blob NOT NULL,                      -- TBD
  locale varchar(12) NOT NULL default '',         -- TBD
  plid int(11) NOT NULL default '0',              -- TBD
  plural int(1) NOT NULL default '0',             -- TBD
  KEY lid (lid),
  KEY lang (locale),
  KEY plid (plid),
  KEY plural (plural)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'menu'
--

CREATE TABLE menu (
  mid int(10) unsigned NOT NULL default '0',      -- TBD
  pid int(10) unsigned NOT NULL default '0',      -- TBD
  path varchar(255) NOT NULL default '',          -- TBD
  title varchar(255) NOT NULL default '',         -- TBD
  description varchar(255) NOT NULL default '',   -- TBD
  weight tinyint(4) NOT NULL default '0',         -- TBD
  type int(2) unsigned NOT NULL default '0',
  PRIMARY KEY (mid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'node'
--

CREATE TABLE node (
  nid int(10) unsigned NOT NULL auto_increment,   -- (PK)
  vid int(10) unsigned NOT NULL default '0',      -- (FK) -> node_revisions.vid
  type varchar(32) NOT NULL default '',           -- TBD
  title varchar(128) NOT NULL default '',         -- TBD
  uid int(10) NOT NULL default '0',               -- (FK) -> users.uid
  status int(4) NOT NULL default '1',             -- TBD
  created int(11) NOT NULL default '0',           -- TBD
  changed int(11) NOT NULL default '0',           -- TBD
  comment int(2) NOT NULL default '0',            -- TBD
  promote int(2) NOT NULL default '0',            -- TBD
  moderate int(2) NOT NULL default '0',           -- TBD
  sticky int(2) NOT NULL default '0',             -- TBD
  PRIMARY KEY  (nid, vid),
  UNIQUE KEY vid (vid),
  KEY node_type (type(4)),
  KEY node_title_type (title, type(4)),
  KEY status (status),
  KEY uid (uid),
  KEY node_moderate (moderate),
  KEY node_promote_status (promote, status),
  KEY node_created (created),
  KEY node_changed (changed),
  KEY node_status_type (status, type, nid),
  KEY nid (nid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table `node_access`
--

CREATE TABLE node_access (
  nid int(10) unsigned NOT NULL default '0',             -- (FK) -> node.nid
  gid int(10) unsigned NOT NULL default '0',             -- TBD
  realm varchar(255) NOT NULL default '',                -- TBD
  grant_view tinyint(1) unsigned NOT NULL default '0',   -- TBD
  grant_update tinyint(1) unsigned NOT NULL default '0', -- TBD
  grant_delete tinyint(1) unsigned NOT NULL default '0', -- TBD
  PRIMARY KEY (nid,gid,realm)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'node_revisions'
--

CREATE TABLE node_revisions (
  nid int(10) unsigned NOT NULL,                  -- (FK) -> node.nid
  vid int(10) unsigned NOT NULL,                  -- (PK)
  uid int(10) NOT NULL default '0',               -- (FK) -> users.uid
  title varchar(128) NOT NULL default '',         -- TBD
  body longtext NOT NULL default '',              -- TBD
  teaser longtext NOT NULL default '',            -- TBD
  log longtext NOT NULL default '',               -- TBD
  timestamp int(11) NOT NULL default '0',         -- TBD
  format int(4) NOT NULL default '0',             -- TBD
  PRIMARY KEY  (vid),
  KEY nid (nid),
  KEY uid (uid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'profile_fields'
--

CREATE TABLE profile_fields (
  fid int(10) NOT NULL auto_increment,            -- (PK)
  title varchar(255) default NULL,                -- TBD 
  name varchar(128) default NULL,                 -- TBD
  explanation TEXT default NULL,                  -- TBD
  category varchar(255) default NULL,             -- TBD
  page varchar(255) default NULL,                 -- TBD
  type varchar(128) default NULL,                 -- TBD
  weight tinyint(1) DEFAULT '0' NOT NULL,         -- TBD
  required tinyint(1) DEFAULT '0' NOT NULL,       -- TBD
  register tinyint(1) DEFAULT '0' NOT NULL,       -- TBD
  visibility tinyint(1) DEFAULT '0' NOT NULL,     -- TBD
  autocomplete tinyint(1) DEFAULT '0' NOT NULL,   -- TBD
  options text,               -- TBD
  KEY category (category),
  UNIQUE KEY name (name),
  PRIMARY KEY (fid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'profile_values'
--

CREATE TABLE profile_values (
  fid int(10) unsigned default '0',               -- (FK) -> profile_fields.fid
  uid int(10) unsigned default '0',               -- (FK) -> users.uid
  value text,                                     -- TBD
  KEY uid (uid),
  KEY fid (fid)
)
DEFAULT CHARACTER SET utf8;


--
-- Table structure for table 'url_alias'
--

CREATE TABLE url_alias (
  pid int(10) unsigned NOT NULL auto_increment,   -- (FK) -> url_alias.pid
  src varchar(128) NOT NULL default '',           -- TBD
  dst varchar(128) NOT NULL default '',           -- TBD
  PRIMARY KEY (pid),
  UNIQUE KEY dst (dst),
  KEY src (src)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'permission'
--

CREATE TABLE permission (
  rid int(10) unsigned NOT NULL default '0',      -- (FK) -> role.rid
  perm longtext,                                  -- TBD
  tid int(10) unsigned NOT NULL default '0',      -- TBD
  KEY rid (rid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'poll'
--

CREATE TABLE poll (
  nid int(10) unsigned NOT NULL default '0',      -- (FK) -> node.nid
  runtime int(10) NOT NULL default '0',           -- TBD
  active int(2) unsigned NOT NULL default '0',    -- TBD
  PRIMARY KEY (nid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'poll_votes'
--

CREATE TABLE poll_votes (
  nid int(10) unsigned NOT NULL,                  -- (FK) -> node.nid
  uid int(10) unsigned NOT NULL default 0,        -- TBD
  chorder int(10) NOT NULL default -1,            -- TBD
  hostname varchar(128) NOT NULL default '',
  INDEX (nid),
  INDEX (uid),
  INDEX (hostname)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'poll_choices'
--

CREATE TABLE poll_choices (
  chid int(10) unsigned NOT NULL auto_increment,  -- TBD
  nid int(10) unsigned NOT NULL default '0',      -- (FK) -> node.nid
  chtext varchar(128) NOT NULL default '',        -- TBD
  chvotes int(6) NOT NULL default '0',            -- TBD
  chorder int(2) NOT NULL default '0',            -- TBD
  PRIMARY KEY (chid),
  KEY nid (nid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'role'
--

CREATE TABLE role (
  rid int(10) unsigned NOT NULL auto_increment,   -- (PK)
  name varchar(32) NOT NULL default '',           -- TBD
  PRIMARY KEY (rid),
  UNIQUE KEY name (name)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'blocks_roles'
--
CREATE TABLE blocks_roles (
  module varchar(64) NOT NULL,                    -- TBD
  delta varchar(32) NOT NULL,                     -- TBD
  rid int(10) unsigned NOT NULL,                  -- TBD
  PRIMARY KEY (module, delta, rid)
)
/*!40100 DEFAULT CHARACTER SET utf8 */ ;

--
-- Table structure for table 'search_dataset'
--
CREATE TABLE search_dataset (
  sid int(10) unsigned NOT NULL default '0',      -- TBD
  type varchar(16) default NULL,                  -- TBD
  data longtext NOT NULL,                         -- TBD
  KEY sid_type (sid, type)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'search_index'
--

CREATE TABLE search_index (
  word varchar(50) NOT NULL default '',           -- TBD
  sid int(10) unsigned NOT NULL default '0',      -- TBD
  type varchar(16) default NULL,                  -- TBD
  fromsid int(10) unsigned NOT NULL default '0',  -- TBD
  fromtype varchar(16) default NULL,              -- TBD
  score float default NULL,                       -- TBD
  KEY sid_type (sid, type),
  KEY from_sid_type (fromsid, fromtype),
  KEY word (word)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'search_total'
--

CREATE TABLE search_total (
  word varchar(50) NOT NULL default '',           -- TBD
  count float default NULL,                       -- TBD
  PRIMARY KEY (word)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'sessions'
--


CREATE TABLE sessions (
  uid int(10) unsigned NOT NULL,                   -- (FK) -> users.uid
  sid varchar(32) NOT NULL default '',             -- Session ID (PHPSESSID Cookie value)
  hostname varchar(128) NOT NULL default '',       -- client's IP
  timestamp int(11) NOT NULL default '0',          -- TBD
  cache int(11) NOT NULL default '0',              -- TBD
  session longtext,                                -- Serialized session variables
  KEY uid (uid),
  PRIMARY KEY (sid),
  KEY timestamp (timestamp)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'sequences'
--

CREATE TABLE sequences (
  name varchar(255) NOT NULL default '',            -- (PK)
  id int(10) unsigned NOT NULL default '0',         -- Value of sequence counter
  PRIMARY KEY (name)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'node_counter'
--

CREATE TABLE node_counter (
  nid int(10) NOT NULL default '0',                     -- (FK) -> node.nid
  totalcount bigint(20) unsigned NOT NULL default '0',  -- TBD
  daycount mediumint(8) unsigned NOT NULL default '0',  -- TBD
  timestamp int(11) unsigned NOT NULL default '0',      -- TBD
  PRIMARY KEY (nid),
  KEY totalcount (totalcount),
  KEY daycount (daycount),
  KEY timestamp (timestamp)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'system'
--

CREATE TABLE system (
  filename varchar(255) NOT NULL default '',      -- TBD
  name varchar(255) NOT NULL default '',          -- TBD
  type varchar(255) NOT NULL default '',          -- TBD
  description varchar(255) NOT NULL default '',   -- TBD
  status int(2) NOT NULL default '0',             -- TBD
  throttle tinyint(1) DEFAULT '0' NOT NULL,       -- TBD
  bootstrap int(2) NOT NULL default '0',          -- TBD
  schema_version smallint(3) NOT NULL default -1, -- TBD
  weight int(2) NOT NULL default '0',             -- TBD
  PRIMARY KEY (filename),
  KEY (weight)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'term_data'
--

CREATE TABLE term_data (
  tid int(10) unsigned NOT NULL auto_increment,   -- (PK)
  vid int(10) unsigned NOT NULL default '0',      -- (FK) -> vocabulary.vid
  name varchar(255) NOT NULL default '',          -- TBD
  description longtext,                           -- TBD
  weight tinyint(4) NOT NULL default '0',         -- TBD
  PRIMARY KEY (tid),
  KEY vid (vid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'term_hierarchy'
--

CREATE TABLE term_hierarchy (
  tid int(10) unsigned NOT NULL default '0',      -- (FK) -> term_data.tid
  parent int(10) unsigned NOT NULL default '0',   -- (FK) -> term_hierarchy.tid
  KEY tid (tid),
  KEY parent (parent),
  PRIMARY KEY (tid, parent)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'term_node'
--

CREATE TABLE term_node (
  nid int(10) unsigned NOT NULL default '0',      -- (FK) -> node.nid
  tid int(10) unsigned NOT NULL default '0',      -- (FK) -> term_data.tid
  KEY nid (nid),
  KEY tid (tid),
  PRIMARY KEY (tid,nid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'term_relation'
--

CREATE TABLE term_relation (
  tid1 int(10) unsigned NOT NULL default '0',     -- (FK) -> term_data.tid
  tid2 int(10) unsigned NOT NULL default '0',     -- TBD
  KEY tid1 (tid1),
  KEY tid2 (tid2)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'term_synonym'
--

CREATE TABLE term_synonym (
  tid int(10) unsigned NOT NULL default '0',      -- (FK) -> term_data.tid
  name varchar(255) NOT NULL default '',          -- TBD
  KEY tid (tid),
  KEY name (name(3))
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'users'
--

CREATE TABLE users (
  uid int(10) unsigned NOT NULL default '0',      -- (PK)
  name varchar(60) NOT NULL default '',           -- TBD
  pass varchar(32) NOT NULL default '',           -- TBD
  mail varchar(64) default '',                    -- TBD
  mode tinyint(1) NOT NULL default '0',           -- TBD
  sort tinyint(1) default '0',                    -- TBD
  threshold tinyint(1) default '0',               -- TBD
  theme varchar(255) NOT NULL default '',         -- TBD
  signature varchar(255) NOT NULL default '',     -- TBD
  created int(11) NOT NULL default '0',           -- TBD
  access int(11) NOT NULL default '0',            -- TBD
  login int(11) NOT NULL default '0',             -- TBD
  status tinyint(4) NOT NULL default '0',         -- TBD
  timezone varchar(8) default NULL,               -- TBD
  language varchar(12) NOT NULL default '',       -- TBD
  picture varchar(255) NOT NULL DEFAULT '',       -- TBD
  init varchar(64) default '',                    -- TBD
  data longtext,
  PRIMARY KEY (uid),
  UNIQUE KEY name (name),
  KEY access (access)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'users_roles'
--

CREATE TABLE users_roles (
  uid int(10) unsigned NOT NULL default '0',      -- (FK) -> users.uid
  rid int(10) unsigned NOT NULL default '0',      -- (FK) -> role.rid
  PRIMARY KEY (uid, rid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'variable'
--

CREATE TABLE variable (
  name varchar(48) NOT NULL default '',           -- TBD
  value longtext NOT NULL,                        -- TBD
  PRIMARY KEY (name)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'vocabulary'
--

CREATE TABLE vocabulary (
  vid int(10) unsigned NOT NULL auto_increment,       -- (PK)
  name varchar(255) NOT NULL default '',              -- TBD
  description longtext,                               -- TBD
  help varchar(255) NOT NULL default '',              -- TBD
  relations tinyint(3) unsigned NOT NULL default '0', -- TBD
  hierarchy tinyint(3) unsigned NOT NULL default '0', -- TBD
  multiple tinyint(3) unsigned NOT NULL default '0',  -- TBD
  required tinyint(3) unsigned NOT NULL default '0',  -- TBD
  tags tinyint(3) unsigned NOT NULL default '0',      -- TBD
  module varchar(255) NOT NULL default '',            -- TBD
  weight tinyint(4) NOT NULL default '0',             -- TBD
  PRIMARY KEY (vid)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'vocabulary_node_types'
--

CREATE TABLE vocabulary_node_types (
  vid int(10) unsigned NOT NULL DEFAULT '0',      -- (FK) -> vocabulary.vid
  type varchar(32) NOT NULL DEFAULT '',           -- TBD
  PRIMARY KEY (vid, type)
)
DEFAULT CHARACTER SET utf8;

--
-- Table structure for table 'watchdog'
--

CREATE TABLE watchdog (
  wid int(5) NOT NULL auto_increment,                -- (PK)
  uid int(10) NOT NULL default '0',                  -- (FK) -> users.uid
  type varchar(16) NOT NULL default '',              -- TBD
  message longtext NOT NULL,                         -- TBD
  severity tinyint(3) unsigned NOT NULL default '0', -- TBD
  link varchar(255) NOT NULL default '',             -- TBD
  location varchar(128) NOT NULL default '',         -- TBD
  referer varchar(128) NOT NULL default '',          -- HTTP referer
  hostname varchar(128) NOT NULL default '',         -- TBD
  timestamp int(11) NOT NULL default '0',            -- TBD
  PRIMARY KEY (wid)
)
DEFAULT CHARACTER SET utf8;

--
-- Insert some default values
--

INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/block.module', 'block', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/comment.module', 'comment', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/filter.module', 'filter', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/help.module', 'help', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/menu.module', 'menu', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/node.module', 'node', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/page.module', 'page', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/story.module', 'story', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/system.module', 'system', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/taxonomy.module', 'taxonomy', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/user.module', 'user', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/watchdog.module', 'watchdog', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('themes/engines/phptemplate/phptemplate.engine', 'phptemplate', 'theme_engine', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('themes/bluemarine/page.tpl.php', 'bluemarine', 'theme', 'themes/engines/phptemplate/phptemplate.engine', 1, 0, 0, 0);
INSERT INTO users (uid, name, mail) VALUES ('0', '', '');

INSERT INTO role (rid, name) VALUES (1, 'anonymous user');
INSERT INTO role (rid, name) VALUES (2, 'authenticated user');

INSERT INTO permission VALUES (1,'access content',0);
INSERT INTO permission VALUES (2,'access comments, access content, post comments, post comments without approval',0);

INSERT INTO variable (name, value) VALUES ('theme_default', 's:10:"bluemarine";');

INSERT INTO blocks (module, delta, theme, status, pages) VALUES ('user', '0', 'bluemarine', '1', '');
INSERT INTO blocks (module, delta, theme, status, pages) VALUES ('user', '1', 'bluemarine', '1', '');

INSERT INTO sequences (name, id) VALUES ('menu_mid', 2);

INSERT INTO node_access VALUES (0, 0, 'all', 1, 0, 0);

INSERT INTO filter_formats VALUES (1,'Filtered HTML',',1,2,',1);
INSERT INTO filter_formats VALUES (2,'PHP code','',0);
INSERT INTO filter_formats VALUES (3,'Full HTML','',1);
INSERT INTO filters VALUES (1,'filter',0,0);
INSERT INTO filters VALUES (1,'filter',2,1);
INSERT INTO filters VALUES (2,'filter',1,0);
INSERT INTO filters VALUES (3,'filter',2,0);
INSERT INTO variable (name,value) VALUES ('filter_html_1','i:1;');

INSERT INTO locales_meta (locale, name, enabled, isdefault) VALUES ('en', 'English', '1', '1');

INSERT INTO variable (name, value) VALUES ('node_options_forum', 'a:1:{i:0;s:6:"status";}');

INSERT INTO menu VALUES (2, 0, '', 'Primary links', '', 0, 115);
INSERT INTO variable VALUES ('menu_primary_menu', 'i:2;');
INSERT INTO variable VALUES ('menu_secondary_menu', 'i:2;');