· 9 years ago · Dec 12, 2016, 08:54 PM
1CREATE TABLE IF NOT EXISTS kits (id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(20) , displayName VARCHAR(60) NOT NULL,lore VARCHAR(500) NOT NULL, price INT DEFAULT 0);
2CREATE UNIQUE INDEX IF NOT EXISTS kits_name_uindex ON kits (name);
3INSERT IGNORE INTO kits (name, displayName, lore, price) VALUES('MARKSMAN','§3Marksman','§7Default kit/§7New line',0),('PYROTECHNIC','§3Pyrotechnic','§7Second kit',5000),('COWARD','§3Coward','§7Third kit',4000);
4CREATE TABLE IF NOT EXISTS players(id INT PRIMARY KEY AUTO_INCREMENT,player VARCHAR(60),pyroKit BOOLEAN DEFAULT FALSE ,cowardKit BOOLEAN DEFAULT FALSE ,wins INT DEFAULT 0,