X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/deb4d2dbb676d7d6f69dfe7815d6e0cb09bd4a44..53593baa211863fbf66540cf1bcc36c8fb37257f:/sql/Pg-upgrade2/files.sql?ds=sidebyside

diff --git a/sql/Pg-upgrade2/files.sql b/sql/Pg-upgrade2/files.sql
new file mode 100644
index 000000000..c5a9cf0ec
--- /dev/null
+++ b/sql/Pg-upgrade2/files.sql
@@ -0,0 +1,25 @@
+-- @tag: files
+-- @description: Tabelle fÃ¼r Files
+-- @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,
+  mime_type                   TEXT NOT NULL,
+  source                      TEXT NOT NULL,
+  backend                     TEXT,
+  backend_data                TEXT,
+  title                       varchar(45),
+  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 = 'dunning') OR (object_type = 'dunning1') OR (object_type = 'dunning2') OR (object_type = 'dunning3')
+          OR (object_type = 'draft') OR (object_type = 'statement'))
+);
