33 lines
8.6 KiB
SQL
33 lines
8.6 KiB
SQL
-- Nieuwe hero-card-varianten in de mediabibliotheek.
|
|
INSERT OR REPLACE INTO media (id, filename, mime_type, size, width, height, alt, storage_key, status, created_at) VALUES
|
|
('01KVABVVPZA6FYGXQYPH0SGJP1', 'werk-1-768.webp', 'image/webp', 172718, 768, 1024, 'Herstelde schoorsteen met nieuw loodwerk op een dak', '01KVABVVPZA6FYGXQYPH0SGJP1.webp', 'ready', datetime('now')),
|
|
('01KVABVVQ0DE1QX42SJ0SD44W8', 'werk-5-768.webp', 'image/webp', 191256, 768, 1024, 'Dak wordt op hoogte gereinigd', '01KVABVVQ0DE1QX42SJ0SD44W8.webp', 'ready', datetime('now'));
|
|
|
|
-- Auto-gegenereerd door scripts/gen-cms-sql.mjs — NIET met de hand bewerken.
|
|
|
|
-- ===== collectie: hero_cards (Homepage · hero-foto's) =====
|
|
INSERT INTO _emdash_collections (id, slug, label, label_singular, supports, source, has_seo) VALUES ('01KVABVVQ1NR3K9F9WKSRESQS2', 'hero_cards', 'Homepage · hero-foto''s', 'Hero-foto', '["drafts"]', 'seed', 0);
|
|
CREATE TABLE "ec_hero_cards" ("id" text primary key, "slug" text, "status" text default 'draft', "author_id" text, "primary_byline_id" text, "created_at" text default (datetime('now')), "updated_at" text default (datetime('now')), "published_at" text, "scheduled_at" text, "deleted_at" text, "version" integer default 1, "live_revision_id" text references "revisions" ("id"), "draft_revision_id" text references "revisions" ("id"), "locale" text default 'en' not null, "translation_group" text, "sort" INTEGER, "image" TEXT, "title" TEXT NOT NULL DEFAULT '', "sub" TEXT, "alt" TEXT, constraint "ec_hero_cards_slug_locale_unique" unique ("slug", "locale"));
|
|
INSERT INTO _emdash_fields (id, collection_id, slug, label, type, column_type, required, sort_order, searchable, translatable) VALUES ('01KVABVVQ122ME8J05N5KVVN6Y', '01KVABVVQ1NR3K9F9WKSRESQS2', 'sort', 'Volgorde', 'integer', 'INTEGER', 0, 0, 0, 1);
|
|
INSERT INTO _emdash_fields (id, collection_id, slug, label, type, column_type, required, sort_order, searchable, translatable) VALUES ('01KVABVVQ16T3Y8AGE0CC5WDMN', '01KVABVVQ1NR3K9F9WKSRESQS2', 'image', 'Foto', 'image', 'TEXT', 0, 1, 0, 1);
|
|
INSERT INTO _emdash_fields (id, collection_id, slug, label, type, column_type, required, sort_order, searchable, translatable) VALUES ('01KVABVVQ16JSEANWCYPSXYZFR', '01KVABVVQ1NR3K9F9WKSRESQS2', 'title', 'Titel (op de foto)', 'string', 'TEXT', 1, 2, 0, 1);
|
|
INSERT INTO _emdash_fields (id, collection_id, slug, label, type, column_type, required, sort_order, searchable, translatable) VALUES ('01KVABVVQ1ECG3EWNNCBJBQ9GS', '01KVABVVQ1NR3K9F9WKSRESQS2', 'sub', 'Ondertitel (op de foto)', 'string', 'TEXT', 0, 3, 0, 1);
|
|
INSERT INTO _emdash_fields (id, collection_id, slug, label, type, column_type, required, sort_order, searchable, translatable) VALUES ('01KVABVVQ1RZHRW4SS4BFQCP0C', '01KVABVVQ1NR3K9F9WKSRESQS2', 'alt', 'Alt-tekst', 'string', 'TEXT', 0, 4, 0, 1);
|
|
INSERT INTO "ec_hero_cards" ("id", "slug", "status", "locale", "sort", "image", "title", "sub", "alt") VALUES ('01KVABVVQ11RQWC684MBJ6WBYK', 'card-1', 'published', 'en', 1, '{"id":"01KVABG8HZN66T8KPTBWHQSFZS","provider":"local","filename":"werk-3.webp","mimeType":"image/webp","width":738,"height":1600,"alt":"Strak nieuw voegwerk tussen bakstenen van een gevel","meta":{"storageKey":"01KVABG8HZN66T8KPTBWHQSFZS.webp"}}', 'Voegwerk', 'gevel hersteld', 'Strak nieuw voegwerk tussen bakstenen van een gevel');
|
|
INSERT INTO "ec_hero_cards" ("id", "slug", "status", "locale", "sort", "image", "title", "sub", "alt") VALUES ('01KVABVVQ1FDVGKZ9D3WMGH5VN', 'card-2', 'published', 'en', 2, '{"id":"01KVABVVPZA6FYGXQYPH0SGJP1","provider":"local","filename":"werk-1-768.webp","mimeType":"image/webp","width":768,"height":1024,"alt":"Herstelde schoorsteen met nieuw loodwerk op een dak","meta":{"storageKey":"01KVABVVPZA6FYGXQYPH0SGJP1.webp"}}', 'Schoorsteen', 'nieuw loodwerk', 'Herstelde schoorsteen met nieuw loodwerk op een dak');
|
|
INSERT INTO "ec_hero_cards" ("id", "slug", "status", "locale", "sort", "image", "title", "sub", "alt") VALUES ('01KVABVVQ1F6R1AX4EQEVX3NY8', 'card-3', 'published', 'en', 3, '{"id":"01KVABVVQ0DE1QX42SJ0SD44W8","provider":"local","filename":"werk-5-768.webp","mimeType":"image/webp","width":768,"height":1024,"alt":"Dak wordt op hoogte gereinigd","meta":{"storageKey":"01KVABVVQ0DE1QX42SJ0SD44W8.webp"}}', 'Dakreiniging', 'op hoogte', 'Dak wordt op hoogte gereinigd');
|
|
|
|
-- ===== collectie: galerij (Homepage · bewijs-galerij) =====
|
|
INSERT INTO _emdash_collections (id, slug, label, label_singular, supports, source, has_seo) VALUES ('01KVABVVQ14SQR0WHZTH7WFDMZ', 'galerij', 'Homepage · bewijs-galerij', 'Galerij-foto', '["drafts"]', 'seed', 0);
|
|
CREATE TABLE "ec_galerij" ("id" text primary key, "slug" text, "status" text default 'draft', "author_id" text, "primary_byline_id" text, "created_at" text default (datetime('now')), "updated_at" text default (datetime('now')), "published_at" text, "scheduled_at" text, "deleted_at" text, "version" integer default 1, "live_revision_id" text references "revisions" ("id"), "draft_revision_id" text references "revisions" ("id"), "locale" text default 'en' not null, "translation_group" text, "sort" INTEGER, "image" TEXT, "caption" TEXT NOT NULL DEFAULT '', "featured" INTEGER, constraint "ec_galerij_slug_locale_unique" unique ("slug", "locale"));
|
|
INSERT INTO _emdash_fields (id, collection_id, slug, label, type, column_type, required, sort_order, searchable, translatable) VALUES ('01KVABVVQ2XMM41D22G827XSK1', '01KVABVVQ14SQR0WHZTH7WFDMZ', 'sort', 'Volgorde', 'integer', 'INTEGER', 0, 0, 0, 1);
|
|
INSERT INTO _emdash_fields (id, collection_id, slug, label, type, column_type, required, sort_order, searchable, translatable) VALUES ('01KVABVVQ2EHPAYE6W6MGDH97V', '01KVABVVQ14SQR0WHZTH7WFDMZ', 'image', 'Foto', 'image', 'TEXT', 0, 1, 0, 1);
|
|
INSERT INTO _emdash_fields (id, collection_id, slug, label, type, column_type, required, sort_order, searchable, translatable) VALUES ('01KVABVVQ2EW3FW6JR4KHXZ99F', '01KVABVVQ14SQR0WHZTH7WFDMZ', 'caption', 'Bijschrift', 'string', 'TEXT', 1, 2, 0, 1);
|
|
INSERT INTO _emdash_fields (id, collection_id, slug, label, type, column_type, required, sort_order, searchable, translatable) VALUES ('01KVABVVQ2VAGD68C1JR9TJS8H', '01KVABVVQ14SQR0WHZTH7WFDMZ', 'featured', 'Uitgelicht (grote tegel)', 'boolean', 'INTEGER', 0, 3, 0, 1);
|
|
INSERT INTO "ec_galerij" ("id", "slug", "status", "locale", "sort", "image", "caption", "featured") VALUES ('01KVABVVQ2YS6NB5BR9QP49G21', 'g-1', 'published', 'en', 1, '{"id":"01KVABG8HZN66T8KPTBWHQSFZS","provider":"local","filename":"werk-3.webp","mimeType":"image/webp","width":738,"height":1600,"alt":"Voegwerk aan de gevel","meta":{"storageKey":"01KVABG8HZN66T8KPTBWHQSFZS.webp"}}', 'Voegwerk aan de gevel', 1);
|
|
INSERT INTO "ec_galerij" ("id", "slug", "status", "locale", "sort", "image", "caption", "featured") VALUES ('01KVABVVQ2CARDWEFR2S7527QT', 'g-2', 'published', 'en', 2, '{"id":"01KVABG8HZENXT71V00NY1M2N5","provider":"local","filename":"werk-1.webp","mimeType":"image/webp","width":1200,"height":1600,"alt":"Schoorsteen met nieuw loodwerk","meta":{"storageKey":"01KVABG8HZENXT71V00NY1M2N5.webp"}}', 'Schoorsteen met nieuw loodwerk', 0);
|
|
INSERT INTO "ec_galerij" ("id", "slug", "status", "locale", "sort", "image", "caption", "featured") VALUES ('01KVABVVQ2R2CFFNSVST3RKW1E', 'g-3', 'published', 'en', 3, '{"id":"01KVABG8HZ2H1TAB7E4J3QRCSM","provider":"local","filename":"werk-4.webp","mimeType":"image/webp","width":1200,"height":1600,"alt":"Dak vol mos, voor reiniging","meta":{"storageKey":"01KVABG8HZ2H1TAB7E4J3QRCSM.webp"}}', 'Dak vol mos, voor reiniging', 0);
|
|
INSERT INTO "ec_galerij" ("id", "slug", "status", "locale", "sort", "image", "caption", "featured") VALUES ('01KVABVVQ20N5N5YNM50TK2991', 'g-4', 'published', 'en', 4, '{"id":"01KVABG8HZSPH8YKM0GJC0WDE2","provider":"local","filename":"werk-2.webp","mimeType":"image/webp","width":1600,"height":1200,"alt":"Tuinmuur en bestrating","meta":{"storageKey":"01KVABG8HZSPH8YKM0GJC0WDE2.webp"}}', 'Tuinmuur en bestrating', 0);
|
|
INSERT INTO "ec_galerij" ("id", "slug", "status", "locale", "sort", "image", "caption", "featured") VALUES ('01KVABVVQ2K99A0XS85TRWPD9Q', 'g-5', 'published', 'en', 5, '{"id":"01KVABG8HZ9KFWV8604FYYSEAY","provider":"local","filename":"werk-5.webp","mimeType":"image/webp","width":1200,"height":1600,"alt":"Dakreiniging op hoogte","meta":{"storageKey":"01KVABG8HZ9KFWV8604FYYSEAY.webp"}}', 'Dakreiniging op hoogte', 0);
|
|
INSERT INTO "ec_galerij" ("id", "slug", "status", "locale", "sort", "image", "caption", "featured") VALUES ('01KVABVVQ2Z0YDXZB31X4TQ10Y', 'g-6', 'published', 'en', 6, '{"id":"01KVABG8HZV3AHQ5RQGVAKW29F","provider":"local","filename":"werk-6.webp","mimeType":"image/webp","width":1200,"height":1600,"alt":"Metselwerk, tuintrap","meta":{"storageKey":"01KVABG8HZV3AHQ5RQGVAKW29F.webp"}}', 'Metselwerk, tuintrap', 0);
|