Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 23cfb53f

Von Werner Hahn vor mehr als 6 Jahren hinzugefügt

  • ID 23cfb53ff36bb0d16e8e1743c49ba724f24d1797
  • Vorgänger 968ad5fe
  • Nachfolger 266b3889

WebshopApi: sql/Pg-upgrade2/files.sql - Whitespaces entfernt

Unterschiede anzeigen:

sql/Pg-upgrade2/files.sql
1 1 
-- @tag: files
2 2 
-- @description: Tabelle für Files
3 3 
-- @charset: UTF-8
4 
-- @depends: release_3_4_1
4 
-- @depends: release_3_4_1
5 5 
CREATE TABLE files(
6 6 
  id                          SERIAL PRIMARY KEY,
7 7 
  object_type                 TEXT NOT NULL,    -- Tabellenname des Moduls z.B. customer, parts ... Fremdschlüssel Zusammen mit object_id
8 8 
  object_id                   INTEGER NOT NULL, -- Fremdschlüssel auf die id der Tabelle aus Spalte object_type
9 
  file_name                   TEXT NOT NULL,
10 
  file_type                   TEXT NOT NULL,
9 
  file_name                   TEXT NOT NULL,
10 
  file_type                   TEXT NOT NULL,
11 11 
  mime_type                   TEXT NOT NULL,
12 
  source                      TEXT NOT NULL,
12 
  source                      TEXT NOT NULL,
13 13 
  backend                     TEXT,
14 
  backend_data                TEXT,
14 
  backend_data                TEXT,
15 15 
  title                       varchar(45),
16 
  description                 TEXT,
16 
  description                 TEXT,
17 17 
  itime                       TIMESTAMP DEFAULT now(),
18 18 
  mtime                       TIMESTAMP,
19 19 
  CONSTRAINT valid_type CHECK (
20 20 
             (object_type = 'credit_note') OR (object_type = 'invoice') OR (object_type = 'sales_order') OR (object_type = 'sales_quotation')
21 21 
          OR (object_type = 'sales_delivery_order') OR (object_type = 'request_quotation') OR (object_type = 'purchase_order')
22 
          OR (object_type = 'purchase_delivery_order') OR (object_type = 'purchase_invoice')
23 
          OR (object_type = 'vendor') OR (object_type = 'customer') OR (object_type = 'part') OR (object_type = 'gl_transaction')
22 
          OR (object_type = 'purchase_delivery_order') OR (object_type = 'purchase_invoice')
23 
          OR (object_type = 'vendor') OR (object_type = 'customer') OR (object_type = 'part') OR (object_type = 'gl_transaction')
24 24 
          OR (object_type = 'dunning') OR (object_type = 'dunning1') OR (object_type = 'dunning2') OR (object_type = 'dunning3')
25 25 
          OR (object_type = 'draft') OR (object_type = 'statement'))
26 26 
);
27 

  		












Auch abrufbar als:  Unified diff