WcfE7ceB

1CREATE DATABASE eo_vipdb;
2USE eo_vipdb;
3
4-- Tables----------------------------------------------------------------------------------
5
6CREATE TABLE IF NOT EXISTS `VIPs`
7(
8	`ID` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
9	`Username` VARCHAR(25) NOT NULL,
10	`VIPLevel` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
11	`Timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
12	`SpawnInBase` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
13	`WeaponPreset` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
14	`WeaponMeleeSlot` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
15	`WeaponPistolSlot` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
16	`WeaponShotgunSlot` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
17	`WeaponSubMachineSlot` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
18	`WeaponAssaultSlot` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
19	`WeaponRifleSlot` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
20            
21	CONSTRAINT pk_id PRIMARY KEY(`ID`)
22);
23
24SELECT * FROM `VIPs`;