Revision 52e39117
Von Moritz Bunkus vor mehr als 10 Jahren hinzugefügt
| SL/DB/MetaSetup/Vendor.pm | ||
|---|---|---|
| 34 | 34 |
iban => { type => 'text' },
|
| 35 | 35 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
| 36 | 36 |
itime => { type => 'timestamp', default => 'now()' },
|
| 37 |
language => { type => 'varchar', length => 5 },
|
|
| 37 |
language => { type => 'text' },
|
|
| 38 | 38 |
language_id => { type => 'integer' },
|
| 39 | 39 |
mtime => { type => 'timestamp' },
|
| 40 | 40 |
name => { type => 'text', not_null => 1 },
|
| sql/Pg-upgrade2/column_type_text_instead_of_varchar3.sql | ||
|---|---|---|
| 1 |
-- @tag: column_type_text_instead_of_varchar3 |
|
| 2 |
-- @description: Spaltentyp Text anstelle von varchar() in diversen Tabellen Teil 3 |
|
| 3 |
-- @depends: column_type_text_instead_of_varchar2 |
|
| 4 |
|
|
| 5 |
-- vendor |
|
| 6 |
ALTER TABLE vendor ALTER COLUMN language TYPE TEXT; |
|
Auch abrufbar als: Unified diff
Spaltentyp Text anstelle von varchar() in diversen Tabellen Teil 3