Project

General

Profile

« Previous | Next » 

Revision 6100

Added by ben leinfelder over 13 years ago

remove docid and rev from systemMetadata table

View differences:

src/xmltables-oracle.sql
404 404 
 */
405 405 
CREATE TABLE systemMetadata (
406 406 
   guid   VARCHAR2(2000),    -- the globally unique string identifier
407 
   docid  VARCHAR(250), 	 -- the local document id #
408 
   rev    NUMBER(8),          -- the revision part of the local identifier
409 407 
   date_uploaded DATE, -- the date/time the document was first submitted
410 408 
   rights_holder VARCHAR2(250), --the user who has rights to the document, usually the first persons to upload it
411 409 
   checksum VARCHAR2(512), --the checksum of the doc using the given algorithm (see below)
src/xmltables-postgres.sql
290 290 
 */
291 291 
CREATE TABLE systemMetadata (
292 292 
   guid   text,          -- the globally unique string identifier of the object that the system metadata describes
293 
   docid  VARCHAR(250),	 -- the local document id #
294 
   rev    INT8,          -- the revision part of the local identifier
295 293 
   date_uploaded TIMESTAMP, -- the date/time the document was first submitted
296 294 
   rights_holder VARCHAR(250), --the user who has rights to the document, usually the first persons to upload it
297 295 
   checksum VARCHAR(512), --the checksum of the doc using the given algorithm (see below)
......
304 302 
   size VARCHAR(256), --the size of the object
305 303 
   CONSTRAINT systemMetadata_pk PRIMARY KEY (guid)
306 304 
);
305 
/*
306 
 * For devs to remove docid, rev
307 
 * ALTER TABLE systemMetadata DROP COLUMN docid;
308 
 * ALTER TABLE systemMetadata DROP COLUMN rev;
309 
 */
307 310 

  		




  308
  311
  
    
/*


  		




  309
  312
  
    
 * Table used to store system metadata provenance information


  		












Also available in:  Unified diff