1 | --
|
---|
2 | -- Table structure for table `email_templates`
|
---|
3 | --
|
---|
4 |
|
---|
5 | CREATE TABLE `email_templates` (
|
---|
6 | `id` int(11) NOT NULL auto_increment,
|
---|
7 | `name` varchar(80) NOT NULL,
|
---|
8 | `description` text NOT NULL,
|
---|
9 | `subject` varchar(80) NOT NULL,
|
---|
10 | `content` text NOT NULL,
|
---|
11 | `availability` tinyint(4) NOT NULL,
|
---|
12 | `creator_id` int(11) NOT NULL default '0',
|
---|
13 | `created` date NOT NULL default '0000-00-00',
|
---|
14 | `updater_id` int(11) default NULL,
|
---|
15 | `updated` date default NULL,
|
---|
16 | PRIMARY KEY (`id`)
|
---|
17 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
---|
18 |
|
---|
19 | --
|
---|
20 | -- Table structure for table `email_schedules`
|
---|
21 | --
|
---|
22 |
|
---|
23 | CREATE TABLE `email_schedules` (
|
---|
24 | `id` int(11) NOT NULL auto_increment,
|
---|
25 | `subject` varchar(80) NOT NULL,
|
---|
26 | `content` text NOT NULL,
|
---|
27 | `date` datetime NOT NULL,
|
---|
28 | `from` varchar(80) NOT NULL,
|
---|
29 | `to` varchar(600) NOT NULL,
|
---|
30 | `course_id` int(11) default NULL,
|
---|
31 | `event_id` int(11) default NULL,
|
---|
32 | `grp_id` int(11) default NULL,
|
---|
33 | `sent` tinyint(1) NOT NULL default '0',
|
---|
34 | `creator_id` int(11) NOT NULL,
|
---|
35 | `created` datetime NOT NULL,
|
---|
36 | PRIMARY KEY (`id`)
|
---|
37 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
---|
38 |
|
---|
39 | --
|
---|
40 | -- Table structure for table `email_merges`
|
---|
41 | --
|
---|
42 |
|
---|
43 | CREATE TABLE `email_merges` (
|
---|
44 | `id` int(11) NOT NULL AUTO_INCREMENT,
|
---|
45 | `key` varchar(80) NOT NULL,
|
---|
46 | `value` varchar(80) NOT NULL,
|
---|
47 | `table_name` varchar(80) NOT NULL,
|
---|
48 | `field_name` varchar(80) NOT NULL,
|
---|
49 | `created` datetime NOT NULL,
|
---|
50 | `modified` datetime NOT NULL,
|
---|
51 | PRIMARY KEY (`id`)
|
---|
52 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
---|
53 |
|
---|
54 | --
|
---|
55 | -- Dumping data for table `email_merges`
|
---|
56 | --
|
---|
57 |
|
---|
58 | INSERT INTO `email_merges` (`id`, `key`, `value`, `field_name`, `created`, `modified`) VALUES
|
---|
59 | (1, 'Username', '{{{USERNAME}}}', 'username', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
|
---|
60 | (2, 'First Name', '{{{FIRSTNAME}}}', 'first_name', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
|
---|
61 | (3, 'Last Name', '{{{LASTNAME}}}', 'last_name', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
|
---|
62 | (4, 'Email Address', '{{{EMAIL}}}', 'email', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
|
---|
63 |
|
---|
64 | --
|
---|
65 | -- Dumping data for table `sys_functions`
|
---|
66 | --
|
---|
67 |
|
---|
68 | 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
|
---|
69 | (1700, 'EMAIL_TEMPLATE', 'Email Templates', 0, 'emailtemplates', 'emailtemplates/index', 'AI', 'A', 0, '0000-00-00 00:00:00', NULL, NULL),
|
---|
70 | (1800, 'EMAIL', 'Emails ', 0, 'emailer', 'emailer/index', 'AI', 'A', 0, '0000-00-00 00:00:00', NULL, NULL);
|
---|
71 |
|
---|
72 | --
|
---|
73 | -- Dumping data for table `sys_parameters`
|
---|
74 | --
|
---|
75 |
|
---|
76 | INSERT INTO `ipeer`.`sys_parameters` (
|
---|
77 | `id` ,
|
---|
78 | `parameter_code` ,
|
---|
79 | `parameter_value` ,
|
---|
80 | `parameter_type` ,
|
---|
81 | `description` ,
|
---|
82 | `record_status` ,
|
---|
83 | `creator_id` ,
|
---|
84 | `created` ,
|
---|
85 | `updater_id` ,
|
---|
86 | `modified`
|
---|
87 | )
|
---|
88 | VALUES (
|
---|
89 | NULL , 'email.port', '465', 'S', 'port number for email smtp option', 'A', '0', '2011-07-18 14:23:26', NULL , '2011-07-18 14:23:26'
|
---|
90 | ),
|
---|
91 | (
|
---|
92 | NULL , 'email.host', 'ssl://smtp.gmail.com', 'S', 'host address for email smtp option', 'A', '0', '2011-07-18 14:23:26', NULL , '2011-07-18 14:23:26'
|
---|
93 | ),
|
---|
94 | (
|
---|
95 | NULL , 'email.username', 'your_username@gmail.com', 'S', 'username for email smtp option', 'A', '0', '2011-07-18 14:23:26', NULL , '2011-07-18 14:23:26'
|
---|
96 | ),
|
---|
97 | (
|
---|
98 | NULL , 'email.password', 'your_gmail_password', 'S', 'password for email smtp option', 'A', '0', '2011-07-18 14:23:26', NULL , '2011-07-18 14:23:26'
|
---|
99 | );
|
---|