Changes between Version 20 and Version 21 of group_email
- Timestamp:
- 2011-07-05T21:33:31Z (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
group_email
v20 v21 33 33 34 34 === Database Table === 35 * Create custom_emails: 35 ==== SQL Code to create 2 tables and insert data for group email system ==== 36 36 37 CREATE TABLE custom_emails ( 37 38 -- 39 -- Table structure for table `email_templates` 40 -- 41 42 CREATE TABLE email_templates ( 38 43 39 44 id int(11) NOT NULL auto_increment, … … 59 64 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 60 65 61 * Insert into sys_functions 66 -- 67 -- Dumping data for table `sys_functions` 68 -- 62 69 63 70 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`) … … 65 72 VALUES (1700, 'EMAIL_TEMPLATE', 'Email Templates', 0, 'emailer', 'emailer/index', 'AI', 'A', 0, '0000-00-00 00:00:00', NULL, NULL); 66 73 67 * Create and Insert email_merges:68 74 69 75 --