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

CREATE TABLE `Configurations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `serviceNodeId` int(10) unsigned NOT NULL DEFAULT '1',
  `file` blob NOT NULL,
  `version` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `objectType` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `objectId` int(10) unsigned DEFAULT NULL,
  `status` enum('error','generation','ok') NOT NULL DEFAULT 'error',
  `description` blob,
  `active` enum('false','true') NOT NULL DEFAULT 'true',
  PRIMARY KEY (`id`),
  KEY `objectTypeAndId_index` (`objectType`,`objectId`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1

CREATE TABLE `Configurations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `serviceNodeId` int(10) unsigned NOT NULL DEFAULT '1', `file` blob NOT NULL, `version` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `objectType` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `objectId` int(10) unsigned DEFAULT NULL, `status` enum('error','generation','ok') NOT NULL DEFAULT 'error', `description` blob, `active` enum('false','true') NOT NULL DEFAULT 'true', PRIMARY KEY (`id`), KEY `objectTypeAndId_index` (`objectType`,`objectId`) ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1