I got the following tables right now -- Categories, Forums, Subforums, Topics and Posts.
I'm stuck on the Topics table because a topic could either be in a forum or a subforum.
Do I need one or two cells for forum/subforum?
Code:
function createUserTable() {
global $usernameMaxLength, $emailMaxLength, $nameMaxLength;
$query =
"CREATE TABLE users(
id INT NOT NULL AUTO_INCREMENT,
username VARCHAR(".$usernameMaxLength.") NOT NULL,
password VARCHAR(32) NOT NULL,
email VARCHAR(".$emailMaxLength.") NOT NULL,
firstname VARCHAR(".$nameMaxLength.") NOT NULL,
lastname VARCHAR(".$nameMaxLength.") NOT NULL,
avatar VARCHAR(30) NOT NULL,
website VARCHAR(128) NOT NULL,
signature TEXT NULL,
powerlevel TINYINT NOT NULL DEFAULT '1',
PRIMARY KEY(id)
) ENGINE=INNODB";
return mysql_query($query);
}
function createChatTable() {
global $usernameMaxLength;
$query =
"CREATE TABLE chat(
id INT NOT NULL AUTO_INCREMENT,
userid INT NOT NULL,
date DATETIME NOT NULL,
text TEXT NULL,
PRIMARY KEY(id)
) ENGINE=INNODB";
return mysql_query($query);
}
function createPMTable() {
$query =
"CREATE TABLE pms(
id INT NOT NULL AUTO_INCREMENT,
from INT NOT NULL,
to INT NOT NULL,
subject VARCHAR(255) NOT NULL,
date DATETIME NOT NULL,
text TEXT NULL,
PRIMARY KEY(id)
) ENGINE=INNODB";
return mysql_query($query);
}
function createCategoriesTable() {
$query =
"CREATE TABLE categories(
id INT NOT NULL AUTO_INCREMENT,
title VARCHAR(128) NOT NULL,
description VARCHAR(128) NOT NULL,
PRIMARY KEY(id)
) ENGINE=INNODB";
return mysql_query($query);
}
function createForumsTable() {
$query =
"CREATE TABLE forums(
id INT NOT NULL AUTO_INCREMENT,
category INT NOT NULL,
title VARCHAR(255) NOT NULL,
comment TEXT NULL,
leader INT NOT NULL,
permissions INT NOT NULL
PRIMARY KEY(id)
) ENGINE=INNODB";
return mysql_query($query);
}
function createSubforumsTable() {
$query =
"CREATE TABLE forums(
id INT NOT NULL AUTO_INCREMENT,
forum INT NOT NULL,
title VARCHAR(255) NOT NULL,
comment TEXT NULL,
leader INT NOT NULL,
permissions INT NOT NULL
PRIMARY KEY(id)
) ENGINE=INNODB";
return mysql_query($query);
}
function createTopicsTable() {
$query =
"CREATE TABLE topics(
id INT NOT NULL AUTO_INCREMENT,
forum INT NOT NULL,
subforum INT NOT NULL,
title VARCHAR(128) NOT NULL,
comment VARCHAR(128) NOT NULL,
creator INT NOT NULL,
PRIMARY KEY(id)
) ENGINE=INNODB";
return mysql_query($query);
}
function createPostsTable() {
$query =
"CREATE TABLE posts(
id INT NOT NULL AUTO_INCREMENT,
topic INT NOT NULL,
poster INT NOT NULL,
text TEXT NULL,
PRIMARY KEY(id)
) ENGINE=INNODB";
return mysql_query($query);
}
EDIT: Never mind, I just decided not to include subforums unless it's a bad idea to have forums without subforums or something.
Last edited by Guest on 23 Jul 2007 06:38:14 pm; edited 1 time in total |
General Coding and Design => Calculator Programming
