108 lines
3.2 KiB
Text
108 lines
3.2 KiB
Text
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'
|
|
);
|