05.01.2016, 20:20
Dont mind the non alligment, I had to crop pictures & put them together since the table is quite big
http://imgur.com/SrDz4Ui
Also if this makes any sense
http://imgur.com/SrDz4Ui
Also if this makes any sense
PHP код:
CREATE TABLE `factions` (
`ID` INT(10) NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(128) NULL DEFAULT '0',
`EnterX` FLOAT NULL DEFAULT '0',
`EnterY` FLOAT NULL DEFAULT '0',
`EnterZ` FLOAT NULL DEFAULT '0',
`ExitX` FLOAT NULL DEFAULT '0',
`ExitY` FLOAT NULL DEFAULT '0',
`ExitZ` FLOAT NULL DEFAULT '0',
`Interior` INT(10) NULL DEFAULT '0',
`World` INT(10) NULL DEFAULT '0',
`Rank1` VARCHAR(24) NULL DEFAULT '0',
`Rank2` VARCHAR(24) NULL DEFAULT '0',
`Rank3` VARCHAR(24) NULL DEFAULT '0',
`Rank4` VARCHAR(24) NULL DEFAULT '0',
`Rank5` VARCHAR(24) NULL DEFAULT '0',
`Rank6` VARCHAR(24) NULL DEFAULT '0',
`Rank7` VARCHAR(24) NULL DEFAULT '0',
`Rank8` VARCHAR(24) NULL DEFAULT '0',
`Rank9` VARCHAR(24) NULL DEFAULT '0',
`Rank10` VARCHAR(24) NULL DEFAULT '0',
`FactionBank` INT(10) NULL DEFAULT '0',
`DeagleAmmo` INT(10) NULL DEFAULT '0',
`M4Ammo` INT(10) NULL DEFAULT '0',
`ShotgunAmmo` INT(10) NULL DEFAULT '0',
`SniperAmmo` INT(10) NULL DEFAULT '0',
`CocaineSmuggledWhen` INT(15) NULL DEFAULT '0',
`Type` INT(2) NULL DEFAULT '0',
`CocaAmount` INT(10) NULL DEFAULT '0',
PRIMARY KEY (`ID`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
;