-- ---
-- Table 'Catalogs'
--
-- ---

DROP TABLE IF EXISTS `Catalogs`;

CREATE TABLE `Catalogs` (
  `id` INTEGER NOT NULL AUTO_INCREMENT DEFAULT NULL,
  `name` VARCHAR NOT NULL,
  PRIMARY KEY (`id`)
);

-- ---
-- Table 'Groups'
--
-- ---

DROP TABLE IF EXISTS `Groups`;

CREATE TABLE `Groups` (
  `id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
  `group_id` VARCHAR NOT NULL,
  `catalog_id` INTEGER NOT NULL,
  PRIMARY KEY (`id`)
);

-- ---
-- Foreign Keys
-- ---

ALTER TABLE `Groups` ADD FOREIGN KEY (catalog_id) REFERENCES `Catalogs` (`id`);

-- ---
-- Table Properties
-- ---

-- ALTER TABLE `Catalogs` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ALTER TABLE `Groups` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ---
-- Test Data
-- ---

-- INSERT INTO `Catalogs` (`id`,`name`) VALUES
-- ('','');
-- INSERT INTO `Groups` (`id`,`group_id`,`catalog_id`) VALUES
-- ('','','');