Page 1 of 1

Got No Access To MySQL Insert Bit :(

Posted: Sat Sep 20, 2003 5:30 am
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 ;)
?>

Posted: Sat Sep 20, 2003 1:22 pm
by McGruff
You can run a .sql file with a db manager like phpMyadmin http://www.phpmyadmin.net/ or SQLyog http://www.webyog.com/

Posted: Sun Sep 21, 2003 7:30 am
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

Posted: Mon Sep 22, 2003 9:38 am
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 ;)