Revision 574c32c0
Von Moritz Bunkus vor mehr als 13 Jahren hinzugefügt
| SL/DB/MetaSetup/Unit.pm | ||
|---|---|---|
| 15 | 15 |
factor => { type => 'numeric', precision => 5, scale => 20 },
|
| 16 | 16 |
type => { type => 'varchar', length => 20 },
|
| 17 | 17 |
sortkey => { type => 'integer', not_null => 1 },
|
| 18 |
id => { type => 'serial', not_null => 1 },
|
|
| 18 | 19 |
], |
| 19 | 20 |
|
| 20 | 21 |
primary_key_columns => [ 'name' ], |
| 21 | 22 |
|
| 23 |
unique_key => [ 'id' ], |
|
| 24 |
|
|
| 22 | 25 |
foreign_keys => [ |
| 23 | 26 |
unit => {
|
| 24 | 27 |
class => 'SL::DB::Unit', |
| sql/Pg-upgrade2/units_id.sql | ||
|---|---|---|
| 1 |
-- @tag: units_id |
|
| 2 |
-- @description: ID-Spalte für Tabelle "units" |
|
| 3 |
-- @depends: release_2_6_2 |
|
| 4 |
-- @charset: utf-8 |
|
| 5 |
ALTER TABLE units ADD COLUMN id serial; |
|
| 6 |
ALTER TABLE units ADD CONSTRAINT units_id_unique UNIQUE (id); |
|
Auch abrufbar als: Unified diff
ID-Spalte für Tabelle "units" hinzugefügt