Revision b50f89e5
Von Moritz Bunkus vor fast 11 Jahren hinzugefügt
| SL/DB/MetaSetup/Shipto.pm | ||
|---|---|---|
|
module => { type => 'text' },
|
||
|
mtime => { type => 'timestamp' },
|
||
|
shipto_id => { type => 'integer', not_null => 1, sequence => 'id' },
|
||
|
shiptocity => { type => 'varchar', length => 75 },
|
||
|
shiptocontact => { type => 'varchar', length => 75 },
|
||
|
shiptocountry => { type => 'varchar', length => 75 },
|
||
|
shiptocity => { type => 'text' },
|
||
|
shiptocontact => { type => 'text' },
|
||
|
shiptocountry => { type => 'text' },
|
||
|
shiptocp_gender => { type => 'text' },
|
||
|
shiptodepartment_1 => { type => 'varchar', length => 75 },
|
||
|
shiptodepartment_2 => { type => 'varchar', length => 75 },
|
||
|
shiptodepartment_1 => { type => 'text' },
|
||
|
shiptodepartment_2 => { type => 'text' },
|
||
|
shiptoemail => { type => 'text' },
|
||
|
shiptofax => { type => 'varchar', length => 30 },
|
||
|
shiptoname => { type => 'varchar', length => 75 },
|
||
|
shiptophone => { type => 'varchar', length => 30 },
|
||
|
shiptostreet => { type => 'varchar', length => 75 },
|
||
|
shiptozipcode => { type => 'varchar', length => 75 },
|
||
|
shiptofax => { type => 'text' },
|
||
|
shiptoname => { type => 'text' },
|
||
|
shiptophone => { type => 'text' },
|
||
|
shiptostreet => { type => 'text' },
|
||
|
shiptozipcode => { type => 'text' },
|
||
|
trans_id => { type => 'integer' },
|
||
|
);
|
||
|
|
||
| sql/Pg-upgrade2/column_type_text_instead_of_varchar2.sql | ||
|---|---|---|
|
-- @tag: column_type_text_instead_of_varchar2
|
||
|
-- @description: Spaltentyp auf Text anstelle von varchar() für diverse Spalten Teil 2
|
||
|
-- @depends: column_type_text_instead_of_varchar
|
||
|
|
||
|
-- shipto
|
||
|
ALTER TABLE shipto
|
||
|
ALTER COLUMN shiptocity TYPE TEXT
|
||
|
, ALTER COLUMN shiptocontact TYPE TEXT
|
||
|
, ALTER COLUMN shiptocountry TYPE TEXT
|
||
|
, ALTER COLUMN shiptodepartment_1 TYPE TEXT
|
||
|
, ALTER COLUMN shiptodepartment_2 TYPE TEXT
|
||
|
, ALTER COLUMN shiptofax TYPE TEXT
|
||
|
, ALTER COLUMN shiptoname TYPE TEXT
|
||
|
, ALTER COLUMN shiptophone TYPE TEXT
|
||
|
, ALTER COLUMN shiptostreet TYPE TEXT
|
||
|
, ALTER COLUMN shiptozipcode TYPE TEXT
|
||
|
;
|
||
Auch abrufbar als: Unified diff
Spaltentyp Text anstelle von varchar() in diversen Tabellen Teil 2
Tabelle »shipto«