Menu
▾
▴
MailManager/sql addRulesetState.zsql,NONE,1.1 addTicketAttribute.zsql,NONE,1.1 deleteRulesetAttributes.zsql,NONE,1.1 deleteRulesetEvents.zsql,NONE,1.1 deleteRulesetStates.zsql,NONE,1.1 deleteRulesetTransitionActions.zsql,NONE,1.1 deleteRulesetTransitionAttributes.zsql,NONE,1.1 deleteRulesetTransitions.zsql,NONE,1.1 getRulesetEvents.zsql,NONE,1.1 getRulesetStates.zsql,NONE,1.1 addAccount.zsql,1.6,1.7 createRulesetTables.zsql,1.6,1.7 createTables.zsql,1.8,1.9
Update of /cvsroot/mailmanager/MailManager/sql In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv13680/sql Modified Files: addAccount.zsql createRulesetTables.zsql createTables.zsql Added Files: addRulesetState.zsql addTicketAttribute.zsql deleteRulesetAttributes.zsql deleteRulesetEvents.zsql deleteRulesetStates.zsql deleteRulesetTransitionActions.zsql deleteRulesetTransitionAttributes.zsql deleteRulesetTransitions.zsql getRulesetEvents.zsql getRulesetStates.zsql Log Message: Added in/modified a number of methods for the ruleset engine and queueing code --- NEW FILE: deleteRulesetAttributes.zsql --- <dtml-comment> title:Delete attributes from a ruleset connection_id: mailmanager_db max_rows:0 arguments:sqv_attribute </dtml-comment> DELETE FROM <dtml-var schema>mm_ruleset_attributes <dtml-sqlgroup where> <dtml-sqltest sqv_attribute column="name" type="nb" optional> </dtml-sqlgroup> --- NEW FILE: addRulesetState.zsql --- <dtml-comment> title:Add a state to a ruleset connection_id:mailmanager_db arguments:sqv_name sqv_description </dtml-comment> INSERT INTO <dtml-var schema>mm_ruleset_states ( name <dtml-if sqv_description>, description </dtml-if> ) VALUES ( <dtml-sqlvar sqv_name type="nb"> <dtml-if sqv_description> , <dtml-sqlvar sqv_description type="nb"> </dtml-if> ) --- NEW FILE: getRulesetStates.zsql --- <dtml-comment> title:Obtain all of the states in the ruleset connection_id:mailmanager_db arguments: </dtml-comment> SELECT * FROM <dtml-var schema>mm_ruleset_states --- NEW FILE: deleteRulesetTransitionAttributes.zsql --- <dtml-comment> title:Delete transition_attributes from a ruleset connection_id: mailmanager_db max_rows:0 arguments:sqv_transition sqv_attribute sqv_status </dtml-comment> DELETE FROM <dtml-var schema>mm_ruleset_transition_attributes <dtml-sqlgroup where> <dtml-sqltest sqv_transition column="transition" type="int" optional> <dtml-and> <dtml-sqltest sqv_attribute column="attribute" type="nb" optional> <dtml-and> <dtml-sqltest sqv_status column="status" type="nb" optional> </dtml-sqlgroup> --- NEW FILE: deleteRulesetTransitions.zsql --- <dtml-comment> title:Delete transitions from a ruleset connection_id: mailmanager_db max_rows:0 arguments:sqv_transition_id </dtml-comment> DELETE FROM <dtml-var schema>mm_ruleset_transitions <dtml-sqlgroup where> <dtml-sqltest sqv_transition_id column="transition_id" type="int" optional> </dtml-sqlgroup> --- NEW FILE: getRulesetEvents.zsql --- <dtml-comment> title:Obtain all of the events in the ruleset connection_id:mailmanager_db arguments: </dtml-comment> SELECT * FROM <dtml-var schema>mm_ruleset_events Index: createRulesetTables.zsql =================================================================== RCS file: /cvsroot/mailmanager/MailManager/sql/createRulesetTables.zsql,v retrieving revision 1.6 retrieving revision 1.7 diff -u -d -r1.6 -r1.7 --- createRulesetTables.zsql 9 Jan 2006 14:46:11 -0000 1.6 +++ createRulesetTables.zsql 16 Jan 2006 14:52:28 -0000 1.7 @@ -165,7 +165,7 @@ <dtml-var sql_delimiter> ALTER TABLE <dtml-var schema>mm_ticket ALTER COLUMN state SET DEFAULT 'Open' <dtml-var sql_delimiter> -ALTER TABLE <dtml-var schema>mm_ticket ADD CHECK (state in ('Open', 'Closed', 'Hold', 'Spam', 'Received', 'New', 'Overdue')) +ALTER TABLE <dtml-var schema>mm_ticket ADD CHECK (state in ('Open', 'Closed', 'Hold', 'Spam', 'Received', 'New', 'Overdue', 'Queued')) <dtml-var sql_delimiter> UPDATE <dtml-var schema>mm_ticket SET state = status @@ -205,7 +205,7 @@ <dtml-var sql_delimiter> ALTER TABLE <dtml-var schema>mm_history ALTER COLUMN state SET DEFAULT 'Open' <dtml-var sql_delimiter> -ALTER TABLE <dtml-var schema>mm_history ADD CHECK (state in ('Open', 'Closed', 'Hold', 'Spam', 'Received', 'New', 'Overdue')) +ALTER TABLE <dtml-var schema>mm_history ADD CHECK (state in ('Open', 'Closed', 'Hold', 'Spam', 'Received', 'New', 'Overdue', 'Queued')) <dtml-var sql_delimiter> UPDATE <dtml-var schema>mm_history SET state = status @@ -246,7 +246,7 @@ <dtml-var sql_delimiter> ALTER TABLE <dtml-var schema>mm_filter ALTER COLUMN state SET DEFAULT 'Open' <dtml-var sql_delimiter> -ALTER TABLE <dtml-var schema>mm_filter ADD CHECK (state in ('Open', 'Closed', 'Hold', 'Spam', 'Received', 'New', 'Overdue')) +ALTER TABLE <dtml-var schema>mm_filter ADD CHECK (state in ('Open', 'Closed', 'Hold', 'Spam', 'Received', 'New', 'Overdue', 'Queued')) <dtml-var sql_delimiter> UPDATE <dtml-var schema>mm_filter SET state = status --- NEW FILE: addTicketAttribute.zsql --- <dtml-comment> title:Adds an attribute to a ticket connection_id:mailmanager_db arguments:sqv_ticket_id sqv_attribute </dtml-comment> INSERT INTO <dtml-var schema>mm_ticket_attributes ( ticket_id, attribute ) VALUES ( <dtml-sqlvar sqv_ticket_id type="int">, <dtml-sqlvar sqv_attribute type="string"> ) --- NEW FILE: deleteRulesetStates.zsql --- <dtml-comment> title:Delete states from a ruleset connection_id: mailmanager_db max_rows:0 arguments:sqv_name </dtml-comment> DELETE FROM <dtml-var schema>mm_ruleset_states <dtml-sqlgroup where> <dtml-sqltest sqv_name column="name" type="nb" optional> </dtml-sqlgroup> Index: createTables.zsql =================================================================== RCS file: /cvsroot/mailmanager/MailManager/sql/createTables.zsql,v retrieving revision 1.8 retrieving revision 1.9 diff -u -d -r1.8 -r1.9 --- createTables.zsql 4 Jan 2006 15:17:29 -0000 1.8 +++ createTables.zsql 16 Jan 2006 14:52:28 -0000 1.9 @@ -69,6 +69,17 @@ html_signature <dtml-var sql_boolean> DEFAULT <dtml-var sql_false> ) <dtml-var sql_tabletype> <dtml-var sql_charset> <dtml-var sql_delimiter> + +<dtml-comment> + + Tickets table + + date_opened will normally be set to the time that the ticket is created in + the SQL database. It is not the time that the ticket was opened in the sense + that it was viewed and changed from the 'new' state. + +</dtml-comment> + CREATE TABLE <dtml-var schema>mm_ticket ( id <dtml-var sql_serialpkey>, subject <dtml-var sql_smalltext>, Index: addAccount.zsql =================================================================== RCS file: /cvsroot/mailmanager/MailManager/sql/addAccount.zsql,v retrieving revision 1.6 retrieving revision 1.7 diff -u -d -r1.6 -r1.7 --- addAccount.zsql 7 Nov 2005 10:00:55 -0000 1.6 +++ addAccount.zsql 16 Jan 2006 14:52:28 -0000 1.7 @@ -2,11 +2,12 @@ title:Add a new account connection_id: mailmanager_db max_rows:0 -arguments:sqv_email sqv_assign_user sqv_assign_group sqv_notify_user sqv_notify_group sqv_routing sqv_mail_server sqv_mail_username sqv_mail_password sqv_server_type sqv_default_priority sqv_default_category0 sqv_default_category1 sqv_default_category2 sqv_response_target sqv_auto_reply sqv_reply_text sqv_html_reply sqv_signature sqv_signature_text sqv_html_signature +arguments:sqv_email sqv_assign_user sqv_assign_group sqv_assign_queue sqv_notify_user sqv_notify_group sqv_routing sqv_mail_server sqv_mail_username sqv_mail_password sqv_server_type sqv_default_priority sqv_default_category0 sqv_default_category1 sqv_default_category2 sqv_response_target sqv_auto_reply sqv_reply_text sqv_html_reply sqv_signature sqv_signature_text sqv_html_signature </dtml-comment> INSERT INTO <dtml-var schema>mm_account (email <dtml-if sqv_assign_user>, assign_user </dtml-if> <dtml-if sqv_assign_group>, assign_group </dtml-if> + <dtml-if sqv_assign_queue>, assign_queue </dtml-if> <dtml-if sqv_notify_user>, notify_user </dtml-if> <dtml-if sqv_notify_group>, notify_group </dtml-if> <dtml-if sqv_routing>, routing </dtml-if> @@ -33,6 +34,9 @@ <dtml-if sqv_assign_group> , <dtml-sqlvar sqv_assign_group type="nb"> </dtml-if> + <dtml-if sqv_assign_queue> + , <dtml-sqlvar sqv_assign_queue type="nb"> + </dtml-if> <dtml-if sqv_notify_user> , <dtml-sqlvar sqv_notify_user type="nb"> </dtml-if> --- NEW FILE: deleteRulesetTransitionActions.zsql --- <dtml-comment> title:Delete transition actions from a ruleset connection_id: mailmanager_db max_rows:0 arguments:sqv_transition sqv_action sqv_params </dtml-comment> DELETE FROM <dtml-var schema>mm_ruleset_transition_actions <dtml-sqlgroup where> <dtml-sqltest sqv_transition column="transition" type="int" optional> <dtml-and> <dtml-sqltest sqv_action column="action" type="nb" optional> <dtml-and> <dtml-sqltest sqv_params column="params" type="nb" optional> </dtml-sqlgroup> --- NEW FILE: deleteRulesetEvents.zsql --- <dtml-comment> title:Delete events from a ruleset connection_id: mailmanager_db max_rows:0 arguments:sqv_name </dtml-comment> DELETE FROM <dtml-var schema>mm_ruleset_events <dtml-sqlgroup where> <dtml-sqltest sqv_name column="name" type="nb" optional> </dtml-sqlgroup> |