File name: C:\Documents and Settings\Administrator.SCARIA\Desktop\form.sql
Creation date: 10/11/2004
Created by Access to MySQL 3.2 [Demo]
--------------------------------------------------
#
Table structure for table 'tblAlertra'
#
DROP TABLE IF EXISTS tblAlertra;
CREATE TABLE tblAlertra (
AlertraID INT NOT NULL AUTO_INCREMENT,
Interval VARCHAR(50),
AlertraPrice DECIMAL(19,4) DEFAULT 0,
INDEX AlertraID (AlertraID),
PRIMARY KEY PrimaryKey (AlertraID)
);
#
Dumping data for table 'tblAlertra'
#
LOCK TABLES tblAlertra WRITE;
INSERT INTO tblAlertra VALUES(1, '60 Min', 5);
INSERT INTO tblAlertra VALUES(2, '30 Min', 10);
INSERT INTO tblAlertra VALUES(3, '5 Min', 25);
UNLOCK TABLES;
#
Table structure for table 'tblGameinfo'
#
DROP TABLE IF EXISTS tblGameinfo;
CREATE TABLE tblGameinfo (
GameID INT NOT NULL AUTO_INCREMENT,
Game_Name VARCHAR(50),
GamePrice DECIMAL(19,4) DEFAULT 0,
Max_Slots INT DEFAULT 0,
INDEX GameID (GameID),
PRIMARY KEY PrimaryKey (GameID)
);
#
Dumping data for table 'tblGameinfo'
#
LOCK TABLES tblGameinfo WRITE;
INSERT INTO tblGameinfo VALUES(1, 'Unreal Tournament 2004 Vechicles', 3.75, 32);
INSERT INTO tblGameinfo VALUES(2, 'Medal of Honor Allied Assault', 3, 32);
INSERT INTO tblGameinfo VALUES(3, 'Medal of Honor Breakthrough', 3.25, 0);
INSERT INTO tblGameinfo VALUES(4, 'Unreal Tournament 2004 No Vechicles', 3.25, 0);
INSERT INTO tblGameinfo VALUES(5, 'Unreal Tournament 2003', 3, 0);
UNLOCK TABLES;
#
Table structure for table 'tblPeronalInfo'
#
DROP TABLE IF EXISTS tblPeronalInfo;
CREATE TABLE tblPeronalInfo (
PersonalID INT NOT NULL AUTO_INCREMENT,
FirstName VARCHAR(50),
LastName VARCHAR(50),
Address VARCHAR(50),
Address2 VARCHAR(50),
Town VARCHAR(50),
State VARCHAR(50),
ZipCode VARCHAR(50),
Country VARCHAR(50),
Email VARCHAR(50),
Server INT DEFAULT 0,
Game INT DEFAULT 0,
Payment VARCHAR(50),
Players INT DEFAULT 0,
Username VARCHAR(50),
Password VARCHAR(50),
Webhosting INT DEFAULT 0,
Monitoring INT DEFAULT 0,
Notes LONGTEXT,
PRIMARY KEY PrimaryKey (PersonalID),
INDEX tblAlertratblPeronalInfo (Monitoring),
INDEX tblGameinfotblPeronalInfo (Game),
INDEX tblServerInfotblPeronalInfo (Server),
INDEX tblWebhostingtblPeronalInfo (Webhosting),
INDEX Zip Code (ZipCode)
);
#
Dumping data for table 'tblPeronalInfo'
#
LOCK TABLES tblPeronalInfo WRITE;
INSERT INTO tblPeronalInfo VALUES(4, 'Paul', 'Tamarin', '1 Poplar Terrace', "", 'Clark', 'NJ', '07066', 'USA', "", NULL, NULL, "", NULL, "", "", NULL, NULL, "");
INSERT INTO tblPeronalInfo VALUES(5, 'Ya', 'Mudda', '645 Seasme St.', 'apt 5', 'Booville', 'Idaho', '65789', 'USA', "", NULL, NULL, "", NULL, "", "", NULL, NULL, "");
UNLOCK TABLES;
#
Table structure for table 'tblServerInfo'
#
DROP TABLE IF EXISTS tblServerInfo;
CREATE TABLE tblServerInfo (
ServerID INT NOT NULL AUTO_INCREMENT,
Location VARCHAR(50),
Comments LONGTEXT,
PRIMARY KEY PrimaryKey (ServerID),
INDEX ServerID (ServerID)
);
#
Dumping data for table 'tblServerInfo'
#
LOCK TABLES tblServerInfo WRITE;
INSERT INTO tblServerInfo VALUES(1, 'ya mudda', 'zvczxcv');
INSERT INTO tblServerInfo VALUES(2, 'sdfadf', 'sdf');
UNLOCK TABLES;
#
Table structure for table 'tblWebhosting'
#
DROP TABLE IF EXISTS tblWebhosting;
CREATE TABLE tblWebhosting (
WebhostingID INT NOT NULL AUTO_INCREMENT,
Space VARCHAR(50),
Transfer VARCHAR(50),
WebhostingPrice DECIMAL(19,4) DEFAULT 0,
PRIMARY KEY PrimaryKey (WebhostingID),
INDEX WebhostingID (WebhostingID)
);
#
Dumping data for table 'tblWebhosting'
#
LOCK TABLES tblWebhosting WRITE;
INSERT INTO tblWebhosting VALUES(1, '500MB', '5GB', 3);
INSERT INTO tblWebhosting VALUES(2, '1GB', '10GB', 5);
INSERT INTO tblWebhosting VALUES(3, '5GB', '50GB', 12);
UNLOCK TABLES;
