8.application-data_v055.sql

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

INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_ticket','qw_source',14,4,'Walkup')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_ticket','qw_source',14,5,'Self')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_ticket','qw_source',14,6,'Other')
//

/*ticket responses*/
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_ticket','qw_response',14,0,'Email')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_ticket','qw_response',14,1,'Phone')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_ticket','qw_response',14,2,'Fax')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_ticket','qw_response',14,3,'Voice Mail')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_ticket','qw_response',14,4,'Walkup')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_ticket','qw_response',14,5,'Self')
//

/*ticket reasons*/
INSERT INTO QW_FIELDINFO VALUES ('qw_ticket','qw_reasoncallid',14,0,'Training Issue')
//
INSERT INTO QW_FIELDINFO VALUES ('qw_ticket','qw_reasoncallid',14,1,'Patch/Upgrade')
//
INSERT INTO QW_FIELDINFO VALUES ('qw_ticket','qw_reasoncallid',14,2,'Configuration Issue')
//
INSERT INTO QW_FIELDINFO VALUES ('qw_ticket','qw_reasoncallid',14,3,'Correct Behaviour')
//
INSERT INTO QW_FIELDINFO VALUES ('qw_ticket','qw_reasoncallid',14,4,'Documentation Error')
//
INSERT INTO QW_FIELDINFO VALUES ('qw_ticket','qw_reasoncallid',14,5,'Insufficient Evidence')
//
INSERT INTO QW_FIELDINFO VALUES ('qw_ticket','qw_reasoncallid',14,6,'Product Limitation')
//
INSERT INTO QW_FIELDINFO VALUES ('qw_ticket','qw_reasoncallid',14,7,'Support Expired')
//
INSERT INTO QW_FIELDINFO VALUES ('qw_ticket','qw_reasoncallid',14,8,'Withdrawn')
//
INSERT INTO QW_FIELDINFO VALUES ('qw_ticket','qw_reasoncallid',14,9,'Other')
//

/*address types*/
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_address','qw_addresstype',14,0,'Primary')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_address','qw_addresstype',14,1,'Secondary')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_address','qw_addresstype',14,2,'Mailing')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_address','qw_addresstype',14,3,'Billing')
//

/*reach by*/
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_employee','qw_reachby',14,0,'Email')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_employee','qw_reachby',14,1,'Phone')
//


/*interaction source*/
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_interaction','qw_source',14,0,'Incoming Call')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_interaction','qw_source',14,1,'Outgoing Call')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_interaction','qw_source',14,2,'Fax')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_interaction','qw_source',14,3,'Incoming Email')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_interaction','qw_source',14,4,'Outgoing Email')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_interaction','qw_source',14,5,'Walk-up')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_interaction','qw_source',14,6,'Other')
//

/* interaction action taken */
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_interaction','qw_action',14,0,'Ticket Linked')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_interaction','qw_action',14,1,'Resolved By Agent')
//

/*ticket notification send modes*/
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_ticketnotification','qw_sendmode',14,0,'Alert')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_ticketnotification','qw_sendmode',14,1,'Email')
//

/*ticket notification recipients*/
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_ticketnotification_recip','qw_recipient',14,0,'Workgroup')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_ticketnotification_recip','qw_recipient',14,1,'Use Email To Address')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_ticketnotification_recip','qw_recipient',14,2,'Agent')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_ticketnotification_recip','qw_recipient',14,3,'Owner')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_ticketnotification_recip','qw_recipient',14,4,'Ticket Customer')
//

/* solution topics */
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_solution','qw_topic',14,0,'Hardware')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_solution','qw_topic',14,1,'Software')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_solution','qw_topic',14,2,'Product')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_solution','qw_topic',14,3,'Service')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_solution','qw_topic',14,4,'Documentation')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_solution','qw_topic',14,5,'Operation')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_solution','qw_topic',14,6,'Network')
//

/* workflow */
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_workflow','qw_objecttype',14,0,'Solution')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_workflow','qw_objecttype',14,1,'Ticket')
//

/* solution status */
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_solution','qw_solutionstatus',14,0,'Draft')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_solution','qw_solutionstatus',14,1,'Reviewed')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_solution','qw_solutionstatus',14,2,'Published')
//
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_solution','qw_solutionstatus',14,3,'Retired')
//


/*event type*/
insert into QW_EVENTTYPE (qw_eventid, qw_eventtype) values (0, 'Ticket Created')
//
insert into QW_EVENTTYPE (qw_eventid, qw_eventtype) values (1, 'Status Change')
//
insert into QW_EVENTTYPE (qw_eventid, qw_eventtype) values (2, 'Priority Change')
//
insert into QW_EVENTTYPE (qw_eventid, qw_eventtype) values (3, 'Impact Change')
//
insert into QW_EVENTTYPE (qw_eventid, qw_eventtype) values (4, 'Type Change')
//
insert into QW_EVENTTYPE (qw_eventid, qw_eventtype) values (5, 'Agent Change')
//
insert into QW_EVENTTYPE (qw_eventid, qw_eventtype) values (6, 'Owner Change')
//
insert into QW_EVENTTYPE (qw_eventid, qw_eventtype) values (7, 'Workgroup Change')
//


/*default values*/
insert into QX_USERS (pkey,loginname,fullname,user_type) values (-1000,'defemp','DEFAULT_EMPLOYEE',0)
//
insert into QW_EMPLOYEE (qw_employeeid,qw_userid,qw_firstname,qw_lastname,qw_fullname) values (-1000,-1000,'DEFAULT','EMPLOYEE','DEFAULT_EMPLOYEE')
//
insert into QW_PRODUCT (qw_productid,qw_name) values (-1000,'DEFAULT_PRODUCT')
//
insert into QW_BUILDVERSION (qw_buildid,qw_name,qw_version,qw_productid) values (-1000,'DEFAULT_VERSION','0.0.0.0',-1000)
//
insert into QW_CUSTOMER (qw_customerid,qw_lastname,qw_firstname,qw_fullname) values (-1000,'CUSTOMER','UNKNOWN','Unknown Customer')
//
CALL QX_NEXT_KEY('qx_sys_prop', 1, @id)
//
insert into QX_SYS_PROP values (@id,'UNKNOWN_CUSTOMER','-1000',NULL,NULL,0,'Default ticket customer