3.framework-data_v068.sql

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

//

insert into QX_LOCALIZED_OBJECT_TYPE values (0, 'Label')
//
insert into QX_LOCALIZED_OBJECT_TYPE values (1, 'Focus')
//
insert into QX_LOCALIZED_OBJECT_TYPE values (2, 'Tab')
//
insert into QX_LOCALIZED_OBJECT_TYPE values (3, 'Form')
//
insert into QX_LOCALIZED_OBJECT_TYPE values (4, 'Server Side Message')
//
insert into QX_LOCALIZED_OBJECT_TYPE values (5, 'Client Side Message')
//
insert into QX_LOCALIZED_OBJECT_TYPE values (6, 'Popup Menu')
//
insert into QX_LOCALIZED_OBJECT_TYPE values (7, 'Sub Focus')
//
insert into QX_LOCALIZED_OBJECT_TYPE values (8, 'Context Menu')
//
insert into QX_LOCALIZED_OBJECT_TYPE values (9, 'Form Button')
//
insert into QX_LOCALIZED_OBJECT_TYPE values (10, 'Html element')
//

--
-- 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_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, '', '[e-mail]')
//
INSERT INTO QX_USERS                (PKEY, LOGINNAME, FULLNAME, USER_TYPE, PASSWORD, EMAIL)
    VALUES (1, 'system', 'System', 0, '', '[e-mail]')
//
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)
//
/*admin id*/
insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION, NEED_RESTART) values (1, 'AdminId', '0', 'Administrator employee ID', 1)
//
/*system id*/
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', 'Queplix', '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')
//


--
-- HISTORY
--

insert into QX_HIS_TABLE values (5, 'qx_employee')
//
insert into QX_HIS_FIELD values (401, 5, 'pkey')
//
insert into QX_HIS_FIELD values (403, 5, 'loginname')
//
insert into QX_HIS_FIELD values (404, 5, 'firstname')
//
insert into QX_HIS_FIELD values (405, 5, 'lastname')
//
insert into QX_HIS_FIELD values (406, 5, 'fullname')
//
insert into QX_HIS_FIELD values (407, 5, 'email')
//


--
-- 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 VALUES (1, 'POP3', 'pop3')
//
INSERT INTO QX_MAIL_PROVIDER VALUES (2, 'IMAP', 'imap')
//

--
-- VERSION
--

insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION, NEED_RESTART) values (15, 'DEFAULT_EMAIL_PROVIDER', 'IMAP', 'Account default email provider', 1)
//
insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION, NEED_RESTART) values (16, '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 (17, 'DEFAULT_EMAIL_PORT', '110', 'Account default server port', 1)
//
insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION, NEED_RESTART) values (18, 'DEFAULT_EMAIL_FOLDER', 'Inbox', 'Account default email folder', 1)
//
insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION) values (19, 'SESSION_TIMEOUT', '720', 'User logon session timeout (in minutes)')
//
insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION) values (20, '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')
//
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, curdate())
//


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')
//

--
-- VERSION
--


insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION) values (14, 'DB_CORE_VERSION', '068', 'Core database version. Do not modify')
//

commit
//