init_schema.sql

来自「通过SyncML对异构数据库复制的代码。如何通过Sync4J作为服务进行同步。」· SQL 代码 · 共 24 行

delete from sync4j_sync_source_type where id='jdbc-testsync';
insert into sync4j_sync_source_type(id, description, class, admin_class)
values('jdbc-testsync','TestSyncSource','test.sync4j.TestSyncSource','');

delete from sync4j_connector where id='testsync';
insert into sync4j_connector(id, name, description, admin_class)
values('testsync','SyncConnectorTestSync','SyncConnector TestSync','');

delete from sync4j_connector_source_type where connector='testsync' and sourcetype='jdbc-testsync';
insert into sync4j_connector_source_type(connector, sourcetype)
values('testsync','jdbc-testsync');

delete from sync4j_module where id='testsync';
insert into sync4j_module (id, name, description)
values('testsync','testsync-1.0','Test Sync 1.0');

delete from sync4j_module_connector where module='testsync' and connector='testsync';
insert into sync4j_module_connector(module, connector)
values('testsync','testsync');

delete from sync4j_sync_source where uri='./testsync';
insert into sync4j_sync_source (uri, config, name, sourcetype)
values('./testsync', 'testsync/jdbc-testsync/TestSyncSource.xml','testsync','jdbc-testsync');