DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
`name` VARCHAR(50) NOT NULL,
`value` text NOT NULL,
`description` VARCHAR(255),
`protected` BOOLEAN NOT NULL DEFAULT '0',
`visible` BOOLEAN NOT NULL DEFAULT '0'
) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
ALTER TABLE `config`
ADD PRIMARY KEY (`name`);
/* -------------------------------------------------- */
DROP TABLE IF EXISTS `asn1id`;
CREATE TABLE `asn1id` (
`lfd` INT(11) NOT NULL,
`oid` VARCHAR(255) NOT NULL,
`name` VARCHAR(255) NOT NULL,
`standardized` BOOLEAN NOT NULL DEFAULT '0',
`well_known` BOOLEAN NOT NULL DEFAULT '0'
) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
ALTER TABLE `asn1id`
ADD PRIMARY KEY (`lfd`),
ADD UNIQUE KEY `oid` (`oid`,`name`);
ALTER TABLE `asn1id`
MODIFY `lfd` INT(11) NOT NULL AUTO_INCREMENT;
/* -------------------------------------------------- */
DROP TABLE IF EXISTS `iri`;
CREATE TABLE `iri` (
`lfd` INT(11) NOT NULL,
`oid` VARCHAR(255) NOT NULL,
`name` VARCHAR(255) NOT NULL,
`longarc` BOOLEAN NOT NULL DEFAULT '0',
`well_known` BOOLEAN NOT NULL DEFAULT '0'
) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
ALTER TABLE `iri`
ADD PRIMARY KEY (`lfd`),
ADD UNIQUE KEY `oid` (`oid`,`name`);
ALTER TABLE `iri`
MODIFY `lfd` INT(11) NOT NULL AUTO_INCREMENT;
/* -------------------------------------------------- */
DROP TABLE IF EXISTS `objects`;
CREATE TABLE `objects` (
`id` VARCHAR(255) NOT NULL,
`parent` VARCHAR(255) DEFAULT NULL,
`title` VARCHAR(255) NULL,
`description` text NULL,
`ra_email` VARCHAR(100) NULL,
`confidential` BOOLEAN NOT NULL,
`created` datetime,
`updated` datetime,
`comment` VARCHAR(255) NULL
) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
ALTER TABLE `objects`
ADD PRIMARY KEY (`id`) USING BTREE,
ADD INDEX `parent` (`parent`),
ADD INDEX `ra_email` (`ra_email`);
/* -------------------------------------------------- */
DROP TABLE IF EXISTS `ra`;
CREATE TABLE `ra` (
`ra_id` INT(11) NOT NULL,
`email` VARCHAR(100) NOT NULL,
`ra_name` VARCHAR(100) NULL,
`personal_name` VARCHAR(100) NULL,
`organization` VARCHAR(100) NULL,
`office` VARCHAR(100) NULL,
`street` VARCHAR(100) NULL,
`zip_town` VARCHAR(100) NULL,
`country` VARCHAR(100) NULL,
`phone` VARCHAR(100) NULL,
`mobile` VARCHAR(100) NULL,
`fax` VARCHAR(100) NULL,
`privacy` BOOLEAN NOT NULL DEFAULT '0',
`salt` VARCHAR(100) NULL,
`authkey` VARCHAR(100) NULL,
`registered` datetime,
`updated` datetime,
`last_login` datetime
) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
ALTER TABLE `ra`
ADD PRIMARY KEY (`ra_id`),
ADD UNIQUE KEY `email` (`email`);
ALTER TABLE `ra`
MODIFY `ra_id` INT(11) NOT NULL AUTO_INCREMENT;
/* -------------------------------------------------- */
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
`id` INT(11) NOT NULL,
`unix_ts` BIGINT NOT NULL,
`addr` VARCHAR(45) NOT NULL,
`event` text NOT NULL
) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
ALTER TABLE `log`
ADD PRIMARY KEY (`id`);
ALTER TABLE `log`
MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT;
/* -------------------------------------------------- */
DROP TABLE IF EXISTS `log_user`;
CREATE TABLE `log_user` (
`id` INT(11) NOT NULL,
`log_id` INT(11) NOT NULL,
`username` VARCHAR(255) NOT NULL,
`severity` INT(11) NOT NULL
) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
ALTER TABLE `log_user`
ADD PRIMARY KEY (`id`),
ADD INDEX `log_id` (`log_id`),
ADD INDEX `username` (`username`),
ADD UNIQUE KEY `log_id_username` (`log_id`,`username`);
ALTER TABLE `log_user`
MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT;
/* -------------------------------------------------- */
DROP TABLE IF EXISTS `log_object`;
CREATE TABLE `log_object` (
`id` INT(11) NOT NULL,
`log_id` INT(11) NOT NULL,
`object` VARCHAR(255) NOT NULL,
`severity` INT(11) NOT NULL
) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
ALTER TABLE `log_object`
ADD PRIMARY KEY (`id`),
ADD INDEX `log_id` (`log_id`),
ADD INDEX `object` (`object`),
ADD UNIQUE KEY `log_id_object` (`log_id`,`object`);
ALTER TABLE `log_object`
MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT;
/* -------------------------------------------------- */
INSERT INTO `config` (name, description, VALUE, protected, visible) VALUES ('database_version', 'Version of the database tables', '1000', '1', '0');