Quote:
INSERT INTO shops ( shopid, npcid ) VALUES ( 1000, 9010002 ); -- Mia Shop (Henesys)
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000000, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000001, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000002, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000003, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000004, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000005, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000006, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000007, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000008, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000009, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000010, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000011, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000012, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000013, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000014, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000015, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000017, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000018, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000020, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000021, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000022, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000023, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000024, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000025, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000028, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000029, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000030, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000031, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000032, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000033, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000034, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000036, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000037, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000039, 1, 0 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 1000, 5000041, 1, 0 );