Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision dc84cf04

Von Werner Hahn vor etwa 7 Jahren hinzugefügt

  • ID dc84cf0421ddd82ae70ff312bcfa737e01929f8f
  • Vorgänger df362eed
  • Nachfolger a5de1c01

Shopmodul: sql-Updatesfiles Fehlerbehebung

Unterschiede anzeigen:

SL/DB/MetaSetup/Customer.pm
29 29 
  depositor                 => { type => 'text' },
30 30 
  direct_debit              => { type => 'boolean', default => 'false' },
31 31 
  discount                  => { type => 'float', scale => 4 },
32 
  dunning_lock              => { type => 'boolean', default => 'false', not_null => 1 },
33 32 
  email                     => { type => 'text' },
34 33 
  fax                       => { type => 'text' },
35 34 
  gln                       => { type => 'text' },
......
43 42 
  language_id               => { type => 'integer' },
44 43 
  mandate_date_of_signature => { type => 'date' },
45 44 
  mandator_id               => { type => 'text' },
46 
  mass_email_lock           => { type => 'boolean', default => 'true', not_null => 1 },
47 
  mass_letter_lock          => { type => 'boolean', default => 'false', not_null => 1 },
48 45 
  mtime                     => { type => 'timestamp' },
49 46 
  name                      => { type => 'text', not_null => 1 },
50 47 
  notes                     => { type => 'text' },
51 48 
  obsolete                  => { type => 'boolean', default => 'false' },
52 
  order_lock                => { type => 'boolean', default => 'false', not_null => 1 },
49 
  order_lock                => { type => 'boolean', default => 'false' },
53 50 
  payment_id                => { type => 'integer' },
54 51 
  phone                     => { type => 'text' },
55 52 
  pricegroup_id             => { type => 'integer' },
......
59 56 
  taxincluded_checked       => { type => 'boolean' },
60 57 
  taxnumber                 => { type => 'text' },
61 58 
  taxzone_id                => { type => 'integer', not_null => 1 },
62 
  telephone_aquisition_lock => { type => 'boolean', default => 'false', not_null => 1 },
63 59 
  user_password             => { type => 'text' },
64 60 
  username                  => { type => 'text' },
65 61 
  ustid                     => { type => 'text' },
sql/Pg-upgrade2/customer_orderlock.sql
2 2 
-- @description: Boolean Auftragssperre benötigt bei shoporders
3 3 
-- @depends: release_3_4_1 shops
4 4 
-- @ignore: 0
5 
ALTER TABLE customer ADD COLUMN order_lock boolean default 0;
5 
ALTER TABLE customer ADD COLUMN order_lock boolean default 'f';
sql/Pg-upgrade2/shop_parts.sql
16 16 
  sortorder        INTEGER,
17 17 
  front_page       BOOLEAN NOT NULL DEFAULT false,
18 18 
  active           BOOLEAN NOT NULL DEFAULT false,  -- rather than obsolete
19 
  shop_category TYPE TEXT[] USING array[shop_category;
19 
  shop_category TEXT[][],
20 20 
  active_price_source TEXT,
21 21 
  metatag_keywords TEXT,
22 
  metatag_keywords TEXT,
22 
  metatag_description TEXT,
23 23 
  metatag_title TEXT,
24 24 
  UNIQUE (part_id, shop_id)  -- make sure a shop_part appears only once per shop and part
25 25 
);

Auch abrufbar als: Unified diff