ui-clear.mysql

国外的一套开源CRM

-- ========================================================= -->
-- Clear UI Tables -->
-- ========================================================= -->
delete from ui_entity;
delete from ui_attribute;
delete from ui_application;
delete from ui_screen;
delete from ui_screen_section;
delete from ui_screen_section_info;
delete from ui_screen_section_entity;
delete from ui_layout_type;
delete from ui_display_type;
delete from ui_display_attrib;
delete from ui_display_object;
delete from ui_display_object_attrib;
delete from code_type where code_type_id <> 'SYSTEM_PARAMETER';
delete from code where code_type_id <> 'SYSTEM_PARAMETER';
delete from role_type where role_type_id like '%SFA%';
delete from lead_source where lead_source_id in('101','102','103','104');
delete from ui_query where QUERY_ID = 1 and SECTION_ID = -1 and PARTY_ID = -1;


-------------------------
-- UI Application for SFA
-------------------------
insert into UI_APPLICATION VALUES ( 1, 'SFA', 'Sales Force Automation');

-------------------------
-- UI Layout Types
-------------------------
insert into UI_LAYOUT_TYPE (LAYOUT_TYPE_ID, LAYOUT_NAME, DESCRIPTION) VALUES ( 1, 'FREEFORM', 'Free Form Layout Style 1');
insert into UI_LAYOUT_TYPE (LAYOUT_TYPE_ID, LAYOUT_NAME, DESCRIPTION) VALUES ( 2, 'TABULAR', 'Multiple Row Table Layout');
insert into UI_LAYOUT_TYPE (LAYOUT_TYPE_ID, LAYOUT_NAME, DESCRIPTION) VALUES ( 3, 'CROSSTAB', 'Cross Tab Table Layout');
insert into UI_LAYOUT_TYPE (LAYOUT_TYPE_ID, LAYOUT_NAME, DESCRIPTION) VALUES ( 4, 'SELECT', 'Select Form Layout');
insert into UI_LAYOUT_TYPE (LAYOUT_TYPE_ID, LAYOUT_NAME, DESCRIPTION) VALUES ( 5, 'COMPOSITE', 'Composite Layout');

-------------------------
-- Standard UI Queries
-------------------------
insert into UI_QUERY (QUERY_ID, SECTION_ID, PARTY_ID, QUERY_NAME) VALUES (1, -1, -1, ".All");

-------------------------
-- SFA Role Types
-------------------------
insert into ROLE_TYPE (ROLE_TYPE_ID, PARENT_TYPE_ID, HAS_TABLE, DESCRIPTION) VALUES ('SFA_ADMIN','','N','Administrator');
insert into ROLE_TYPE (ROLE_TYPE_ID, PARENT_TYPE_ID, HAS_TABLE, DESCRIPTION) VALUES ('SFA_USER','','N','User');
insert into ROLE_TYPE (ROLE_TYPE_ID, PARENT_TYPE_ID, HAS_TABLE, DESCRIPTION) VALUES ('SFA_LEADS_ADMIN','','N','Leads Administrator');
insert into ROLE_TYPE (ROLE_TYPE_ID, PARENT_TYPE_ID, HAS_TABLE, DESCRIPTION) VALUES ('SFA_LEADS_USER','','N','Leads User');

-------------------------
-- Standard Lead Sources
-------------------------
insert into LEAD_SOURCE (LEAD_SOURCE_ID, LEAD_SOURCE_NAME, LEAD_SOURCE_TYPE_ID) VALUES ("101", "Best Buy", "wbste");
insert into LEAD_SOURCE (LEAD_SOURCE_ID, LEAD_SOURCE_NAME, LEAD_SOURCE_TYPE_ID) VALUES ("102", "Comp USA", "wbste");
insert into LEAD_SOURCE (LEAD_SOURCE_ID, LEAD_SOURCE_NAME, LEAD_SOURCE_TYPE_ID) VALUES ("103", "AT&T Online Store", "wbste");
insert into LEAD_SOURCE (LEAD_SOURCE_ID, LEAD_SOURCE_NAME, LEAD_SOURCE_TYPE_ID) VALUES ("104", "Circuit City", "wbste");