Project

General

Profile

Revision 755

Added by bojilova almost 20 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