94 lines
6.1 KiB
SQL
94 lines
6.1 KiB
SQL
DROP TABLE IF EXISTS heroic_ops;
|
|
CREATE TABLE heroic_ops (
|
|
id INTEGER PRIMARY KEY,
|
|
ho_type TEXT NOT NULL DEFAULT 'Starter',
|
|
name TEXT,
|
|
starter_link_id INTEGER NOT NULL DEFAULT 0,
|
|
starter_class INTEGER NOT NULL DEFAULT 0,
|
|
enhancer_class INTEGER NOT NULL DEFAULT 0,
|
|
starter_icon INTEGER NOT NULL DEFAULT 65535,
|
|
chain_order INTEGER NOT NULL DEFAULT 0,
|
|
shift_icon INTEGER NOT NULL DEFAULT 41,
|
|
spell_id INTEGER NOT NULL DEFAULT 0,
|
|
chance REAL NOT NULL DEFAULT 0,
|
|
ability1 INTEGER NOT NULL DEFAULT 65535,
|
|
ability2 INTEGER NOT NULL DEFAULT 65535,
|
|
ability3 INTEGER NOT NULL DEFAULT 65535,
|
|
ability4 INTEGER NOT NULL DEFAULT 65535,
|
|
ability5 INTEGER NOT NULL DEFAULT 65535,
|
|
ability6 INTEGER NOT NULL DEFAULT 65535
|
|
);
|
|
|
|
INSERT INTO heroic_ops VALUES
|
|
(1,'Starter',NULL,0,21,0,26,0,0,0,0,25,65535,65535,65535,65535,65535),
|
|
(2,'Starter',NULL,0,21,2147483648,26,0,0,0,0,41,65535,65535,65535,65535,65535),
|
|
(3,'Starter',NULL,0,21,2048,26,0,0,0,0,14,65535,65535,65535,65535,65535),
|
|
(4,'Starter',NULL,0,11,2147483648,17,0,0,0,0,41,65535,65535,65535,65535,65535),
|
|
(5,'Starter',NULL,0,11,0,17,0,0,0,0,14,65535,65535,65535,65535,65535),
|
|
(6,'Starter',NULL,0,1,2048,1,0,0,0,0,12,65535,65535,65535,65535,65535),
|
|
(7,'Starter',NULL,0,1,2099200,1,0,0,0,0,14,25,65535,65535,65535,65535),
|
|
(8,'Starter',NULL,0,1,0,1,0,0,0,0,0,65535,65535,65535,65535,65535),
|
|
(9,'Starter',NULL,0,1,2147483648,1,0,0,0,0,41,65535,65535,65535,65535,65535),
|
|
(10,'Starter',NULL,0,31,2050,39,0,0,0,0,4,12,65535,65535,65535,65535),
|
|
(12,'Starter',NULL,0,31,2097154,39,0,0,0,0,2,25,65535,65535,65535,65535),
|
|
(13,'Starter',NULL,0,31,0,39,0,0,0,0,41,65535,65535,65535,65535,65535),
|
|
(14,'Starter',NULL,0,31,2099200,39,0,0,0,0,12,25,65535,65535,65535,65535),
|
|
(15,'Starter',NULL,0,1,2097152,1,0,0,0,0,25,65535,65535,65535,65535,65535),
|
|
(16,'Starter',NULL,0,31,2099202,39,0,0,0,0,2,16,28,65535,65535,65535),
|
|
(21,'Wheel',NULL,1,0,2097152,0,0,41,5188,60,25,65535,65535,65535,65535,65535),
|
|
(22,'Wheel',NULL,1,0,2097152,0,0,41,5240,30,29,65535,65535,65535,65535,65535),
|
|
(23,'Wheel',NULL,1,0,2097152,0,0,41,5187,10,28,65535,65535,65535,65535,65535),
|
|
(31,'Wheel',NULL,5,0,11,0,0,41,5205,60,14,65535,65535,65535,65535,65535),
|
|
(32,'Wheel',NULL,5,0,11,0,0,41,5212,30,14,65535,65535,65535,65535,65535),
|
|
(33,'Wheel',NULL,5,0,11,0,0,41,5195,10,12,65535,65535,65535,65535,65535),
|
|
(41,'Wheel',NULL,13,0,2147483648,0,0,41,5221,60,36,65535,65535,65535,65535,65535),
|
|
(42,'Wheel',NULL,13,0,2147483648,0,0,41,5232,30,36,65535,65535,65535,65535,65535),
|
|
(43,'Wheel',NULL,13,0,2147483648,0,0,41,5196,10,36,65535,65535,65535,65535,65535),
|
|
(51,'Wheel',NULL,8,0,0,0,0,41,5203,20,2,65535,65535,65535,65535,65535),
|
|
(52,'Wheel',NULL,8,0,0,0,0,41,5225,70,2,65535,65535,65535,65535,65535),
|
|
(53,'Wheel',NULL,8,0,0,0,0,41,5211,10,2,65535,65535,65535,65535,65535),
|
|
(201,'Wheel',NULL,3,0,2048,0,0,41,5181,10,16,65535,65535,65535,65535,65535),
|
|
(202,'Wheel',NULL,3,0,2048,0,0,41,5230,70,14,25,65535,65535,65535,65535),
|
|
(203,'Wheel',NULL,3,0,2048,0,0,41,5199,70,25,12,65535,65535,65535,65535),
|
|
(204,'Wheel',NULL,3,0,2048,0,1,41,5186,30,28,12,65535,65535,65535,65535),
|
|
(205,'Wheel',NULL,2,0,2147483648,0,0,41,5190,70,25,36,65535,65535,65535,65535),
|
|
(206,'Wheel',NULL,2,0,2147483648,0,0,41,5220,30,38,36,25,65535,65535,65535),
|
|
(207,'Wheel',NULL,2,0,2147483648,0,1,41,5235,10,34,38,65535,65535,65535,65535),
|
|
(208,'Wheel',NULL,2,0,2147483648,0,1,41,5224,70,36,25,65535,65535,65535,65535),
|
|
(301,'Wheel',NULL,4,0,2147483648,0,0,41,5218,70,16,40,65535,65535,65535,65535),
|
|
(302,'Wheel',NULL,4,0,2147483648,0,1,41,5207,30,12,40,65535,65535,65535,65535),
|
|
(303,'Wheel',NULL,4,0,2147483648,0,1,41,5209,70,36,12,65535,65535,65535,65535),
|
|
(304,'Wheel',NULL,4,0,2147483648,0,1,41,5208,10,12,40,65535,65535,65535,65535),
|
|
(401,'Wheel',NULL,12,0,2097154,0,0,41,5237,70,29,38,2,65535,65535,65535),
|
|
(402,'Wheel',NULL,12,0,2097154,0,0,41,5226,70,0,36,25,65535,65535,65535),
|
|
(403,'Wheel',NULL,12,0,2097154,0,0,41,5210,30,25,38,5,65535,65535,65535),
|
|
(404,'Wheel',NULL,12,0,2097154,0,1,41,5184,10,28,40,5,65535,65535,65535),
|
|
(405,'Wheel',NULL,10,0,2050,0,0,41,5238,70,12,65535,65535,65535,65535,65535),
|
|
(406,'Wheel',NULL,10,0,2050,0,0,41,5198,70,0,36,25,65535,65535,65535),
|
|
(407,'Wheel',NULL,10,0,2050,0,0,41,5216,30,38,0,14,65535,65535,65535),
|
|
(408,'Wheel',NULL,10,0,2050,0,0,41,5223,10,25,2,16,65535,65535,65535),
|
|
(409,'Wheel',NULL,14,0,2099200,0,1,41,5197,70,25,15,65535,65535,65535,65535),
|
|
(410,'Wheel',NULL,14,0,2099200,0,1,41,5192,30,25,14,36,65535,65535,65535),
|
|
(411,'Wheel',NULL,14,0,2099200,0,1,41,5202,10,25,40,12,65535,65535,65535),
|
|
(412,'Wheel',NULL,14,0,2099200,0,1,41,5215,30,0,15,28,65535,65535,65535),
|
|
(413,'Wheel',NULL,16,0,2099202,0,1,41,5233,70,2,36,25,65535,65535,65535),
|
|
(414,'Wheel',NULL,16,0,2099202,0,0,41,5229,30,12,5,65535,65535,65535,65535),
|
|
(415,'Wheel',NULL,16,0,2099202,0,1,41,5217,10,29,5,40,65535,65535,65535),
|
|
(416,'Wheel',NULL,16,0,2099202,0,0,41,5182,30,4,40,25,14,65535,65535),
|
|
(501,'Wheel',NULL,9,0,2147483648,0,0,41,5213,70,4,40,65535,65535,65535,65535),
|
|
(502,'Wheel',NULL,9,0,2147483648,0,0,41,5194,70,0,36,65535,65535,65535,65535),
|
|
(503,'Wheel',NULL,9,0,2147483648,0,1,41,5231,30,40,5,65535,65535,65535,65535),
|
|
(504,'Wheel',NULL,9,0,2147483648,0,1,41,5219,10,40,2,65535,65535,65535,65535),
|
|
(505,'Wheel',NULL,6,0,2048,0,0,41,5204,70,14,0,65535,65535,65535,65535),
|
|
(506,'Wheel',NULL,6,0,2048,0,0,41,5206,70,0,12,65535,65535,65535,65535),
|
|
(507,'Wheel',NULL,6,0,2048,0,0,41,5201,30,2,16,65535,65535,65535,65535),
|
|
(508,'Wheel',NULL,6,0,2048,0,0,41,5200,10,12,65535,65535,65535,65535,65535),
|
|
(509,'Wheel',NULL,15,0,21,0,1,41,5222,70,2,25,65535,65535,65535,65535),
|
|
(510,'Wheel',NULL,15,0,21,0,0,41,5185,70,3,29,65535,65535,65535,65535),
|
|
(511,'Wheel',NULL,15,0,21,0,0,41,5228,30,25,2,65535,65535,65535,65535),
|
|
(512,'Wheel',NULL,15,0,21,0,1,41,5227,10,28,5,65535,65535,65535,65535),
|
|
(513,'Wheel',NULL,7,0,2099200,0,0,41,5189,70,29,5,12,65535,65535,65535),
|
|
(514,'Wheel',NULL,7,0,2099200,0,1,41,5191,30,15,5,28,65535,65535,65535),
|
|
(515,'Wheel',NULL,7,0,2099200,0,0,41,5234,10,0,28,14,65535,65535,65535),
|
|
(516,'Wheel',NULL,7,0,2099200,0,1,41,5183,70,28,3,14,65535,65535,65535);
|