From 23cfb53ff36bb0d16e8e1743c49ba724f24d1797 Mon Sep 17 00:00:00 2001 From: Werner Hahn Date: Mon, 25 Sep 2017 10:59:15 +0200 Subject: [PATCH] WebshopApi: sql/Pg-upgrade2/files.sql - Whitespaces entfernt --- sql/Pg-upgrade2/files.sql | 17 ++++++++--------- 1 file changed, 8 insertions(+), 9 deletions(-) diff --git a/sql/Pg-upgrade2/files.sql b/sql/Pg-upgrade2/files.sql index abbb39bf5..2209cf7bb 100644 --- a/sql/Pg-upgrade2/files.sql +++ b/sql/Pg-upgrade2/files.sql @@ -1,27 +1,26 @@ -- @tag: files -- @description: Tabelle für Files -- @charset: UTF-8 --- @depends: release_3_4_1 +-- @depends: release_3_4_1 CREATE TABLE files( id SERIAL PRIMARY KEY, object_type TEXT NOT NULL, -- Tabellenname des Moduls z.B. customer, parts ... Fremdschlüssel Zusammen mit object_id object_id INTEGER NOT NULL, -- Fremdschlüssel auf die id der Tabelle aus Spalte object_type - file_name TEXT NOT NULL, - file_type TEXT NOT NULL, + file_name TEXT NOT NULL, + file_type TEXT NOT NULL, mime_type TEXT NOT NULL, - source TEXT NOT NULL, + source TEXT NOT NULL, backend TEXT, - backend_data TEXT, + backend_data TEXT, title varchar(45), - description TEXT, + description TEXT, itime TIMESTAMP DEFAULT now(), mtime TIMESTAMP, CONSTRAINT valid_type CHECK ( (object_type = 'credit_note') OR (object_type = 'invoice') OR (object_type = 'sales_order') OR (object_type = 'sales_quotation') OR (object_type = 'sales_delivery_order') OR (object_type = 'request_quotation') OR (object_type = 'purchase_order') - OR (object_type = 'purchase_delivery_order') OR (object_type = 'purchase_invoice') - OR (object_type = 'vendor') OR (object_type = 'customer') OR (object_type = 'part') OR (object_type = 'gl_transaction') + OR (object_type = 'purchase_delivery_order') OR (object_type = 'purchase_invoice') + OR (object_type = 'vendor') OR (object_type = 'customer') OR (object_type = 'part') OR (object_type = 'gl_transaction') OR (object_type = 'dunning') OR (object_type = 'dunning1') OR (object_type = 'dunning2') OR (object_type = 'dunning3') OR (object_type = 'draft') OR (object_type = 'statement')) ); - -- 2.20.1