CREATE TABLE bpt_audit_log (
  log_id               INTEGER AUTO_INCREMENT NOT NULL ,
  log_time             DATETIME NOT NULL ,
  log_user             INTEGER NOT NULL ,
  log_ip               VARCHAR(15) NOT NULL ,
  log_module           VARCHAR(30) NOT NULL ,
  log_msg              VARCHAR(250) NOT NULL  ,
PRIMARY KEY (log_id),
INDEX (log_user),
INDEX (log_ip),
INDEX (log_module))
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE TABLE bpt_user_info (
  user_id              INTEGER AUTO_INCREMENT NOT NULL ,
  user_admin           INTEGER NOT NULL ,
  user_status          INTEGER NOT NULL ,
  user_created         DATETIME NOT NULL ,
  user_modified        DATETIME NOT NULL ,
  user_hash            VARCHAR(50) NOT NULL ,
  user_name            VARCHAR(50) NOT NULL ,
  user_firstname       VARCHAR(250) ,
  user_lastname        VARCHAR(250) NOT NULL ,
  user_email           VARCHAR(250) NOT NULL ,
  user_password        VARCHAR(250) NOT NULL ,
  user_properties      TEXT ,
PRIMARY KEY (user_id),
INDEX (user_admin),
INDEX (user_status),
INDEX (user_created),
UNIQUE INDEX (user_hash),
UNIQUE INDEX (user_name),
UNIQUE INDEX (user_email))
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE TABLE bpt_folders (
  folder_id            INTEGER AUTO_INCREMENT NOT NULL ,
  folder_user_id       INTEGER NOT NULL ,
  folder_parent_id     INTEGER ,
  folder_allow_subfolders INTEGER ,
  folder_public        INTEGER ,
  folder_limit         INTEGER ,
  folder_created       DATETIME NOT NULL ,
  folder_modified      DATETIME NOT NULL ,
  folder_title         VARCHAR(250) NOT NULL ,
  folder_orderby       VARCHAR(50) NOT NULL ,
  folder_name          VARCHAR(50) NOT NULL ,
  folder_text          TEXT ,
  folder_props         TEXT ,
PRIMARY KEY (folder_id),
INDEX (folder_user_id),
INDEX (folder_parent_id),
INDEX (folder_allow_subfolders),
INDEX (folder_public),
INDEX (folder_created),
UNIQUE INDEX (folder_name),
FOREIGN KEY (folder_user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE UNIQUE INDEX bpt_folders_title_ndx ON bpt_folders (folder_parent_id, folder_title)

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE TABLE bpt_pages (
  page_id              INTEGER AUTO_INCREMENT NOT NULL ,
  page_user_id         INTEGER NOT NULL ,
  page_folder_id       INTEGER NOT NULL ,
  page_hidden          INTEGER NOT NULL ,
  page_created         DATETIME NOT NULL ,
  page_modified        DATETIME NOT NULL ,
  page_class           VARCHAR(20) ,
  page_title           VARCHAR(250) NOT NULL ,
  page_name            VARCHAR(50) NOT NULL ,
  page_text            TEXT NOT NULL ,
  page_props           TEXT ,
PRIMARY KEY (page_id),
INDEX (page_user_id),
INDEX (page_folder_id),
INDEX (page_hidden),
INDEX (page_created),
INDEX (page_class),
UNIQUE INDEX (page_name),
FOREIGN KEY (page_user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT,
FOREIGN KEY (page_folder_id) REFERENCES bpt_folders (folder_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE TABLE bpt_files (
  file_id              INTEGER AUTO_INCREMENT NOT NULL ,
  file_user_id         INTEGER NOT NULL ,
  file_page_id         INTEGER NOT NULL ,
  file_size            INTEGER ,
  file_created         DATETIME NOT NULL ,
  file_modified        DATETIME NOT NULL ,
  file_mime_type       VARCHAR(30) NOT NULL ,
  file_mime_subtype    VARCHAR(50) NOT NULL ,
  file_path            VARCHAR(250) NOT NULL ,
  file_props           TEXT ,
PRIMARY KEY (file_id),
INDEX (file_user_id),
INDEX (file_page_id),
INDEX (file_created),
INDEX (file_mime_type),
INDEX (file_mime_subtype),
UNIQUE INDEX (file_path),
FOREIGN KEY (file_user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT,
FOREIGN KEY (file_page_id) REFERENCES bpt_pages (page_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE TABLE bpt_comments (
  comment_id           INTEGER AUTO_INCREMENT NOT NULL ,
  comment_user_id      INTEGER NOT NULL ,
  comment_page_id      INTEGER NOT NULL ,
  comment_reply_to     INTEGER ,
  comment_created      DATETIME NOT NULL ,
  comment_modified     DATETIME NOT NULL ,
  comment_subject      VARCHAR(250) NOT NULL ,
  comment_props        TEXT ,
PRIMARY KEY (comment_id),
INDEX (comment_user_id),
INDEX (comment_reply_to),
INDEX (comment_created),
FOREIGN KEY (comment_user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT,
FOREIGN KEY (comment_page_id) REFERENCES bpt_pages (page_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE TABLE bpt_tags (
  tag_id               INTEGER AUTO_INCREMENT NOT NULL ,
  tag_created          DATETIME NOT NULL ,
  tag_name             VARCHAR(50) NOT NULL  ,
PRIMARY KEY (tag_id),
INDEX (tag_created),
UNIQUE INDEX (tag_name))
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE TABLE bpt_page_tag_link (
  rel_id               INTEGER AUTO_INCREMENT ,
  tag_id               INTEGER NOT NULL ,
  page_id              INTEGER NOT NULL ,
  rel_created          DATETIME NOT NULL  ,
PRIMARY KEY (rel_id),
INDEX (tag_id),
INDEX (page_id),
INDEX (rel_created),
FOREIGN KEY (tag_id) REFERENCES bpt_tags (tag_id) ON DELETE RESTRICT,
FOREIGN KEY (page_id) REFERENCES bpt_pages (page_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE UNIQUE INDEX tag_page_ndx ON bpt_page_tag_link (tag_id, page_id)

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE TABLE bpt_tag_user_link (
  tag_id               INTEGER NOT NULL ,
  user_id              INTEGER NOT NULL ,
  rel_created          DATETIME NOT NULL ,
INDEX (tag_id),
INDEX (user_id),
INDEX (rel_created),
FOREIGN KEY (tag_id) REFERENCES bpt_tags (tag_id) ON DELETE RESTRICT,
FOREIGN KEY (user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE UNIQUE INDEX tag_user_ndx ON bpt_tag_user_link (tag_id, user_id)

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE TABLE bpt_ratings (
  rate_id              INTEGER AUTO_INCREMENT NOT NULL ,
  rate_page_id         INTEGER NOT NULL ,
  rate_user_id         INTEGER NOT NULL ,
  rate_rating          INTEGER NOT NULL  ,
PRIMARY KEY (rate_id),
FOREIGN KEY (rate_page_id) REFERENCES bpt_pages (page_id) ON DELETE RESTRICT,
FOREIGN KEY (rate_user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE UNIQUE INDEX rate_ndx ON bpt_ratings (rate_page_id, rate_user_id)

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE TABLE bpt_search_text (
  obj_class            VARCHAR(10) NOT NULL ,
  obj_id               INTEGER NOT NULL ,
  obj_text             TEXT NOT NULL )
ENGINE=MyISAM
DEFAULT CHARSET=utf8

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE UNIQUE INDEX search_ndx ON bpt_search_text (obj_class, obj_id)

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE FULLTEXT INDEX search_full_ndx on bpt_search_text (obj_text)

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE TABLE bpt_text (
  text_id              INTEGER AUTO_INCREMENT NOT NULL ,
  text_created         DATETIME NOT NULL ,
  text_modified        DATETIME NOT NULL ,
  text_name            VARCHAR(50) NOT NULL ,
  text_title           VARCHAR(250) ,
  text_body            TEXT ,
  text_props           TEXT ,
PRIMARY KEY (text_id),
INDEX (text_created),
UNIQUE INDEX (text_name))
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE TABLE bpt_properties (
  name                 VARCHAR(50) NOT NULL ,
  value                TEXT  ,
PRIMARY KEY (name),
UNIQUE INDEX (name))
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE TABLE bpt_invitations (
  inv_id               INTEGER AUTO_INCREMENT NOT NULL ,
  inv_user_id          INTEGER NOT NULL ,
  inv_accepted         INTEGER NOT NULL ,
  inv_created          DATETIME NOT NULL ,
  inv_modified         DATETIME NOT NULL ,
  inv_email            VARCHAR(250) NOT NULL ,
  inv_hash             VARCHAR(50) NOT NULL ,
  inv_properties       TEXT ,
PRIMARY KEY (inv_id),
INDEX (inv_user_id),
INDEX (inv_accepted),
UNIQUE INDEX (inv_hash),
FOREIGN KEY (inv_user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE UNIQUE INDEX inv_user_email ON bpt_invitations (inv_user_id,inv_email)

Table 'raleigh_raleighwood.bpt_user_info' doesn't exist

CREATE TABLE bpt_subscriptions (
  sub_id               INTEGER AUTO_INCREMENT NOT NULL ,
  sub_user_id          INTEGER NOT NULL ,
  sub_folder_id        INTEGER NOT NULL ,
  sub_created          DATETIME NOT NULL ,
  sub_modified         DATETIME NOT NULL ,
  sub_properties       TEXT ,
PRIMARY KEY (sub_id),
INDEX (sub_user_id),
INDEX (sub_folder_id),
FOREIGN KEY (sub_user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT,
FOREIGN KEY (sub_folder_id) REFERENCES bpt_folders (folder_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Completed OK

CREATE UNIQUE INDEX sub_user_id_ndx ON bpt_subscriptions (sub_user_id,sub_folder_id)

Completed OK

CREATE TABLE bpt_memoranda (
  memo_id              INTEGER AUTO_INCREMENT NOT NULL ,
  memo_read            INTEGER NOT NULL ,
  memo_to_user_id      INTEGER NOT NULL ,
  memo_from_user_id    INTEGER NOT NULL ,
  memo_created         DATETIME NOT NULL ,
  memo_modified        DATETIME NOT NULL ,
  memo_subject         VARCHAR(250) NOT NULL ,
  memo_props           TEXT ,
PRIMARY KEY (memo_id),
INDEX (memo_read),
INDEX (memo_to_user_id),
INDEX (memo_from_user_id),
INDEX (memo_created),
FOREIGN KEY (memo_to_user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT,
FOREIGN KEY (memo_from_user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Completed OK

CREATE TABLE bpt_favorites (
  fav_id               INTEGER AUTO_INCREMENT NOT NULL ,
  user_id              INTEGER NOT NULL ,
  fav_user_id          INTEGER NOT NULL ,
  fav_created          DATETIME  ,
PRIMARY KEY (fav_id),
INDEX (user_id),
INDEX (fav_user_id),
INDEX (fav_created),
FOREIGN KEY (user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT,
FOREIGN KEY (fav_user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Completed OK

CREATE UNIQUE INDEX tag_page_ndx ON bpt_favorites (user_id, fav_user_id)

Completed OK

CREATE TABLE bpt_quotes (
  quote_id             INTEGER AUTO_INCREMENT NOT NULL ,
  quote_user_id        INTEGER NOT NULL ,
  quote_created        DATETIME ,
  quote_modified       DATETIME ,
  quote_properties     TEXT ,
PRIMARY KEY (quote_id),
INDEX (quote_user_id),
INDEX (quote_created),
INDEX (quote_modified),
FOREIGN KEY (quote_user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Completed OK

CREATE TABLE bpt_templates (
  tpl_id               INTEGER AUTO_INCREMENT NOT NULL ,
  tpl_user_id          INTEGER NOT NULL ,
  tpl_public           INTEGER NOT NULL ,
  tpl_created          DATETIME ,
  tpl_modified         DATETIME ,
  tpl_class            VARCHAR(15) NOT NULL ,
  tpl_name             VARCHAR(250) NOT NULL ,
  tpl_properties       TEXT ,
PRIMARY KEY (tpl_id),
INDEX (tpl_user_id),
INDEX (tpl_public),
INDEX (tpl_created),
INDEX (tpl_modified),
INDEX (tpl_class),
UNIQUE INDEX (tpl_name),
FOREIGN KEY (tpl_user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Completed OK

CREATE TABLE bpt_user_log_raw (
  log_user_id          INTEGER NOT NULL ,
  log_b_cookie         VARCHAR(40) ,
  log_created          DATETIME ,
  log_script           VARCHAR(250) ,
  log_server_protocol  VARCHAR(10) ,
  log_request_method   VARCHAR(5) ,
  log_referer          VARCHAR(250) ,
  log_user_agent       VARCHAR(250) ,
  log_remote_addr      VARCHAR(15) ,
  log_remote_host      VARCHAR(250) ,
  log_request_uri      VARCHAR(250) )
ENGINE=ARCHIVE
DEFAULT CHARSET=utf8

Completed OK

CREATE TABLE bpt_folder_access_list (
  acl_folder_id        INTEGER NOT NULL ,
  acl_user_id          INTEGER NOT NULL ,
INDEX (acl_folder_id),
INDEX (acl_user_id),
FOREIGN KEY (acl_folder_id) REFERENCES bpt_folders (folder_id) ON DELETE RESTRICT,
FOREIGN KEY (acl_user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Completed OK

CREATE TABLE bpt_links (
  link_id              INTEGER AUTO_INCREMENT NOT NULL ,
  link_user_id         INTEGER NOT NULL ,
  link_num_visits      INTEGER NOT NULL ,
  link_created         DATETIME NOT NULL ,
  link_modified        DATETIME NOT NULL ,
  link_text            VARCHAR(250) ,
  link_url             VARCHAR(250) ,
  link_properties      TEXT ,
PRIMARY KEY (link_id),
INDEX (link_user_id),
INDEX (link_created),
INDEX (link_modified),
INDEX (link_text),
INDEX (link_url),
FOREIGN KEY (link_user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Completed OK

CREATE UNIQUE INDEX bpt_links_user_link_ndx ON bpt_links (link_user_id, link_text)

Completed OK

CREATE TABLE bpt_page_link_link (
  link_id              INTEGER NOT NULL ,
  page_id              INTEGER NOT NULL ,
  link_rel_created     DATETIME NOT NULL ,
INDEX (link_id),
INDEX (page_id),
INDEX (link_rel_created),
FOREIGN KEY (link_id) REFERENCES bpt_links (link_id) ON DELETE RESTRICT,
FOREIGN KEY (page_id) REFERENCES bpt_pages (page_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Completed OK

CREATE UNIQUE INDEX link_page_ndx ON bpt_page_link_link (link_id, page_id)

Completed OK

CREATE TABLE bpt_groups (
  group_id             INTEGER AUTO_INCREMENT NOT NULL ,
  group_open           INTEGER ,
  group_user_id        INTEGER NOT NULL ,
  group_created        DATETIME NOT NULL ,
  group_modified       DATETIME NOT NULL ,
  group_name           VARCHAR(50) NOT NULL ,
  group_title          VARCHAR(250) NOT NULL ,
  group_properties     TEXT ,
PRIMARY KEY (group_id),
INDEX (group_open),
INDEX (group_user_id),
UNIQUE INDEX (group_name),
UNIQUE INDEX (group_title),
FOREIGN KEY (group_user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Completed OK

CREATE TABLE bpt_group_users (
  r_group_id           INTEGER NOT NULL ,
  r_user_id            INTEGER NOT NULL ,
INDEX (r_group_id),
INDEX (r_user_id),
FOREIGN KEY (r_group_id) REFERENCES bpt_groups (group_id) ON DELETE RESTRICT,
FOREIGN KEY (r_user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Completed OK

CREATE UNIQUE INDEX bpt_group_users_g_u_ndx ON bpt_group_users (r_group_id, r_user_id)

Completed OK

CREATE TABLE bpt_tag_views (
  view_tag_id          INTEGER NOT NULL ,
  view_user_id         INTEGER NOT NULL ,
  view_created         DATETIME NOT NULL ,
INDEX (view_tag_id),
INDEX (view_user_id),
INDEX (view_created),
FOREIGN KEY (view_tag_id) REFERENCES bpt_tags (tag_id) ON DELETE RESTRICT,
FOREIGN KEY (view_user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Completed OK

CREATE TABLE bpt_rss (
  rss_id               INTEGER AUTO_INCREMENT ,
  rss_user_id          INTEGER NOT NULL ,
  rss_ttl              INTEGER NOT NULL ,
  rss_created          DATETIME NOT NULL ,
  rss_modified         DATETIME NOT NULL ,
  rss_url              VARCHAR(250) NOT NULL ,
  rss_text             TEXT ,
  rss_array            TEXT ,
  rss_props            TEXT ,
PRIMARY KEY (rss_id),
INDEX (rss_user_id),
INDEX (rss_created),
UNIQUE INDEX (rss_url),
FOREIGN KEY (rss_user_id) REFERENCES bpt_user_info (user_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Completed OK

CREATE TABLE bpt_trackbacks (
  tb_id                INTEGER AUTO_INCREMENT NOT NULL ,
  tb_page_id           INTEGER NOT NULL ,
  tb_created           DATETIME NOT NULL ,
  tb_modified          DATETIME NOT NULL ,
  tb_title             VARCHAR(250) ,
  tb_url               VARCHAR(250) ,
  tb_blog_name         VARCHAR(250) ,
  tb_props             TEXT ,
PRIMARY KEY (tb_id),
INDEX (tb_created),
INDEX (tb_title),
INDEX (tb_url),
INDEX (tb_blog_name),
FOREIGN KEY (tb_page_id) REFERENCES bpt_pages (page_id) ON DELETE RESTRICT)
ENGINE=InnoDB
DEFAULT CHARSET=utf8

Completed OK

Administrator user created

A copy of the SQL used to create the database has been saved in files/setup.sql