Changes between Version 12 and Version 13 of group_email

Timestamp:

2011-06-30T00:07:29Z (13 years ago)

Author:

Taehyun You

Comment:

--

group_email

@@ -33 +33 @@
 
 === Database Table ===
-* custom_emails:
+* Create custom_emails:
 
 CREATE TABLE custom_emails (
+
   id int(11) NOT NULL auto_increment,
+
   `name` varchar(80) NOT NULL,
+
   user_id int(11) NOT NULL,
+
   description text NOT NULL,
+
   content text NOT NULL,
+
   availability tinyint(4) NOT NULL,
+
   creator_id int(11) NOT NULL default '0',
+
   created date NOT NULL default '0000-00-00',
+
   updater_id int(11) default NULL,
+
   updated date default NULL,
+
   PRIMARY KEY  (id)
+
 ) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
 
+* Insert into sys_functions
+
+INSERT INTO `sys_functions` (`id`, `function_code`, `function_name`, `parent_id`, `controller_name`, `url_link`, `permission_type`, `record_status`, `creator_id`, `created`, `updater_id`, `modified`) 
+
+VALUES (1700, 'CUSTOM_EMAIL', 'Email Template', 0, 'emailer', 'emailer/index', 'AI', 'A', 0, '0000-00-00 00:00:00', NULL, NULL);
+