SQL Database

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?

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 
-- ----------------------------
 
Hey. That is an SQL query which you would run on a database. You can't specify which server to run it on through actual SQL code. You need to use an SQL client of some sort - be it command line tool, phpmyadmin or an automatic installer. Does freesql provide you with any kind of admin panel?
 
Having a look on the site it does have a link to phpmyadmin, but it doesn't work at present (may be something to do with the message explaining the server crash on the homepage!)
 
sql database is one type of the programming language.
Sql Database language is use to store a data in the database.to use Sql query of the store data in the database.
How to Insert Data in the Database:
INSERT INTO table1(no,name,address) VALUES('1','maulik','address');
 
Back
Top Bottom