Got No Access To MySQL Insert Bit :(

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Dale
Forum Contributor
Posts: 466
Joined: Fri Jun 21, 2002 5:57 pm
Location: Atherstone, Warks

Got No Access To MySQL Insert Bit :(

Post by Dale »

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 ;)
?>
McGruff
DevNet Master
Posts: 2893
Joined: Thu Jan 30, 2003 8:26 pm
Location: Glasgow, Scotland

Post by McGruff »

You can run a .sql file with a db manager like phpMyadmin http://www.phpmyadmin.net/ or SQLyog http://www.webyog.com/
Nay
Forum Regular
Posts: 951
Joined: Fri Jun 20, 2003 11:03 am
Location: Brisbane, Australia

Post by Nay »

Or...

I'm not sure about this but maybe you can do a create.php or so with that code above with mysql_query().

-Nay
Dale
Forum Contributor
Posts: 466
Joined: Fri Jun 21, 2002 5:57 pm
Location: Atherstone, Warks

Post by Dale »

Nay wrote:Or...

I'm not sure about this but maybe you can do a create.php or so with that code above with mysql_query().

-Nay
Thats what i would like and i have only got access to a public library computer so i cant install anything. So would it be ok if someone actually created that install script for me please ;)
Post Reply