1
2
3
4
5
6
7
8
9
10
11
12
13

CREATE TABLE `PlanItems` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `classname` varchar(255) CHARACTER SET ascii NOT NULL,
  `name` varchar(255) CHARACTER SET ascii NOT NULL,
  `isVisible` int(10) unsigned DEFAULT '1',
  `applicableToSubscription` int(10) unsigned DEFAULT '0',
  `applicableToEmail` int(10) unsigned DEFAULT '0',
  `applicableToSite` int(10) unsigned DEFAULT '0',
  `uuid` varchar(36) CHARACTER SET ascii NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `uuid` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `PlanItems` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `classname` varchar(255) CHARACTER SET ascii NOT NULL, `name` varchar(255) CHARACTER SET ascii NOT NULL, `isVisible` int(10) unsigned DEFAULT '1', `applicableToSubscription` int(10) unsigned DEFAULT '0', `applicableToEmail` int(10) unsigned DEFAULT '0', `applicableToSite` int(10) unsigned DEFAULT '0', `uuid` varchar(36) CHARACTER SET ascii NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), UNIQUE KEY `uuid` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1