warband scripts sql

-- ---
-- Globals
-- ---

-- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-- SET FOREIGN_KEY_CHECKS=0;

-- ---
-- Table 'account'
--
-- ---

DROP TABLE IF EXISTS `account`;

CREATE TABLE `account` (
  `id` INTEGER(5) NULL AUTO_INCREMENT DEFAULT NULL,
  `guid` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is the players unique id!',
  `head` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is where head armor goes!',
  `body` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is where body armor goes!',
  `hand` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is where hand armor goes!',
  `foot` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is where foot armor goes!',
  `horse` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is where equiped horse goes!',
  `horse_health` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is where equiped horse health goes!',
  `slot1` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is item slot 1!',
  `slot2` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is item slot 2!',
  `slot3` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is item slot 3!',
  `slot4` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is item slot 4!',
  `health` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is player health!',
  `hunger` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is player hunger!',
  `faction` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is player faction!',
  `player_gold` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is player gold!',
  `bank_gold` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is player bank gold!',
  `status` INTEGER NULL DEFAULT NULL COMMENT 'This is player status (online, offline, etc)',
  `posx` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is the player x position!',
  `posy` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is the player y position!',
  `posz` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is the player z position!',
  `banned_yes` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is if the player is banned or not!',
  `admin_level` INTEGER(30) NULL DEFAULT NULL COMMENT '0 = none, 1 = teleport, 2 = kick, 3 = ban',
  PRIMARY KEY (`id`),
  UNIQUE KEY (`guid`)
);

-- ---
-- Table 'names'
--
-- ---

DROP TABLE IF EXISTS `names`;

CREATE TABLE `names` (
  `id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
  `guid` INTEGER(30) NULL DEFAULT NULL COMMENT 'This is the players unique id!',
  `name` VARCHAR(30) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY (`name`)
);

-- ---
-- Foreign Keys
-- ---

ALTER TABLE `names` ADD FOREIGN KEY (guid) REFERENCES `account` (`guid`);

-- ---
-- Table Properties
-- ---

-- ALTER TABLE `account` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ALTER TABLE `names` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ---
-- Test Data
-- ---

-- INSERT INTO `account` (`id`,`guid`,`head`,`body`,`hand`,`foot`,`horse`,`horse_health`,`slot1`,`slot2`,`slot3`,`slot4`,`health`,`hunger`,`faction`,`player_gold`,`bank_gold`,`status`,`posx`,`posy`,`posz`,`banned_yes`,`admin_level`) VALUES
-- ('','','','','','','','','','','','','','','','','','','','','','','');
-- INSERT INTO `names` (`id`,`guid`,`name`) VALUES
-- ('','','');