lejayandCursor
30921aade6
Ship configurator updates with catalog DB included for server deploy. Co-authored-by: Cursor <[email protected]>
76 lines
4.7 KiB
SQL
76 lines
4.7 KiB
SQL
-- Données initiales V1 (SQLite)
|
|
|
|
INSERT OR REPLACE INTO settings (key, value) VALUES
|
|
('kit_preparation_fee_chf', '350'),
|
|
('panel_thickness_mm', '19'),
|
|
('plinth_height_min_mm', '60'),
|
|
('plinth_height_max_mm', '200'),
|
|
('niche_clearance_multiplier', '2'),
|
|
('min_clearance_mm', '20'),
|
|
('sliding_doors_min_width_mm', '1200');
|
|
|
|
INSERT OR IGNORE INTO products (code, label, active) VALUES
|
|
('SIGNATURE', 'Armoire SIGNATURE', 1);
|
|
|
|
INSERT OR IGNORE INTO block_types (code, label, base_price_chf, width_min_mm, width_max_mm) VALUES
|
|
('penderie', 'Penderie', 550, 400, 1200),
|
|
('rayonnage', 'Rayonnage', 550, 400, 1200),
|
|
('mixte_vertical', 'Mixte vertical', 550, 400, 1200),
|
|
('mixte_horizontal', 'Mixte horizontal', 550, 400, 1200);
|
|
|
|
INSERT INTO panel_formats (name, width_mm, height_mm, price_chf) VALUES
|
|
('Stratifié standard', 2800, 2070, 85),
|
|
('Stratifié couleur', 2800, 2070, 95),
|
|
('Stratifié effet bois', 2800, 2070, 110),
|
|
('Stratifié vieux bois', 2800, 2070, 120);
|
|
|
|
INSERT OR IGNORE INTO finishes (code, label, panel_format_id) VALUES
|
|
('stratifie_decor', 'Stratifié décor', (SELECT id FROM panel_formats WHERE name = 'Stratifié standard' LIMIT 1)),
|
|
('stratifie_couleur', 'Stratifié couleur', (SELECT id FROM panel_formats WHERE name = 'Stratifié couleur' LIMIT 1)),
|
|
('stratifie_effet_bois', 'Stratifié effet bois', (SELECT id FROM panel_formats WHERE name = 'Stratifié effet bois' LIMIT 1)),
|
|
('stratifie_vieux_bois', 'Stratifié vieux bois', (SELECT id FROM panel_formats WHERE name = 'Stratifié vieux bois' LIMIT 1));
|
|
|
|
INSERT OR IGNORE INTO service_options (code, label, price_chf, price_type) VALUES
|
|
('prise_mesure', 'Prise de mesure', 95, 'per_hour'),
|
|
('montage', 'Montage', 95, 'per_hour');
|
|
|
|
-- Modules standards V2
|
|
INSERT OR IGNORE INTO modules (code, name, category, width_mm, height_mm, depth_mm, shelves_count, drawers_count, has_rod, customizable, base_price_chf) VALUES
|
|
('penderie_simple', 'Penderie simple', 'penderie', 600, NULL, 580, 1, 0, 1, 1, 450),
|
|
('penderie_double', 'Penderie double', 'penderie', 900, NULL, 580, 2, 0, 1, 1, 550),
|
|
('penderie_large', 'Penderie large', 'penderie', 1200, NULL, 580, 2, 0, 1, 1, 650),
|
|
('rayonnage_4', 'Rayonnage 4 étagères', 'rayonnage', 600, NULL, 580, 4, 0, 0, 1, 380),
|
|
('rayonnage_5', 'Rayonnage 5 étagères', 'rayonnage', 600, NULL, 580, 5, 0, 0, 1, 420),
|
|
('rayonnage_6', 'Rayonnage 6 étagères', 'rayonnage', 600, NULL, 580, 6, 0, 0, 1, 460),
|
|
('tiroirs_3', 'Bloc 3 tiroirs', 'tiroirs', 600, 600, 580, 0, 3, 0, 0, 520),
|
|
('tiroirs_4', 'Bloc 4 tiroirs', 'tiroirs', 600, 800, 580, 0, 4, 0, 0, 620),
|
|
('tiroirs_5', 'Bloc 5 tiroirs', 'tiroirs', 600, 1000, 580, 0, 5, 0, 0, 720),
|
|
('mixte_penderie_tiroirs', 'Penderie + tiroirs', 'mixte', 600, NULL, 580, 0, 2, 1, 1, 580),
|
|
('mixte_rayonnage_tiroirs', 'Rayonnage + tiroirs', 'mixte', 600, NULL, 580, 3, 2, 0, 1, 550),
|
|
('mixte_complet', 'Module complet', 'mixte', 900, NULL, 580, 2, 2, 1, 1, 720);
|
|
|
|
-- Quincaillerie Blum
|
|
INSERT OR IGNORE INTO blum_hardware (code, name, type, variant, price_chf, specs_json) VALUES
|
|
('legrabox_pure', 'LEGRABOX pure', 'drawer_system', 'legrabox', 85, '{"height_mm": 177, "load_kg": 70, "soft_close": true}'),
|
|
('legrabox_free', 'LEGRABOX free', 'drawer_system', 'legrabox', 95, '{"height_mm": 177, "load_kg": 70, "soft_close": true, "tip_on": true}'),
|
|
('tandembox_antaro', 'TANDEMBOX antaro', 'drawer_system', 'tandembox', 65, '{"height_mm": 83, "load_kg": 65, "soft_close": true}'),
|
|
('tandembox_intivo', 'TANDEMBOX intivo', 'drawer_system', 'tandembox', 75, '{"height_mm": 83, "load_kg": 65, "soft_close": true}'),
|
|
('movento_runner', 'MOVENTO coulisse', 'runner', 'movento', 45, '{"load_kg": 60, "soft_close": true}'),
|
|
('clip_top_soft', 'CLIP top BLUMOTION', 'hinge', 'clip_top', 12, '{"opening_angle": 110, "soft_close": true}'),
|
|
('clip_top_standard', 'CLIP top Standard', 'hinge', 'clip_top', 8, '{"opening_angle": 110, "soft_close": false}'),
|
|
('aventos_hf', 'AVENTOS HF', 'lift_system', 'aventos', 180, '{"type": "bi-fold", "soft_close": true}'),
|
|
('aventos_hl', 'AVENTOS HL', 'lift_system', 'aventos', 150, '{"type": "lift_up", "soft_close": true}');
|
|
|
|
-- Variantes poignées
|
|
INSERT OR IGNORE INTO handle_variants (code, name, style, length_mm, price_chf) VALUES
|
|
('barre_moderne', 'Barre moderne', 'moderne', 160, 25),
|
|
('barre_longue', 'Barre longue', 'moderne', 320, 35),
|
|
('bouton_rond', 'Bouton rond', 'classique', 35, 15),
|
|
('coquille', 'Coquille encastrée', 'minimaliste', 100, 28),
|
|
('profil_alu', 'Profil aluminium', 'minimaliste', NULL, 45);
|
|
|
|
-- Variantes charnières
|
|
INSERT OR IGNORE INTO hinge_variants (code, name, type, brand, price_chf) VALUES
|
|
('blum_vissee', 'Blum vissée', 'vissee', 'Blum', 12),
|
|
('blum_plantee', 'Blum plantée (INSERTA)', 'plantee', 'Blum', 18);
|