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_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);--admin id
insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION, NEED_RESTART) values (2, 'ReporterId', '1', 'Reporter employee ID', 1);--system id

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


/*
insert into QX_SCRIPT_PARAM_TYPES values (0, 'integer');
insert into QX_SCRIPT_PARAM_TYPES values (1, 'long');
insert into QX_SCRIPT_PARAM_TYPES values (2, 'float');
insert into QX_SCRIPT_PARAM_TYPES values (3, 'string');
*/


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

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

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

--
-- VERSION
--

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


commit;