Building SQL table
#5

Did you resolve this mate? Make sure you use auto increment on the "entranceDBID" row.

I would send you the table if I still had it... I'm sure I put it in the script somewhere anyway :3

Edit: Yes I did.
pawn Код:
CREATE TABLE `entrances` (
    `entranceDBID` INT(11) NOT NULL AUTO_INCREMENT,
    `entranceName` VARCHAR(128) NULL DEFAULT '',
    `entranceExteriorVW` INT(11) NULL DEFAULT '0',
    `entranceInteriorVW` INT(11) NULL DEFAULT '0',
    `entranceExteriorIntWorld` INT(11) NULL DEFAULT '0',
    `entranceInteriorIntWorld` INT(11) NULL DEFAULT '0',
    `entranceExteriorPosX` VARCHAR(64) NULL DEFAULT '0.0',
    `entranceExteriorPosY` VARCHAR(64) NULL DEFAULT '0.0',
    `entranceExteriorPosZ` VARCHAR(64) NULL DEFAULT '0.0',
    `entranceExteriorPosA` VARCHAR(64) NULL DEFAULT '0.0',
    `entranceInteriorPosX` VARCHAR(64) NULL DEFAULT '0.0',
    `entranceInteriorPosY` VARCHAR(64) NULL DEFAULT '0.0',
    `entranceInteriorPosZ` VARCHAR(64) NULL DEFAULT '0.0',
    `entranceInteriorPosA` VARCHAR(64) NULL DEFAULT '0.0',
    `entranceStreamedExterior` INT(11) NULL DEFAULT '0',
    `entranceStreamedInterior` INT(11) NULL DEFAULT '0',
    `entranceVIP` INT(11) NULL DEFAULT '0',
    `entranceGang` INT(11) NULL DEFAULT '255',
    `entranceGroup` INT(11) NULL DEFAULT '255',
    `entranceGroupType` INT(11) NULL DEFAULT '0',
    `entranceAdmin` INT(11) NULL DEFAULT '0',
    `entranceOwnerDBID` INT(11) NULL DEFAULT '0',
    `entranceOwnerName` VARCHAR(24) NULL DEFAULT '',
    `entranceWantedLevel` INT(11) NULL DEFAULT '0',
    `entranceVehicleAble` INT(11) NULL DEFAULT '0',
    `entranceColour` INT(11) NULL DEFAULT '0',
    `entrancePickupModel` INT(11) NULL DEFAULT '0',
    `entranceLocked` INT(11) NULL DEFAULT '0',
    `entrancePass` INT(11) NULL DEFAULT '0',
    `entranceTracable` INT(11) NULL DEFAULT '0',
    PRIMARY KEY (`entranceDBID`)
)
Reply


Messages In This Thread
Building SQL table - by conor565 - 16.11.2013, 19:12
Re: Building SQL table - by Memoryz - 16.11.2013, 21:24
Re: Building SQL table - by conor565 - 17.11.2013, 09:18
Re: Building SQL table - by conor565 - 17.11.2013, 09:43
Re: Building SQL table - by ryansheilds - 23.11.2013, 05:34

Forum Jump:


Users browsing this thread: 1 Guest(s)