source: contrib/funambol/trunk/modules/psync/src/main/sql/postgresql/init_schema.sql @ 2082

Revision 2082, 2.1 KB checked in by emersonfaria, 14 years ago (diff)

Ticket #927 - Reestruturacao dos diretorios do Funambol

Line 
1--
2-- Initialization data for the pSync module
3--
4-- Module structure registration
5--
6delete from fnbl_module where id='psync';
7insert into fnbl_module (id, name, description) values('psync','psync','pSync');
8
9delete from fnbl_connector where id='psync';
10insert into fnbl_connector(id, name, description) values('psync','Funambol pSync Connector','Funambol pSync Connector');
11
12--
13-- SyncSource Types
14--
15delete from fnbl_sync_source_type where id='contact';
16insert into fnbl_sync_source_type(id, description, class, admin_class)
17values('contact','PIM Contact SyncSource','br.com.prognus.psync.engine.source.PIMContactSyncSource','br.com.prognus.psync.admin.PIMContactSyncSourceConfigPanel');
18
19delete from fnbl_sync_source_type where id='calendar';
20insert into fnbl_sync_source_type(id, description, class, admin_class)
21values('calendar','PIM Calendar SyncSource','br.com.prognus.psync.engine.source.PIMCalendarSyncSource','br.com.prognus.psync.admin.PIMCalendarSyncSourceConfigPanel');
22
23
24--
25-- Connectors
26--
27delete from fnbl_connector_source_type where connector='psync' and sourcetype='contact';
28insert into fnbl_connector_source_type(connector, sourcetype) values('psync','contact');
29
30delete from fnbl_connector_source_type where connector='psync' and sourcetype='calendar';
31insert into fnbl_connector_source_type(connector, sourcetype) values('psync','calendar');
32
33--
34-- Module - Connector
35--
36delete from fnbl_module_connector where module='psync' and connector='psync';
37insert into fnbl_module_connector(module, connector) values('psync','psync');
38
39--
40-- SyncSources
41--
42delete from fnbl_client_mapping
43where (sync_source='catalogo' or sync_source='calendario');
44
45delete from fnbl_last_sync
46where (sync_source='catalogo' or sync_source='calendario');
47
48
49delete from fnbl_sync_source where uri='catalogo';
50insert into fnbl_sync_source (uri, config, name, sourcetype)
51  values('catalogo', 'psync/contact/VCardSource.xml','catalogo','contact');
52
53delete from fnbl_sync_source where uri='calendario';
54insert into fnbl_sync_source (uri, config, name, sourcetype)
55  values('calendario', 'psync/calendar/VEventSource.xml','calendario','calendar');
Note: See TracBrowser for help on using the repository browser.