Subversion Repositories oidplus

Rev

Rev 855 | Blame | Last modification | View Log | RSS feed

  1. DROP TABLE IF EXISTS `config`;
  2. CREATE TABLE `config` (
  3.   `name` VARCHAR(50) NOT NULL,
  4.   `value` text NOT NULL,
  5.   `description` VARCHAR(255),
  6.   `protected` BOOLEAN NOT NULL DEFAULT '0',
  7.   `visible` BOOLEAN NOT NULL DEFAULT '0'
  8. ) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
  9.  
  10. ALTER TABLE `config`
  11.   ADD PRIMARY KEY (`name`);
  12.  
  13. /* -------------------------------------------------- */
  14.  
  15. DROP TABLE IF EXISTS `asn1id`;
  16. CREATE TABLE `asn1id` (
  17.   `lfd` INT(11) NOT NULL,
  18.   `oid` VARCHAR(255) NOT NULL COLLATE utf8_bin,
  19.   `name` VARCHAR(255) NOT NULL,
  20.   `standardized` BOOLEAN NOT NULL DEFAULT '0',
  21.   `well_known` BOOLEAN NOT NULL DEFAULT '0'
  22. ) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
  23.  
  24. ALTER TABLE `asn1id`
  25.   ADD PRIMARY KEY (`lfd`),
  26.   ADD UNIQUE KEY `oid` (`oid`,`name`);
  27. ALTER TABLE `asn1id`
  28.   MODIFY `lfd` INT(11) NOT NULL AUTO_INCREMENT;
  29.  
  30. /* -------------------------------------------------- */
  31.  
  32. DROP TABLE IF EXISTS `iri`;
  33. CREATE TABLE `iri` (
  34.   `lfd` INT(11) NOT NULL,
  35.   `oid` VARCHAR(255) NOT NULL COLLATE utf8_bin,
  36.   `name` VARCHAR(255) NOT NULL,
  37.   `longarc` BOOLEAN NOT NULL DEFAULT '0',
  38.   `well_known` BOOLEAN NOT NULL DEFAULT '0'
  39. ) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
  40.  
  41. ALTER TABLE `iri`
  42.   ADD PRIMARY KEY (`lfd`),
  43.   ADD UNIQUE KEY `oid` (`oid`,`name`);
  44. ALTER TABLE `iri`
  45.   MODIFY `lfd` INT(11) NOT NULL AUTO_INCREMENT;
  46.  
  47. /* -------------------------------------------------- */
  48.  
  49. DROP TABLE IF EXISTS `objects`;
  50. CREATE TABLE `objects` (
  51.   `id` VARCHAR(255) NOT NULL COLLATE utf8_bin,
  52.   `parent` VARCHAR(255) DEFAULT NULL COLLATE utf8_bin,
  53.   `title` VARCHAR(255) NULL,
  54.   `description` text NULL,
  55.   `ra_email` VARCHAR(100) NULL,
  56.   `confidential` BOOLEAN NOT NULL,
  57.   `created` datetime,
  58.   `updated` datetime,
  59.   `comment` VARCHAR(255) NULL
  60. ) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
  61.  
  62. ALTER TABLE `objects`
  63.   ADD PRIMARY KEY (`id`) USING BTREE,
  64.   ADD INDEX `parent` (`parent`),
  65.   ADD INDEX `ra_email` (`ra_email`);
  66.  
  67. /* -------------------------------------------------- */
  68.  
  69. DROP TABLE IF EXISTS `ra`;
  70. CREATE TABLE `ra` (
  71.   `ra_id` INT(11) NOT NULL,
  72.   `email` VARCHAR(100) NOT NULL,
  73.   `ra_name` VARCHAR(100) NULL,
  74.   `personal_name` VARCHAR(100) NULL,
  75.   `organization` VARCHAR(100) NULL,
  76.   `office` VARCHAR(100) NULL,
  77.   `street` VARCHAR(100) NULL,
  78.   `zip_town` VARCHAR(100) NULL,
  79.   `country` VARCHAR(100) NULL,
  80.   `phone` VARCHAR(100) NULL,
  81.   `mobile` VARCHAR(100) NULL,
  82.   `fax` VARCHAR(100) NULL,
  83.   `privacy` BOOLEAN NOT NULL DEFAULT '0',
  84.   `authkey` VARCHAR(250) NULL,
  85.   `registered` datetime,
  86.   `updated` datetime,
  87.   `last_login` datetime
  88. ) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
  89.  
  90. ALTER TABLE `ra`
  91.   ADD PRIMARY KEY (`ra_id`),
  92.   ADD UNIQUE KEY `email` (`email`);
  93. ALTER TABLE `ra`
  94.   MODIFY `ra_id` INT(11) NOT NULL AUTO_INCREMENT;
  95.  
  96. /* -------------------------------------------------- */
  97.  
  98. DROP TABLE IF EXISTS `log`;
  99. CREATE TABLE `log` (
  100.   `id` INT(11) NOT NULL,
  101.   `unix_ts` BIGINT NOT NULL,
  102.   `addr` VARCHAR(45) NOT NULL,
  103.   `event` text NOT NULL
  104. ) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
  105.  
  106. ALTER TABLE `log`
  107.   ADD PRIMARY KEY (`id`);
  108. ALTER TABLE `log`
  109.   MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT;
  110.  
  111. /* -------------------------------------------------- */
  112.  
  113. DROP TABLE IF EXISTS `log_user`;
  114. CREATE TABLE `log_user` (
  115.   `id` INT(11) NOT NULL,
  116.   `log_id` INT(11) NOT NULL,
  117.   `username` VARCHAR(255) NOT NULL,
  118.   `severity` INT(11) NOT NULL
  119. ) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
  120.  
  121. ALTER TABLE `log_user`
  122.   ADD PRIMARY KEY (`id`),
  123.   ADD INDEX `log_id` (`log_id`),
  124.   ADD INDEX `username` (`username`),
  125.   ADD UNIQUE KEY `log_id_username` (`log_id`,`username`);
  126.  
  127. ALTER TABLE `log_user`
  128.   MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT;
  129.  
  130. /* -------------------------------------------------- */
  131.  
  132. DROP TABLE IF EXISTS `log_object`;
  133. CREATE TABLE `log_object` (
  134.   `id` INT(11) NOT NULL,
  135.   `log_id` INT(11) NOT NULL,
  136.   `object` VARCHAR(255) NOT NULL COLLATE utf8_bin,
  137.   `severity` INT(11) NOT NULL
  138. ) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
  139.  
  140. ALTER TABLE `log_object`
  141.   ADD PRIMARY KEY (`id`),
  142.   ADD INDEX `log_id` (`log_id`),
  143.   ADD INDEX `object` (`object`),
  144.   ADD UNIQUE KEY `log_id_object` (`log_id`,`object`);
  145. ALTER TABLE `log_object`
  146.   MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT;
  147.  
  148. /* -------------------------------------------------- */
  149.  
  150. INSERT INTO `config` (name, description, VALUE, protected, visible) VALUES ('database_version', 'Version of the database tables', '1002', '1', '0');
  151.