Just for Newbies
Subject: Re: I have mysql woes too
Posted on: 7 October 1999 by Philip M. Hofer (Frumph)
Post:Discussit has a problem where it doesnt always self create
the appropriate tables necessary for its own database. You
can go in manually and insert the tables it needs.
NOTE: You will have to write some function on your own for adding users to the users table. (also modifying and deleting them)
They Are:
CREATE TABLE users (
userid INTEGER AUTO_INCREMENT PRIMARY KEY,
username char(16),
password char(16),
real_name char(64),
email char(96),
stamp datetime);
CREATE TABLE forum_names (
id INTEGER AUTO_INCREMENT PRIMARY KEY,
forum_name char(64),
forum_description blob,
stamp datetime);
CREATE TABLE read_entries (
userid INTEGER NOT NULL,
article_id INTEGER NOT NULL,
forum_id INTEGER,
stamp datetime,
KEY user_article (userid, article_id))
CREATE TABLE articles (
id integer auto_increment primary key,
forum integer not null,
parent integer default 0,
subject char(255),
userid INTEGER,
text blob,
stats integer,
stamp datetime);
* dont ask my why it doesnt autocreate the tables necessary the documentation sucks, and reading the code doesnt help, but its fun
to use when its working.
[ New Post ] [ Post Reply ] [ Previous Post ] [ Next Post ] [ Previous in Thread ] [ Next in Thread ] [ Forum Index ]
Follow Up:
