metacat / src / xmltables-sqlserver.sql @ 7515

  • svn:eol-style: native
  • svn:executable: *
  • svn:keywords: Author Date Id Revision
# Date Author Comment
6012 03/16/2011 10:56 PM ben leinfelder

add support for temporal element query in pathquery

4080 07/06/2008 09:25 PM daigle

Merge 1.9 changes into Head

2359 12/30/2004 03:51 PM sgarg

Modified database creation sql code so that in xml_nodes, nodedatanumerical coulmn is added.

2112 04/08/2004 09:23 AM Duane Costa

Correct minor problems with foreign keys in Harvester tables

2109 04/06/2004 03:11 PM Duane Costa

Add three new Harvester tables

1806 08/20/2003 01:40 PM Jing Tao

Drop xml_accesssubtree table before the xml_document table.

1743 07/21/2003 03:53 PM Jing Tao

Fix somebugs for the script.

1740 07/19/2003 06:50 PM Jing Tao

Update script for sql: change a unique constraint in xml_relation table. Adding new fields in xml_replication and xml_access table. Adding new talbe xml_accesssubtree.

772 06/05/2001 12:24 PM bojilova

cleared the COLLATION specifiers on column definitions:
it is new in SQL Server 2000 and not supported in its earlier versions

762 06/01/2001 12:08 PM bojilova

INSERT INTO xml_replication (serverid, server, replicate) VALUES ('1', 'localhost', '0');
which was missing

759 05/31/2001 05:26 PM bojilova

several changes were needed related to the change of the unique id generation and use

755 05/29/2001 11:09 AM bojilova

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

743 05/21/2001 01:51 PM Matt Jones

Modifications that change the package handling behavior of metacat. Package
membership is now determined by an identifier being used as either the subject
or object in a triple. One can not request arbitrary returndocs -- only
those types that have package information embedded can be "returndoctype"...

729 04/12/2001 11:13 AM berkley

uncompleted script file to create DB on SQL server