communigate (phase 2): rules. RT#7514

[freeside.git] / FS / FS / Schema.pm

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 67cf606..28f8264 100644 (file)
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -1675,13 +1675,13 @@ sub tables_hashref {
         'cgp_addmailtrailer', 'char', 'NULL',       1, '', '', #AddMailTrailer
         #XXX archive messages, mailing lists
         #preferences
         'cgp_addmailtrailer', 'char', 'NULL',       1, '', '', #AddMailTrailer
         #XXX archive messages, mailing lists
         #preferences

-        'cgp_deletemode',  'varchar', 'NULL', $char_d, '', '', #DeleteMode
-        'cgp_emptytrash',  'varchar', 'NULL', $char_d, '', '', #EmptyTrash
-        'cgp_language',    'varchar', 'NULL', $char_d, '', '', #Language
-        'cgp_timezone',    'varchar', 'NULL', $char_d, '', '', #TimeZone
-        'cgp_skinname',    'varchar', 'NULL', $char_d, '', '', #SkinName
-        #XXX pronto style?
-        'cgp_sendmdnmode', 'varchar', 'NULL', $char_d, '', '', #SendMDNMode
+        'cgp_deletemode',     'varchar', 'NULL', $char_d, '', '',#DeleteMode
+        'cgp_emptytrash',     'varchar', 'NULL', $char_d, '', '',#EmptyTrash
+        'cgp_language',       'varchar', 'NULL', $char_d, '', '',#Language
+        'cgp_timezone',       'varchar', 'NULL', $char_d, '', '',#TimeZone
+        'cgp_skinname',       'varchar', 'NULL', $char_d, '', '',#SkinName
+        'cgp_prontoskinname', 'varchar', 'NULL', $char_d, '', '',#ProntoSkinName
+        'cgp_sendmdnmode',    'varchar', 'NULL', $char_d, '', '',#SendMDNMode

         #mail
 #vacation message, redirect all mail, mail rules
         #XXX RPOP settings
         #mail
 #vacation message, redirect all mail, mail rules
         #XXX RPOP settings


@@ -1734,26 +1734,26 @@ sub tables_hashref {
         'cgp_aliases',  'varchar', 'NULL',      255, '', '',
         'cgp_accessmodes','varchar','NULL',     255, '', '', #DomainAccessModes
         #settings
         'cgp_aliases',  'varchar', 'NULL',      255, '', '',
         'cgp_accessmodes','varchar','NULL',     255, '', '', #DomainAccessModes
         #settings

-        'acct_def_password_selfchange','char', 'NULL',       1, '', '', 
-        'acct_def_password_recover',   'char', 'NULL',       1, 'Y', '', 
-        'acct_def_cgp_accessmodes', 'varchar', 'NULL',     255, '', '',
-        'acct_def_quota',           'varchar', 'NULL', $char_d, '', '',
-        'acct_def_file_quota',      'varchar', 'NULL', $char_d, '', '',
-        'acct_def_file_maxnum',     'varchar', 'NULL', $char_d, '', '',
-        'acct_def_file_maxsize',    'varchar', 'NULL', $char_d, '', '',
-        'acct_def_cgp_rulesallowed','varchar', 'NULL', $char_d, '', '',
-        'acct_def_cgp_rpopallowed',    'char', 'NULL',       1, '', '', 
-        'acct_def_cgp_mailtoall',      'char', 'NULL',       1, '', '', 
-        'acct_def_cgp_addmailtrailer', 'char', 'NULL',       1, '', '', 
+        'acct_def_password_selfchange',   'char', 'NULL',       1,  '', '', 
+        'acct_def_password_recover',      'char', 'NULL',       1, 'Y', '', 
+        'acct_def_cgp_accessmodes',    'varchar', 'NULL',     255,  '', '',
+        'acct_def_quota',              'varchar', 'NULL', $char_d,  '', '',
+        'acct_def_file_quota',         'varchar', 'NULL', $char_d,  '', '',
+        'acct_def_file_maxnum',        'varchar', 'NULL', $char_d,  '', '',
+        'acct_def_file_maxsize',       'varchar', 'NULL', $char_d,  '', '',
+        'acct_def_cgp_rulesallowed',   'varchar', 'NULL', $char_d,  '', '',
+        'acct_def_cgp_rpopallowed',       'char', 'NULL',       1,  '', '', 
+        'acct_def_cgp_mailtoall',         'char', 'NULL',       1,  '', '', 
+        'acct_def_cgp_addmailtrailer',    'char', 'NULL',       1,  '', '', 

         #XXX archive messages
         #preferences
         #XXX archive messages
         #preferences

-        'acct_def_cgp_deletemode',  'varchar', 'NULL', $char_d, '', '',
-        'acct_def_cgp_emptytrash',  'varchar', 'NULL', $char_d, '', '',
-        'acct_def_cgp_language',    'varchar', 'NULL', $char_d, '', '',
-        'acct_def_cgp_timezone',    'varchar', 'NULL', $char_d, '', '',
-        'acct_def_cgp_skinname',    'varchar', 'NULL', $char_d, '', '',
-        #XXX pronto style?
-        'acct_def_cgp_sendmdnmode', 'varchar', 'NULL', $char_d, '', '',
+        'acct_def_cgp_deletemode',     'varchar', 'NULL', $char_d,  '', '',
+        'acct_def_cgp_emptytrash',     'varchar', 'NULL', $char_d,  '', '',
+        'acct_def_cgp_language',       'varchar', 'NULL', $char_d,  '', '',
+        'acct_def_cgp_timezone',       'varchar', 'NULL', $char_d,  '', '',
+        'acct_def_cgp_skinname',       'varchar', 'NULL', $char_d,  '', '',
+        'acct_def_cgp_prontoskinname', 'varchar', 'NULL', $char_d,  '', '',
+        'acct_def_cgp_sendmdnmode',    'varchar', 'NULL', $char_d,  '', '',

         #mail
         #XXX rules, archive rule, spam foldering rule(s)
       ],
         #mail
         #XXX rules, archive rule, spam foldering rule(s)
       ],


@@ -1786,6 +1786,44 @@ sub tables_hashref {
       'index'       => [],
     },
 
       'index'       => [],
     },
 

+    'cgp_rule' => {
+      'columns' => [
+        'rulenum',  'serial',     '',      '', '', '',
+        'name',    'varchar',     '', $char_d, '', '',
+        'comment', 'varchar', 'NULL', $char_d, '', '',
+        'svcnum',      'int',     '',      '', '', '',
+        'priority',    'int',     '',      '', '', '',
+      ],
+      'primary_key' => 'rulenum',
+      'unique'      => [],
+      'index'       => [ [ 'svcnum' ] ],
+    },
+
+    'cgp_rule_condition' => {
+      'columns' => [
+        'ruleconditionnum',  'serial', '',      '', '', '',
+        'condition',        'varchar', '', $char_d, '', '',
+        'op',               'varchar', '', $char_d, '', '',
+        'params',           'varchar', '',     255, '', '',
+        'rulenum',              'int', '',      '', '', '',
+      ],
+      'primary_key' => 'ruleconditionnum',
+      'unique'      => [],
+      'index'       => [ [ 'rulenum' ] ],
+    },
+
+    'cgp_rule_action' => {
+       'columns' => [
+        'ruleactionnum',  'serial', '',      '', '', '',
+        'action',        'varchar', '', $char_d, '', '',
+        'params',        'varchar', '',     255, '', '',
+        'rulenum',           'int', '',      '', '', '',
+      ],
+      'primary_key' => 'ruleactionnum',
+      'unique'      => [],
+      'index'       => [ [ 'rulenum' ] ],
+   },
+

     'svc_forward' => {
       'columns' => [
         'svcnum',   'int',            '',   '', '', '', 
     'svc_forward' => {
       'columns' => [
         'svcnum',   'int',            '',   '', '', '',