Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

please help


  • Please log in to reply

#1
playmate19

playmate19

    New Member

  • Member
  • Pip
  • 7 posts
okay ive made the database but when i go to put the tables in i get this error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'read enum('0','1') NOT NULL default '0',
ticket varchar(100) NOT NULL default' at line 5


this is what im putting into the database


-- Table structure for table `attempts`
--

DROP TABLE IF EXISTS attempts;
CREATE TABLE attempts (
id int(32) NOT NULL default '0',
attacker varchar(100) NOT NULL default '',
target varchar(100) NOT NULL default '',
outcome enum('Alive','Dead') NOT NULL default 'Alive',
time varchar(100) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `attempts`
--


--
-- Table structure for table `auctions`
--

DROP TABLE IF EXISTS auctions;
CREATE TABLE auctions (
id int(32) NOT NULL auto_increment,
highest varchar(100) NOT NULL default '',
last varchar(100) NOT NULL default '',
item varchar(100) NOT NULL default '',
username varchar(100) NOT NULL default '',
min varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `auctions`
--


--
-- Table structure for table `ban`
--

DROP TABLE IF EXISTS ban;
CREATE TABLE ban (
id int(32) NOT NULL auto_increment,
username varchar(100) NOT NULL default '',
reason varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `ban`
--


--
-- Table structure for table `carsales`
--

DROP TABLE IF EXISTS carsales;
CREATE TABLE carsales (
carid int(32) NOT NULL auto_increment,
car varchar(100) NOT NULL default '',
owner varchar(100) NOT NULL default '',
damage varchar(100) NOT NULL default '',
value varchar(100) NOT NULL default '',
original varchar(100) NOT NULL default '',
price varchar(100) NOT NULL default '',
PRIMARY KEY (carid)
) TYPE=MyISAM;

--
-- Dumping data for table `carsales`
--

INSERT INTO carsales (carid, car, owner, damage, value, original, price) VALUES (2,'Smart Roadster','','47','8872','','1000');

--
-- Table structure for table `chat`
--

DROP TABLE IF EXISTS chat;
CREATE TABLE chat (
id int(32) NOT NULL auto_increment,
username varchar(100) NOT NULL default '',
date varchar(100) NOT NULL default '',
bericht varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `chat`
--


--
-- Table structure for table `countries`
--

DROP TABLE IF EXISTS countries;
CREATE TABLE countries (
id int(32) NOT NULL auto_increment,
country enum('Holland','USA') NOT NULL default 'Holland',
blackjack varchar(100) NOT NULL default '',
blackjack_max varchar(100) NOT NULL default '',
blackjack_profit varchar(100) NOT NULL default '',
bulletfactory varchar(100) NOT NULL default '',
bullet_time varchar(100) NOT NULL default '',
bullet_stock varchar(100) NOT NULL default '',
bullet_price bigint(100) NOT NULL default '1000',
bullet_produce enum('0','1') NOT NULL default '0',
slots varchar(100) NOT NULL default '',
racetrack varchar(100) NOT NULL default '',
race varchar(100) NOT NULL default '',
roullette varchar(100) NOT NULL default '',
slots_max varchar(100) NOT NULL default '',
racetrack__max varchar(100) NOT NULL default '',
race_max varchar(100) NOT NULL default '',
roulette_max varchar(100) NOT NULL default '',
roulette_profit varchar(100) NOT NULL default '',
race_profit varchar(100) NOT NULL default '',
racetrack_profit varchar(100) NOT NULL default '',
slots_profit varchar(100) NOT NULL default '',
coin varchar(100) NOT NULL default '',
coin_max varchar(100) NOT NULL default '',
coin_profit varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `countries`
--

INSERT INTO countries (id, country, blackjack, blackjack_max, blackjack_profit, bulletfactory, bullet_time, bullet_stock, bullet_price, bullet_produce, slots, racetrack, race, roullette, slots_max, racetrack__max, race_max, roulette_max, roulette_profit, race_profit, racetrack_profit, slots_profit, coin, coin_max, coin_profit) VALUES (2,'USA','','','','','','',1000,'0','','','','','','','','','','','','','','','');
INSERT INTO countries (id, country, blackjack, blackjack_max, blackjack_profit, bulletfactory, bullet_time, bullet_stock, bullet_price, bullet_produce, slots, racetrack, race, roullette, slots_max, racetrack__max, race_max, roulette_max, roulette_profit, race_profit, racetrack_profit, slots_profit, coin, coin_max, coin_profit) VALUES (1,'Holland','','','','subzero2005','','',1000,'0','','','','','','','','','','','','','','','');

--
-- Table structure for table `crews`
--

DROP TABLE IF EXISTS crews;
CREATE TABLE crews (
id int(32) NOT NULL auto_increment,
crewname varchar(100) NOT NULL default '0',
leader varchar(100) NOT NULL default '0',
underboss varchar(100) NOT NULL default '0',
crewbank varchar(100) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `crews`
--


--
-- Table structure for table `drugs`
--

DROP TABLE IF EXISTS drugs;
CREATE TABLE drugs (
id int(32) NOT NULL auto_increment,
weed varchar(100) NOT NULL default '',
XTC varchar(100) NOT NULL default '',
speed varchar(100) NOT NULL default '',
country varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `drugs`
--


--
-- Table structure for table `garage`
--

DROP TABLE IF EXISTS garage;
CREATE TABLE garage (
id int(32) NOT NULL auto_increment,
owner varchar(100) NOT NULL default '',
value varchar(100) NOT NULL default '',
damage varchar(100) NOT NULL default '',
car varchar(100) NOT NULL default '',
original enum('Holland','USA') NOT NULL default 'Holland',
time varchar(100) NOT NULL default '',
country varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `garage`
--


--
-- Table structure for table `garages`
--

DROP TABLE IF EXISTS garages;
CREATE TABLE garages (
id int(32) NOT NULL auto_increment,
garage varchar(100) NOT NULL default '',
max varchar(100) NOT NULL default '0',
price varchar(100) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `garages`
--

INSERT INTO garages (id, garage, max, price) VALUES (1,'10 Car Garage','10','5000');

--
-- Table structure for table `guns`
--

DROP TABLE IF EXISTS guns;
CREATE TABLE guns (
id int(32) NOT NULL auto_increment,
gun varchar(100) NOT NULL default '',
price varchar(100) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `guns`
--

INSERT INTO guns (id, gun, price) VALUES (1,'Pistol','500');

--
-- Table structure for table `issues`
--

DROP TABLE IF EXISTS issues;
CREATE TABLE issues (
id int(11) NOT NULL auto_increment,
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `issues`
--


--
-- Table structure for table `jobs`
--

DROP TABLE IF EXISTS jobs;
CREATE TABLE jobs (
id int(32) NOT NULL auto_increment,
job varchar(100) NOT NULL default '',
payout varchar(100) NOT NULL default '',
level varchar(100) NOT NULL default '',
app_fee varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `jobs`
--

INSERT INTO jobs (id, job, payout, level, app_fee) VALUES (1,'Paper Writer','5000000','3','500');

--
-- Table structure for table `kills`
--

DROP TABLE IF EXISTS kills;
CREATE TABLE kills (
id int(32) NOT NULL auto_increment,
killer varchar(100) NOT NULL default '',
target varchar(100) NOT NULL default '',
amount varchar(100) NOT NULL default '',
date varchar(100) NOT NULL default '',
actie varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `kills`
--


--
-- Table structure for table `messages`
--

DROP TABLE IF EXISTS messages;
CREATE TABLE messages (
id int(32) NOT NULL auto_increment,
van varchar(100) NOT NULL default '',
naar varchar(100) NOT NULL default '',
bericht varchar(100) NOT NULL default '',
gelezen varchar(100) NOT NULL default '',
datum varchar(100) NOT NULL default '',
saved enum('0','1') NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `messages`
--

INSERT INTO messages (id, van, naar, bericht, gelezen, datum, saved) VALUES (1,'subzero2005','subzero2005','test','0','02:49:42 30-05-2005','0');
INSERT INTO messages (id, van, naar, bericht, gelezen, datum, saved) VALUES (2,'subzero2005','subzero205','this is a test','0','02:53:28 30-05-2005','0');

--
-- Table structure for table `newspaper`
--

DROP TABLE IF EXISTS newspaper;
CREATE TABLE newspaper (
id int(11) NOT NULL auto_increment,
issue varchar(100) NOT NULL default '',
info text NOT NULL,
writer varchar(100) NOT NULL default '',
date datetime NOT NULL default '0000-00-00 00:00:00',
title varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `newspaper`
--


--
-- Table structure for table `oc`
--

DROP TABLE IF EXISTS oc;
CREATE TABLE oc (
id int(11) NOT NULL auto_increment,
leader varchar(40) NOT NULL default '',
we varchar(40) NOT NULL default '',
ee varchar(40) NOT NULL default '',
driver varchar(40) NOT NULL default '',
weapons varchar(100) NOT NULL default '0-0-0-0-0',
explosives varchar(100) NOT NULL default '0-0-0-0-0',
car int(11) NOT NULL default '0',
we_inv varchar(40) NOT NULL default '0',
ee_inv varchar(40) NOT NULL default '0',
driver_inv varchar(40) NOT NULL default '0',
share enum('1','2') NOT NULL default '1',
we_ready varchar(10) NOT NULL default '',
ee_ready varchar(10) NOT NULL default '',
driver_ready varchar(10) NOT NULL default '',
location varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `oc`
--


--
-- Table structure for table `online`
--

DROP TABLE IF EXISTS online;
CREATE TABLE online (
id int(32) NOT NULL auto_increment,
username varchar(100) NOT NULL default '',
time varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `online`
--

INSERT INTO online (id, username, time) VALUES (1,'','1117401414');
INSERT INTO online (id, username, time) VALUES (2,'subzero2005','1117452666');

--
-- Table structure for table `planes`
--

DROP TABLE IF EXISTS planes;
CREATE TABLE planes (
id int(32) NOT NULL auto_increment,
plane varchar(100) NOT NULL default '',
price varchar(100) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `planes`
--

INSERT INTO planes (id, plane, price) VALUES (1,'Boeing 777','1000000');

--
-- Table structure for table `protection`
--

DROP TABLE IF EXISTS protection;
CREATE TABLE protection (
id int(32) NOT NULL auto_increment,
protection varchar(100) NOT NULL default '',
price varchar(100) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `protection`
--

INSERT INTO protection (id, protection, price) VALUES (1,'Body Armour','1000');

--
-- Table structure for table `ranks`
--

DROP TABLE IF EXISTS ranks;
CREATE TABLE ranks (
id int(32) NOT NULL auto_increment,
rank enum('Scum','Thief','Mobster','Thug','Soldier','Local Boss','Boss','Commander','Godfather','Legendary Godfather','General','Don','Respectable Don','Legendary Don','Moderator','Administrator') NOT NULL default 'Scum',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `ranks`
--


--
-- Table structure for table `support`
--

DROP TABLE IF EXISTS support;
CREATE TABLE support (
id int(32) NOT NULL auto_increment,
writer varchar(100) NOT NULL default '',
reply varchar(100) NOT NULL default '',
read enum('0','1') NOT NULL default '0',
ticket varchar(100) NOT NULL default '',
time varchar(100) NOT NULL default '',
title varchar(100) NOT NULL default '',
catogorie varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `support`
--

INSERT INTO support (id, writer, reply, read, ticket, time, title, catogorie) VALUES (1,'subzero2005','0','0','asa','2005-05-30 02:58:23','hi','Bugs');

--
-- Table structure for table `table`
--

DROP TABLE IF EXISTS table;
CREATE TABLE table (
id int(32) NOT NULL auto_increment,
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `table`
--


--
-- Table structure for table `transfers`
--

DROP TABLE IF EXISTS transfers;
CREATE TABLE transfers (
id int(32) NOT NULL auto_increment,
van varchar(100) NOT NULL default '',
naar varchar(100) NOT NULL default '',
amount varchar(100) NOT NULL default '',
datum varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `transfers`
--


--
-- Table structure for table `updates`
--

DROP TABLE IF EXISTS updates;
CREATE TABLE updates (
id int(11) NOT NULL auto_increment,
username varchar(100) NOT NULL default '',
date datetime NOT NULL default '0000-00-00 00:00:00',
update text NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `updates`
--

INSERT INTO updates (id, username, date, update) VALUES (1,'subzero2005','2005-05-30 09:02:25','test');
INSERT INTO updates (id, username, date, update) VALUES (2,'subzero2005','2005-05-30 09:36:46','f');

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS users;
CREATE TABLE users (
id int(32) NOT NULL auto_increment,
username varchar(100) NOT NULL default '',
email varchar(100) NOT NULL default '0',
ip varchar(100) NOT NULL default '127.0.0',
password varchar(100) NOT NULL default '',
code enum('0','1') NOT NULL default '0',
ervaring varchar(100) NOT NULL default '0',
country enum('Holland','USA') NOT NULL default 'Holland',
money varchar(100) NOT NULL default '0',
crew varchar(100) NOT NULL default 'none',
crewlvl varchar(100) NOT NULL default '0',
life enum('0','1') NOT NULL default '1',
tijd_crime varchar(100) NOT NULL default '0',
crime_chance varchar(100) NOT NULL default '0-0-0-0-0',
rank enum('Scum','Thief','Mobster','Thug','Soldier','Local Boss','Boss','Commander','Godfather','Legendary Godfather','General','Don','Respectable Don','Legendary Don','Moderator','Administrator') NOT NULL default 'Scum',
drugs varchar(100) NOT NULL default '',
imgurl varchar(100) NOT NULL default 'images/nopic.jpg',
quote varchar(100) NOT NULL default 'No Quote',
status enum('Alive','Dead','Banned') NOT NULL default 'Alive',
gun varchar(100) NOT NULL default 'None',
protection varchar(100) NOT NULL default 'None',
max_cars varchar(100) NOT NULL default '5',
plane varchar(100) NOT NULL default 'None',
tijd_gta varchar(100) NOT NULL default '',
gta_chance varchar(100) NOT NULL default '',
tijd_job enum('0','1') NOT NULL default '0',
job varchar(100) NOT NULL default '',
job_lvl varchar(100) NOT NULL default '',
tijd_oc varchar(100) NOT NULL default '',
oc varchar(100) NOT NULL default '',
bank varchar(100) NOT NULL default '0',
messages varchar(100) NOT NULL default '0',
startdate varchar(100) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `users`
--

INSERT INTO users (id, username, email, ip, password, code, ervaring, country, money, crew, crewlvl, life, tijd_crime, crime_chance, rank, drugs, imgurl, quote, status, gun, protection, max_cars, plane, tijd_gta, gta_chance, tijd_job, job, job_lvl, tijd_oc, oc, bank, messages, startdate) VALUES (1,'subzero2005','0','127.0.0','daniel','1','0','Holland','5000000','none','','1','0','0-0-0-0-0','Administrator','','','','Alive','','','5','','','','1','Unemployed','5','','','0','0','0');



i can not figure out what i am doing wrong for the life of me
  • 0

Advertisements


#2
Paradox924X

Paradox924X

    Member

  • Member
  • PipPipPip
  • 208 posts
Yup, none of us here have a life so we're going to read through all of this and figure out exactly what you did or were trying to do, and help you fix it...
Comon, get real... pos the snippets of code where you mightof been wrong, or you guessed on what code shouldof been there...
Until then, not many people are going to help you..
  • 0

#3
ditto

ditto

    - i pwn n00bs -

  • Member
  • PipPipPipPip
  • 1,260 posts
Hey playmate19,

It looks like your error is with the enum() function in the mysql:
DROP TABLE IF EXISTS attempts;
CREATE TABLE attempts (
id int(32) NOT NULL default '0',
attacker varchar(100) NOT NULL default '',
target varchar(100) NOT NULL default '',
outcome enum('Alive','Dead') NOT NULL default 'Alive',
time varchar(100) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;


i am not very familiar with mysql scripting, so maybe reading the manual may help.

http://dev.mysql.com....1/en/enum.html


Paradox924x, perhaps you could be a little more welcoming.

ditto


ps - should these be movied to web design forum?
  • 0

#4
playmate19

playmate19

    New Member

  • Topic Starter
  • Member
  • Pip
  • 7 posts
SQL query:

--
-- Dumping data for table `updates`
--
INSERT INTO updates1( id, username, date1,
UPDATE ) VALUES (
'subzero2005', '2005-05-30 09:02:25', 'test'
)

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update) VALUES ('subzero2005','2005-05-30 09:02:25','test')' at line 5



thats my issue
i cant figure it out





-- Table structure for table `attempts`
--

DROP TABLE IF EXISTS attempts;
CREATE TABLE attempts (
id int(32) NOT NULL default '0',
attacker varchar(100) NOT NULL default '',
target varchar(100) NOT NULL default '',
outcome enum('Alive','Dead') NOT NULL default 'Alive',
time varchar(100) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `attempts`
--


--
-- Table structure for table `auctions`
--

DROP TABLE IF EXISTS auctions;
CREATE TABLE auctions (
id int(32) NOT NULL auto_increment,
highest varchar(100) NOT NULL default '',
last varchar(100) NOT NULL default '',
item varchar(100) NOT NULL default '',
username varchar(100) NOT NULL default '',
min varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `auctions`
--


--
-- Table structure for table `ban`
--

DROP TABLE IF EXISTS ban;
CREATE TABLE ban (
id int(32) NOT NULL auto_increment,
username varchar(100) NOT NULL default '',
reason varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `ban`
--


--
-- Table structure for table `carsales`
--

DROP TABLE IF EXISTS carsales;
CREATE TABLE carsales (
carid int(32) NOT NULL auto_increment,
car varchar(100) NOT NULL default '',
owner varchar(100) NOT NULL default '',
damage varchar(100) NOT NULL default '',
value varchar(100) NOT NULL default '',
original varchar(100) NOT NULL default '',
price varchar(100) NOT NULL default '',
PRIMARY KEY (carid)
) TYPE=MyISAM;

--
-- Dumping data for table `carsales`
--

INSERT INTO carsales (carid, car, owner, damage, value, original, price) VALUES (2,'Smart Roadster','','47','8872','','1000');

--
-- Table structure for table `chat`
--

DROP TABLE IF EXISTS chat;
CREATE TABLE chat (
id int(32) NOT NULL auto_increment,
username varchar(100) NOT NULL default '',
date varchar(100) NOT NULL default '',
bericht varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `chat`
--


--
-- Table structure for table `countries`
--

DROP TABLE IF EXISTS countries;
CREATE TABLE countries (
id int(32) NOT NULL auto_increment,
country enum('Holland','USA') NOT NULL default 'Holland',
blackjack varchar(100) NOT NULL default '',
blackjack_max varchar(100) NOT NULL default '',
blackjack_profit varchar(100) NOT NULL default '',
bulletfactory varchar(100) NOT NULL default '',
bullet_time varchar(100) NOT NULL default '',
bullet_stock varchar(100) NOT NULL default '',
bullet_price bigint(100) NOT NULL default '1000',
bullet_produce enum('0','1') NOT NULL default '0',
slots varchar(100) NOT NULL default '',
racetrack varchar(100) NOT NULL default '',
race varchar(100) NOT NULL default '',
roullette varchar(100) NOT NULL default '',
slots_max varchar(100) NOT NULL default '',
racetrack__max varchar(100) NOT NULL default '',
race_max varchar(100) NOT NULL default '',
roulette_max varchar(100) NOT NULL default '',
roulette_profit varchar(100) NOT NULL default '',
race_profit varchar(100) NOT NULL default '',
racetrack_profit varchar(100) NOT NULL default '',
slots_profit varchar(100) NOT NULL default '',
coin varchar(100) NOT NULL default '',
coin_max varchar(100) NOT NULL default '',
coin_profit varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `countries`
--

INSERT INTO countries (id, country, blackjack, blackjack_max, blackjack_profit, bulletfactory, bullet_time, bullet_stock, bullet_price, bullet_produce, slots, racetrack, race, roullette, slots_max, racetrack__max, race_max, roulette_max, roulette_profit, race_profit, racetrack_profit, slots_profit, coin, coin_max, coin_profit) VALUES (2,'USA','','','','','','',1000,'0','','','','','','','','','','','','','','','');
INSERT INTO countries (id, country, blackjack, blackjack_max, blackjack_profit, bulletfactory, bullet_time, bullet_stock, bullet_price, bullet_produce, slots, racetrack, race, roullette, slots_max, racetrack__max, race_max, roulette_max, roulette_profit, race_profit, racetrack_profit, slots_profit, coin, coin_max, coin_profit) VALUES (1,'Holland','','','','subzero2005','','',1000,'0','','','','','','','','','','','','','','','');

--
-- Table structure for table `crews`
--

DROP TABLE IF EXISTS crews;
CREATE TABLE crews (
id int(32) NOT NULL auto_increment,
crewname varchar(100) NOT NULL default '0',
leader varchar(100) NOT NULL default '0',
underboss varchar(100) NOT NULL default '0',
crewbank varchar(100) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `crews`
--


--
-- Table structure for table `drugs`
--

DROP TABLE IF EXISTS drugs;
CREATE TABLE drugs (
id int(32) NOT NULL auto_increment,
weed varchar(100) NOT NULL default '',
XTC varchar(100) NOT NULL default '',
speed varchar(100) NOT NULL default '',
country varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `drugs`
--


--
-- Table structure for table `garage`
--

DROP TABLE IF EXISTS garage;
CREATE TABLE garage (
id int(32) NOT NULL auto_increment,
owner varchar(100) NOT NULL default '',
value varchar(100) NOT NULL default '',
damage varchar(100) NOT NULL default '',
car varchar(100) NOT NULL default '',
original enum('Holland','USA') NOT NULL default 'Holland',
time varchar(100) NOT NULL default '',
country varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `garage`
--


--
-- Table structure for table `garages`
--

DROP TABLE IF EXISTS garages;
CREATE TABLE garages (
id int(32) NOT NULL auto_increment,
garage varchar(100) NOT NULL default '',
max varchar(100) NOT NULL default '0',
price varchar(100) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `garages`
--

INSERT INTO garages (id, garage, max, price) VALUES (1,'10 Car Garage','10','5000');

--
-- Table structure for table `guns`
--

DROP TABLE IF EXISTS guns;
CREATE TABLE guns (
id int(32) NOT NULL auto_increment,
gun varchar(100) NOT NULL default '',
price varchar(100) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `guns`
--

INSERT INTO guns (id, gun, price) VALUES (1,'Pistol','500');

--
-- Table structure for table `issues`
--

DROP TABLE IF EXISTS issues;
CREATE TABLE issues (
id int(11) NOT NULL auto_increment,
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `issues`
--


--
-- Table structure for table `jobs`
--

DROP TABLE IF EXISTS jobs;
CREATE TABLE jobs (
id int(32) NOT NULL auto_increment,
job varchar(100) NOT NULL default '',
payout varchar(100) NOT NULL default '',
level varchar(100) NOT NULL default '',
app_fee varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `jobs`
--

INSERT INTO jobs (id, job, payout, level, app_fee) VALUES (1,'Paper Writer','5000000','3','500');

--
-- Table structure for table `kills`
--

DROP TABLE IF EXISTS kills;
CREATE TABLE kills (
id int(32) NOT NULL auto_increment,
killer varchar(100) NOT NULL default '',
target varchar(100) NOT NULL default '',
amount varchar(100) NOT NULL default '',
date varchar(100) NOT NULL default '',
actie varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `kills`
--


--
-- Table structure for table `messages`
--

DROP TABLE IF EXISTS messages;
CREATE TABLE messages (
id int(32) NOT NULL auto_increment,
van varchar(100) NOT NULL default '',
naar varchar(100) NOT NULL default '',
bericht varchar(100) NOT NULL default '',
gelezen varchar(100) NOT NULL default '',
datum varchar(100) NOT NULL default '',
saved enum('0','1') NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `messages`
--

INSERT INTO messages (id, van, naar, bericht, gelezen, datum, saved) VALUES (1,'subzero2005','subzero2005','test','0','02:49:42 30-05-2005','0');
INSERT INTO messages (id, van, naar, bericht, gelezen, datum, saved) VALUES (2,'subzero2005','subzero205','this is a test','0','02:53:28 30-05-2005','0');

--
-- Table structure for table `newspaper`
--

DROP TABLE IF EXISTS newspaper;
CREATE TABLE newspaper (
id int(11) NOT NULL auto_increment,
issue varchar(100) NOT NULL default '',
info text NOT NULL,
writer varchar(100) NOT NULL default '',
date datetime NOT NULL default '0000-00-00 00:00:00',
title varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `newspaper`
--


--
-- Table structure for table `oc`
--

DROP TABLE IF EXISTS oc;
CREATE TABLE oc (
id int(11) NOT NULL auto_increment,
leader varchar(40) NOT NULL default '',
we varchar(40) NOT NULL default '',
ee varchar(40) NOT NULL default '',
driver varchar(40) NOT NULL default '',
weapons varchar(100) NOT NULL default '0-0-0-0-0',
explosives varchar(100) NOT NULL default '0-0-0-0-0',
car int(11) NOT NULL default '0',
we_inv varchar(40) NOT NULL default '0',
ee_inv varchar(40) NOT NULL default '0',
driver_inv varchar(40) NOT NULL default '0',
share enum('1','2') NOT NULL default '1',
we_ready varchar(10) NOT NULL default '',
ee_ready varchar(10) NOT NULL default '',
driver_ready varchar(10) NOT NULL default '',
location varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `oc`
--


--
-- Table structure for table `online`
--

DROP TABLE IF EXISTS online;
CREATE TABLE online (
id int(32) NOT NULL auto_increment,
username varchar(100) NOT NULL default '',
time varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `online`
--

INSERT INTO online (id, username, time) VALUES (1,'','1117401414');
INSERT INTO online (id, username, time) VALUES (2,'subzero2005','1117452666');

--
-- Table structure for table `planes`
--

DROP TABLE IF EXISTS planes;
CREATE TABLE planes (
id int(32) NOT NULL auto_increment,
plane varchar(100) NOT NULL default '',
price varchar(100) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `planes`
--

INSERT INTO planes (id, plane, price) VALUES (1,'Boeing 777','1000000');

--
-- Table structure for table `protection`
--

DROP TABLE IF EXISTS protection;
CREATE TABLE protection (
id int(32) NOT NULL auto_increment,
protection varchar(100) NOT NULL default '',
price varchar(100) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `protection`
--

INSERT INTO protection (id, protection, price) VALUES (1,'Body Armour','1000');

--
-- Table structure for table `ranks`
--

DROP TABLE IF EXISTS ranks;
CREATE TABLE ranks (
id int(32) NOT NULL auto_increment,
rank enum('Scum','Thief','Mobster','Thug','Soldier','Local Boss','Boss','Commander','Godfather','Legendary Godfather','General','Don','Respectable Don','Legendary Don','Moderator','Administrator') NOT NULL default 'Scum',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `ranks`
--


--
-- Table structure for table `support`
--

DROP TABLE IF EXISTS support;
CREATE TABLE support (
id int(32) NOT NULL auto_increment,
writer varchar(100) NOT NULL default '',
reply varchar(100) NOT NULL default '',
read2 enum('0') NOT NULL default '0',
ticket varchar(100) NOT NULL default '',
time varchar(100) NOT NULL default '',
title varchar(100) NOT NULL default '',
catogorie varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `support`
--

INSERT INTO support (id, writer, reply, read2, ticket, time, title, catogorie) VALUES (1,'subzero2005','0','0','asa','2005-05-30 02:58:23','hi','Bugs');

--
-- Table structure for table `table1`
--

DROP TABLE IF EXISTS table1;
CREATE TABLE table1 (
id int(32) NOT NULL auto_increment,
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `table1`
--


--
-- Table structure for table `transfers`
--

DROP TABLE IF EXISTS transfers;
CREATE TABLE transfers (
id int(32) NOT NULL auto_increment,
van varchar(100) NOT NULL default '',
naar varchar(100) NOT NULL default '',
amount varchar(100) NOT NULL default '',
datum varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `transfers`
--


--
-- Table structure for table `updates`
--

DROP TABLE IF EXISTS updates;
CREATE TABLE updates (
id int(11) NOT NULL auto_increment,
username varchar(100) NOT NULL default '',
date datetime NOT NULL default '0000-00-00 00:00:00',
update1 text NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `updates`
--

INSERT INTO updates1 (id, username, date1, update) VALUES ('subzero2005','2005-05-30 09:02:25','test');
INSERT INTO updates1 (id, username, date, update) VALUES (2,'subzero2005','2005-05-30 09:36:46','f');

that is the orginal code that its having issues with
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP