openidm.sql revision b3ec0fd47cdcf8f64148a88ac62a7a68411c5c89
231b2dbbbc26e620c41026c9211d248e47859b51Phill CunningtonSET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
231b2dbbbc26e620c41026c9211d248e47859b51Phill CunningtonSET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
231b2dbbbc26e620c41026c9211d248e47859b51Phill CunningtonSET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
231b2dbbbc26e620c41026c9211d248e47859b51Phill CunningtonCREATE SCHEMA IF NOT EXISTS `openidm` DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_bin;
231b2dbbbc26e620c41026c9211d248e47859b51Phill Cunnington-- -----------------------------------------------------
231b2dbbbc26e620c41026c9211d248e47859b51Phill Cunnington-- Table `openidm`.`objecttypes`
231b2dbbbc26e620c41026c9211d248e47859b51Phill Cunnington-- -----------------------------------------------------
231b2dbbbc26e620c41026c9211d248e47859b51Phill CunningtonCREATE TABLE IF NOT EXISTS `openidm`.`objecttypes` (
231b2dbbbc26e620c41026c9211d248e47859b51Phill Cunnington `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
231b2dbbbc26e620c41026c9211d248e47859b51Phill Cunnington UNIQUE INDEX `idx_objecttypes_objecttype` (`objecttype` ASC) )
231b2dbbbc26e620c41026c9211d248e47859b51Phill Cunnington-- -----------------------------------------------------
231b2dbbbc26e620c41026c9211d248e47859b51Phill Cunnington-- Table `openidm`.`genericobjects`
231b2dbbbc26e620c41026c9211d248e47859b51Phill Cunnington-- -----------------------------------------------------
231b2dbbbc26e620c41026c9211d248e47859b51Phill CunningtonCREATE TABLE IF NOT EXISTS `openidm`.`genericobjects` (
231b2dbbbc26e620c41026c9211d248e47859b51Phill Cunnington `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
231b2dbbbc26e620c41026c9211d248e47859b51Phill Cunnington `objecttypes_id` BIGINT UNSIGNED NOT NULL ,
231b2dbbbc26e620c41026c9211d248e47859b51Phill Cunnington INDEX `fk_genericobjects_objecttypes` (`objecttypes_id` ASC) ,
231b2dbbbc26e620c41026c9211d248e47859b51Phill Cunnington UNIQUE INDEX `idx_genericobjects_object` (`objecttypes_id` ASC, `objectid` ASC) ,
231b2dbbbc26e620c41026c9211d248e47859b51Phill Cunnington-- -----------------------------------------------------
231b2dbbbc26e620c41026c9211d248e47859b51Phill Cunnington-- Table `openidm`.`genericobjectproperties`
231b2dbbbc26e620c41026c9211d248e47859b51Phill Cunnington-- -----------------------------------------------------
231b2dbbbc26e620c41026c9211d248e47859b51Phill CunningtonCREATE TABLE IF NOT EXISTS `openidm`.`genericobjectproperties` (
231b2dbbbc26e620c41026c9211d248e47859b51Phill Cunnington `genericobjects_id` BIGINT UNSIGNED NOT NULL ,
231b2dbbbc26e620c41026c9211d248e47859b51Phill Cunnington INDEX `fk_genericobjectproperties_genericobjects` (`genericobjects_id` ASC) ,
231b2dbbbc26e620c41026c9211d248e47859b51Phill Cunnington INDEX `idx_genericobjectproperties_prop` (`propkey` ASC, `propvalue`(23) ASC) ,
231b2dbbbc26e620c41026c9211d248e47859b51Phill Cunnington CONSTRAINT `fk_genericobjectproperties_genericobjects`
ON DELETE CASCADE
ON UPDATE NO ACTION)
CONSTRAINT `fk_managedobjects_objectypes`
ON DELETE CASCADE
ON UPDATE NO ACTION)
CONSTRAINT `fk_managedobjectproperties_managedobjects`
ON DELETE CASCADE
ON UPDATE NO ACTION)
CONSTRAINT `fk_configobjects_objecttypes`
ON DELETE CASCADE
ON UPDATE NO ACTION)
CONSTRAINT `fk_configobjectproperties_configobjects`
ON DELETE CASCADE
ON UPDATE NO ACTION)
CONSTRAINT `fk_schedulerobjects_objectypes`
ON DELETE CASCADE
ON UPDATE NO ACTION)
CONSTRAINT `fk_schedulerobjectproperties_schedulerobjects`
ON DELETE CASCADE
ON UPDATE NO ACTION)
START TRANSACTION;
INSERT INTO `openidm`.`internaluser` (`objectid`, `rev`, `pwd`, `roles`) VALUES ('openidm-admin', '0', '{\"$crypto\":{\"value\":{\"iv\":\"fIevcJYS4TMxClqcK7covg==\",\"data\":\"Tu9o/S+j+rhOIgdp9uYc5Q==\",\"cipher\":\"AES/CBC/PKCS5Padding\",\"key\":\"openidm-sym-default\"},\"type\":\"x-simple-encryption\"}}', 'openidm-admin,openidm-authorized');