| 1 | DROP TABLE IF EXISTS translatica.translatica_pl_pl CASCADE; |
|---|
| 2 | DROP SEQUENCE IF EXISTS translatica.translatica_pl_pl_trn_id_seq; |
|---|
| 3 | |
|---|
| 4 | DROP INDEX IF EXISTS translatica_translatica_pl_pl_tblnam_idx; |
|---|
| 5 | DROP INDEX IF EXISTS translatica_translatica_pl_pl_keyval_idx; |
|---|
| 6 | DROP INDEX IF EXISTS translatica_translatica_pl_pl_colnam_idx; |
|---|
| 7 | DROP INDEX IF EXISTS translatica_translatica_pl_pl_text___idx; |
|---|
| 8 | |
|---|
| 9 | CREATE TABLE translatica.translatica_pl_pl ( |
|---|
| 10 | trn_id SERIAL PRIMARY KEY, |
|---|
| 11 | |
|---|
| 12 | tbinid INTEGER NOT NULL REFERENCES translatica.translatica_table_index (tbinid) ON DELETE CASCADE |
|---|
| 13 | ) INHERITS (translatica.translatica); |
|---|
| 14 | |
|---|
| 15 | CREATE INDEX translatica_translatica_pl_pl_tbinid_idx ON translatica.translatica_pl_pl (tbinid); |
|---|
| 16 | CREATE INDEX translatica_translatica_pl_pl_keyval_idx ON translatica.translatica_pl_pl (keyval); |
|---|
| 17 | CREATE INDEX translatica_translatica_pl_pl_colnam_idx ON translatica.translatica_pl_pl (colnam); |
|---|
| 18 | CREATE INDEX translatica_translatica_pl_pl_text___idx ON translatica.translatica_pl_pl (text__); |
|---|
| 19 | |
|---|
| 20 | REVOKE ALL ON translatica.translatica_pl_pl FROM http; |
|---|
| 21 | REVOKE ALL ON translatica.translatica_pl_pl_trn_id_seq FROM http; |
|---|
| 22 | |
|---|
| 23 | GRANT SELECT, INSERT, UPDATE, DELETE ON translatica.translatica_pl_pl TO http; |
|---|
| 24 | GRANT SELECT, UPDATE ON translatica.translatica_pl_pl_trn_id_seq TO http; |
|---|
| 25 | |
|---|
| 26 | |
|---|
| 27 | |
|---|
| 28 | COMMENT ON TABLE translatica.translatica_pl_pl IS 'Konkretna tabela z tłumaczeniami dla języka polskiego'; |
|---|
| 29 | |
|---|
| 30 | COMMENT ON COLUMN translatica.translatica_pl_pl.trn_id IS 'Klucz główny'; |
|---|
| 31 | |
|---|
| 32 | COMMENT ON COLUMN translatica.translatica_pl_pl.tbinid IS 'Identyfikator indeksu tabel (translatica.translatica_table_index.tbinid) - wskazuje na przynależność do danej przestrzeni tabel. Tłumaczone frazy nie są współdzielone'; |
|---|
