predicatesintoviews.sql

derby database source code.good for you.

)values ( 
	'6e7fb600-d184-11d6-85ee-646533376c37', 
	'717bb7f3-d184-11d6-85ee-646533376c37', 
	'DIVISION',
	'DIVISION');

insert into xr.classification_value_ancestors ( 
	versionid, 
	valueid, 
	ancestorid 
) values ( 
	'6e7fb600-d184-11d6-85ee-646533376c37', 
	'717bb7f3-d184-11d6-85ee-646533376c37', 
	'717bb7f3-d184-11d6-85ee-646533376c37');

--echo ==========================================================;


insert into xr.classification_values ( 
	versionid, 
	valueid, 
	value, 
	description 
) values ( 
	'6e7fb600-d184-11d6-85ee-646533376c37', 
	'717bb7f1-d184-11d6-85ee-646533376c37', 
	'GROUP',
	'GROUP');

insert into xr.classification_value_ancestors ( 
	versionid, 
	valueid, 
	ancestorid 
) values ( 
	'6e7fb600-d184-11d6-85ee-646533376c37', 
	'717bb7f1-d184-11d6-85ee-646533376c37', 
	'717bb7f1-d184-11d6-85ee-646533376c37');

--echo ==========================================================;


insert into xr.classification_values ( 
	versionid, 
	valueid, 
	value, 
	description 
) values ( 
	'6e7fb600-d184-11d6-85ee-646533376c37', 
	'717bb7f2-d184-11d6-85ee-646533376c37', 
	'PARTNERSHIP',
	'PARTNERSHIP');

insert into xr.classification_value_ancestors ( 
	versionid, 
	valueid, 
	ancestorid 
) values ( 
	'6e7fb600-d184-11d6-85ee-646533376c37', 
	'717bb7f2-d184-11d6-85ee-646533376c37', 
	'717bb7f2-d184-11d6-85ee-646533376c37');

--echo ==========================================================;
--echo == Locator Use types ====================================;
--echo =========================================================;


insert into xr.repositoryobjectversion (
	id, 
	resourceid, 
	name, 
	versionName,
	folderid, 
	uri, 
	versionuri, 
	description,
	ownerid, 
	creatorid, 
	versiondate, 
	changedate, 
	previousversion
) values (
	'67c249a1-d160-11d6-bb9c-646533376c37',
	'67c249a2-d160-11d6-bb9c-646533376c37', 
	'Locator Use Types', '1.0',  
	'225924f8-1a72-42c9-a58d-05b41d8415ce',
	'Locator+Use+Types',
	'1.0/Locator+Use+Types/1.0',
	'Valid values for the Use Type property of a Locator',
	'26747154-0dfc-46af-a85d-1dc30c230c4e',
	'26747154-0dfc-46af-a85d-1dc30c230c4e',
	CURRENT TIMESTAMP, 
	CURRENT TIMESTAMP,
	null
	);

insert into xr.repositoryobjectresource (
	id, 
	type, 
	subtype, 
	creatorid, 
	createdate, 
	currentVersion, 
	versionControlled
) values (
	'67c249a2-d160-11d6-bb9c-646533376c37', 
	'CLASSIFICATION_SCHEME', 
	'19adf2cf-0a2e-4d98-8f68-221708370b4c',
	'26747154-0dfc-46af-a85d-1dc30c230c4e',
	CURRENT TIMESTAMP,
	'67c249a1-d160-11d6-bb9c-646533376c37', 
	0);

-- This scheme goes into root folder
insert into xr.objectgroup_content (
	versionid,
	memberid
) values (
	'077bb8c4-0894-4d99-937a-356c315d26e2',
	'67c249a2-d160-11d6-bb9c-646533376c37'
);

insert into xr.classificationscheme (
	id, 
	structuretype
) values (
	'67c249a2-d160-11d6-bb9c-646533376c37', 
	'LIST');


-- This scheme classified as INTERNAL_USE
insert into xr.classifications ( 
	objectversionid, 
	valueid 
) values (
	'67c249a1-d160-11d6-bb9c-646533376c37',
	'196b15da-136f-4e19-933f-036f01481f5f');




--echo ==========================================================;


insert into xr.classification_values ( 
	versionid, 
	valueid, 
	value, 
	description 
) values ( 
	'67c249a1-d160-11d6-bb9c-646533376c37', 
	'67c249a3-d160-11d6-bb9c-646533376c37', 
	'HOME',
	'HOME');

insert into xr.classification_value_ancestors ( 
	versionid, 
	valueid, 
	ancestorid 
) values ( 
	'67c249a1-d160-11d6-bb9c-646533376c37', 
	'67c249a3-d160-11d6-bb9c-646533376c37', 
	'67c249a3-d160-11d6-bb9c-646533376c37');

--echo ==========================================================;


insert into xr.classification_values ( 
	versionid, 
	valueid, 
	value, 
	description 
)values ( 
	'67c249a1-d160-11d6-bb9c-646533376c37', 
	'67c249a4-d160-11d6-bb9c-646533376c37', 
	'OFFICE',
	'OFFICE');

insert into xr.classification_value_ancestors ( 
	versionid, 
	valueid, 
	ancestorid
)values ( 
	'67c249a1-d160-11d6-bb9c-646533376c37', 
	'67c249a4-d160-11d6-bb9c-646533376c37', 
	'67c249a4-d160-11d6-bb9c-646533376c37');

--echo ==========================================================;


insert into xr.classification_values ( 
	versionid, 
	valueid, 
	value, 
	description 
)values ( 
	'67c249a1-d160-11d6-bb9c-646533376c37', 
	'67c249a5-d160-11d6-bb9c-646533376c37', 
	'MOBILE',
	'MOBILE');

insert into xr.classification_value_ancestors ( 
	versionid, 
	valueid, 
	ancestorid 
) values ( 
	'67c249a1-d160-11d6-bb9c-646533376c37', 
	'67c249a5-d160-11d6-bb9c-646533376c37', 
	'67c249a5-d160-11d6-bb9c-646533376c37');

--echo ==========================================================;


insert into xr.classification_values ( 
	versionid, 
	valueid, 
	value, 
	description 
) values ( 
	'67c249a1-d160-11d6-bb9c-646533376c37', 
	'67c9eac0-d160-11d6-bb9c-646533376c37', 
	'PAGER',
	'PAGER');

insert into xr.classification_value_ancestors ( 
	versionid, 
	valueid, 
	ancestorid 
) values ( 
	'67c249a1-d160-11d6-bb9c-646533376c37', 
	'67c9eac0-d160-11d6-bb9c-646533376c37', 
	'67c9eac0-d160-11d6-bb9c-646533376c37');


--echo ==========================================================;
--echo == Create Association types ClassificationScheme ====================================;
--echo =====================================================================================;



insert into xr.repositoryobjectversion (
	id, 
	resourceid, 
	name, 
	versionName,
	folderid, 
	uri, 
	versionuri, 
	description,
	ownerid, 
	creatorid, 
	versiondate, 
	changedate, 
	previousversion
) values (
	'67bf3c60-d160-11d6-bb9c-646533376c37',
	'67bf3c61-d160-11d6-bb9c-646533376c37', 
	'Business Relationship Types', '1.0',  
	'225924f8-1a72-42c9-a58d-05b41d8415ce',
	'Business+Relationship+Types',
	'1.0/Business+Relationship+Types/1.0',
	'Valid values for the Type property of a Business Relationship',
	'26747154-0dfc-46af-a85d-1dc30c230c4e',
	'26747154-0dfc-46af-a85d-1dc30c230c4e',
	CURRENT TIMESTAMP, 
	CURRENT TIMESTAMP,
	null
	);

insert into xr.repositoryobjectresource (
	id, 
	type, 
	subtype, 
	creatorid, 
	createdate, 
	currentVersion, 
	versionControlled
) values (
	'67bf3c61-d160-11d6-bb9c-646533376c37', 
	'CLASSIFICATION_SCHEME', 
	'19adf2cf-0a2e-4d98-8f68-221708370b4c',
	'26747154-0dfc-46af-a85d-1dc30c230c4e',
	CURRENT TIMESTAMP,
	'67bf3c60-d160-11d6-bb9c-646533376c37', 
	0);

-- This scheme goes into root folder
insert into xr.objectgroup_content (
	versionid,
	memberid
) values (
	'077bb8c4-0894-4d99-937a-356c315d26e2',
	'67bf3c61-d160-11d6-bb9c-646533376c37'
);

insert into xr.classificationscheme (
	id, 
	structuretype
) values (
	'67bf3c61-d160-11d6-bb9c-646533376c37', 
	'LIST');

-- This scheme classified as INTERNAL_USE
insert into xr.classifications ( 
	objectversionid, 
	valueid 
) values (
	'67bf3c60-d160-11d6-bb9c-646533376c37',
	'196b15da-136f-4e19-933f-036f01481f5f');



--echo =====================================================================================;


insert into xr.classification_values ( 
	versionid, 
	valueid, 
	value, 
	description 
) values ( 
	'67bf3c60-d160-11d6-bb9c-646533376c37', 
	'67bf3c62-d160-11d6-bb9c-646533376c37', 
	'CUSTOMER',
	'CUSTOMER');

insert into xr.classification_value_ancestors ( 
	versionid, 
	valueid, 
	ancestorid 
) values ( 
	'67bf3c60-d160-11d6-bb9c-646533376c37', 
	'67bf3c62-d160-11d6-bb9c-646533376c37', 
	'67bf3c62-d160-11d6-bb9c-646533376c37');

--echo =====================================================================================;


insert into xr.classification_values ( 
	versionid, 
	valueid, 
	value, 
	description 
)values ( 
	'67bf3c60-d160-11d6-bb9c-646533376c37', 
	'67bf3c63-d160-11d6-bb9c-646533376c37', 
	'SUPPLIER',
	'SUPPLIER');

insert into xr.classification_value_ancestors ( 
	versionid, 
	valueid, 
	ancestorid
)values ( 
	'67bf3c60-d160-11d6-bb9c-646533376c37', 
	'67bf3c63-d160-11d6-bb9c-646533376c37', 
	'67bf3c63-d160-11d6-bb9c-646533376c37');

--echo =====================================================================================;


insert into xr.classification_values ( 
	versionid, 
	valueid, 
	value, 
	description 
)values ( 
	'67bf3c60-d160-11d6-bb9c-646533376c37', 
	'67c0c300-d160-11d6-bb9c-646533376c37', 
	'PARTNER',
	'PARTNER');

insert into xr.classification_value_ancestors ( 
	versionid, 
	valueid, 
	ancestorid 
) values ( 
	'67bf3c60-d160-11d6-bb9c-646533376c37', 
	'67c0c300-d160-11d6-bb9c-646533376c37', 
	'67c0c300-d160-11d6-bb9c-646533376c37');

--echo =====================================================================================;


insert into xr.classification_values ( 
	versionid, 
	valueid, 
	value, 
	description 
) values ( 
	'67bf3c60-d160-11d6-bb9c-646533376c37', 
	'67c0c301-d160-11d6-bb9c-646533376c37', 
	'MANAGER',
	'MANAGER');

insert into xr.classification_value_ancestors ( 
	versionid, 
	valueid, 
	ancestorid 
) values ( 
	'67bf3c60-d160-11d6-bb9c-646533376c37', 
	'67c0c301-d160-11d6-bb9c-646533376c37', 
	'67c0c301-d160-11d6-bb9c-646533376c37');


--echo == Create Scheme Types ClassificationScheme ====================================;

insert into xr.repositoryobjectversion (
	id, 
	resourceid, 
	name, 
	versionName,
	folderid, 
	uri, 
	versionuri, 
	description,
	ownerid, 
	creatorid, 
	versiondate, 
	changedate, 
	previousversion
) values (
	'0a6a053e-1837-48dc-b7c4-11082c8c3b35',
	'1a07217d-3a90-4266-bc7e-1e493ea22b8f', 
	'Classification Scheme Types', '1.0',  
	'225924f8-1a72-42c9-a58d-05b41d8415ce',
	'Classification+Scheme+Types',
	'1.0/Classification+Scheme+Types/1.0',
	'Valid values for the ClassificationSchemeType property of a Classification Scheme',
	'26747154-0dfc-46af-a85d-1dc30c230c4e',
	'26747154-0dfc-46af-a85d-1dc30c230c4e',
	CURRENT TIMESTAMP, CURRENT TIMESTAMP,
	null
	);

insert into xr.repositoryobjectresource (
	id, type, subtype, creatorid, createdate, currentVersion, versionControlled
	) values (
	'1a07217d-3a90-4266-bc7e-1e493ea22b8f', 'CLASSIFICATION_SCHEME', 
	'19adf2cf-0a2e-4d98-8f68-221708370b4c',
	'26747154-0dfc-46af-a85d-1dc30c230c4e',
	CURRENT TIMESTAMP,
	'0a6a053e-1837-48dc-b7c4-11082c8c3b35', 0);

-- This scheme goes into root folder
insert into xr.objectgroup_content (
	versionid,
	memberid
) values (
	'077bb8c4-0894-4d99-937a-356c315d26e2',
	'1a07217d-3a90-4266-bc7e-1e493ea22b8f'
);

insert into xr.classificationscheme (id, structuretype) 
	values ('1a07217d-3a90-4266-bc7e-1e493ea22b8f', 'LIST');

-- This scheme classified as INTERNAL_USE
insert into xr.classifications ( objectversionid, valueid )
	values ('0a6a053e-1837-48dc-b7c4-11082c8c3b35', '196b15da-136f-4e19-933f-036f01481f5f');

insert into xr.classification_values ( versionid, valueid, value )
	values ( '0a6a053e-1837-48dc-b7c4-11082c8c3b35', 
	'19adf2cf-0a2e-4d98-8f68-221708370b4c', 'VALUE_LIST');

insert into xr.classification_value_ancestors ( versionid, valueid, ancestorid )
	values ( '0a6a053e-1837-48dc-b7c4-11082c8c3b35', 
	'19adf2cf-0a2e-4d98-8f68-221708370b4c', '19adf2cf-0a2e-4d98-8f68-221708370b4c');

--echo == Create MimeTypes ClassificationScheme ====================================;

insert into xr.repositoryobjectversion (
	id, 
	resourceid, 
	name, 
	versionName,
	folderid, 
	uri, 
	versionuri, 
	description,
	ownerid, 
	creatorid, 
	versiondate, 
	changedate, 
	previousversion
) values (
	'131fe75d-2447-45d3-87a2-37ee31dd08d4',
	'392005d2-1949-4aae-856e-2425093733e2', 
	'Mime Types', '1.0', 
	'225924f8-1a72-42c9-a58d-05b41d8415ce',
	 'Mime+Types',
	'1.0/Mime+Types/1,0',
	'Valid values for the MimeType property of a Registry Entry',
	'26747154-0dfc-46af-a85d-1dc30c230c4e',
	'26747154-0dfc-46af-a85d-1dc30c230c4e',
	CURRENT TIMESTAMP, CURRENT TIMESTAMP,
	null
	);

insert into xr.repositoryobjectresource (
	id, type, subtype, creatorid, createdate, currentVersion, versionControlled
	) values (
	'392005d2-1949-4aae-856e-2425093733e2', 'CLASSIFICATION_SCHEME', 
	'19adf2cf-0a2e-4d98-8f68-221708370b4c',
	'26747154-0dfc-46af-a85d-1dc30c230c4e',
	CURRENT TIMESTAMP,
	'131fe75d-2447-45d3-87a2-37ee31dd08d4', 0);

-- This scheme goes into root folder
insert into xr.objectgroup_content (
	versionid,
	memberid
) values (
	'077bb8c4-0894-4d99-937a-356c315d26e2',
	'392005d2-1949-4aae-856e-2425093733e2'
);

insert into xr.classificationscheme (id, structuretype) 
	values ('392005d2-1949-4aae-856e-2425093733e2', 'LIST');

-- This scheme classified as INTERNAL_USE
insert into xr.classifications ( objectversionid, valueid )
	values ('131fe75d-2447-45d3-87a2-37ee31dd08d4', '196b15da-136f-4e19-933f-036f01481f5f');




insert into xr.classification_values ( versionid, valueid, value, description )
	values ( '131fe75d-2447-45d3-87a2-37ee31dd08d4', 
	'212936b2-32bd-4328-b2e5-0a7915bb225b', 'TEXT/S-SSI-HTML',
	'For: htmls and shtml file types');

insert into xr.classification_value_ancestors ( versionid, valueid, ancestorid )
	values ( '131fe75d-2447-45d3-87a2-37ee31dd08d4', 
	'212936b2-32bd-4328-b2e5-0a7915bb225b', '212936b2-32bd-4328-b2e5-0a7915bb225b');


insert into xr.classification_values ( versionid, valu