Heres the code:
їphp]
#
# Table structure for table `Cpp`
#
CREATE TABLE Cpp (
ID int(12) NOT NULL auto_increment,
PostedBy varchar(50) default NULL,
Date varchar(15) default NULL,
ReplyID varchar(50) default '0',
Message longtext,
Subject varchar(255) default NULL,
EmailReply varchar(5) default NULL,
LastAccessed varchar(50) default NULL,
KEY ID (ID),
FULLTEXT KEY Message (Message)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `Users`
#
CREATE TABLE Users (
ID int(12) NOT NULL auto_increment,
UserName varchar(50) default NULL,
Password varchar(50) default NULL,
FirstName varchar(50) default NULL,
LastName varchar(50) default NULL,
Email varchar(100) default NULL,
Signature mediumtext,
Admin varchar(5) default 'false',
Date varchar(15) default NULL,
Posts varchar(15) default '0',
AIM varchar(50) default NULL,
ICQ varchar(50) default NULL,
KEY ID (ID),
FULLTEXT KEY Signature (Signature)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `asp`
#
CREATE TABLE asp (
ID int(12) NOT NULL auto_increment,
PostedBy varchar(50) default NULL,
Date varchar(15) default NULL,
ReplyID varchar(50) default '0',
Message longtext,
Subject varchar(255) default NULL,
EmailReply varchar(5) default NULL,
LastAccessed varchar(50) default NULL,
KEY ID (ID),
FULLTEXT KEY Message (Message)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `delphi`
#
CREATE TABLE delphi (
ID int(12) NOT NULL auto_increment,
PostedBy varchar(50) default NULL,
Date varchar(15) default NULL,
ReplyID varchar(50) default '0',
Message longtext,
Subject varchar(255) default NULL,
EmailReply varchar(5) default NULL,
LastAccessed varchar(50) default NULL,
KEY ID (ID),
FULLTEXT KEY Message (Message)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `dotnet`
#
CREATE TABLE dotnet (
ID int(12) NOT NULL auto_increment,
PostedBy varchar(50) default NULL,
Date varchar(15) default NULL,
ReplyID varchar(50) default '0',
Message longtext,
Subject varchar(255) default NULL,
EmailReply varchar(5) default NULL,
LastAccessed varchar(50) default NULL,
KEY ID (ID),
FULLTEXT KEY Message (Message)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `general`
#
CREATE TABLE general (
ID int(12) NOT NULL auto_increment,
PostedBy varchar(50) default NULL,
Date varchar(15) default NULL,
ReplyID varchar(50) default '0',
Message longtext,
Subject varchar(255) default NULL,
EmailReply varchar(5) default NULL,
LastAccessed varchar(50) default NULL,
KEY ID (ID),
FULLTEXT KEY Message (Message)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `java`
#
CREATE TABLE java (
ID int(12) NOT NULL auto_increment,
PostedBy varchar(50) default NULL,
Date varchar(15) default NULL,
ReplyID varchar(50) default '0',
Message longtext,
Subject varchar(255) default NULL,
EmailReply varchar(5) default NULL,
LastAccessed varchar(50) default NULL,
KEY ID (ID),
FULLTEXT KEY Message (Message)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `php`
#
CREATE TABLE php (
ID int(12) NOT NULL auto_increment,
PostedBy varchar(50) default NULL,
Date varchar(15) default NULL,
ReplyID varchar(50) default '0',
Message longtext,
Subject varchar(255) default NULL,
EmailReply varchar(5) default NULL,
LastAccessed varchar(50) default NULL,
KEY ID (ID),
FULLTEXT KEY Message (Message)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sql`
#
CREATE TABLE sql (
ID int(12) NOT NULL auto_increment,
PostedBy varchar(50) default NULL,
Date varchar(15) default NULL,
ReplyID varchar(50) default '0',
Message longtext,
Subject varchar(255) default NULL,
EmailReply varchar(5) default NULL,
LastAccessed varchar(50) default NULL,
KEY ID (ID),
FULLTEXT KEY Message (Message)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `visualbasic`
#
CREATE TABLE visualbasic (
ID int(12) NOT NULL auto_increment,
PostedBy varchar(50) default NULL,
Date varchar(15) default NULL,
ReplyID varchar(50) default '0',
Message longtext,
Subject varchar(255) default NULL,
EmailReply varchar(5) default NULL,
LastAccessed varchar(50) default NULL,
KEY ID (ID),
FULLTEXT KEY Message (Message)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `web`
#
CREATE TABLE web (
ID int(12) NOT NULL auto_increment,
PostedBy varchar(50) default NULL,
Date varchar(15) default NULL,
ReplyID varchar(50) default '0',
Message longtext,
Subject varchar(255) default NULL,
EmailReply varchar(5) default NULL,
LastAccessed varchar(50) default NULL,
KEY ID (ID),
FULLTEXT KEY Message (Message)
) TYPE=MyISAM;ї/php]
Thanks
?>