165 lines
7.2 KiB
SQL
165 lines
7.2 KiB
SQL
/* Generic data suitable for all kind of boats
|
||
* SPDX-License-Identifier: WTFPL
|
||
|
||
Add this data additionally after applying minmal.sql
|
||
|
||
*/
|
||
|
||
INSERT INTO user (userid, login, pass, displayname, role) VALUES
|
||
(2, 'helmsman', '$2y$10$LFl2jvrt2kB.c2KXBLaCI.RF2XAGNmFsoRc.V2tzLKrfCPiBCbI0e', 'Helmsman', 'helmsman'),
|
||
(3, 'sailor', '$2y$10$H5ZKd9r3KLAzI7W5u3ocgOCcXF4aDgjMAFYCzVC9Q9/Q9BqAV0MKS', 'Sailor', 'sailor');
|
||
|
||
INSERT INTO vessel (vid, vesselname, model, loa, lwl, beam, draught, displacement, ballast) VALUES
|
||
(1, 'Generic vessel', 'Generic model', 10.0, 9.5, 3.0, 1.8, 4000, 1200);
|
||
|
||
INSERT INTO storage (sid, vid, sname, stype, x, y, z, remarks) VALUES
|
||
(0, 1, 'An Bord', 0, 0, 0, 0, 'Alles wo der Ort nicht spezifiziert werden kann');
|
||
|
||
INSERT INTO dropdown (ddid, ddval, ddtext) VALUES
|
||
(1, 1, 'Mono'),
|
||
(1, 2, 'Katamaran'),
|
||
(1, 3, 'Trimaran');
|
||
|
||
INSERT INTO dropdown (ddid, ddval, ddtext, flags) VALUES
|
||
(2, 4, 'Dienstleister', NULL), -- Service
|
||
(2, 5, 'Segelmacher', NULL), -- Sailmaker
|
||
(2, 6, 'Yachthafen', NULL); -- Marina
|
||
|
||
INSERT INTO dropdown (ddid, ddval, ddtext, flags) VALUES
|
||
(3, 2, 'Bilge', NULL),
|
||
(3, 3, 'Schwalbennest', NULL);
|
||
|
||
INSERT INTO dropdown (ddid, ddval, ddtext) VALUES
|
||
(4, 1, 'Rumpf'),
|
||
(4, 2, 'Deck'),
|
||
(4, 3, 'Rigg'),
|
||
(4, 4, 'Segel'),
|
||
(4, 5, 'Motor'),
|
||
(4, 6, 'Elektrik'),
|
||
(4, 7, 'Elektronik'),
|
||
(4, 8, 'Navigation'),
|
||
(4, 9, 'Pantry');
|
||
|
||
INSERT INTO dropdown (ddid, ddval, ddtext) VALUES
|
||
(5, 1, 'Allgemein'),
|
||
(5, 2, 'Frischware'),
|
||
(5, 3, 'Trockenware'),
|
||
(5, 4, 'Konserven'),
|
||
(5, 5, 'Gefriergetrocknet'),
|
||
(5, 6, 'Snacks (süß)'),
|
||
(5, 7, 'Snacks (salzig)'),
|
||
(5, 8, 'Getränke');
|
||
|
||
INSERT INTO dropdown (ddid, ddval, ddtext, ddshort) VALUES
|
||
(6, 1, 'kg', 'kg'),
|
||
(6, 2, 'Liter', 'L'),
|
||
(6, 3, 'Stück', 'St'),
|
||
(6, 4, 'Packung', 'Pkg'),
|
||
(6, 5, 'Dose', 'Ds'),
|
||
(6, 6, 'Flasche', 'Fl'),
|
||
(6, 7, 'Tüte', 'Tue'),
|
||
(6, 8, 'Tafel', 'Ta'),
|
||
(6, 9, 'Glas', 'Gl');
|
||
|
||
INSERT INTO dropdown (ddid, ddval, ddtext, ddshort) VALUES
|
||
(7, 1, 'ATO/ATC-Stecksicherung', 'ATO'),
|
||
(7, 2, 'MAXI-Stecksicherung', 'Max'),
|
||
(7, 3, 'MIDI/AMI-Sicherung', 'MIDI'),
|
||
(7, 4, 'MEGA/AMG-Sicherung', 'MEGA'),
|
||
(7, 5, 'MRBF-Sicherung', 'MRBF'),
|
||
(7, 6, 'ANL-Sicherung', 'ANL'),
|
||
(7, 7, 'Class-T-Sicherung', 'Class T'),
|
||
(7, 8, 'Feinsicherung 5×20 mm', 'Fein'),
|
||
(7, 9, 'Glassicherung inline', 'Glas'),
|
||
(7, 10, 'Automat / Leitungsschutzschalter', 'Auto'),
|
||
(7, 11, 'Torpedosicherung', 'Torp'),
|
||
(7, 12, 'Streifensicherung', 'Str');
|
||
|
||
INSERT INTO dropdown (ddid, ddval, ddtext, ddshort) VALUES
|
||
(8, 1, 'Millimeter', 'mm'),
|
||
(8, 2, 'Zentimeter', 'cm'),
|
||
(8, 3, 'Meter', 'm'),
|
||
(8, 4, 'Gramm', 'g'),
|
||
(8, 5, 'Kilogramm', 'kg'),
|
||
(8, 6, 'Watt', 'W'),
|
||
(8, 7, 'Kilowatt', 'kW'),
|
||
(8, 8, 'Ampere', 'A');
|
||
|
||
INSERT INTO dropdown (ddid, ddval, ddtext) VALUES
|
||
(9, 1, 'Plastikbox, klein'),
|
||
(9, 2, 'Plastikbox, groß'),
|
||
(9, 3, 'Sortimentskasten'),
|
||
(9, 4, 'Werkzeugkiste');
|
||
|
||
INSERT INTO dropdown (ddid, ddval, ddtext) VALUES
|
||
(11, 1, 'Einzelader'),
|
||
(11, 2, 'Steuerleitung'),
|
||
(11, 3, 'Datenkabel'),
|
||
(11, 4, 'Netzwerkkabel'),
|
||
(11, 5, 'Koaxialkabel'),
|
||
(11, 6, 'Antennenkabel'),
|
||
(11, 7, 'Lautsprecherkabel'),
|
||
(11, 8, 'Mikrofonkabel'),
|
||
(11, 9, 'Batteriekabel'),
|
||
(11, 10, 'Solarkabel'),
|
||
(11, 11, 'Gummileitung'),
|
||
(11, 12, 'Flachbandkabel'),
|
||
(11, 13, 'Telefonkabel'),
|
||
(11, 14, 'NMEA-Kabel'),
|
||
(11, 15, 'CAN-Bus-Kabel'),
|
||
(11, 16, 'USB-Kabel');
|
||
|
||
INSERT INTO dropdown (ddid, ddval, ddtext) VALUES
|
||
(12, 1, 'H05V-K'),
|
||
(12, 2, 'H07V-K'),
|
||
(12, 3, 'H05VV-F'),
|
||
(12, 4, 'H07RN-F'),
|
||
(12, 5, 'LiYY'),
|
||
(12, 6, 'LiYCY'),
|
||
(12, 7, 'LiYCY-TP'),
|
||
(12, 8, 'Cat 5e'),
|
||
(12, 9, 'Cat 6'),
|
||
(12, 10, 'RG-58'),
|
||
(12, 11, 'RG-213'),
|
||
(12, 12, 'RG-316'),
|
||
(12, 13, 'H-155'),
|
||
(12, 14, 'Aircell 5'),
|
||
(12, 15, 'Aircell 7'),
|
||
(12, 16, 'Ecoflex 10');
|
||
|
||
/* supplier */
|
||
INSERT INTO company (comptype, compname, street, zip, city, country, phone, email, web) VALUES
|
||
(1, 'Compass24', NULL, NULL, 'Ascheberg', 'Deutschland', NULL, NULL, 'compass24.de'),
|
||
(1, 'Gründl', NULL, NULL, NULL, 'Deutschland', NULL, NULL, 'gruendl.de'),
|
||
(1, 'KlabauterShop', NULL, NULL, NULL, 'Deutschland', NULL, 'info@klabautershop.de', 'klabautershop.de'),
|
||
(1, 'SVB', NULL, NULL, 'Bremen', 'Deutschland', NULL, NULL, 'svb.de'),
|
||
(1, 'Toplicht', 'Notkestraße 97', '22607', 'Hamburg', 'Deutschland', '040 8890100', 'toplicht@toplicht.de', 'toplicht.de');
|
||
|
||
/* manufacturer */
|
||
INSERT INTO company (comptype, compname, street, zip, city, country, contact, phone, email, web) VALUES
|
||
(2, 'Airmar', NULL, NULL, NULL, 'USA', 'Sales', NULL, 'sales@airmar.com', 'airmar.com'),
|
||
(2, 'B&G', 'Marienthaler Str. 17', '24340', 'Eckernförde', 'Deutschland', 'Sales', '+49 4351 883290', 'sales.de@navico.com', 'bandg.com'),
|
||
(2, 'Blue Sea Systems', 'N85 W12545 Westbrook Crossing', '53051', 'Menomonee Falls', 'USA', 'Customer Service', '+1 800 307 6702', NULL, 'bluesea.com'),
|
||
(2, 'Dometic', 'Hemvärnsgatan 15', '171 54', 'Solna', 'Schweden', 'Customer Service', '+49 511 474046-400', 'contact.eu@dometic.com', 'dometic.com'),
|
||
(2, 'Garmin', 'Parkring 35', '85748', 'Garching', 'Deutschland', 'Zentrale', '+49 89 541999-700', 'impressum@garmin.de', 'garmin.com'),
|
||
(2, 'Harken', NULL, NULL, 'Pewaukee', 'USA', 'Customer Service', NULL, NULL, 'harken.com'),
|
||
(2, 'Hella Marine', NULL, NULL, 'Auckland', 'Neuseeland', 'Marine', NULL, NULL, 'hellamarine.com'),
|
||
(2, 'Icom', NULL, NULL, NULL, 'Japan', 'Marine', NULL, NULL, 'icomjapan.com'),
|
||
(2, 'Isotherm', NULL, NULL, NULL, 'Italien', 'Marine', NULL, NULL, 'indelwebastomarine.com'),
|
||
(2, 'Jabsco', '301 Water Street SE, Suite 200', '20003', 'Washington', 'USA', 'Xylem', '+1 978 281 0440', NULL, 'xylem.com'),
|
||
(2, 'Johnson Pump', NULL, NULL, NULL, 'Schweden', 'Marine', NULL, NULL, 'johnson-pump.com'),
|
||
(2, 'Lewmar', 'Southmoor Lane', 'PO9 1JJ', 'Havant', 'Vereinigtes Königreich', 'Customer Service', '+44 23 9247 1841', 'info@lewmar.com', 'lewmar.com'),
|
||
(2, 'Lofrans', 'Via Leonardo Da Vinci 6', '20040', 'Cambiago (MI)', 'Italien', 'Customer Service', '+39 02 36640684', NULL, 'lofrans.it'),
|
||
(2, 'Mastervolt', 'Snijdersbergweg 93', '1105 AN', 'Amsterdam', 'Niederlande', 'Customer Service', '+31 20 3422100', 'info.emea@OneASG.com', 'mastervolt.com'),
|
||
(2, 'Plastimo', NULL, NULL, 'Lorient', 'Frankreich', 'Marine', NULL, NULL, 'plastimo.com'),
|
||
(2, 'Quick', 'Via Piangipane 120/A', '48124', 'Piangipane (RA)', 'Italien', 'Headquarters', '+39 0544 415061', 'quick@quickitaly.com', 'quickitaly.com'),
|
||
(2, 'Raymarine', 'Atlantic-Haus, Zirkusweg 1', '20359', 'Hamburg', 'Deutschland', 'Support', '+49 40 2378080', NULL, 'raymarine.com'),
|
||
(2, 'Ronstan', NULL, NULL, 'Melbourne', 'Australien', 'Marine', NULL, NULL, 'ronstan.com'),
|
||
(2, 'Selden', 'Redegatan 11', '421 21', 'Västra Frölunda', 'Schweden', 'Headquarters', '+46 31 696900', 'info@seldenmast.com', 'seldenmast.com'),
|
||
(2, 'Simrad', NULL, NULL, NULL, 'Norwegen', 'Marine', NULL, NULL, 'simrad-yachting.com'),
|
||
(2, 'Spinlock', 'Birmingham Road', 'PO31 7BH', 'Cowes', 'Vereinigtes Königreich', 'Customer Service', '+44 1983 295555', NULL, 'spinlock.co.uk'),
|
||
(2, 'Torqeedo', NULL, NULL, NULL, 'Deutschland', 'Marine', NULL, NULL, 'torqeedo.com'),
|
||
(2, 'Vetus', 'Havenstraat 11', '3115 HC', 'Schiedam', 'Niederlande', 'Headquarters', '+31 884 884700', 'info@vetus.com', 'vetus.com'),
|
||
(2, 'Victron Energy', 'De Paal 35', '1351 JG', 'Almere', 'Niederlande', 'Headquarters', NULL, NULL, 'victronenergy.com'),
|
||
(2, 'Whale', NULL, NULL, NULL, 'Vereinigtes Königreich', 'Marine', NULL, NULL, 'whalepumps.com');
|