Changes between Version 22 and Version 23 of group_email


Ignore:
Timestamp:
2011-07-05T22:07:00Z (13 years ago)
Author:
Taehyun You
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • group_email

    v22 v23  
    7676  --
    7777
    78   CREATE TABLE `email_merges` (
     78CREATE 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,
     85PRIMARY KEY  (`id`)
     86) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
    7987
    80     `id` int(11) NOT NULL auto_increment,
    81 
    82     `key` varchar(80) NOT NULL,
    83 
    84     `value` varchar(80) NOT NULL,
    85 
    86     `field_name` varchar(80) NOT NULL,
    87 
    88     `created` datetime NOT NULL,
    89 
    90     `modified` datetime NOT NULL,
    91 
    92     PRIMARY KEY  (`id`)
    93 
    94   ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
    9588
    9689  --
    … …  
    9891  --
    9992  INSERT INTO `email_merges` (`id` ,`key` ,`value` ,`field_name` ,`created` ,`modified`)
    100   VALUES
    101   (NULL , 'Username', '<<USERNAME>>', 'username', '', ''),
    102   (NULL , 'First Name', '<<FIRSTNAME>>', 'first_name', '', ''),
    103   (NULL , 'Last Name', '<<LASTNAME>>', 'last_name', '', ''),
    104   (NULL , 'Email Address', '<<Email>>', 'email', '', '');
     93VALUES
     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', '', '');