136 lines
5.4 KiB
SQL
136 lines
5.4 KiB
SQL
DROP TABLE IF EXISTS starting_items;
|
|
CREATE TABLE starting_items (
|
|
id INTEGER PRIMARY KEY,
|
|
class_id INTEGER NOT NULL DEFAULT 255,
|
|
race_id INTEGER NOT NULL DEFAULT 255,
|
|
type TEXT NOT NULL DEFAULT 'NOT-EQUIPPED',
|
|
item_id INTEGER NOT NULL DEFAULT 0,
|
|
creator TEXT,
|
|
condition_ INTEGER NOT NULL DEFAULT 100,
|
|
attuned INTEGER NOT NULL DEFAULT 0,
|
|
count INTEGER NOT NULL DEFAULT 1,
|
|
UNIQUE(class_id, race_id, type, item_id),
|
|
FOREIGN KEY (item_id) REFERENCES items(id) ON UPDATE CASCADE
|
|
);
|
|
CREATE INDEX idx_starting_items_item_id ON starting_items(item_id);
|
|
|
|
INSERT INTO starting_items VALUES
|
|
(3,42,255,'EQUIPPED',134899,'',100,0,1),
|
|
(4,42,255,'EQUIPPED',71041,'',100,0,1),
|
|
(5,42,255,'EQUIPPED',134900,'',100,0,1),
|
|
(6,42,255,'EQUIPPED',134901,'',100,0,1),
|
|
(7,36,255,'EQUIPPED',186964,'',100,0,1),
|
|
(8,36,255,'EQUIPPED',89436,'',100,0,2),
|
|
(14,37,255,'EQUIPPED',144517,'',100,0,1),
|
|
(15,37,255,'EQUIPPED',144519,'',100,0,1),
|
|
(16,37,255,'EQUIPPED',144516,'',100,0,1),
|
|
(20,13,255,'EQUIPPED',184887,'',100,0,1),
|
|
(21,13,255,'EQUIPPED',184889,'',100,0,1),
|
|
(22,13,255,'EQUIPPED',184886,'',100,0,1),
|
|
(23,13,255,'EQUIPPED',88905,'',100,0,1),
|
|
(24,17,255,'EQUIPPED',154403,'',100,0,1),
|
|
(25,17,255,'EQUIPPED',154402,'',100,0,1),
|
|
(26,17,255,'EQUIPPED',154401,'',100,0,1),
|
|
(27,17,255,'EQUIPPED',79258,'',100,0,1),
|
|
(29,14,255,'EQUIPPED',160641,'',100,0,1),
|
|
(30,14,255,'EQUIPPED',160638,'',100,0,1),
|
|
(31,14,255,'EQUIPPED',83260,'',100,0,1),
|
|
(32,16,255,'EQUIPPED',189954,'',100,0,1),
|
|
(33,16,255,'EQUIPPED',189955,'',100,0,1),
|
|
(34,16,255,'EQUIPPED',189953,'',100,0,1),
|
|
(35,16,255,'EQUIPPED',90087,'',100,0,1),
|
|
(36,27,255,'EQUIPPED',139787,'',100,0,1),
|
|
(37,27,255,'EQUIPPED',139788,'',100,0,1),
|
|
(38,27,255,'EQUIPPED',139789,'',100,0,1),
|
|
(39,27,255,'EQUIPPED',73251,'',100,0,1),
|
|
(40,26,255,'EQUIPPED',158994,'',100,0,1),
|
|
(41,26,255,'EQUIPPED',158995,'',100,0,1),
|
|
(42,26,255,'EQUIPPED',158996,'',100,0,1),
|
|
(43,26,255,'EQUIPPED',80159,'',100,0,1),
|
|
(44,6,255,'EQUIPPED',164838,'',100,0,1),
|
|
(45,6,255,'EQUIPPED',164839,'',100,0,1),
|
|
(46,6,255,'EQUIPPED',164841,'',100,0,1),
|
|
(47,6,255,'EQUIPPED',84307,'',100,0,1),
|
|
(49,6,255,'EQUIPPED',43203,'',100,0,1),
|
|
(50,6,255,'EQUIPPED',20530,'',100,0,50),
|
|
(51,14,255,'EQUIPPED',160639,'',100,0,1),
|
|
(52,9,255,'EQUIPPED',86297,'',100,0,1),
|
|
(53,9,255,'EQUIPPED',176518,'',100,0,1),
|
|
(54,9,255,'EQUIPPED',176519,'',100,0,1),
|
|
(55,9,255,'EQUIPPED',176520,'',100,0,1),
|
|
(56,9,255,'EQUIPPED',54189,'',100,0,1),
|
|
(60,3,255,'EQUIPPED',157226,'',100,0,1),
|
|
(61,3,255,'EQUIPPED',157229,'',100,0,1),
|
|
(62,3,255,'EQUIPPED',157225,'',100,0,1),
|
|
(63,3,255,'EQUIPPED',79782,'',100,0,1),
|
|
(64,3,255,'EQUIPPED',52601,'',100,0,1),
|
|
(67,7,255,'EQUIPPED',137308,'',100,0,1),
|
|
(68,7,255,'EQUIPPED',137307,'',100,0,1),
|
|
(69,7,255,'EQUIPPED',137306,'',100,0,1),
|
|
(73,7,255,'EQUIPPED',40228,'',100,0,1),
|
|
(74,7,255,'EQUIPPED',20538,'',100,0,50),
|
|
(76,7,255,'EQUIPPED',72751,'',100,0,1),
|
|
(77,4,255,'EQUIPPED',135223,'',100,0,1),
|
|
(78,4,255,'EQUIPPED',135225,'',100,0,1),
|
|
(79,4,255,'EQUIPPED',135227,'',100,0,1),
|
|
(80,4,255,'EQUIPPED',71059,'',100,0,1),
|
|
(84,2,255,'EQUIPPED',43528,'',100,0,1),
|
|
(85,8,255,'EQUIPPED',43528,'',100,0,1),
|
|
(86,2,255,'EQUIPPED',20527,'',100,0,50),
|
|
(87,8,255,'EQUIPPED',20527,'',100,0,50),
|
|
(88,10,255,'EQUIPPED',168902,'',100,0,1),
|
|
(89,10,255,'EQUIPPED',168903,'',100,0,1),
|
|
(90,10,255,'EQUIPPED',168904,'',100,0,1),
|
|
(91,10,255,'EQUIPPED',85113,'',100,0,1),
|
|
(92,10,255,'EQUIPPED',53700,'',100,0,1),
|
|
(94,20,255,'EQUIPPED',144058,'',100,0,1),
|
|
(95,20,255,'EQUIPPED',144059,'',100,0,1),
|
|
(96,20,255,'EQUIPPED',144060,'',100,0,1),
|
|
(97,20,255,'EQUIPPED',75400,'',100,0,1),
|
|
(98,19,255,'EQUIPPED',165131,'',100,0,1),
|
|
(99,19,255,'EQUIPPED',165132,'',100,0,1),
|
|
(100,19,255,'EQUIPPED',165135,'',100,0,1),
|
|
(101,19,255,'EQUIPPED',84347,'',100,0,1),
|
|
(102,23,255,'EQUIPPED',191144,'',100,0,1),
|
|
(103,23,255,'EQUIPPED',191145,'',100,0,1),
|
|
(104,23,255,'EQUIPPED',191146,'',100,0,1),
|
|
(105,23,255,'EQUIPPED',90320,'',100,0,1),
|
|
(106,30,255,'EQUIPPED',165457,'',100,0,1),
|
|
(107,30,255,'EQUIPPED',165458,'',100,0,1),
|
|
(108,30,255,'EQUIPPED',165459,'',100,0,1),
|
|
(109,30,255,'EQUIPPED',84367,'',100,0,1),
|
|
(110,24,255,'EQUIPPED',189973,'',100,0,1),
|
|
(111,24,255,'EQUIPPED',189974,'',100,0,1),
|
|
(112,24,255,'EQUIPPED',189975,'',100,0,1),
|
|
(113,24,255,'EQUIPPED',90096,'',100,0,1),
|
|
(114,29,255,'EQUIPPED',140141,'',100,0,1),
|
|
(115,29,255,'EQUIPPED',140142,'',100,0,1),
|
|
(116,29,255,'EQUIPPED',140143,'',100,0,1),
|
|
(117,29,255,'EQUIPPED',73663,'',100,0,1),
|
|
(118,33,255,'EQUIPPED',183463,'',100,0,1),
|
|
(119,33,255,'EQUIPPED',183464,'',100,0,1),
|
|
(120,33,255,'EQUIPPED',183465,'',100,0,1),
|
|
(122,33,255,'EQUIPPED',88681,'',100,0,1),
|
|
(124,32,255,'EQUIPPED',43534,'',100,0,1),
|
|
(125,32,255,'EQUIPPED',20535,'',100,0,50),
|
|
(127,37,255,'EQUIPPED',75509,'',100,0,1),
|
|
(128,35,255,'EQUIPPED',43528,'',100,0,1),
|
|
(129,35,255,'EQUIPPED',20527,'',100,0,50),
|
|
(130,40,255,'EQUIPPED',133757,'',100,0,1),
|
|
(131,40,255,'EQUIPPED',133760,'',100,0,1),
|
|
(132,40,255,'EQUIPPED',133761,'',100,0,1),
|
|
(134,40,255,'EQUIPPED',70875,'',100,0,1),
|
|
(135,40,255,'EQUIPPED',40189,'',100,0,1),
|
|
(136,38,255,'EQUIPPED',20527,'',100,0,50),
|
|
(137,38,255,'EQUIPPED',47635,'',100,0,1),
|
|
(138,32,255,'EQUIPPED',47836,'',100,0,1),
|
|
(139,34,255,'EQUIPPED',137128,'',100,0,1),
|
|
(140,34,255,'EQUIPPED',137129,'',100,0,1),
|
|
(141,34,255,'EQUIPPED',137130,'',100,0,1),
|
|
(143,34,255,'EQUIPPED',72648,'',100,0,1),
|
|
(144,39,255,'EQUIPPED',172484,'',100,0,1),
|
|
(145,39,255,'EQUIPPED',172486,'',100,0,1),
|
|
(146,39,255,'EQUIPPED',172487,'',100,0,1),
|
|
(148,39,255,'EQUIPPED',85697,'',100,0,1),
|
|
(149,39,255,'EQUIPPED',42288,'',100,0,1);
|