Equinox1354
In Runtime
- Messages
- 255
Can anyone help me connect my SQL database to www.freeSql.com:3306
Where do I put it into the database?
Where do I put it into the database?
Code:
/*
wat
wat
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for achievements
-- ----------------------------
DROP TABLE IF EXISTS `achievements`;
CREATE TABLE `achievements` (
`ID` text NOT NULL,
`GMod Racer: Record Breaker` int(11) NOT NULL,
`GMod Racer: Speed Demon` int(11) NOT NULL,
`GMod Racer: Road Rage` int(11) NOT NULL,
`GMod Racer: Destruction Derby` int(11) NOT NULL,
`GMod Racer: Rolling the Rick` int(11) NOT NULL,
`GMod Racer: Bomber` int(11) NOT NULL,
`GMod Racer: Black Worshiper` int(11) NOT NULL,
`Murder: Cold Blood` int(11) NOT NULL,
`Murder: Framed` int(11) NOT NULL,
`Murder: No Rest for the Wicked` int(11) NOT NULL,
`Murder: Short Round` int(11) NOT NULL,
`Murder: Wanna Be Cop` int(11) NOT NULL,
`Murder: Ninja` int(11) NOT NULL,
`Murder: Sharp Shooter` int(11) NOT NULL,
`Murder: Last Stand` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for admin_times
-- ----------------------------
DROP TABLE IF EXISTS `admin_times`;
CREATE TABLE `admin_times` (
`STEAMID` text NOT NULL,
`NAME` text NOT NULL,
`SERVER` text NOT NULL,
`TIME` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for bans
-- ----------------------------
DROP TABLE IF EXISTS `bans`;
CREATE TABLE `bans` (
`ID` text NOT NULL,
`NAME` text NOT NULL,
`UNBAN` int(11) NOT NULL default '0',
`BANNER` text,
`REASON` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for global_chat
-- ----------------------------
DROP TABLE IF EXISTS `global_chat`;
CREATE TABLE `global_chat` (
`server_id` text,
`user_name` text,
`message` text,
`num` int(11) NOT NULL auto_increment,
PRIMARY KEY (`num`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for gmp_coins
-- ----------------------------
DROP TABLE IF EXISTS `gmp_coins`;
CREATE TABLE `gmp_coins` (
`STEAMID` text NOT NULL,
`NAME` text NOT NULL,
`COINS` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for gmp_minigames
-- ----------------------------
DROP TABLE IF EXISTS `gmp_minigames`;
CREATE TABLE `gmp_minigames` (
`NAME` text NOT NULL,
`NUMBER` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for gorpg_items
-- ----------------------------
DROP TABLE IF EXISTS `gorpg_items`;
CREATE TABLE `gorpg_items` (
`user` text,
`item_id` text,
`quantity` int(11) default '1',
`x` int(11) default '0',
`y` int(11) default '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for gorpg_map_vars
-- ----------------------------
DROP TABLE IF EXISTS `gorpg_map_vars`;
CREATE TABLE `gorpg_map_vars` (
`var_name` text,
`var_value` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for gorpg_vars
-- ----------------------------
DROP TABLE IF EXISTS `gorpg_vars`;
CREATE TABLE `gorpg_vars` (
`user` text,
`var_name` text,
`var_value` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for gorpg_vars_quest
-- ----------------------------
DROP TABLE IF EXISTS `gorpg_vars_quest`;
CREATE TABLE `gorpg_vars_quest` (
`user` text,
`var_name` text,
`var_value` int(11) default '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for rp_items
-- ----------------------------
DROP TABLE IF EXISTS `rp_items`;
CREATE TABLE `rp_items` (
`steamid` text NOT NULL,
`item_id` text NOT NULL,
`item_quantity` int(10) unsigned zerofill NOT NULL default '0000000000'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for rp_org
-- ----------------------------
DROP TABLE IF EXISTS `rp_org`;
CREATE TABLE `rp_org` (
`id` int(10) unsigned zerofill NOT NULL auto_increment,
`name` text NOT NULL,
`owner_steamid` text NOT NULL,
`motd` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for rp_users
-- ----------------------------
DROP TABLE IF EXISTS `rp_users`;
CREATE TABLE `rp_users` (
`steamid` text NOT NULL,
`name` text NOT NULL,
`money` int(10) unsigned zerofill NOT NULL default '0000001000',
`free_points` int(10) unsigned zerofill NOT NULL default '0000000006',
`time_played` int(10) unsigned zerofill NOT NULL default '0000000000',
`blacklist` text NOT NULL,
`vehicles` text NOT NULL,
`vehicle_skins` text NOT NULL,
`org` int(10) unsigned zerofill NOT NULL default '0000000000',
`model` text NOT NULL,
`skill_dexterity` int(10) unsigned zerofill NOT NULL default '0000000000',
`skill_stamina` int(10) unsigned zerofill NOT NULL default '0000000000',
`skill_intelligence` int(10) unsigned zerofill NOT NULL default '0000000000',
`skill_strength` int(10) unsigned zerofill NOT NULL default '0000000000',
`skill_craftiness` int(10) unsigned zerofill NOT NULL default '0000000000',
`ammo_pistol` int(10) unsigned zerofill NOT NULL default '0000000000',
`ammo_rifle` int(10) unsigned zerofill NOT NULL default '0000000000',
`ammo_shotgun` int(10) unsigned zerofill NOT NULL default '0000000000'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`ID` text NOT NULL,
`NAME` text NOT NULL,
`RANK` int(11) NOT NULL default '5'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for ve_donations
-- ----------------------------
DROP TABLE IF EXISTS `ve_donations`;
CREATE TABLE `ve_donations` (
`ID` text NOT NULL,
`Ammount` int(11) NOT NULL,
`Claimed` int(11) NOT NULL default '0',
`Name` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for ve_profiles
-- ----------------------------
DROP TABLE IF EXISTS `ve_profiles`;
CREATE TABLE `ve_profiles` (
`SkillLevel_1` int(11) NOT NULL,
`SkillLevel_2` int(11) NOT NULL,
`SkillLevel_3` int(11) NOT NULL,
`SkillLevel_4` int(11) NOT NULL,
`SkillLevel_5` int(11) NOT NULL,
`SkillLevel_6` int(11) NOT NULL,
`SkillLevel_7` int(11) NOT NULL,
`SkillLevel_8` int(11) NOT NULL,
`SkillLevel_9` int(11) NOT NULL,
`OwnsWeapon_1` int(11) NOT NULL,
`OwnsWeapon_2` int(11) NOT NULL,
`OwnsWeapon_3` int(11) NOT NULL,
`OwnsWeapon_4` int(11) NOT NULL,
`OwnsWeapon_5` int(11) NOT NULL,
`OwnsWeapon_6` int(11) NOT NULL,
`OwnsWeapon_7` int(11) NOT NULL,
`OwnsWeapon_8` int(11) NOT NULL,
`OwnsWeapon_9` int(11) NOT NULL,
`OwnsWeapon_10` int(11) NOT NULL,
`OwnsWeapon_11` int(11) NOT NULL,
`OwnsWeapon_12` int(11) NOT NULL,
`OwnsWeapon_13` int(11) NOT NULL,
`OwnsWeapon_14` int(11) NOT NULL,
`SteamID` text NOT NULL,
`Name` text NOT NULL,
`EquipedWep` int(11) NOT NULL,
`EquipedWep_Side` int(11) NOT NULL,
`Cash` int(11) NOT NULL,
`Kills` int(11) NOT NULL,
`Deaths` int(11) NOT NULL,
`Headshots` int(11) NOT NULL,
`TimeSpent` int(11) NOT NULL,
`TimesPlayed` int(11) NOT NULL,
`TimesWon` int(11) NOT NULL,
`Points` int(11) NOT NULL,
`OwnsIronsights` int(11) NOT NULL,
`OwnsFrag` int(11) NOT NULL,
`OwnsSmoke` int(11) NOT NULL,
`Rank` int(11) NOT NULL,
`CustTitle` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for zh_donations
-- ----------------------------
DROP TABLE IF EXISTS `zh_donations`;
CREATE TABLE `zh_donations` (
`ID` text NOT NULL,
`AMMOUNT` int(11) NOT NULL default '0',
`CLAIMED` int(11) NOT NULL default '0',
`NAME` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for zh_players
-- ----------------------------
DROP TABLE IF EXISTS `zh_players`;
CREATE TABLE `zh_players` (
`STEAMID` text NOT NULL,
`KILLS` int(11) NOT NULL,
`NAME` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records
-- ----------------------------