DROP TABLE IF EXISTS spell_aa_list; CREATE TABLE spell_aa_list ( list_id INTEGER PRIMARY KEY, name TEXT NOT NULL DEFAULT '', level INTEGER NOT NULL DEFAULT 0, maximumpoints INTEGER NOT NULL DEFAULT 0, maxpoints INTEGER NOT NULL DEFAULT 0, minimumpointsrequired INTEGER NOT NULL DEFAULT 0, iswardertree INTEGER NOT NULL DEFAULT 0, last_update REAL NOT NULL DEFAULT 0, ts REAL NOT NULL, version INTEGER NOT NULL DEFAULT 0 ); INSERT INTO spell_aa_list VALUES (1,'Bard',10,0,100,0,0,1384380000,1384380000,2), (2,'Brawler',10,0,100,0,0,1384380000,1384380000,2), (3,'Cleric',10,0,100,0,0,1384380000,1384380000,2), (4,'Crusader',10,0,100,0,0,1384380000,1384380000,2), (5,'Druid',10,0,100,0,0,1384380000,1384380000,2), (6,'Enchanter',10,0,100,0,0,1384290000,1384290000,2), (7,'Predator',10,0,100,0,0,1384380000,1384380000,2), (8,'Rogue',10,0,100,0,0,1384370000,1384370000,2), (9,'Shaman',10,0,100,0,0,1384370000,1384370000,2), (10,'Sorcerer',10,0,100,0,0,1384380000,1384380000,2), (11,'Summoner',10,0,100,0,0,1384380000,1384380000,2), (12,'Warrior',10,0,100,0,0,1384380000,1384380000,2), (13,'Guardian',10,0,100,0,0,1384380000,1384380000,2), (14,'Berserker',10,0,100,0,0,1384380000,1384380000,2), (15,'Paladin',10,0,100,0,0,1384380000,1384380000,2), (16,'Shadowknight',10,0,100,0,0,1384380000,1384380000,2), (17,'Monk',10,0,100,0,0,1384380000,1384380000,2), (18,'Bruiser',10,0,100,0,0,1384380000,1384380000,2), (19,'Assassin',10,0,100,0,0,1384380000,1384380000,2), (20,'Ranger',10,0,100,0,0,1384370000,1384370000,2), (21,'Brigand',10,0,100,0,0,1384380000,1384380000,2), (22,'Swashbuckler',10,0,100,0,0,1384380000,1384380000,2), (23,'Dirge',10,0,100,0,0,1384380000,1384380000,2), (24,'Troubador',10,0,100,0,0,1384380000,1384380000,2), (25,'Templar',10,0,100,0,0,1384380000,1384380000,2), (26,'Inquisitor',10,0,100,0,0,1384380000,1384380000,2), (27,'Warden',10,0,100,0,0,1384380000,1384380000,2), (28,'Fury',10,0,100,0,0,1384380000,1384380000,2), (29,'Mystic',10,0,100,0,0,1384380000,1384380000,2), (30,'Defiler',10,0,100,0,0,1384380000,1384380000,2), (31,'Wizard',10,0,100,0,0,1384380000,1384380000,2), (32,'Warlock',10,0,100,0,0,1384380000,1384380000,2), (33,'Conjuror',10,0,100,0,0,1384380000,1384380000,2), (34,'Necromancer',10,0,100,0,0,1384380000,1384380000,2), (35,'Coercer',10,0,100,0,0,1384380000,1384380000,2), (36,'Illusionist',10,0,100,0,0,1384370000,1384370000,2), (37,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (38,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (39,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (40,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (41,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (42,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (43,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (44,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (45,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (46,'Shadows',10,0,100,0,0,1384290000,1384290000,2), (47,'Shadows',10,0,100,0,0,1384370000,1384370000,2), (48,'Shadows',10,0,100,0,0,1384370000,1384370000,2), (49,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (50,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (51,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (52,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (53,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (54,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (55,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (56,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (57,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (58,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (59,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (60,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (61,'Heroic',10,0,100,0,0,1384380000,1384380000,2), (62,'Heroic',10,0,100,0,0,1384380000,1384380000,2), (63,'Heroic',10,0,100,0,0,1384380000,1384380000,2), (64,'Heroic',10,0,100,0,0,1384290000,1384290000,2), (65,'Heroic',10,0,100,0,0,1384380000,1384380000,2), (66,'Heroic',10,0,100,0,0,1384380000,1384380000,2), (67,'Heroic',10,0,100,0,0,1384380000,1384380000,2), (68,'Heroic',10,0,100,0,0,1384380000,1384380000,2), (69,'Heroic',10,0,100,0,0,1384370000,1384370000,2), (70,'Heroic',10,0,100,0,0,1384380000,1384380000,2), (71,'Heroic',10,0,100,0,0,1384370000,1384370000,2), (72,'Heroic',10,0,100,0,0,1384380000,1384380000,2), (73,'Tradeskill',10,0,40,0,0,1384380000,1384380000,2), (74,'Animalist',10,0,100,0,0,1384380000,1384380000,2), (75,'Beastlord',10,0,100,0,0,1384380000,1384380000,2), (76,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (77,'Heroic',10,0,100,0,0,1384380000,1384380000,2), (78,'Aquatic',20,0,40,0,0,1384290000,1384290000,2), (79,'Canine',20,0,40,0,0,1384380000,1384380000,2), (80,'Feline',20,0,40,0,0,1384380000,1384380000,2), (81,'Avian',20,0,40,0,0,1384380000,1384380000,2), (82,'Bat',20,0,40,0,0,1384380000,1384380000,2), (83,'Reptile',20,0,40,0,0,1384290000,1384290000,2), (84,'Bear',20,0,40,0,0,1384380000,1384380000,2), (85,'Boar',20,0,40,0,0,1384290000,1384290000,2), (86,'Bovid',20,0,40,0,0,1384380000,1384380000,2), (87,'War Boar',20,0,40,0,0,1384380000,1384380000,2), (88,'Mystical',20,0,40,0,0,1384380000,1384380000,2), (89,'Simian',20,0,40,0,0,1384380000,1384380000,2), (90,'Amphibian',20,0,40,0,0,1384290000,1384290000,2), (91,'Dire',20,0,40,0,0,1384380000,1384380000,2), (92,'Drake',20,0,40,0,0,1384380000,1384380000,2), (93,'Enchanted',20,0,40,0,0,1384370000,1384370000,2), (94,'Rodent',20,0,40,0,0,1384380000,1384380000,2), (95,'Insect',20,0,40,0,0,1384380000,1384380000,2), (96,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (97,'Prestige',90,0,25,0,0,1384370000,1384370000,2), (98,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (99,'Prestige',90,0,25,0,0,1384290000,1384290000,2), (100,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (101,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (102,'Prestige',90,0,25,0,0,1384290000,1384290000,2), (103,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (104,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (105,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (106,'Prestige',90,0,25,0,0,1384290000,1384290000,2), (107,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (108,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (109,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (110,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (111,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (112,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (113,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (114,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (115,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (116,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (117,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (118,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (119,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (120,'Prestige',90,0,25,0,0,1384370000,1384370000,2), (121,'Tradeskill Prestige',90,0,25,0,0,1384380000,1384380000,2), (122,'Shaper',10,0,100,0,0,1384380000,1384380000,2), (123,'Channeler',10,0,100,0,0,1384380000,1384380000,2), (124,'Shadows',10,0,100,0,0,1384380000,1384380000,2), (125,'Heroic',10,0,100,0,0,1384380000,1384380000,2), (126,'Prestige',90,0,25,0,0,1384380000,1384380000,2), (127,'Dragon',10,0,100,0,0,1384380000,1384380000,2), (128,'Dragon',10,0,100,0,0,1384380000,1384380000,2), (129,'Dragon',10,0,100,0,0,1384380000,1384380000,2), (130,'Dragon',10,0,100,0,0,1384290000,1384290000,2), (132,'Prismatic',95,0,25,0,0,1384290000,1384290000,2), (158,'Far Seas',95,0,25,0,0,1384290000,1384290000,2);