Revision 9224
Added by Jing Tao over 9 years ago
| src/xmltables-postgres.sql | ||
|---|---|---|
| 320 | 320 |
file_name text, -- the suggested file name for this object |
| 321 | 321 |
CONSTRAINT systemMetadata_pk PRIMARY KEY (guid) |
| 322 | 322 |
); |
| 323 |
|
|
| 323 | 324 |
/* |
| 325 |
* Table used to store the properties for media types. They are part of the system metadata. But a media type |
|
| 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. |
|
| 328 |
*/ |
|
| 329 |
CREATE TABLE smMediaTypeProperties ( |
|
| 330 |
guid text, -- id refer to guid in the system metadata table |
|
| 331 |
name text, -- name of the property |
|
| 332 |
value text, -- value of the property |
|
| 333 |
CONSTRAINT mediaTypeProperties_fk |
|
| 334 |
FOREIGN KEY (guid) REFERENCES systemMetadata DEFERRABLE |
|
| 335 |
); |
|
| 336 |
/* |
|
| 324 | 337 |
* For devs to remove docid, rev |
| 325 | 338 |
* ALTER TABLE systemMetadata DROP COLUMN docid; |
| 326 | 339 |
* ALTER TABLE systemMetadata DROP COLUMN rev; |
Also available in: Unified diff
Add a new table smMediaTypeProperties to store the properties associated with a media type.