Rev 171 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed
| Rev 171 | Rev 222 | ||
|---|---|---|---|
| Line 14... | Line 14... | ||
| 14 | dsc_papel VARCHAR(120) NOT NULL, |
14 | dsc_papel VARCHAR(120) NOT NULL, |
| 15 | CONSTRAINT pk_papel PRIMARY KEY (cod_papel) |
15 | CONSTRAINT pk_papel PRIMARY KEY (cod_papel) |
| 16 | );
|
16 | );
|
| 17 | 17 | ||
| 18 | -- set table ownership
|
18 | -- set table ownership
|
| 19 | ALTER TABLE sec_papel owner TO espacoc |
- | |
| - | 19 | ALTER TABLE sec_papel owner TO espacoc_sc_sec |
|
| 20 | ; |
20 | ; |
| 21 | 21 | ||
| 22 | /*==============================================================*/
|
22 | /*==============================================================*/
|
| 23 | /* Table: sec_pessoa_papel */
|
23 | /* Table: sec_pessoa_papel */
|
| 24 | /*==============================================================*/
|
24 | /*==============================================================*/
|
| Line 27... | Line 27... | ||
| 27 | cod_papel INT8 NOT NULL, |
27 | cod_papel INT8 NOT NULL, |
| 28 | CONSTRAINT pk_pessoapapel PRIMARY KEY (seq_pessoa, cod_papel) |
28 | CONSTRAINT pk_pessoapapel PRIMARY KEY (seq_pessoa, cod_papel) |
| 29 | );
|
29 | );
|
| 30 | 30 | ||
| 31 | -- set table ownership
|
31 | -- set table ownership
|
| 32 | ALTER TABLE sec_pessoa_papel owner TO espacoc |
- | |
| - | 32 | ALTER TABLE sec_pessoa_papel owner TO espacoc_sc_sec |
|
| 33 | ; |
33 | ; |
| 34 | 34 | ||
| 35 | ALTER TABLE sec_pessoa_papel |
35 | ALTER TABLE sec_pessoa_papel |
| 36 | ADD CONSTRAINT fk_papel_pessoapapel FOREIGN KEY (cod_papel) |
36 | ADD CONSTRAINT fk_papel_pessoapapel FOREIGN KEY (cod_papel) |
| 37 | REFERENCES sec_papel (cod_papel) |
37 | REFERENCES sec_papel (cod_papel) |