Revision 9225
Added by Jing Tao over 9 years ago
| src/xmltables-postgres.sql | ||
|---|---|---|
| 324 | 324 |
/* |
| 325 | 325 |
* Table used to store the properties for media types. They are part of the system metadata. But a media type |
| 326 | 326 |
* can have multiple properties, we have to store them in a separate table. The guids in this table refer |
| 327 |
* the guid in the systemMetadata. |
|
| 327 |
* the guids in the systemMetadata.
|
|
| 328 | 328 |
*/ |
| 329 | 329 |
CREATE TABLE smMediaTypeProperties ( |
| 330 | 330 |
guid text, -- id refer to guid in the system metadata table |
| 331 | 331 |
name text, -- name of the property |
| 332 | 332 |
value text, -- value of the property |
| 333 |
CONSTRAINT mediaTypeProperties_fk
|
|
| 333 |
CONSTRAINT smMediaTypeProperties_fk
|
|
| 334 | 334 |
FOREIGN KEY (guid) REFERENCES systemMetadata DEFERRABLE |
| 335 | 335 |
); |
| 336 | 336 |
/* |
Also available in: Unified diff
Change the name of the foreign key on the smMediaTypeProperties.