This file contains the SQL code to build out the databases, you really don't
need to be looking in there ya know!


create table forums
  (
    forum_id int(10) not null auto_increment,
    forum_order int(10) null,
    forum_name varchar(64) not null,
    forum_desc varchar(255) not null,
    primary key(forum_id)
  );

create table threads
  (
    thread_id int(10) not null auto_increment,
    thread_title varchar(64) not null,
    thread_body text not null,
    thread_time timestamp(14) not null,
    user_id int(10) not null,
    user_ip varchar(15) not null,
    forum_id int(10) not null,
    primary key(thread_id)
  );

create table users
  (
    user_id int(10) not null auto_increment,
    user_name varchar(64) not null,
    user_email varchar(128) not null,
    user_pass varchar(64) not null,
    user_location varchar(128) null,
    user_occupation varchar(64) null,
    user_homepage varchar(128) null,
    user_picture varchar(128) null,
    user_interests varchar(255) null,
    user_aim varchar(16) null,
    user_icq varchar(16) null,
    user_yahoo varchar(32) null,
    user_signature varchar(255) null,
    user_usesig int(1) null default '0',
    primary key(user_id)
  );

create table replies
  (
    reply_id int(10) not null auto_increment,
    reply_body text not null,
    reply_time timestamp(14) not null,
    user_id int(10) not null,
    user_ip varchar(15) not null,
    thread_id int(10) not null,
    forum_id int(10) not null,
    primary key(reply_id)
  );

create table moderators
  (
    moderator_id int(10) not null auto_increment,
    user_id int(10) not null,
    forum_id int(10) not null,
    primary key(moderator_id)
  );

create table administrators
  (
    admin_id int(10) not null auto_increment,
    user_id int(10) not null,
    primary key(admin_id)
  );

create table messages
  (
    message_id int(10) not null auto_increment,
    message_name varchar(64) not null,
    message_body text not null,
    primary key(message_id)
  );

create table schemes
  (
    scheme_id int(10) not null auto_increment,
    scheme_name varchar(64) not null,
    scheme_desc varchar(255) not null default 'No description provided.',
    background_color varchar(7) not null default '#FFFFFF',
    table_border_color varchar(7) not null default '#000000',
    table_border_size int(1) not null default '1',
    header_background varchar(7) not null default '#FFFFFF',
    menu_background varchar(7) not null default '#EEEEEE',
    text_color varchar(7) not null default '#000000',
    text_font varchar(64) not null default 'Verdana',
    text_small int(2) not null default '10',
    text_regular int(2) not null default '12',
    link_color varchar(7) not null default '#000000',
    table_header_background varchar(7) not null default '#000000',
    table_header_text_color varchar(7) not null default '#FFFFFF',
    table_color_1 varchar(7) not null default '#EEEEEE',
    table_color_2 varchar(7) not null default '#CCCCCC',
    error_message varchar(7) not null default '#FF0000',
    active_scheme varchar(1) not null default '0',
    primary key(scheme_id)
  );

create table properties
  (
    board_name varchar(64) not null default 'Forums',
    title_image varchar(128) not null default './images/title.png'
  );