Project

General

Profile

Revision 93

Added by bojilova over 20 years ago

clear xml_catalog table and rename xml_catalog_entities to xml_catalog

View differences:

src/xmltables.sql
21 21

  
22 22
DROP TRIGGER xml_nodes_before_insert;
23 23
DROP TRIGGER xml_documents_before_insert;
24
DROP TRIGGER xml_cat_entities_before_insert;
24
DROP TRIGGER xml_catalog_before_insert;
25 25

  
26
DROP TABLE xml_catalog_entities;
27 26
DROP TABLE xml_catalog;
28 27
DROP TABLE xml_documents;
29 28
DROP TABLE xml_nodes;
......
83 82
/
84 83

  
85 84
/* 
86
 * XML Catalog -- tables to store all external sources for XML documents
85
 * XML Catalog -- table to store all external sources for XML documents
87 86
 */
88 87
CREATE TABLE xml_catalog (
89
	doctype		VARCHAR2(100),
90
	date_created	DATE,
91
	date_updated	DATE,
92
   CONSTRAINT xml_catalog_pk PRIMARY KEY (doctype)
93
);
94

  
95
CREATE TABLE xml_catalog_entities (
96 88
	entity_id	NUMBER(20),
97 89
	entity_name	VARCHAR2(100),
98 90
	entity_type	VARCHAR2(20),
......
102 94
	system_id	VARCHAR2(1000),
103 95
	date_created	DATE,
104 96
	date_updated	DATE,
105
   CONSTRAINT xml_catalog_entities_pk PRIMARY KEY (entity_id),
106
   CONSTRAINT xml_catalog_entities_uk UNIQUE (entity_type, source_doctype, target_doctype, public_id),
107
   CONSTRAINT xml_source_catalog_fk FOREIGN KEY (source_doctype) REFERENCES xml_catalog,
108
   CONSTRAINT xml_target_catalog_fk FOREIGN KEY (target_doctype) REFERENCES xml_catalog
97
   CONSTRAINT xml_catalog_pk PRIMARY KEY (entity_id),
98
   CONSTRAINT xml_catalog_uk UNIQUE (entity_type, source_doctype, target_doctype, public_id)
109 99
);
110 100

  
111 101
CREATE SEQUENCE xml_entity_id_seq;
112 102

  
113
CREATE TRIGGER xml_cat_entities_before_insert
114
BEFORE INSERT ON xml_catalog_entities FOR EACH ROW
103
CREATE TRIGGER xml_catalog_before_insert
104
BEFORE INSERT ON xml_catalog FOR EACH ROW
115 105
BEGIN
116 106
  SELECT xml_entity_id_seq.nextval
117 107
    INTO :new.entity_id
xmltables.sql
21 21

  
22 22
DROP TRIGGER xml_nodes_before_insert;
23 23
DROP TRIGGER xml_documents_before_insert;
24
DROP TRIGGER xml_cat_entities_before_insert;
24
DROP TRIGGER xml_catalog_before_insert;
25 25

  
26
DROP TABLE xml_catalog_entities;
27 26
DROP TABLE xml_catalog;
28 27
DROP TABLE xml_documents;
29 28
DROP TABLE xml_nodes;
......
83 82
/
84 83

  
85 84
/* 
86
 * XML Catalog -- tables to store all external sources for XML documents
85
 * XML Catalog -- table to store all external sources for XML documents
87 86
 */
88 87
CREATE TABLE xml_catalog (
89
	doctype		VARCHAR2(100),
90
	date_created	DATE,
91
	date_updated	DATE,
92
   CONSTRAINT xml_catalog_pk PRIMARY KEY (doctype)
93
);
94

  
95
CREATE TABLE xml_catalog_entities (
96 88
	entity_id	NUMBER(20),
97 89
	entity_name	VARCHAR2(100),
98 90
	entity_type	VARCHAR2(20),
......
102 94
	system_id	VARCHAR2(1000),
103 95
	date_created	DATE,
104 96
	date_updated	DATE,
105
   CONSTRAINT xml_catalog_entities_pk PRIMARY KEY (entity_id),
106
   CONSTRAINT xml_catalog_entities_uk UNIQUE (entity_type, source_doctype, target_doctype, public_id),
107
   CONSTRAINT xml_source_catalog_fk FOREIGN KEY (source_doctype) REFERENCES xml_catalog,
108
   CONSTRAINT xml_target_catalog_fk FOREIGN KEY (target_doctype) REFERENCES xml_catalog
97
   CONSTRAINT xml_catalog_pk PRIMARY KEY (entity_id),
98
   CONSTRAINT xml_catalog_uk UNIQUE (entity_type, source_doctype, target_doctype, public_id)
109 99
);
110 100

  
111 101
CREATE SEQUENCE xml_entity_id_seq;
112 102

  
113
CREATE TRIGGER xml_cat_entities_before_insert
114
BEFORE INSERT ON xml_catalog_entities FOR EACH ROW
103
CREATE TRIGGER xml_catalog_before_insert
104
BEFORE INSERT ON xml_catalog FOR EACH ROW
115 105
BEGIN
116 106
  SELECT xml_entity_id_seq.nextval
117 107
    INTO :new.entity_id

Also available in: Unified diff