Guest User

Fortcarson Table structure

a guest
Jun 30th, 2014
740
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.11 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `fortcarson` (
  2.   `Fullname` VARCHAR(128) NOT NULL,
  3.   `Password` VARCHAR(129) NOT NULL,
  4.   `SqlID` INT(11) DEFAULT NULL,
  5.   `PositionX` FLOAT NOT NULL,
  6.   `PositionY` FLOAT NOT NULL,
  7.   `PositionZ` FLOAT NOT NULL,
  8.   `PositionA` FLOAT NOT NULL,
  9.   `Health` FLOAT NOT NULL,
  10.   `Armour` FLOAT NOT NULL,
  11.   `Interior` INT(11) NOT NULL,
  12.   `VirtualWorld` INT(11) NOT NULL,
  13.   `AdminLevel` INT(11) NOT NULL DEFAULT '0',
  14.   `AdminKey` INT(11) NOT NULL DEFAULT '1234',
  15.   `Banned` INT(11) NOT NULL DEFAULT '0',
  16.   `BanReason` VARCHAR(126) NOT NULL DEFAULT 'Not Banned',
  17.   `BannedBy` VARCHAR(126) DEFAULT 'Not Banned',
  18.   `Warnings` INT(11) NOT NULL DEFAULT '0',
  19.   `Warning1Reason` VARCHAR(126) NOT NULL DEFAULT 'Not Warned',
  20.   `Warning2Reason` VARCHAR(126) NOT NULL DEFAULT 'Not Warned',
  21.   `Warning3Reason` VARCHAR(126) NOT NULL DEFAULT 'Not Warned',
  22.   `WarnedBy1` VARCHAR(126) NOT NULL DEFAULT 'Not Warned',
  23.   `WarnedBy2` VARCHAR(126) NOT NULL DEFAULT 'Not Warned',
  24.   `WarnedBy3` VARCHAR(126) NOT NULL DEFAULT 'Not Warned',
  25.   `Dead` INT(11) DEFAULT '0',
  26.   `HospitalTime` INT(11) NOT NULL DEFAULT '0'
  27. )
Advertisement
Add Comment
Please, Sign In to add comment