|
|
| |
|
|
| |
 |
Help with mySQL tables
01.12.03, 19:21:16
|
|
|
|
Post #1 (permalink) |
|
|
| |
|
|
Erm, im making my users system for my site but i got errors while working with these tables:
PHP Code:
CREATE TABLE session (
id int(14) NOT NULL auto_increment,
sessionid varchar(255) NOT NULL default '',
username varchar(20) NOT NULL default '',
auth int(14) NOT NULL default '0',
userid int(14) NOT NULL default '0',
firstname varchar(50) NOT NULL default '',
lastname varchar(50) NOT NULL default '',
PRIMARY KEY (id)
);
and
PHP Code:
CREATE TABLE `comments` (
`id` INT(14) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`newsid` INT NOT NULL
`userid` INT(14) NOT NULL,
`comment` TEXT NOT NULL,
`date` TIMESTAMP NOT NULL
);
What am i doing wrong? |
|
|
|
|