1
2
3
4
5
6
7
8

CREATE TABLE `DashboardPreset` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 DEFAULT '',
  `uri` varchar(255) CHARACTER SET ascii NOT NULL,
  `type` enum('admin','reseller','client','domain','private','custom') NOT NULL DEFAULT 'private',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_type` (`name`,`type`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1

CREATE TABLE `DashboardPreset` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 DEFAULT '', `uri` varchar(255) CHARACTER SET ascii NOT NULL, `type` enum('admin','reseller','client','domain','private','custom') NOT NULL DEFAULT 'private', PRIMARY KEY (`id`), UNIQUE KEY `name_type` (`name`,`type`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1