Project

General

Profile

« Previous | Next » 

Revision 6923

Added by ben leinfelder almost 13 years ago

use larger ("text") db field for guid in the xml_access.accessfileid column

View differences:

src/upgrade-db-to-2.0.0-oracle.sql
77 77 
 *  Allow guid in xml_access table (for system metadata)
78 78 
*/
79 79 
ALTER TABLE xml_access ADD COLUMN guid VARCHAR2(2000);
80 
/**
81 
 *  Expand accessfileid in xml_access table to hold guids
82 
 */
83 
ALTER TABLE xml_access ALTER COLUMN accessfileid TYPE VARCHAR2(2000);
80 84 

  		




  
  85
  
    

  		




  81
  86
  
    
/**


  		




  82
  87
  
    
 * Upgrade xml_access records to use GUID from identifier table


  		




  83
  88
  
    
 * NOTE: This duplicates existing access rules for every revision of a document


  		












  

    
      src/xmltables-oracle.sql
    
  





  282
  282
  
    
 */


  		




  283
  283
  
    
CREATE TABLE xml_access (


  		




  284
  284
  
    
	guid   VARCHAR2(2000),    -- the globally unique string identifier


  		




  285
  
  
    
	accessfileid	VARCHAR2(250),	-- the document id # for the access file


  		




  
  285
  
    
	accessfileid	VARCHAR2(2000),	-- the id for the access file


  		




  286
  286
  
    
	principal_name	VARCHAR2(100),	-- name of user, group, etc.


  		




  287
  287
  
    
	permission	NUMBER(1),	-- "read", "write", "all"


  		




  288
  288
  
    
	perm_type	VARCHAR2(32),	-- "allowed" or "denied"


  		












  

    
      src/upgrade-db-to-2.0.0-postgres.sql
    
  





  81
  81
  
    
 *  Add guid in xml_access table


  		




  82
  82
  
    
 */


  		




  83
  83
  
    
ALTER TABLE xml_access ADD COLUMN guid text;


  		




  
  84
  
    
/**


  		




  
  85
  
    
 *  Expand accessfileid in xml_access table to hold guids


  		




  
  86
  
    
 */


  		




  
  87
  
    
ALTER TABLE xml_access ALTER COLUMN accessfileid TYPE text;


  		




  84
  88
  
    

  		




  85
  89
  
    
/**


  		




  86
  90
  
    
 * Upgrade xml_access records to use GUID from identifier table


  		












  

    
      src/xmltables-postgres.sql
    
  





  207
  207
  
    
 */


  		




  208
  208
  
    
CREATE TABLE xml_access (


  		




  209
  209
  
    
	guid text,	-- foreign key to system metadata


  		




  210
  
  
    
	accessfileid VARCHAR(250),	-- the document id # for the access file


  		




  
  210
  
    
	accessfileid text,	-- the id for the access file


  		




  211
  211
  
    
	principal_name VARCHAR(100),	-- name of user, group, etc.


  		




  212
  212
  
    
	permission INT8,		-- "read", "write", "all"


  		




  213
  213
  
    
	perm_type VARCHAR(32),	-- "allowed" or "denied"


  		












Also available in:  Unified diff