CREATE PROCEDURE `setEconomyPrices`()
    NO SQL
INSERT INTO `economy` (`numero`, `ressource`, `sellprice`, `buyprice`, `varprice`, `minprice`, `maxprice`, `factor`, `shoptype`) VALUES
(1, 'apple', 50, 65, 1, 1, 60, '1', 'market'),
(2, 'heroinu', 2250, 0, 5, 1, 4000, '0', 'heroin'),
(3, 'heroinp', 4500, 0, 10, 1, 5000, '2', 'heroin'),
(4, 'salema', 45, 55, 1, 1, 100, '4', 'fishmarket'),
(5, 'ornate', 40, 50, 1, 1, 100, '4', 'fishmarket'),
(6, 'mackerel', 175, 200, 1, 1, 1000, '4', 'fishmarket'),
(7, 'tuna', 700, 900, 1, 1, 2000, '4', 'fishmarket'),
(8, 'mullet', 250, 300, 1, 1, 1000, '4', 'fishmarket'),
(9, 'catshark', 300, 350, 1, 1, 1000, '4', 'fishmarket'),
(10, 'rabbit', 65, 75, 1, 1, 500, '0', 'market'),
(11, 'oilp', 2250, 0, 2, 1, 3500, '3', 'oil'),
(12, 'turtle', 5750, 15000, 10, 1, 8000, '0', 'wongs'),
(13, 'water', 0, 10, 0, 1, 25, '0', 'market'),
(14, 'coffee', 0, 10, 0, 1, 75, '0', 'cop'),
(15, 'turtlesoup', 4500, 15000, 0, 1, 5000, '0', 'wongs'),
(16, 'donuts', 0, 10, 0, 1, 200, '0', 'cop'),
(17, 'marijuana', 3000, 0, 10, 1, 6000, '2', 'heroin'),
(18, 'tbacon', 25, 75, 0, 1, 75, '0', 'market'),
(19, 'lockpick', 750, 4000, 0, 1, 4100, '0', 'market'),
(20, 'redgull', 750, 1000, 0, 1, 1200, '0', 'market'),
(21, 'peach', 65, 70, 1, 1, 100, '1', 'market'),
(22, 'cocaine', 2500, 0, 5, 1, 4500, '0', 'heroin'),
(23, 'cocainep', 5000, 0, 10, 1, 8000, '2', 'heroin'),
(24, 'diamond', 1500, 0, 3, 1, 2000, '3', 'diamond'),
(25, 'diamondc', 3000, 0, 3, 1, 6000, '3', 'diamond'),
(26, 'iron_r', 1500, 0, 3, 1, 3000, '3', 'iron'),
(27, 'copper_r', 1000, 0, 3, 1, 1500, '3', 'iron'),
(28, 'salt_r', 2500, 0, 3, 1, 5000, '3', 'salt'),
(29, 'glass', 1500, 0, 3, 1, 3000, '3', 'glass'),
(30, 'fuelF', 10, 500, 0, 1, 1500, '0', 'market'),
(31, 'spikeStrip', 0, 10, 0, 1, 2000, '0', 'cop'),
(32, 'cement', 1000, 0, 3, 1, 8000, '3', 'cement'),
(33, 'goldbar', 90000, 0, 0, 1, 180000, '0', 'goldbar'),
(34, 'blastingcharge', 10000, 50000, 0, 1, 50000, '0', 'market'),
(35, 'boltcutter', 5000, 8000, 0, 1, 5000, '0', 'market'),
(36, 'defusekit', 0, 10, 0, 1, 2500, '0', 'cop'),
(37, 'storagesmall', 10, 125000, 0, 1, 10, '0', 'market'),
(38, 'storagebig', 10, 250000, 0, 1, 10, '0', 'market'),
(39, 'pickaxe', 700, 1200, 0, 1, 750, '0', 'market'),
(40, 'methu', 1875, 3750, 5, 1, 3600, '2', 'heroin'),
(41, 'methp', 3750, 0, 10, 1, 6500, '2', 'heroin'),
(42, 'bottledwhiskey', 5500, 3750, 5, 1, 6000, '2', 'speakeasy'),
(43, 'bottledbeer', 750, 1250, 5, 1, 1450, '2', 'speakeasy'),
(44, 'whiskey', 1250, 5500, 4, 1, 2500, '2', 'speakeasy'),
(45, 'wine', 1000, 4000, 2, 1, 4500, '2', 'beer'),
(46, 'grapes', 70, 95, 2, 1, 140, '2', 'market'),
(47, 'battery', 50, 100, 0, 1, 100, '2', 'market'),
(48, 'painkillers', 250, 500, 0, 1, 500, '2', 'pharmacy'),
(49, 'mash', 500, 2500, 1, 1, 1500, '2', 'bar'),
(50, 'rye', 2000, 0, 2, 1, 3500, '2', 'bar'),
(51, 'morphium', 100, 1500, 0, 1, 1500, '2', 'pharmacy'),
(52, 'yeast', 2000, 0, 2, 1, 3500, '2', 'pharmacy'),
(53, 'cornmeal', 200, 500, 2, 1, 750, '2', 'bar'),
(54, 'bottles', 50, 100, 1, 1, 100, '2', 'bar'),
(55, 'uranium', 10000, 0, 8, 1, 12500, '2', 'uranium'),
(56, 'kidney', 9000, 15000, 0, 1, 16750, '2', 'pharmacy'),
(57, 'scalpel', 1000, 7500, 0, 1, 7500, '2', 'pharmacy'),
(58, 'beerp', 550, 3750, 3, 1, 1500, '2', 'speakeasy'),
(59, 'mauer', 5, 10, 0, 1, 10, '2', 'cop'),
(60, 'zipties', 5, 500, 0, 1, 500, '2', 'market'),
(61, 'puranium', 250, 1000, 0, 1, 1000, '2', 'uranium'),
(62, 'ipuranium', 3500, 9000, 0, 1, 9000, '2', 'uranium')$$
DELIMITER ;