kivitendo/sql/Pg-upgrade/Pg-upgrade-2.4.0.1-2.4.0.2.sql @ ccf2eedc
| af853490 | Moritz Bunkus | CREATE TABLE units_language (
|
|
unit varchar (20) NOT NULL,
|
|||
language_id integer NOT NULL,
|
|||
localized varchar (20),
|
|||
localized_plural varchar (20),
|
|||
FOREIGN KEY (unit) REFERENCES units (name),
|
|||
FOREIGN KEY (language_id) REFERENCES language (id)
|
|||
);
|
|||
CREATE INDEX units_name_idx ON units (name);
|
|||
CREATE INDEX units_language_unit_idx ON units_language (unit);
|