148 lines
3.7 KiB
SQL
148 lines
3.7 KiB
SQL
/* Generic data suitable for all kind of boats
|
|
* SPDX-License-Identifier: WTFPL
|
|
*/
|
|
|
|
-- minimal vessel
|
|
INSERT INTO vessel (vid, vesselname) VALUES (1, 'Generic vessel');
|
|
|
|
INSERT INTO user (userid, login, pass, displayname, role) VALUES
|
|
(2, 'helmsman', '$2y$10$4keuVm.WD/JeRmAqp2h4MeSxxKITsKv2q07XZrxPUuT/V80CTPbje', 'Helmsman', 'helmsman'),
|
|
(3, 'sailor', '$2y$10$4keuVm.WD/JeRmAqp2h4MeSxxKITsKv2q07XZrxPUuT/V80CTPbje', 'Sailor', 'sailor');
|
|
|
|
INSERT INTO settings (userid, sno, valint) VALUES
|
|
(2, 1, 1), -- Vessel 1 for helmsman
|
|
(3, 1, 1); -- Vessel 1 for sailor
|
|
|
|
INSERT INTO dropdown (ddid, ddval, ddtext) VALUES
|
|
(1, 1, 'Einrumpf'), -- Mono
|
|
(1, 2, 'Katamaran'),
|
|
(1, 3, 'Trimaran');
|
|
|
|
INSERT INTO dropdown (ddid, ddval, ddtext) VALUES
|
|
(2, 4, 'Dienstleister'), -- Service
|
|
(2, 5, 'Segelmacher'), -- Sailmaker
|
|
(2, 6, 'Yachthafen'); -- Marina
|
|
|
|
INSERT INTO dropdown (ddid, ddval, ddtext) VALUES
|
|
(3, 3, 'Bilge'),
|
|
(3, 4, 'Schwalbennest');
|
|
|
|
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'),
|
|
(4, 10, 'Solar'),
|
|
(4, 11, 'Sicherheit'),
|
|
(4, 12, 'lfd. Gut');
|
|
|
|
INSERT INTO dropdown (ddid, ddval, ddtext) VALUES
|
|
(5, 1, 'Allgemein'),
|
|
(5, 2, 'Getränke'),
|
|
(5, 3, 'Naschkram'),
|
|
(5, 4, 'Konserven'),
|
|
(5, 5, 'Frischware'),
|
|
(5, 6, 'Trockenware'),
|
|
(5, 7, 'Gefriergetrocknet'),
|
|
(5, 8, 'Snacks (salzig)');
|
|
|
|
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) VALUES
|
|
(7, 1, 'ATO'),
|
|
(7, 2, 'Streifensicherung'),
|
|
(7, 3, 'Feinsicherung (GS)'),
|
|
(7, 4, 'Torpedosicherung'),
|
|
(7, 5, 'T-Sicherung');
|
|
|
|
INSERT INTO dropdown (ddid, ddval, ddshort, ddtext) VALUES
|
|
(8, 1, 'mm', 'Millimeter'),
|
|
(8, 2, 'cm', 'Zentimeter'),
|
|
(8, 3, 'g', 'Gramm'),
|
|
(8, 4, 'kg', 'Kilogramm'),
|
|
(8, 5, 'm', 'Meter'),
|
|
(8, 6, 'kW', 'Kilowatt'),
|
|
(8, 7, 'A', 'Ampere'),
|
|
(8, 8, 'l', 'Liter');
|
|
|
|
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
|
|
(10, 1, 'Kabel-Inline'),
|
|
(10, 2, 'BlueSea innen'),
|
|
(10, 3, 'Bluesea außen'),
|
|
(10, 4, 'Panel 1 (STV 103)'),
|
|
(10, 5, 'Panel 2 (STV 108)'),
|
|
(10, 6, 'Reihenklemme 1'),
|
|
(10, 7, 'Reihenklemme 2');
|
|
|
|
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');
|
|
|
|
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');
|
|
|
|
/* Eine Liste mit häufig verwendeten Herstellern
|
|
comptype=2
|
|
*/
|
|
|
|
INSERT INTO company (comptype, compname) VALUES
|
|
(2, 'Garmin'),
|
|
(2, 'Watcheye'),
|
|
(2, 'Digital Yacht'),
|
|
(2, 'B&G'),
|
|
(2, 'Raymarine'),
|
|
(2, 'Harken'),
|
|
(2, 'Selden');
|