Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 3eb3d1b1

Von Moritz Bunkus vor mehr als 11 Jahren hinzugefügt

  • ID 3eb3d1b144adb92e62de08e67dc6ff3d39bf7483
  • Vorgänger e7ae5b6a
  • Nachfolger 0b5b8355

MetaSetup: Spalten- und Fremdschlüsselnamen alphabetisch sortieren

Unterschiede anzeigen:

SL/DB/MetaSetup/Shipto.pm
9 9
__PACKAGE__->meta->table('shipto');
10 10

  
11 11
__PACKAGE__->meta->columns(
12
  trans_id           => { type => 'integer' },
13
  shiptoname         => { type => 'varchar', length => 75 },
14
  shiptodepartment_1 => { type => 'varchar', length => 75 },
15
  shiptodepartment_2 => { type => 'varchar', length => 75 },
16
  shiptostreet       => { type => 'varchar', length => 75 },
17
  shiptozipcode      => { type => 'varchar', length => 75 },
18
  shiptocity         => { type => 'varchar', length => 75 },
19
  shiptocountry      => { type => 'varchar', length => 75 },
20
  shiptocontact      => { type => 'varchar', length => 75 },
21
  shiptophone        => { type => 'varchar', length => 30 },
22
  shiptofax          => { type => 'varchar', length => 30 },
23
  shiptoemail        => { type => 'text' },
24 12
  itime              => { type => 'timestamp', default => 'now()' },
25
  mtime              => { type => 'timestamp' },
26 13
  module             => { type => 'text' },
14
  mtime              => { type => 'timestamp' },
27 15
  shipto_id          => { type => 'integer', not_null => 1, sequence => 'id' },
16
  shiptocity         => { type => 'varchar', length => 75 },
17
  shiptocontact      => { type => 'varchar', length => 75 },
18
  shiptocountry      => { type => 'varchar', length => 75 },
28 19
  shiptocp_gender    => { type => 'text' },
20
  shiptodepartment_1 => { type => 'varchar', length => 75 },
21
  shiptodepartment_2 => { type => 'varchar', length => 75 },
22
  shiptoemail        => { type => 'text' },
23
  shiptofax          => { type => 'varchar', length => 30 },
24
  shiptoname         => { type => 'varchar', length => 75 },
25
  shiptophone        => { type => 'varchar', length => 30 },
26
  shiptostreet       => { type => 'varchar', length => 75 },
27
  shiptozipcode      => { type => 'varchar', length => 75 },
28
  trans_id           => { type => 'integer' },
29 29
);
30 30

  
31 31
__PACKAGE__->meta->primary_key_columns([ 'shipto_id' ]);
32 32

  
33 33
__PACKAGE__->meta->allow_inline_column_values(1);
34 34

  
35
# __PACKAGE__->meta->initialize;
36

  
37 35
1;
38 36
;

Auch abrufbar als: Unified diff