Sql Updated

CREATE TABLE IF NOT EXISTS `codex_supplies` (
  `town` varchar(50) NOT NULL,
  `supplies` int(11) NOT NULL DEFAULT 0,
  `has_raided` varchar(50) NOT NULL,
  PRIMARY KEY (`town`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=DYNAMIC;

INSERT INTO `codex_supplies` (`town`, `supplies`, `has_raided`) VALUES
    ('AnnessBurg', 2, '0'),
    ('Armadilo', 2, '0'),
    ('BlackWater', 2, '0'),
    ('Rhodes', 2, '0'),
    ('Saint Denis', 999, '0'),
    ('Strawberry', 999, '0'),
    ('TambleWeed', 999, '0'),
    ('Valentine', 999, '0'),
    ('VanHorn', 999, '0');

Last updated

Was this helpful?