pogohelper.db.sql

CREATE TABLE IF NOT EXISTS RAIDBOSS(ID INTEGER PRIMARY KEY AUTOINCREMENT, BOSS TEXT NOT NULL, STRENGTH INT);
CREATE TABLE IF NOT EXISTS NOTIFICATIONS(ID INTEGER PRIMARY KEY AUTOINCREMENT, RAIDID INTEGER NOT NULL, PLAYERID INTEGER NOT NULL, READY BOOLEAN DEFAULT 0);
CREATE TABLE IF NOT EXISTS USERS(ID INT PRIMARY KEY NOT NULL, NAME TEXT NOT NULL, TEAM TEXT NOT NULL, LEVEL SMALLINT NOT NULL, FIRSTNAME TEXT, SURNAME TEXT, USERNAME TEXT, NOTIFICATIONS BOOLEAN DEFAULT 0, HEARTBEAT DATETIME, LANGUAGE INT DEFAULT 1);
CREATE TABLE IF NOT EXISTS RAID(ID INTEGER PRIMARY KEY AUTOINCREMENT, CREATED_BY INT NOT NULL, BOSS TEXT NOT NULL, LAT FLOAT NOT NULL, LONG FLOAT NOT NULL, TIME DATETIME NOT NULL, GYM TEXT, READY BOOLEAN DEFAULT 0);
CREATE TABLE IF NOT EXISTS RAIDPLAYERS(ID INTEGER PRIMARY KEY AUTOINCREMENT, RAIDID INTEGER NOT NULL, PLAYERID INTEGER NOT NULL, FRIENDS INTEGER DEFAULT 0, PREFERRED_TIME DATETIME DEFAULT (datetime('now','localtime')));
CREATE TABLE IF NOT EXISTS LANGUAGES(ID INTEGER PRIMARY KEY AUTOINCREMENT, LANGUAGE TEXT NOT NULL);
INSERT OR IGNORE INTO LANGUAGES (ID,LANGUAGE) VALUES (1,'ENGLISH');
INSERT OR IGNORE INTO LANGUAGES (ID,LANGUAGE) VALUES (2,'ITALIAN');
INSERT OR IGNORE INTO LANGUAGES (ID,LANGUAGE) VALUES (3,'DUTCH');
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(1,'Magikarp',1);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(2,'Croconaw',1);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(3,'Bayleef',1);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(4,'Quilava',1);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(5,'Electabuzz',1);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(6,'Exeggutor',1);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(7,'Magmar',1);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(8,'Muk',1);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(9,'Weezing',1);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(10,'Vaporeon',3);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(11,'Arcanine',2);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(12,'Machamp',3);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(13,'Jolteon',3);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(14,'Gengar',3);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(15,'Flareon',3);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(16,'Alakazam',3);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(17,'Lapras',6);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(18,'Blastoise',5);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(19,'Venusaur',5);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(20,'Charizard',5);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(21,'Snorlax',7);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(22,'Rhydon',7);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(23,'Tyranitar',7);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(24,'Articuno',8);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(25,'Zapdos',8);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(26,'Moltres',7);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(27,'Mewtwo',15);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(28,'Raikou',NULL);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(29,'Entei',NULL);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(30,'Suicune',NULL);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(31,'Lugia',13);
INSERT OR IGNORE INTO "RAIDBOSS" VALUES(32,'Ho-oh',15);
COMMIT;