Re: Your Last Copy & Paste!
CREATE TABLE articles (
id INT PRIMARY KEY AUTO_INCREMENT,
title VARCHAR(100) DEFAULT NULL,
text TEXT,
textlimit INT(5) NOT NULL DEFAULT '0',
date DATETIME DEFAULT NULL,
category INT(8) NOT NULL DEFAULT '0',
position CHAR(3),
displaytitle CHAR(3) NOT NULL DEFAULT 'YES',
displayinfo CHAR(3) NOT NULL DEFAULT 'YES',
commentable VARCHAR(5) NOT NULL,
image varchar(30) DEFAULT NULL
);
CREATE TABLE categories (
id int(8) PRIMARY KEY AUTO_INCREMENT,
name varchar(20) NOT NULL,
description varchar(50) NOT NULL,
published varchar(4) NOT NULL DEFAULT 'YES'
);
CREATE TABLE comments (
id INT(11) PRIMARY KEY AUTO_INCREMENT,
articleid INT(11) DEFAULT '0',
name varchar(50) DEFAULT '',
comment TEXT,
time DATETIME NOT NULL DEFAULT ''
);
__________________
-Steve
The things that I've loved the things that I've lost
The things I've held sacred that I've dropped
I won't lie no more you can bet
I don't want to learn what I'll need to forget- Audioslave, "Doesn't Remind Me"
|