Changes between Version 13 and Version 14 of group_email

Timestamp:

2011-06-30T00:08:14Z (14 years ago)

Author:

Taehyun You

Comment:

--

group_email

@@ -35 +35 @@
 * Create custom_emails:
 
-CREATE TABLE custom_emails (
+  CREATE TABLE custom_emails (
 
-  id int(11) NOT NULL auto_increment,
+    id int(11) NOT NULL auto_increment,
 
-  `name` varchar(80) NOT NULL,
+    `name` varchar(80) NOT NULL,
 
-  user_id int(11) NOT NULL,
+    user_id int(11) NOT NULL,
 
-  description text NOT NULL,
+    description text NOT NULL,
 
-  content text NOT NULL,
+    content text NOT NULL,
 
-  availability tinyint(4) NOT NULL,
+    availability tinyint(4) NOT NULL,
 
-  creator_id int(11) NOT NULL default '0',
+    creator_id int(11) NOT NULL default '0',
 
-  created date NOT NULL default '0000-00-00',
+    created date NOT NULL default '0000-00-00',
 
-  updater_id int(11) default NULL,
+    updater_id int(11) default NULL,
 
-  updated date default NULL,
+    updated date default NULL,
 
-  PRIMARY KEY  (id)
+    PRIMARY KEY  (id)
 
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
+  ) 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`) 
+  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);
+  VALUES (1700, 'CUSTOM_EMAIL', 'Email Template', 0, 'emailer', 'emailer/index', 'AI', 'A', 0, '0000-00-00 00:00:00', NULL, NULL);