Subversion Repositories oidplus

Rev

Rev 442 | Go to most recent revision | 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,
  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,
  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,
  52.   `parent` VARCHAR(255) DEFAULT NULL,
  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.   `salt` VARCHAR(100) NULL,
  85.   `authkey` VARCHAR(100) NULL,
  86.   `registered` datetime,
  87.   `updated` datetime,
  88.   `last_login` datetime
  89. ) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
  90.  
  91. ALTER TABLE `ra`
  92.   ADD PRIMARY KEY (`ra_id`),
  93.   ADD UNIQUE KEY `email` (`email`);
  94. ALTER TABLE `ra`
  95.   MODIFY `ra_id` INT(11) NOT NULL AUTO_INCREMENT;
  96.  
  97. /* -------------------------------------------------- */
  98.  
  99. DROP TABLE IF EXISTS `log`;
  100. CREATE TABLE `log` (
  101.   `id` INT(11) NOT NULL,
  102.   `unix_ts` BIGINT NOT NULL,
  103.   `addr` VARCHAR(45) NOT NULL,
  104.   `event` text NOT NULL
  105. ) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
  106.  
  107. ALTER TABLE `log`
  108.   ADD PRIMARY KEY (`id`);
  109. ALTER TABLE `log`
  110.   MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT;
  111.  
  112. /* -------------------------------------------------- */
  113.  
  114. DROP TABLE IF EXISTS `log_user`;
  115. CREATE TABLE `log_user` (
  116.   `id` INT(11) NOT NULL,
  117.   `log_id` INT(11) NOT NULL,
  118.   `username` VARCHAR(255) NOT NULL,
  119.   `severity` INT(11) NOT NULL
  120. ) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
  121.  
  122. ALTER TABLE `log_user`
  123.   ADD PRIMARY KEY (`id`),
  124.   ADD INDEX `log_id` (`log_id`),
  125.   ADD INDEX `username` (`username`),
  126.   ADD UNIQUE KEY `log_id_username` (`log_id`,`username`);
  127.  
  128. ALTER TABLE `log_user`
  129.   MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT;
  130.  
  131. /* -------------------------------------------------- */
  132.  
  133. DROP TABLE IF EXISTS `log_object`;
  134. CREATE TABLE `log_object` (
  135.   `id` INT(11) NOT NULL,
  136.   `log_id` INT(11) NOT NULL,
  137.   `object` VARCHAR(255) NOT NULL,
  138.   `severity` INT(11) NOT NULL
  139. ) /*ENGINE=InnoDB*/ DEFAULT CHARSET=utf8;
  140.  
  141. ALTER TABLE `log_object`
  142.   ADD PRIMARY KEY (`id`),
  143.   ADD INDEX `log_id` (`log_id`),
  144.   ADD INDEX `object` (`object`),
  145.   ADD UNIQUE KEY `log_id_object` (`log_id`,`object`);
  146. ALTER TABLE `log_object`
  147.   MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT;
  148.  
  149. /* -------------------------------------------------- */
  150.  
  151. INSERT INTO `config` (name, description, VALUE, protected, visible) VALUES ('database_version', 'Version of the database tables', '1000', '1', '0');
  152.