Project

General

Profile

« Previous | Next » 

Revision 5333

Added by berkley almost 14 years ago

adding a system to track system metadata documents for dataone

View differences:

xmltables-postgres.sql
283 283
);
284 284

  
285 285
/*
286
 * Table used to store all document identifiers for system metadata objects
287
 * similar restraints to identifier.  Cannot use identifier table for this 
288
 * purpose because then you have to worry about whether you insert the
289
 * data first or the systemMetadata first.
290
 */
291
CREATE TABLE systemMetadata (
292
   guid   text,          -- the globally unique string identifier
293
   docid  VARCHAR(250),	 -- the local document id #
294
   rev    INT8,          -- the revision part of the local identifier
295
   CONSTRAINT systemMetadata_pk PRIMARY KEY (guid)
296
);
297

  
298
/*
286 299
 * accesssubtree -- table to store access subtree info
287 300
 */
288 301
CREATE TABLE xml_accesssubtree (

Also available in: Unified diff