27 lines
1.7 KiB
SQL
Executable file
27 lines
1.7 KiB
SQL
Executable file
-- Copyright (C) 2025 Eduard Wisch <data@data-it-solution.de>
|
|
--
|
|
-- This program is free software: you can redistribute it and/or modify
|
|
-- it under the terms of the GNU General Public License as published by
|
|
-- the Free Software Foundation, either version 3 of the License, or
|
|
-- (at your option) any later version.
|
|
--
|
|
-- EPCQR-Modul - Script wird bei jedem Dolibarr-Upgrade ausgeführt
|
|
-- Stellt sicher, dass alle Extrafelder existieren
|
|
--
|
|
|
|
-- Extrafelder für Rechnungen anlegen (ON DUPLICATE KEY UPDATE verhindert Fehler)
|
|
|
|
-- Extrafeld: qrcode (HTML-Anzeige)
|
|
INSERT INTO llx_extrafields (name, label, type, size, elementtype, fieldunique, fieldrequired, pos, alwayseditable, param, enabled, perms, list, totalizable, printable, langs, help, entity)
|
|
VALUES ('qrcode', 'EPC QR-Code', 'html', '500', 'facture', 0, 0, 800, 0, '', '1', '', '1', 0, 0, NULL, 'QR-Code als HTML-Bild', 0)
|
|
ON DUPLICATE KEY UPDATE label = 'EPC QR-Code';
|
|
|
|
-- Extrafeld: qrcodepfad (URL)
|
|
INSERT INTO llx_extrafields (name, label, type, size, elementtype, fieldunique, fieldrequired, pos, alwayseditable, param, enabled, perms, list, totalizable, printable, langs, help, entity)
|
|
VALUES ('qrcodepfad', 'QR-Code URL', 'html', '500', 'facture', 0, 0, 801, 0, '', '1', '', '0', 0, 0, NULL, 'URL zum QR-Code', 0)
|
|
ON DUPLICATE KEY UPDATE label = 'QR-Code URL';
|
|
|
|
-- Extrafeld: qrcodepath (Lokaler Pfad für ODT)
|
|
INSERT INTO llx_extrafields (name, label, type, size, elementtype, fieldunique, fieldrequired, pos, alwayseditable, param, enabled, perms, list, totalizable, printable, langs, help, entity)
|
|
VALUES ('qrcodepath', 'QR-Code Pfad', 'varchar', '255', 'facture', 0, 0, 802, 0, '', '1', '', '0', 0, 0, NULL, 'Lokaler Pfad zur QR-Code-Bilddatei', 0)
|
|
ON DUPLICATE KEY UPDATE label = 'QR-Code Pfad';
|