This always gives me trouble.
Can anyone see the problem with this?
CREATE TABLE Posts(
post_id INT(10) NOT NULL ,
post_ticket_id INT(6) NOT NULL ,
post_subject VARCHAR(255) NULL ,
post_body TEXT(1000) NOT NULL ,
post_timestamp INT(15) NOT NULL ,
PRIMARY KEY (post_id),
UNIQUE (post_id)
)
Can anyone see the problem with this?
CREATE TABLE Posts(
post_id INT(10) NOT NULL ,
post_ticket_id INT(6) NOT NULL ,
post_subject VARCHAR(255) NULL ,
post_body TEXT(1000) NOT NULL ,
post_timestamp INT(15) NOT NULL ,
PRIMARY KEY (post_id),
UNIQUE (post_id)
)