Hi,
assume a table as follows:
CREATE TABLE Posts (
Board varchar(100) NOT NULL,
Number int(11) unsigned NOT NULL auto_increment,
Posted int(11) unsigned DEFAULT '0' NOT NULL,
Subject text,
Body text,
PRIMARY KEY (Number),
KEY index1 (Number, Board),
KEY index2 (Board),
Hi,
assume a table as follows:
CREATE TABLE Posts (
Board varchar(100) NOT NULL,
Number int(11) unsigned NOT NULL auto_increment,
Posted int(11) unsigned DEFAULT '0' NOT NULL,
Subject text,
Body text,
PRIMARY KEY (Number),
KEY index1 (Number, Board),
KEY index2 (Board),