Revision 9226
Added by Jing Tao over 9 years ago
| src/xmltables-oracle.sql | ||
|---|---|---|
| 429 | 429 |
PRIMARY KEY (guid) |
| 430 | 430 |
) |
| 431 | 431 |
|
| 432 |
/* |
|
| 433 |
* Table used to store the properties for media types. They are part of the system metadata. But a media type |
|
| 434 |
* can have multiple properties, we have to store them in a separate table. The guids in this table refer |
|
| 435 |
* the guids in the systemMetadata. |
|
| 436 |
*/ |
|
| 437 |
CREATE TABLE smMediaTypeProperties ( |
|
| 438 |
guid VARCHAR2(2000), -- id refer to guid in the system metadata table |
|
| 439 |
name VARCHAR2(512), -- name of the property |
|
| 440 |
value VARCHAR2(512), -- value of the property |
|
| 441 |
CONSTRAINT smMediaTypeProperties_fk |
|
| 442 |
FOREIGN KEY (guid) REFERENCES systemMetadata DEFERRABLE |
|
| 443 |
); |
|
| 444 |
|
|
| 432 | 445 |
CREATE TABLE smReplicationPolicy ( |
| 433 | 446 |
guid VARCHAR2(2000), -- the globally unique string identifier of the object that the system metadata describes |
| 434 | 447 |
member_node VARCHAR(250), -- replication member node |
Also available in: Unified diff
Add the code to create a new table smMediaTypeProperties.