scouter/database-scripts/scrap.sql

53 lines
2.4 KiB
MySQL
Raw Permalink Normal View History

2024-02-28 16:56:44 -05:00
insert into main.scrap (scrap_id, scrap_name, min_value, max_value, weight, conductive, two_handed)
values (1, 'Air Horn', 52, 72, 0, 0, 0),
(2, 'Apparatus', 80, 80, 31, 1, 1),
(3, 'Bee Hive', 50, 156, 0, 1, 1),
(4, 'Bottles', 44, 56, 19, 0, 1),
(5, 'Brass Bell', 48, 80, 24, 1, 0),
(6, 'Candy', 6, 36, 11, 0, 0),
(7, 'Cash Register', 80, 160, 84, 1, 1),
(8, 'Chemical Jug', 32, 84, 32, 0, 1),
(9, 'Clown Horn', 52, 72, 0, 1, 0),
(10, 'Coffee Mug', 24, 68, 5, 0, 0),
(11, 'Comedy Mask', 28, 52, 11, 0, 0),
(12, 'Cookie Mold Pan', 12, 40, 16, 0, 0),
(13, 'Dustpan', 12, 32, 0, 0, 0),
(14, 'Egg Beater', 12, 44, 11, 1, 0),
(15, 'Fancy Lamp', 60, 128, 21, 1, 1),
(16, 'Flask', 16, 44, 19, 1, 0),
(17, 'Gift', 12, 28, 19, 0, 0),
(18, 'Gold Bar', 102, 210, 77, 1, 0),
(19, 'Golden Cup', 40, 80, 16, 0, 0),
(20, 'Hair Brush', 8, 36, 11, 0, 0),
(21, 'Hairdryer', 60, 100, 7, 0, 0),
(22, 'Homemade Flashbang', 10, 28, 5, 0, 0),
(23, 'Jar of Pickles', 32, 60, 16, 0, 0),
(24, 'Large Axle', 36, 56, 16, 1, 1),
(25, 'Large Bolt', 20, 32, 19, 1, 0),
(26, 'Laser Pointer', 32, 100, 0, 0, 0),
(27, 'Magic 7 Ball', 36, 72, 16, 0, 0),
(28, 'Magnifying Glass', 44, 60, 11, 0, 0),
(29, 'Metal Sheet', 10, 22, 26, 1, 0),
(30, 'Old Phone', 48, 64, 5, 0, 0),
(31, 'Painting', 60, 124, 32, 0, 1),
(32, 'Perfume Bottle', 48, 104, 0, 0, 0),
(33, 'Pill Bottle', 16, 40, 0, 0, 0),
(34, 'Plastic Fish', 28, 40, 0, 0, 0),
(35, 'Player Body', 5, 5, 11, 0, 1),
(36, 'Red Soda', 18, 90, 7, 1, 0),
(37, 'Remote', 20, 48, 0, 0, 0),
(38, 'Robot Toy', 56, 88, 21, 1, 0),
(39, 'Rubber Duckie', 2, 100, 0, 0, 0),
(40, 'Shotgun', 30, 90, 16, 0, 0),
(41, 'Shotgun Shell', 0, 0, 0, 0, 0),
(42, 'Steering Wheel', 16, 32, 16, 0, 0),
(43, 'Stop Sign', 20, 52, 21, 1, 0),
(44, 'Tea Kettle', 32, 56, 21, 1, 0),
(45, 'Teeth', 60, 84, 0, 0, 0),
(46, 'Toothpaste', 14, 48, 0, 0, 0),
(47, 'Toy Cube', 24, 44, 0, 0, 0),
(48, 'Tragedy Mask', 28, 52, 11, 0, 0),
(49, 'V-Type Engine', 20, 56, 16, 1, 1),
(50, 'Wedding Ring', 52, 80, 16, 1, 0),
(51, 'Whoopie Cushion', 6, 20, 0, 1, 0),
(52, 'Yield Sign', 18, 36, 42, 1, 0);