I am extremely new to MySQL and web databse programming. I am runnning an Invision Board forum and have had numerous problems when installing mods (I know, install at my own risk, blah blah blah). My question is this: I am restoring the SQL database (I did make a backup; I'm not completely stupid), and I am trying to restore it (all the table are in parts). I came to the ibf_posts table (name of table is irrelevant) and am trying to make it create the table on my new database.
CREATE TABLE ibf_posts (
pid int(10) NOT NULL default "" auto_increment,
append_edit tinyint(1),
edit_time int(10),
author_id mediumint(8) NOT NULL default "0",
author_name varchar(32),
use_sig tinyint(1) NOT NULL default "0",
use_emo tinyint(1) NOT NULL default "0",
ip_address varchar(16) NOT NULL default "",
post_date int(10),
icon_id smallint(3),
post text, - Here's my problem: I didn't change this line; it worked fine in the old DB, so what's wrong with my syntax
queued tinyint(1),
topic_id int(10) NOT NULL default "0",
forum_id smallint(5) NOT NULL default "0",
attach_id varchar(64),
attach_hits int(10),
attach_type varchar(128),
attach_file varchar(255),
post_title varchar(255),
new_topic tinyint(1),
edit_name varchar(255),
PRIMARY KEY (pid),
UNIQUE topic_id (topic_id,author_id),
UNIQUE author_id (author_id),
UNIQUE forum_id (forum_id,post_date),
UNIQUE post (post)
);
