14 lines
1.8 KiB
SQL
14 lines
1.8 KiB
SQL
-- Auto-gegenereerd — Over ons: hero- en verhaal-afbeelding beheerbaar maken.
|
|
ALTER TABLE ec_over_ons ADD COLUMN hero_image TEXT;
|
|
ALTER TABLE ec_over_ons ADD COLUMN story_image TEXT;
|
|
-- Herorden zodat de beeldvelden logisch tussen de tekst staan.
|
|
UPDATE _emdash_fields SET sort_order=4 WHERE collection_id=(SELECT id FROM _emdash_collections WHERE slug='over_ons') AND slug='story_title';
|
|
UPDATE _emdash_fields SET sort_order=5 WHERE collection_id=(SELECT id FROM _emdash_collections WHERE slug='over_ons') AND slug='story_body';
|
|
UPDATE _emdash_fields SET sort_order=7 WHERE collection_id=(SELECT id FROM _emdash_collections WHERE slug='over_ons') AND slug='values_title';
|
|
UPDATE _emdash_fields SET sort_order=8 WHERE collection_id=(SELECT id FROM _emdash_collections WHERE slug='over_ons') AND slug='values_intro';
|
|
UPDATE _emdash_fields SET sort_order=9 WHERE collection_id=(SELECT id FROM _emdash_collections WHERE slug='over_ons') AND slug='waarden';
|
|
UPDATE _emdash_fields SET sort_order=10 WHERE collection_id=(SELECT id FROM _emdash_collections WHERE slug='over_ons') AND slug='meta_title';
|
|
UPDATE _emdash_fields SET sort_order=11 WHERE collection_id=(SELECT id FROM _emdash_collections WHERE slug='over_ons') AND slug='meta_description';
|
|
INSERT INTO _emdash_fields (id, collection_id, slug, label, type, column_type, required, sort_order, searchable, translatable) VALUES ('01KV83NTC09VQG6CDC4CWPP7PD', (SELECT id FROM _emdash_collections WHERE slug='over_ons'), 'hero_image', 'Hero · afbeelding (banner) — leeg = standaardfoto', 'image', 'TEXT', 0, 3, 0, 1);
|
|
INSERT INTO _emdash_fields (id, collection_id, slug, label, type, column_type, required, sort_order, searchable, translatable) VALUES ('01KV83NTC27JH5XEV6CBFX2PX8', (SELECT id FROM _emdash_collections WHERE slug='over_ons'), 'story_image', 'Verhaal · foto — leeg = standaardfoto', 'image', 'TEXT', 0, 6, 0, 1);
|