Go Back   Computer Forums > General Computing > Programming
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 08-18-2010, 07:19 PM   #1
In Runtime
 
Equinox1354's Avatar
 
Join Date: Apr 2009
Posts: 255
Default SQL Database

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 
-- ----------------------------
__________________

Equinox1354 is offline   Reply With Quote
Old 08-18-2010, 09:33 PM   #2
j03
~~~~~~~~
 
Join Date: Jan 2005
Location: Wales
Posts: 5,556
Send a message via MSN to j03
Default Re: SQL Database

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?
__________________

j03 is offline   Reply With Quote
Old 08-19-2010, 08:52 AM   #3
Site Team
 
root's Avatar
 
Join Date: Mar 2004
Posts: 8,004
Default Re: SQL Database

you need to write

use database name;

at the start
__________________
I didn’t fight my way to the top of the food chain to be a vegetarian…
Im sick of people saying 'dont waste paper'. If trees wanted to live, they'd all carry guns.
"The inherent vice of capitalism is the unequal sharing of blessings; The inherent vice of socialism is the equal sharing of miseries."
root is offline   Reply With Quote
Old 08-19-2010, 10:38 AM   #4
j03
~~~~~~~~
 
Join Date: Jan 2005
Location: Wales
Posts: 5,556
Send a message via MSN to j03
Default Re: SQL Database

Also, I believe that it's FreeSQL.org, not .com.
j03 is offline   Reply With Quote
Old 08-19-2010, 10:42 AM   #5
Site Team
 
berry120's Avatar
 
Join Date: Jul 2009
Location: England, UK
Posts: 3,425
Default Re: SQL Database

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!)
__________________
Save the whales, feed the hungry, free the mallocs.
berry120 is offline   Reply With Quote
Old 09-11-2010, 05:12 AM   #6
Beta Member
 
Join Date: Sep 2010
Posts: 1
Default Re: SQL Database

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');
__________________

adelf is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 04:54 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0