| 36 | | |
| 37 | | |
| 38 | | -- |
| 39 | | -- Table structure for table `email_templates` |
| 40 | | -- |
| 41 | | |
| 42 | | CREATE TABLE email_templates ( |
| 43 | | |
| 44 | | id int(11) NOT NULL auto_increment, |
| 45 | | |
| 46 | | `name` varchar(80) NOT NULL, |
| 47 | | |
| 48 | | description text NOT NULL, |
| 49 | | |
| 50 | | content text NOT NULL, |
| 51 | | |
| 52 | | availability tinyint(4) NOT NULL, |
| 53 | | |
| 54 | | creator_id int(11) NOT NULL default '0', |
| 55 | | |
| 56 | | created date NOT NULL default '0000-00-00', |
| 57 | | |
| 58 | | updater_id int(11) default NULL, |
| 59 | | |
| 60 | | updated date default NULL, |
| 61 | | |
| 62 | | PRIMARY KEY (id) |
| 63 | | |
| 64 | | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| 65 | | |
| 66 | | -- |
| 67 | | -- Dumping data for table `sys_functions` |
| 68 | | -- |
| 69 | | |
| 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`) |
| 71 | | VALUES (1700, 'EMAIL_TEMPLATE', 'Email Templates', 0, 'emailer', 'emailer/index', 'AI', 'A', 0, '0000-00-00 00:00:00', NULL, NULL); |
| 72 | | |
| 73 | | |
| 74 | | -- |
| 75 | | -- Table structure for table `email_merges` |
| 76 | | -- |
| 77 | | |
| 78 | | CREATE TABLE 'email_merges' ( |
| 79 | | 'id' int(11) NOT NULL auto_increment, |
| 80 | | 'key' varchar(80) NOT NULL, |
| 81 | | 'value' varchar(80) NOT NULL, |
| 82 | | 'field_name' varchar(80) NOT NULL, |
| 83 | | 'created' datetime NOT NULL, |
| 84 | | 'modified' datetime NOT NULL, |
| 85 | | PRIMARY KEY ('id') |
| 86 | | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; |
| 87 | | |
| 88 | | |
| 89 | | -- |
| 90 | | -- Dumping data for table `email_merges` |
| 91 | | -- |
| 92 | | INSERT INTO 'email_merges' ('id' ,'key' ,'value' ,'field_name' ,'created' ,'modified') |
| 93 | | VALUES |
| 94 | | (NULL , 'Username', '<<USERNAME>>', 'username', '', ''), |
| 95 | | (NULL , 'First Name', '<<FIRSTNAME>>', 'first_name', '', ''), |
| 96 | | (NULL , 'Last Name', '<<LASTNAME>>', 'last_name', '', ''), |
| 97 | | (NULL , 'Email Address', '<<Email>>', 'email', '', ''); |
