Got No Access To MySQL Insert Bit :(
Posted: Sat Sep 20, 2003 5:30 am
I have no access on my host at the moment to insert or upload any .SQL files. So could someone please create a on-the-web-database-install page for me 
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
?>
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
?>