3.framework-data_v061.sql

CRM源码This file describes some issues that should be implemented in future and how it should be imple

-- SECURITY
--
insert into QX_ACCESSLEVEL (pkey, name) VALUES (0, 'Read');
insert into QX_ACCESSLEVEL (pkey, name) VALUES (1, 'Write');
insert into QX_ACCESSLEVEL (pkey, name) VALUES (2, 'Owner');
insert into QX_ACCESSLEVEL (pkey, name) VALUES (3, 'Full Control');

INSERT INTO QX_ROLE(role_id, default_focus_id, name, description) VALUES(0, NULL, 'Administrator', 'This role can manage other users.');
INSERT INTO QX_ROLE(role_id, default_focus_id, name, description) VALUES(1, NULL, 'User', 'Regular user.');

INSERT INTO QX_VIEW_OBJECT_TYPES (pkey, type_description) VALUES (0, 'Focus');
INSERT INTO QX_VIEW_OBJECT_TYPES (pkey, type_description) VALUES (1, 'SubFocus');
INSERT INTO QX_VIEW_OBJECT_TYPES (pkey, type_description) VALUES (2, 'Tab');
INSERT INTO QX_VIEW_OBJECT_TYPES (pkey, type_description) VALUES (3, 'Form');
--INSERT INTO QX_VIEW_OBJECT_TYPES (pkey, type_description) VALUES (4, 'Field');

insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION, NEED_RESTART) values (0, 'CustomerHosts', '127.0.0.1', 'List of hosts that are considered as Customer Hosts', 0);

--
-- EMPLOYEE/WORKGROUP
--
insert into QX_FIELDINFO values ('qx_groupmember', 'notifymethod', 14, 0, 'Alert');
insert into QX_FIELDINFO values ('qx_groupmember', 'notifymethod', 14, 1, 'Email');

insert into QX_FIELDINFO values ('qx_workgroup', 'notifymethod', 14, 0, 'Owners');
insert into QX_FIELDINFO values ('qx_workgroup', 'notifymethod', 14, 1, 'Alert');
insert into QX_FIELDINFO values ('qx_workgroup', 'notifymethod', 14, 2, 'Email');

insert into QX_USER_TYPE values (0, 'database_login');

INSERT INTO QX_USERS (PKEY, LOGINNAME, FULLNAME, USER_TYPE, PASSWORD, EMAIL) VALUES (0, 'admin', 'Administrator', 0, '', '');
INSERT INTO QX_USERS (PKEY, LOGINNAME, FULLNAME, USER_TYPE, PASSWORD, EMAIL) VALUES (1, 'system', 'System', 0, '', '');
INSERT INTO QX_WORKGROUP            (pkey, name, description)         VALUES (0, 'Administrators', 'Administrators workgroup.');
INSERT INTO QX_GROUPMEMBER          (pkey, EMPLOYEEGROUP, WORKGROUPGROUP)  VALUES (0, 0, 0);
INSERT INTO QX_WORKGROUP_TO_ROLE    (pkey, role_id, workgroup_id)     VALUES (0, 0, 0);

insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION, NEED_RESTART) values (1, 'AdminId', '0', 'Administrator employee ID', 1);
insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION, NEED_RESTART) values (2, 'ReporterId', '1', 'Reporter employee ID', 1);

insert into QX_FIELDINFO values ('qx_user_settings', 'date_position', 14, 0, 'First');
insert into QX_FIELDINFO values ('qx_user_settings', 'date_position', 14, 1, 'Second');

insert into QX_VIEW_OBJECTS(pkey, name, type, parent_object, order_in_group) values(0, 'admin', 0, null, 0);
insert into qx_permission(permission_id, role_id, access_level, permission_object_type, object_id) values(0, 0, 3, 0, 0);

--
-- ALERTS
--

insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION, NEED_RESTART) values (3, 'ALERT_PING_INTERVAL', '60000', 'Default ping interval for alerts', 0);

insert into QX_FIELDINFO values ('qx_alert', 'severity', 14, 0, 'Low');
insert into QX_FIELDINFO values ('qx_alert', 'severity', 14, 1, 'Moderate');
insert into QX_FIELDINFO values ('qx_alert', 'severity', 14, 2, 'Serious');
insert into QX_FIELDINFO values ('qx_alert', 'severity', 14, 3, 'Critical');


--
-- ATTACHMENTS
--

insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION) values (4, 'FILE_STORAGE', '/tmp/upload', 'Folder to store attachment files');


--
-- LOGGING
--

insert into QX_LOG_TYPE values ('0', 'error');
insert into QX_LOG_TYPE values ('1', 'warning');
insert into QX_LOG_TYPE values ('2', 'info');
insert into QX_LOG_TYPE values ('3', 'debug');

insert into QX_LOG_CLASS values (0, 'Default', 'QX_LOG');

insert into QX_ERROR_CFG values (100, '*', 'com.queplix.core.modules.services.utils.log.impl.DefMailMsgHnd', null, 0, null, 0);

insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION) values (5, 'LOG_LEVEL_ERROR', '1', 'ERROR log level flag: 1 - enabled, 0 - disabled');
insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION) values (6, 'LOG_LEVEL_WARNING', '0', 'WARNING log level flag: 1 - enabled, 0 - disabled');
insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION) values (7, 'LOG_LEVEL_INFO', '1', 'INFO log level flag: 1 - enabled, 0 - disabled');
insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION) values (8, 'LOG_LEVEL_DEBUG', '0', 'DEBUG log level flag: 1 - enabled, 0 - disabled');

--
-- REPORTS
--
insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION) values (9, 'DEFAULT_SENDER', '[e-mail]', 'Default mail sender e-mail');
insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION) values (10, 'DEFAULT_MAILER', '', 'Default mailer (X-Mailer property)');
insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION) values (11, 'SMTP_SERVER', 'mail.queplix.com', 'SMTP host');
insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION) values (12, 'REPORT_ZIP_DIR', '/tmp/zip', 'Directory to make report ZIP in.');


insert into QX_FIELDINFO values ('qx_report_sched', 'period_unit', 14, 1, 'Minute');
insert into QX_FIELDINFO values ('qx_report_sched', 'period_unit', 14, 2, 'Hour');
insert into QX_FIELDINFO values ('qx_report_sched', 'period_unit', 14, 3, 'Day');
insert into QX_FIELDINFO values ('qx_report_sched', 'period_unit', 14, 4, 'Week');
insert into QX_FIELDINFO values ('qx_report_sched', 'period_unit', 14, 5, 'Month');
insert into QX_FIELDINFO values ('qx_report_sched', 'period_unit', 14, 6, 'Year');
insert into QX_FIELDINFO values ('qx_report_sched', 'period_unit', 14, 7, 'One time only');


--
-- TASKS
--

insert into QX_TASK_DELAYUNIT values (0, 'Minutes');
insert into QX_TASK_DELAYUNIT values (1, 'Hours');
insert into QX_TASK_DELAYUNIT values (2, 'Days');
insert into QX_TASK_DELAYUNIT values (3, 'Months');


insert into QX_TASK_STATUS values (0, 'NEW');
insert into QX_TASK_STATUS values (1, 'READY');
insert into QX_TASK_STATUS values (2, 'RUNNING');
insert into QX_TASK_STATUS values (3, 'WAITING');
insert into QX_TASK_STATUS values (4, 'COMPLETED');
insert into QX_TASK_STATUS values (5, 'INTERRUPTED');


--
-- LOCKING
--

insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION, NEED_RESTART) values (13, 'LockTimeout', '600', 'Max lock record timeout in seconds', 0);


--
-- STATES
--
INSERT INTO QX_STATES VALUES(1,'Alabama','AL');
INSERT INTO QX_STATES VALUES(2,'Alaska','AK');
INSERT INTO QX_STATES VALUES(3,'Arizona','AZ');
INSERT INTO QX_STATES VALUES(4,'Arkansas','AR');
INSERT INTO QX_STATES VALUES(5,'California','CA');
INSERT INTO QX_STATES VALUES(6,'Colorado','CO');
INSERT INTO QX_STATES VALUES(7,'Connecticut','CT');
INSERT INTO QX_STATES VALUES(8,'Delaware','DE');
INSERT INTO QX_STATES VALUES(9,'District Columbia','DC');
INSERT INTO QX_STATES VALUES(10,'Florida','FL');
INSERT INTO QX_STATES VALUES(11,'Georgia','GA');
INSERT INTO QX_STATES VALUES(12,'Hawaii','HI');
INSERT INTO QX_STATES VALUES(13,'Idaho','ID');
INSERT INTO QX_STATES VALUES(14,'Illinois','IL');
INSERT INTO QX_STATES VALUES(15,'Indiana','IN');
INSERT INTO QX_STATES VALUES(16,'Iowa','IA');
INSERT INTO QX_STATES VALUES(17,'Kansas','KS');
INSERT INTO QX_STATES VALUES(18,'Kentucky','KY');
INSERT INTO QX_STATES VALUES(19,'Louisiana','LA');
INSERT INTO QX_STATES VALUES(20,'Maine','ME');
INSERT INTO QX_STATES VALUES(21,'Maryland','MD');
INSERT INTO QX_STATES VALUES(22,'Massachusetts','MA');
INSERT INTO QX_STATES VALUES(23,'Michigan','MI');
INSERT INTO QX_STATES VALUES(24,'Minnesota','MN');
INSERT INTO QX_STATES VALUES(25,'Mississippi','MS');
INSERT INTO QX_STATES VALUES(26,'Missouri','MO');
INSERT INTO QX_STATES VALUES(27,'Montana','MT');
INSERT INTO QX_STATES VALUES(28,'Nebraska','NE');
INSERT INTO QX_STATES VALUES(29,'Nevada','NV');
INSERT INTO QX_STATES VALUES(30,'New Hampshire','NH');
INSERT INTO QX_STATES VALUES(31,'New Jersey','NJ');
INSERT INTO QX_STATES VALUES(32,'New Mexico','NM');
INSERT INTO QX_STATES VALUES(33,'New York','NY');
INSERT INTO QX_STATES VALUES(34,'North Carolina','NC');
INSERT INTO QX_STATES VALUES(35,'North Dakota','ND');
INSERT INTO QX_STATES VALUES(36,'Ohio','OH');
INSERT INTO QX_STATES VALUES(37,'Oklahoma','OK');
INSERT INTO QX_STATES VALUES(38,'Oregon','OR');
INSERT INTO QX_STATES VALUES(39,'Pennsylvania','PA');
INSERT INTO QX_STATES VALUES(40,'Rhode Island','RI');
INSERT INTO QX_STATES VALUES(41,'South Carolina','SC');
INSERT INTO QX_STATES VALUES(42,'South Dakota','SD');
INSERT INTO QX_STATES VALUES(43,'Tennessee','TN');
INSERT INTO QX_STATES VALUES(44,'Texas','TX');
INSERT INTO QX_STATES VALUES(45,'Utah','UT');
INSERT INTO QX_STATES VALUES(46,'Vermont','VT');
INSERT INTO QX_STATES VALUES(47,'Virginia','VA');
INSERT INTO QX_STATES VALUES(48,'Washington','WA');
INSERT INTO QX_STATES VALUES(49,'West Virginia','WV');
INSERT INTO QX_STATES VALUES(50,'Wisconsin','WI');
INSERT INTO QX_STATES VALUES(51,'Wyoming','WY');


INSERT INTO QX_MAIL_PROVIDER(PKEY, PROVIDER_ID, PROVIDER_NAME) VALUES(1, 'POP3', 'pop3');
INSERT INTO QX_MAIL_PROVIDER(PKEY, PROVIDER_ID, PROVIDER_NAME) VALUES(2, 'IMAP', 'imap');


--
-- SESSION TIMEOUT
--

insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION) values (14, 'SESSION_TIMEOUT', '720', 'User logon session timeout (in minutes)');
insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION) values (15, 'SESSION_TIMEOUT_WARN_BEFORE', '3', 'If the value is positive integer, a warning will be displayed the specified number of minutes before user logon session times out');

--
-- ACCOUNT
--

insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION, NEED_RESTART) values (16, 'DEFAULT_EMAIL_PROVIDER', 'IMAP', 'Account default email provider', 1);
insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION, NEED_RESTART) values (17, 'DEFAULT_EMAIL_SERVER', 'mail.queplix.com', 'Account default email server name', 1);
insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION, NEED_RESTART) values (18, 'DEFAULT_EMAIL_PORT', '110', 'Account default server port', 1);
insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION, NEED_RESTART) values (19, 'DEFAULT_EMAIL_FOLDER', 'Inbox', 'Account default email folder', 1);


--
-- INBOX
--

INSERT INTO QX_LOG_CLASS VALUES (1, 'Email Inbox', 'QX_EMAIL_SERVICE_LOG');
INSERT INTO QX_LOG_CLASS VALUES (2, 'Email Outbox', 'QX_EMAIL_SERVICE_LOG');
INSERT INTO QX_LOG_CLASS VALUES (3, 'Email Trash', 'QX_EMAIL_SERVICE_LOG');
INSERT INTO QX_LOG_CLASS VALUES (4, 'Email Autoreply', 'QX_EMAIL_SERVICE_LOG');
INSERT INTO QX_LOG_CLASS VALUES (5, 'Email Filter', 'QX_EMAIL_SERVICE_LOG');
INSERT INTO QX_LOG_CLASS VALUES (6, 'Email Routing', 'QX_EMAIL_SERVICE_LOG');
INSERT INTO QX_LOG_CLASS VALUES (7, 'Email Ticket', 'QX_EMAIL_SERVICE_LOG');
INSERT INTO QX_LOG_CLASS VALUES (8, 'Email System', 'QX_EMAIL_SERVICE_LOG');

insert into QX_SCRIPT(SCRIPT_ID, SCRIPT_NAME, SCRIPT_DESCRIPTION, SCRIPT_CLASS_NAME, CREATOR_ID, DATE_MODIFIED)
values(1, 'Inbox', 'Email processing', 'com.queplix.core.modules.inbox.actions.InboxManagerAction', 0, sysdate);


--
-- VERSION
--

insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION) values (20, 'DB_CORE_VERSION', '062', 'Core database version. Do not modify');

commit;