X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/2bb452ee62e74c2a42113171eeb53de8d09bbbf5..d54df677b17d94bed2cbb049f7bfd02865144205:/sql/Pg-upgrade2/files.sql

diff --git a/sql/Pg-upgrade2/files.sql b/sql/Pg-upgrade2/files.sql
index abbb39bf5..c5a9cf0ec 100644
--- a/sql/Pg-upgrade2/files.sql
+++ b/sql/Pg-upgrade2/files.sql
@@ -1,27 +1,25 @@
 -- @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'))
 );
-
