Project

General

Profile

« Previous | Next » 

Revision 755

Added by bojilova about 22 years ago

- made xmltables-sqlserver.sql from SQL Server running here on rincon machine
- included db index on xml_nodes.nodename which was missing

View differences:

xmltables_postgres.sql
1 1 
/*
2 
 * xmltables.sql -- Create or replace tables for storing XML in the db
2 
 * xmltables-postgres.sql
3 
 *             : Create or replace tables for storing XML in PostgreSQL
3 4 
 *
4 
 *      Purpose: creates tables needed for XML database
5 
 *      Purpose: creates tables needed for storing XML in PostgreSQL database
5 6 
 *
6 7 
 *      Created: 08 May 2001
7 8 
 *       Author: John Harris
8 9 
 * Organization: National Center for Ecological Analysis and Synthesis
9 10 
 *    Copyright: 2000 Regents of the University of California and the
10 11 
 *               National Center for Ecological Analysis and Synthesis
12 
 *  For Details: http://www.nceas.ucsb.edu/
13 
 *    File Info: '$Id$'
11 14 
 *
12 15 
 *	this is sql script does the same as the sql script named
13 16 
 *	xmltables.sql except that this script is to be use to
......
79 82 
 */
80 83 
CREATE INDEX xml_nodes_idx1 ON xml_nodes (rootnodeid);
81 84 
CREATE INDEX xml_nodes_idx2 ON xml_nodes (parentnodeid);
85 
CREATE INDEX xml_nodes_idx3 ON xml_nodes (nodename);
82 86 
CREATE SEQUENCE xml_nodes_id_seq;
83 87 

  		




  84
  88
  
    

  		












Also available in:  Unified diff