mirror of
https://github.com/simtactics/mysimulation.git
synced 2025-03-22 09:22:24 +00:00
26 lines
835 B
MySQL
26 lines
835 B
MySQL
|
CREATE TABLE IF NOT EXISTS `fso_shards` (
|
|||
|
|
`shard_id` int(11) NOT NULL,
|
|||
|
|
`name` varchar(100) NOT NULL,
|
|||
|
|
`rank` int(11) NOT NULL,
|
|||
|
|
`map` varchar(10) NOT NULL,
|
|||
|
|
`status` enum('up','down','busy','full','closed','frontier') NOT NULL,
|
|||
|
|
`internal_host` varchar(100) NOT NULL,
|
|||
|
|
`public_host` varchar(100) NOT NULL,
|
|||
|
|
PRIMARY KEY (`shard_id`)
|
|||
|
|
)
|
|||
|
|
COLLATE='utf8_general_ci'
|
|||
|
|
ENGINE=InnoDB;
|
|||
|
|
|
|||
|
|
-- Default shard
|
|||
|
|
INSERT INTO fso_shards VALUES (1, 'Alphaville', 1, '0001', 'up', '127.0.0.1:7777', '127.0.0.1:7777') ON DUPLICATE KEY UPDATE shard_id = shard_id;
|
|||
|
|
|
|||
|
|
CREATE TABLE IF NOT EXISTS `fso_shard_tickets` (
|
|||
|
|
`ticket_id` VARCHAR(36) NOT NULL,
|
|||
|
|
`user_id` INT UNSIGNED NOT NULL,
|
|||
|
|
`date` INT UNSIGNED NOT NULL,
|
|||
|
|
`ip` VARCHAR(50) NOT NULL,
|
|||
|
|
`avatar_id` INT UNSIGNED NOT NULL,
|
|||
|
|
PRIMARY KEY (`ticket_id`)
|
|||
|
|
)
|
|||
|
|
COLLATE='utf8_general_ci'
|
|||
|
|
ENGINE=InnoDB;
|