Revision b50f89e5
Von Moritz Bunkus vor mehr als 10 Jahren hinzugefügt
| SL/DB/MetaSetup/Shipto.pm | ||
|---|---|---|
| 13 | 13 |
module => { type => 'text' },
|
| 14 | 14 |
mtime => { type => 'timestamp' },
|
| 15 | 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 },
|
|
| 16 |
shiptocity => { type => 'text' },
|
|
| 17 |
shiptocontact => { type => 'text' },
|
|
| 18 |
shiptocountry => { type => 'text' },
|
|
| 19 | 19 |
shiptocp_gender => { type => 'text' },
|
| 20 |
shiptodepartment_1 => { type => 'varchar', length => 75 },
|
|
| 21 |
shiptodepartment_2 => { type => 'varchar', length => 75 },
|
|
| 20 |
shiptodepartment_1 => { type => 'text' },
|
|
| 21 |
shiptodepartment_2 => { type => 'text' },
|
|
| 22 | 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 },
|
|
| 23 |
shiptofax => { type => 'text' },
|
|
| 24 |
shiptoname => { type => 'text' },
|
|
| 25 |
shiptophone => { type => 'text' },
|
|
| 26 |
shiptostreet => { type => 'text' },
|
|
| 27 |
shiptozipcode => { type => 'text' },
|
|
| 28 | 28 |
trans_id => { type => 'integer' },
|
| 29 | 29 |
); |
| 30 | 30 |
|
| sql/Pg-upgrade2/column_type_text_instead_of_varchar2.sql | ||
|---|---|---|
| 1 |
-- @tag: column_type_text_instead_of_varchar2 |
|
| 2 |
-- @description: Spaltentyp auf Text anstelle von varchar() für diverse Spalten Teil 2 |
|
| 3 |
-- @depends: column_type_text_instead_of_varchar |
|
| 4 |
|
|
| 5 |
-- shipto |
|
| 6 |
ALTER TABLE shipto |
|
| 7 |
ALTER COLUMN shiptocity TYPE TEXT |
|
| 8 |
, ALTER COLUMN shiptocontact TYPE TEXT |
|
| 9 |
, ALTER COLUMN shiptocountry TYPE TEXT |
|
| 10 |
, ALTER COLUMN shiptodepartment_1 TYPE TEXT |
|
| 11 |
, ALTER COLUMN shiptodepartment_2 TYPE TEXT |
|
| 12 |
, ALTER COLUMN shiptofax TYPE TEXT |
|
| 13 |
, ALTER COLUMN shiptoname TYPE TEXT |
|
| 14 |
, ALTER COLUMN shiptophone TYPE TEXT |
|
| 15 |
, ALTER COLUMN shiptostreet TYPE TEXT |
|
| 16 |
, ALTER COLUMN shiptozipcode TYPE TEXT |
|
| 17 |
; |
|
Auch abrufbar als: Unified diff
Spaltentyp Text anstelle von varchar() in diversen Tabellen Teil 2
Tabelle »shipto«