You can create custom registries by populating your database using SQL commands. The SQL commands that create the AssetRepository database tables are located in the file assetregistry_ddl.sql, in the <ATG2007.3>/CAF2007.3/CAF/sql/db_components/<db_type> directory, where <db_type> is the type of database you are using.
The following example shows a set of SQL commands that can be used to create a page registry and a promotion registry. These commands work with the SOLID database.
-- SQL file for defining asset registries.
-- ============= Page Registry =============
-- Define the registry
insert into caf_registry values('reg001', 'PageRegistry', 'pages',
'pathBasedAsset');
-- Folder: /
insert into caf_reg_folder values('fol001', 'PageRegistry', null);
insert into caf_reg_rootfolder values('reg001', 'fol001');
-- Folder: /First Folder
insert into caf_reg_folder values('fol002', 'First Folder', 'fol001');
-- Asset: /First Folder/Page One
insert into caf_reg_asset values('path001', 'Page One', 'A page
describing the 25% off helmet promotion', 'fol002', 2, 'reg001');
insert into caf_reg_pathasset values('path001',
'PioneerCyclingJSP:/en/promotions/helmet_25.jsp');
-- Folder: /First Folder
insert into caf_reg_folder values('fol003', 'Second Folder', 'fol001');
-- Asset: /First Folder/Page Two
insert into caf_reg_asset values('path002', 'Page Two', 'A page
describing the 25% off helmet promotion', 'fol003', 2, 'reg001');
insert into caf_reg_pathasset values('path002',
'PioneerCyclingJSP:/en/promotions/helmet_40.jsp');
-- ============= Promotion Registry =============
-- Define the registry
insert into caf_registry values('reg002', 'PromotionRegistry',
'promotions', 'repositoryAsset');
-- Folder: /
insert into caf_reg_folder values('fol004', 'PromotionRegistry', null);
insert into caf_reg_rootfolder values('reg002', 'fol004');
-- Folder: /Helmet Promotions
insert into caf_reg_folder values('fol005', 'Helmet Promotions',
'fol004');
-- Asset: /Helmet Promotions/25% off
insert into caf_reg_asset values('rep001', '25% off', 'get 25% off on a
helmet when you purchase a bike', 'fol005', 1, 'reg002');
insert into caf_reg_repasset values('rep001',
'/atg/commerce/catalog/ProductCatalog', 'promotion', 'promo10103');
-- Asset: /Helmet Promotions/30% off
insert into caf_reg_asset values('rep002', '30% off', 'get 30% off on a
helmet when you purchase a bike', 'fol005', 1, 'reg002');
insert into caf_reg_repasset values('rep002',
'/atg/commerce/catalog/ProductCatalog', 'promotion', 'promo10102');
-- Asset: /Helmet Promotions/40% off
insert into caf_reg_asset values('rep003', '40% off', 'get 40% off on a
helmet when you purchase a bike', 'fol005', 1, 'reg002');
insert into caf_reg_repasset values('rep003',
'/atg/commerce/catalog/ProductCatalog', 'promotion', 'promo10101');
commit work;