[HELP]DB SQL -
SuperMarioRol - 20.01.2011
Buenas....
Estoy intentado reactivar las funciones MySQL de LA-RP, gracias a brunosiico pero, parece que hay un error en el siguiente cуdigo
PHP код:
DROP TABLE IF EXISTS `bans`;
CREATE TABLE `bans` (
`id` int(11) NOT NULL auto_increment,
`type` tinyint(2) NOT NULL,
`player` int(11) NOT NULL,
`time` int(11) NOT NULL,
`amount` bigint(20) NOT NULL default '0',
`ip` varchar(16) NOT NULL,
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
)
DROP TABLE IF EXISTS `logins`;
CREATE TABLE `logins` (
`id` int(11) NOT NULL auto_increment,
`time` int(11) NOT NULL,
`ip` varchar(16) NOT NULL,
`userid` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
)
DROP TABLE IF EXISTS `players`;
CREATE TABLE `players` (
`id` int(11) NOT NULL auto_increment,
`Name` varchar(50) NOT NULL,
`Password` varchar(50) NOT NULL,
`PlayerLevel` int(11) NOT NULL default '1',
`AdminLevel` int(11) NOT NULL default '0',
`DonateRank` int(11) NOT NULL default '0',
`UpgradePoints` int(11) NOT NULL default '0',
`ConnectedTime` int(11) NOT NULL default '0',
`Registered` int(11) NOT NULL default '0',
`Sex` int(11) NOT NULL default '1',
`Age` int(11) NOT NULL default '0',
`Origin` int(11) NOT NULL default '255',
`CK` int(11) NOT NULL default '0',
`Muted` int(11) NOT NULL default '0',
`Respect` int(11) NOT NULL default '0',
`Money` bigint(20) NOT NULL default '500',
`Bank` int(11) NOT NULL default '1000',
`Crimes` int(11) NOT NULL default '0',
`Kills` int(11) NOT NULL default '0',
`Deaths` int(11) NOT NULL default '0',
`Arrested` int(11) NOT NULL default '0',
`WantedDeaths` int(11) NOT NULL default '0',
`Phonebook` int(11) NOT NULL default '0',
`LottoNr` int(11) NOT NULL default '0',
`Fishes` int(11) NOT NULL default '0',
`BiggestFish` int(11) NOT NULL default '0',
`Job` int(11) NOT NULL default '0',
`Paycheck` int(11) NOT NULL default '0',
`HeadValue` int(11) NOT NULL default '0',
`Jailed` int(11) NOT NULL default '0',
`JailTime` int(11) NOT NULL default '0',
`Materials` int(11) NOT NULL default '0',
`Drugs` int(11) NOT NULL default '0',
`Leader` int(11) NOT NULL default '0',
`Member` int(11) NOT NULL default '0',
`FMember` int(11) NOT NULL default '255',
`Rank` int(11) NOT NULL default '0',
`Chara` int(11) NOT NULL default '0',
`ContractTime` int(11) NOT NULL default '0',
`DetSkill` int(11) NOT NULL default '0',
`SexSkill` int(11) NOT NULL default '0',
`BoxSkill` int(11) NOT NULL default '0',
`LawSkill` int(11) NOT NULL default '0',
`MechSkill` int(11) NOT NULL default '0',
`JackSkill` int(11) NOT NULL default '0',
`CarSkill` int(11) NOT NULL default '0',
`NewsSkill` int(11) NOT NULL default '0',
`DrugsSkill` int(11) NOT NULL default '0',
`CookSkill` int(11) NOT NULL default '0',
`FishSkill` int(11) NOT NULL default '0',
`pSHealth` varchar(16) default '50.0',
`pHealth` varchar(16) default '50.0',
`Inte` int(11) NOT NULL default '0',
`Local` int(11) NOT NULL default '255',
`Team` int(11) NOT NULL default '3',
`Model` int(11) NOT NULL default '264',
`PhoneNr` int(11) NOT NULL default '0',
`House` int(11) NOT NULL default '255',
`Car` int(11) NOT NULL default '255',
`Appt` int(11) NOT NULL default '255',
`Bizz` int(11) NOT NULL default '255',
`Pos_x` varchar(16) NOT NULL default '1684.9',
`Pos_y` varchar(16) NOT NULL default '-2244.5',
`Pos_z` varchar(16) NOT NULL default '13.5',
`CarLic` int(11) NOT NULL default '0',
`FlyLic` int(11) NOT NULL default '0',
`BoatLic` int(11) NOT NULL default '0',
`FishLic` int(11) NOT NULL default '0',
`GunLic` int(11) NOT NULL default '0',
`Gun1` int(11) NOT NULL default '0',
`Gun2` int(11) NOT NULL default '0',
`Gun3` int(11) NOT NULL default '0',
`Gun4` int(11) NOT NULL default '0',
`Ammo1` int(11) NOT NULL default '0',
`Ammo2` int(11) NOT NULL default '0',
`Ammo3` int(11) NOT NULL default '0',
`Ammo4` int(11) NOT NULL default '0',
`CarTime` int(11) NOT NULL default '0',
`PayDay` int(11) NOT NULL default '0',
`PayDayHad` int(11) NOT NULL default '0',
`CDPlayer` int(11) NOT NULL default '0',
`Wins` int(11) NOT NULL default '0',
`Loses` int(11) NOT NULL default '0',
`AlcoholPerk` int(11) NOT NULL default '0',
`DrugPerk` int(11) NOT NULL default '0',
`MiserPerk` int(11) NOT NULL default '0',
`PainPerk` int(11) NOT NULL default '0',
`TraderPerk` int(11) NOT NULL default '0',
`Tutorial` int(11) NOT NULL default '0',
`Mission` int(11) NOT NULL default '0',
`Warnings` int(11) NOT NULL default '0',
`Adjustable` int(11) NOT NULL default '0',
`Fuel` int(11) NOT NULL default '0',
`Married` int(11) NOT NULL default '0',
`MarriedTo` varchar(50) default 'No-one',
`Locked` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
)
El error estб en la lнnea 12...el segundo "pack" de datos, que empieza asin...
PHP код:
DROP TABLE IF EXISTS `logins`;
CREATE TABLE `logins` (
`id` int(11) NOT NULL auto_increment,
`time` int(11) NOT NULL,
`ip` varchar(16) NOT NULL,
`userid` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
)
El error es este
Код:
consulta SQL:
CREATE TABLE `bans` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`type` TINYINT( 2 ) NOT NULL ,
`player` INT( 11 ) NOT NULL ,
`time` INT( 11 ) NOT NULL ,
`amount` BIGINT( 20 ) NOT NULL DEFAULT '0',
`ip` VARCHAR( 16 ) NOT NULL ,
`inactive` TINYINT( 1 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( `id` )
) DROP TABLE IF EXISTS `logins` ;
MySQL ha dicho:
#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 'DROP TABLE IF EXISTS `logins`' at line 12
Si teneis alguna idea os lo agradeceria un montonazo...
Respuesta: [HELP]DB SQL -
benjas09 - 21.01.2011
Asi deberia funcionar....
Код:
CREATE TABLE 'bans' (
'id' int(11) NOT NULL auto_increment,
'type' tinyint(2) NOT NULL,
'player' int(11) NOT NULL,
'time' int(11) NOT NULL,
'amount' bigint(20) NOT NULL default '0',
'ip' varchar(16) NOT NULL,
'inactive' tinyint(1) NOT NULL default '0',
PRIMARY KEY ('id')
);
CREATE TABLE 'logins' (
'id' int(11) NOT NULL auto_increment,
'time' int(11) NOT NULL,
'ip' varchar(16) NOT NULL,
'userid' int(11) NOT NULL default '0',
PRIMARY KEY ('id')
);
CREATE TABLE 'players' (
'id' int(11) NOT NULL auto_increment,
'Name' varchar(50) NOT NULL,
'Password' varchar(50) NOT NULL,
'PlayerLevel' int(11) NOT NULL default '1',
'AdminLevel' int(11) NOT NULL default '0',
'DonateRank' int(11) NOT NULL default '0',
'UpgradePoints' int(11) NOT NULL default '0',
'ConnectedTime' int(11) NOT NULL default '0',
'Registered' int(11) NOT NULL default '0',
'Sex' int(11) NOT NULL default '1',
'Age' int(11) NOT NULL default '0',
'Origin' int(11) NOT NULL default '255',
'CK' int(11) NOT NULL default '0',
'Muted' int(11) NOT NULL default '0',
'Respect' int(11) NOT NULL default '0',
'Money' bigint(20) NOT NULL default '500',
'Bank' int(11) NOT NULL default '1000',
'Crimes' int(11) NOT NULL default '0',
'Kills' int(11) NOT NULL default '0',
'Deaths' int(11) NOT NULL default '0',
'Arrested' int(11) NOT NULL default '0',
'WantedDeaths' int(11) NOT NULL default '0',
'Phonebook' int(11) NOT NULL default '0',
'LottoNr' int(11) NOT NULL default '0',
'Fishes' int(11) NOT NULL default '0',
'BiggestFish' int(11) NOT NULL default '0',
'Job' int(11) NOT NULL default '0',
'Paycheck' int(11) NOT NULL default '0',
'HeadValue' int(11) NOT NULL default '0',
'Jailed' int(11) NOT NULL default '0',
'JailTime' int(11) NOT NULL default '0',
'Materials' int(11) NOT NULL default '0',
'Drugs' int(11) NOT NULL default '0',
'Leader' int(11) NOT NULL default '0',
'Member' int(11) NOT NULL default '0',
'FMember' int(11) NOT NULL default '255',
'Rank' int(11) NOT NULL default '0',
'Chara' int(11) NOT NULL default '0',
'ContractTime' int(11) NOT NULL default '0',
'DetSkill' int(11) NOT NULL default '0',
'SexSkill' int(11) NOT NULL default '0',
'BoxSkill' int(11) NOT NULL default '0',
'LawSkill' int(11) NOT NULL default '0',
'MechSkill' int(11) NOT NULL default '0',
'JackSkill' int(11) NOT NULL default '0',
'CarSkill' int(11) NOT NULL default '0',
'NewsSkill' int(11) NOT NULL default '0',
'DrugsSkill' int(11) NOT NULL default '0',
'CookSkill' int(11) NOT NULL default '0',
'FishSkill' int(11) NOT NULL default '0',
'pSHealth' varchar(16) default '50.0',
'pHealth' varchar(16) default '50.0',
'Inte' int(11) NOT NULL default '0',
'Local' int(11) NOT NULL default '255',
'Team' int(11) NOT NULL default '3',
'Model' int(11) NOT NULL default '264',
'PhoneNr' int(11) NOT NULL default '0',
'House' int(11) NOT NULL default '255',
'Car' int(11) NOT NULL default '255',
'Appt' int(11) NOT NULL default '255',
'Bizz' int(11) NOT NULL default '255',
'Pos_x' varchar(16) NOT NULL default '1684.9',
'Pos_y' varchar(16) NOT NULL default '-2244.5',
'Pos_z' varchar(16) NOT NULL default '13.5',
'CarLic' int(11) NOT NULL default '0',
'FlyLic' int(11) NOT NULL default '0',
'BoatLic' int(11) NOT NULL default '0',
'FishLic' int(11) NOT NULL default '0',
'GunLic' int(11) NOT NULL default '0',
'Gun1' int(11) NOT NULL default '0',
'Gun2' int(11) NOT NULL default '0',
'Gun3' int(11) NOT NULL default '0',
'Gun4' int(11) NOT NULL default '0',
'Ammo1' int(11) NOT NULL default '0',
'Ammo2' int(11) NOT NULL default '0',
'Ammo3' int(11) NOT NULL default '0',
'Ammo4' int(11) NOT NULL default '0',
'CarTime' int(11) NOT NULL default '0',
'PayDay' int(11) NOT NULL default '0',
'PayDayHad' int(11) NOT NULL default '0',
'CDPlayer' int(11) NOT NULL default '0',
'Wins' int(11) NOT NULL default '0',
'Loses' int(11) NOT NULL default '0',
'AlcoholPerk' int(11) NOT NULL default '0',
'DrugPerk' int(11) NOT NULL default '0',
'MiserPerk' int(11) NOT NULL default '0',
'PainPerk' int(11) NOT NULL default '0',
'TraderPerk' int(11) NOT NULL default '0',
'Tutorial' int(11) NOT NULL default '0',
'Mission' int(11) NOT NULL default '0',
'Warnings' int(11) NOT NULL default '0',
'Adjustable' int(11) NOT NULL default '0',
'Fuel' int(11) NOT NULL default '0',
'Married' int(11) NOT NULL default '0',
'MarriedTo' varchar(50) default 'No-one',
'Locked' tinyint(1) NOT NULL default '0',
PRIMARY KEY ('id')
);
Respuesta: [HELP]DB SQL -
SuperMarioRol - 21.01.2011
Код:
consulta SQL:
CREATE TABLE 'bans'(
'id'INT( 11 ) NOT NULL AUTO_INCREMENT ,
'type'TINYINT( 2 ) NOT NULL ,
'player'INT( 11 ) NOT NULL ,
'time'INT( 11 ) NOT NULL ,
'amount'BIGINT( 20 ) NOT NULL DEFAULT '0',
'ip'VARCHAR( 16 ) NOT NULL ,
'inactive'TINYINT( 1 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( 'id' )
);
MySQL ha dicho:
#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 ''bans' (
'id' int(11) NOT NULL auto_increment,
'type' tinyint(2) NOT NULL,' at line 1
Respuesta: [HELP]DB SQL -
benjas09 - 21.01.2011
asi
Код:
CREATE TABLE 'bans' (
'id' int (11) NOT NULL auto_increment,
'type' tinyint (2) NOT NULL,
'player' int (11) NOT NULL,
'time' int (11) NOT NULL,
'amount' bigint (20) NOT NULL default '0',
'ip' varchar (16) NOT NULL,
'inactive' tinyint (1) NOT NULL default '0',
PRIMARY KEY ('id')
);
CREATE TABLE 'logins' (
'id' int (11) NOT NULL auto_increment,
'time' int (11) NOT NULL,
'ip' varchar (16) NOT NULL,
'userid' int (11) NOT NULL default '0',
PRIMARY KEY ('id')
);
CREATE TABLE 'players' (
'id' int (11) NOT NULL auto_increment,
'Name' varchar (50) NOT NULL,
'Password' varchar (50) NOT NULL,
'PlayerLevel' int (11) NOT NULL default '1',
'AdminLevel' int (11) NOT NULL default '0',
'DonateRank' int (11) NOT NULL default '0',
'UpgradePoints' int (11) NOT NULL default '0',
'ConnectedTime' int (11) NOT NULL default '0',
'Registered' int (11) NOT NULL default '0',
'Sex' int (11) NOT NULL default '1',
'Age' int (11) NOT NULL default '0',
'Origin' int (11) NOT NULL default '255',
'CK' int (11) NOT NULL default '0',
'Muted' int (11) NOT NULL default '0',
'Respect' int (11) NOT NULL default '0',
'Money' bigint (20) NOT NULL default '500',
'Bank' int (11) NOT NULL default '1000',
'Crimes' int (11) NOT NULL default '0',
'Kills' int (11) NOT NULL default '0',
'Deaths' int (11) NOT NULL default '0',
'Arrested' int (11) NOT NULL default '0',
'WantedDeaths' int (11) NOT NULL default '0',
'Phonebook' int (11) NOT NULL default '0',
'LottoNr' int (11) NOT NULL default '0',
'Fishes' int (11) NOT NULL default '0',
'BiggestFish' int (11) NOT NULL default '0',
'Job' int (11) NOT NULL default '0',
'Paycheck' int (11) NOT NULL default '0',
'HeadValue' int (11) NOT NULL default '0',
'Jailed' int (11) NOT NULL default '0',
'JailTime' int (11) NOT NULL default '0',
'Materials' int (11) NOT NULL default '0',
'Drugs' int (11) NOT NULL default '0',
'Leader' int (11) NOT NULL default '0',
'Member' int (11) NOT NULL default '0',
'FMember' int (11) NOT NULL default '255',
'Rank' int (11) NOT NULL default '0',
'Chara' int (11) NOT NULL default '0',
'ContractTime' int (11) NOT NULL default '0',
'DetSkill' int (11) NOT NULL default '0',
'SexSkill' int (11) NOT NULL default '0',
'BoxSkill' int (11) NOT NULL default '0',
'LawSkill' int (11) NOT NULL default '0',
'MechSkill' int (11) NOT NULL default '0',
'JackSkill' int (11) NOT NULL default '0',
'CarSkill' int (11) NOT NULL default '0',
'NewsSkill' int (11) NOT NULL default '0',
'DrugsSkill' int (11) NOT NULL default '0',
'CookSkill' int (11) NOT NULL default '0',
'FishSkill' int (11) NOT NULL default '0',
'pSHealth' varchar (16) default '50.0',
'pHealth' varchar (16) default '50.0',
'Inte' int (11) NOT NULL default '0',
'Local' int (11) NOT NULL default '255',
'Team' int (11) NOT NULL default '3',
'Model' int (11) NOT NULL default '264',
'PhoneNr' int (11) NOT NULL default '0',
'House' int (11) NOT NULL default '255',
'Car' int (11) NOT NULL default '255',
'Appt' int (11) NOT NULL default '255',
'Bizz' int (11) NOT NULL default '255',
'Pos_x' varchar (16) NOT NULL default '1684.9',
'Pos_y' varchar (16) NOT NULL default '-2244.5',
'Pos_z' varchar (16) NOT NULL default '13.5',
'CarLic' int (11) NOT NULL default '0',
'FlyLic' int (11) NOT NULL default '0',
'BoatLic' int (11) NOT NULL default '0',
'FishLic' int (11) NOT NULL default '0',
'GunLic' int (11) NOT NULL default '0',
'Gun1' int (11) NOT NULL default '0',
'Gun2' int (11) NOT NULL default '0',
'Gun3' int (11) NOT NULL default '0',
'Gun4' int (11) NOT NULL default '0',
'Ammo1' int (11) NOT NULL default '0',
'Ammo2' int (11) NOT NULL default '0',
'Ammo3' int (11) NOT NULL default '0',
'Ammo4' int (11) NOT NULL default '0',
'CarTime' int (11) NOT NULL default '0',
'PayDay' int (11) NOT NULL default '0',
'PayDayHad' int (11) NOT NULL default '0',
'CDPlayer' int (11) NOT NULL default '0',
'Wins' int (11) NOT NULL default '0',
'Loses' int (11) NOT NULL default '0',
'AlcoholPerk' int (11) NOT NULL default '0',
'DrugPerk' int (11) NOT NULL default '0',
'MiserPerk' int (11) NOT NULL default '0',
'PainPerk' int (11) NOT NULL default '0',
'TraderPerk' int (11) NOT NULL default '0',
'Tutorial' int (11) NOT NULL default '0',
'Mission' int (11) NOT NULL default '0',
'Warnings' int (11) NOT NULL default '0',
'Adjustable' int (11) NOT NULL default '0',
'Fuel' int (11) NOT NULL default '0',
'Married' int (11) NOT NULL default '0',
'MarriedTo' varchar (50) default 'No-one',
'Locked' tinyint (1) NOT NULL default '0',
PRIMARY KEY ('id')
);
Respuesta: [HELP]DB SQL -
SuperMarioRol - 23.01.2011
Ya tengo la soluciуn.
Faltaban ";"
Por si alguien le interesa, es el cуdigo SQL para las DB por defecto de LA-RP
Код:
DROP TABLE IF EXISTS `bans`;
CREATE TABLE `bans` (
`id` int(11) NOT NULL auto_increment,
`type` tinyint(2) NOT NULL,
`player` int(11) NOT NULL,
`time` int(11) NOT NULL,
`amount` bigint(20) NOT NULL default '0',
`ip` varchar(16) NOT NULL,
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
); /* Faltaba ; */
DROP TABLE IF EXISTS `logins`;
CREATE TABLE `logins` (
`id` int(11) NOT NULL auto_increment,
`time` int(11) NOT NULL,
`ip` varchar(16) NOT NULL,
`userid` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
); /* Faltaba ; */
DROP TABLE IF EXISTS `players`;
CREATE TABLE `players` (
`id` int(11) NOT NULL auto_increment,
`Name` varchar(50) NOT NULL,
`Password` varchar(50) NOT NULL,
`PlayerLevel` int(11) NOT NULL default '1',
`AdminLevel` int(11) NOT NULL default '0',
`DonateRank` int(11) NOT NULL default '0',
`UpgradePoints` int(11) NOT NULL default '0',
`ConnectedTime` int(11) NOT NULL default '0',
`Registered` int(11) NOT NULL default '0',
`Sex` int(11) NOT NULL default '1',
`Age` int(11) NOT NULL default '0',
`Origin` int(11) NOT NULL default '255',
`CK` int(11) NOT NULL default '0',
`Muted` int(11) NOT NULL default '0',
`Respect` int(11) NOT NULL default '0',
`Money` bigint(20) NOT NULL default '500',
`Bank` int(11) NOT NULL default '1000',
`Crimes` int(11) NOT NULL default '0',
`Kills` int(11) NOT NULL default '0',
`Deaths` int(11) NOT NULL default '0',
`Arrested` int(11) NOT NULL default '0',
`WantedDeaths` int(11) NOT NULL default '0',
`Phonebook` int(11) NOT NULL default '0',
`LottoNr` int(11) NOT NULL default '0',
`Fishes` int(11) NOT NULL default '0',
`BiggestFish` int(11) NOT NULL default '0',
`Job` int(11) NOT NULL default '0',
`Paycheck` int(11) NOT NULL default '0',
`HeadValue` int(11) NOT NULL default '0',
`Jailed` int(11) NOT NULL default '0',
`JailTime` int(11) NOT NULL default '0',
`Materials` int(11) NOT NULL default '0',
`Drugs` int(11) NOT NULL default '0',
`Leader` int(11) NOT NULL default '0',
`Member` int(11) NOT NULL default '0',
`FMember` int(11) NOT NULL default '255',
`Rank` int(11) NOT NULL default '0',
`Chara` int(11) NOT NULL default '0',
`ContractTime` int(11) NOT NULL default '0',
`DetSkill` int(11) NOT NULL default '0',
`SexSkill` int(11) NOT NULL default '0',
`BoxSkill` int(11) NOT NULL default '0',
`LawSkill` int(11) NOT NULL default '0',
`MechSkill` int(11) NOT NULL default '0',
`JackSkill` int(11) NOT NULL default '0',
`CarSkill` int(11) NOT NULL default '0',
`NewsSkill` int(11) NOT NULL default '0',
`DrugsSkill` int(11) NOT NULL default '0',
`CookSkill` int(11) NOT NULL default '0',
`FishSkill` int(11) NOT NULL default '0',
`pSHealth` varchar(16) default '50.0',
`pHealth` varchar(16) default '50.0',
`Inte` int(11) NOT NULL default '0',
`Local` int(11) NOT NULL default '255',
`Team` int(11) NOT NULL default '3',
`Model` int(11) NOT NULL default '264',
`PhoneNr` int(11) NOT NULL default '0',
`House` int(11) NOT NULL default '255',
`Car` int(11) NOT NULL default '255',
`Appt` int(11) NOT NULL default '255',
`Bizz` int(11) NOT NULL default '255',
`Pos_x` varchar(16) NOT NULL default '1684.9',
`Pos_y` varchar(16) NOT NULL default '-2244.5',
`Pos_z` varchar(16) NOT NULL default '13.5',
`CarLic` int(11) NOT NULL default '0',
`FlyLic` int(11) NOT NULL default '0',
`BoatLic` int(11) NOT NULL default '0',
`FishLic` int(11) NOT NULL default '0',
`GunLic` int(11) NOT NULL default '0',
`Gun1` int(11) NOT NULL default '0',
`Gun2` int(11) NOT NULL default '0',
`Gun3` int(11) NOT NULL default '0',
`Gun4` int(11) NOT NULL default '0',
`Ammo1` int(11) NOT NULL default '0',
`Ammo2` int(11) NOT NULL default '0',
`Ammo3` int(11) NOT NULL default '0',
`Ammo4` int(11) NOT NULL default '0',
`CarTime` int(11) NOT NULL default '0',
`PayDay` int(11) NOT NULL default '0',
`PayDayHad` int(11) NOT NULL default '0',
`CDPlayer` int(11) NOT NULL default '0',
`Wins` int(11) NOT NULL default '0',
`Loses` int(11) NOT NULL default '0',
`AlcoholPerk` int(11) NOT NULL default '0',
`DrugPerk` int(11) NOT NULL default '0',
`MiserPerk` int(11) NOT NULL default '0',
`PainPerk` int(11) NOT NULL default '0',
`TraderPerk` int(11) NOT NULL default '0',
`Tutorial` int(11) NOT NULL default '0',
`Mission` int(11) NOT NULL default '0',
`Warnings` int(11) NOT NULL default '0',
`Adjustable` int(11) NOT NULL default '0',
`Fuel` int(11) NOT NULL default '0',
`Married` int(11) NOT NULL default '0',
`MarriedTo` varchar(50) default 'No-one',
`Locked` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
); /* Faltaba ; */