1
2
3
4
5
6

CREATE TABLE `SubscriptionProperties` (
  `subscription_id` int(10) unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `value` varchar(255) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`subscription_id`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `SubscriptionProperties` ( `subscription_id` int(10) unsigned NOT NULL, `name` varchar(255) CHARACTER SET utf8 NOT NULL, `value` varchar(255) CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`subscription_id`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1