Changes between Version 18 and Version 19 of group_email

Timestamp:

2011-07-05T18:38:32Z (14 years ago)

Author:

Taehyun You

Comment:

--

group_email

@@ -65 +65 @@
   VALUES (1700, 'EMAIL_TEMPLATE', 'Email Templates', 0, 'emailer', 'emailer/index', 'AI', 'A', 0, '0000-00-00 00:00:00', NULL, NULL);
 
+* Create and Insert email_merges:
+
+  --
+  -- Table structure for table `email_merge`
+  --
+
+  CREATE TABLE `email_merge` (
+
+    `id` int(11) NOT NULL auto_increment,
+
+    `key` varchar(80) NOT NULL,
+
+    `value` varchar(80) NOT NULL,
+
+    `field_name` varchar(80) NOT NULL,
+
+    `created` datetime NOT NULL,
+
+    `modified` datetime NOT NULL,
+
+    PRIMARY KEY  (`id`)
+
+  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
+
+  --
+  -- Dumping data for table `email_merge`
+  --
+
+  INSERT INTO `email_merge` (`id`, `key`, `value`, `field_name`, `created`, `modified`) VALUES
+
+  (1, 'Username', '<<USERNAME>>', 'username', '2011-07-05 11:35:06', '2011-07-05 11:35:11'),
+
+  (2, 'First Name', '<<FIRSTNAME>>', 'first_name', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
+
+  (3, 'Last Name', '<<LASTNAME>>', 'last_name', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
+
+  (4, 'Email Address', '<<EMAIL>>', 'email', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
+
+