Jump to content


fred

Member Since 30 Oct 2003
Offline Last Active Dec 13 2003 09:33 PM

Posts I've Made

In Topic: Move to Hosted

20 November 2003 - 09:31 PM

hey

there was an error in the users table of the tfh database.

could someone please drop that table and put this one in instead?

CREATE TABLE users (
id int(25) NOT NULL AUTO_INCREMENT,
permission int(25) NOT NULL default '1',
email_address varchar(255) NOT NULL default '',
username varchar(25) NOT NULL default '',
password varchar(255) NOT NULL default '',
country varchar(255) NOT NULL,
work varchar(255) NOT NULL,
sides varchar(255) NOT NULL,
signup_date datetime NOT NULL default '0000-00-00 00:00:00',
activated enum('0','1') default '1',
decrypted_password varchar(255) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY username (username)
);



thanks,

fred

In Topic: Move to Hosted

16 November 2003 - 08:04 PM

if you make a new database for tfh, could you please use the following (some minor changes to the original):

CREATE TABLE news (
id int(25) NOT NULL AUTO_INCREMENT,
title varchar(100) NOT NULL default '',
date datetime NOT NULL default '0000-00-00 00:00:00',
username varchar(25) NOT NULL default '',
type varchar(25) NOT NULL default 'news',
body text NOT NULL,
PRIMARY KEY (id)
);

CREATE TABLE users (
id int(25) NOT NULL AUTO_INCREMENT,
email_address varchar(255) NOT NULL default '',
username varchar(25) NOT NULL default '',
password varchar(255) NOT NULL default '',
country varchar(255) NOT NULL,
work varchar(255) NOT NULL,
sides varchar(255) NOT NULL,
signup_date datetime NOT NULL default '0000-00-00 00:00:00',
activated enum('0','1') default '1',
decrypted_password varchar(255) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY username (username)
);

CREATE TABLE vars (
variable varchar(255) NOT NULL default '',
value varchar(255) NOT NULL default '',
UNIQUE KEY variable (variable)
);

INSERT INTO vars VALUES('newsid','0');
INSERT INTO vars VALUES('userid','0');
INSERT INTO vars VALUES('users','0');
INSERT INTO vars VALUES('visits','0');

thanks
fred

In Topic: Move to Hosted

03 November 2003 - 02:22 AM

thanks

everything works now :lol:

In Topic: Move to Hosted

02 November 2003 - 05:08 PM

Hello,
I have a request for some database help.
I tried to create a table in the our (tfh) database. For some reason, it won't let me do it though php.
Could someone (i heard Detail could do this) insert two tables into the database so that we could make our site functional. I have the sql files and commands that would be needed to insert them.

thanks,
fred