Subversion Repositories oidplus

Compare Revisions

Regard whitespace Rev 1175 → Rev 1176

/trunk/setup/sql/struct_sqlite.sql
11,7 → 11,7
DROP TABLE IF EXISTS `asn1id`;
CREATE TABLE `asn1id` (
`lfd` INTEGER PRIMARY KEY AUTOINCREMENT,
`oid` TEXT NOT NULL REFERENCES `objects`(`id`),
`oid` TEXT NOT NULL, -- REFERENCES `objects`(`id`)
`name` TEXT NOT NULL,
`standardized` INTEGER NOT NULL DEFAULT 0,
`well_known` INTEGER NOT NULL DEFAULT 0,
21,7 → 21,7
DROP TABLE IF EXISTS `iri`;
CREATE TABLE `iri` (
`lfd` INTEGER PRIMARY KEY AUTOINCREMENT,
`oid` TEXT NOT NULL REFERENCES `objects`(`id`),
`oid` TEXT NOT NULL, -- REFERENCES `objects`(`id`)
`name` TEXT NOT NULL,
`longarc` INTEGER NOT NULL DEFAULT 0,
`well_known` INTEGER NOT NULL DEFAULT 0,
31,10 → 31,10
DROP TABLE IF EXISTS `objects`;
CREATE TABLE `objects` (
`id` TEXT NOT NULL,
`parent` TEXT DEFAULT NULL REFERENCES `objects`(`id`),
`parent` TEXT DEFAULT NULL, -- REFERENCES `objects`(`id`)
`title` TEXT NULL,
`description` TEXT NULL,
`ra_email` TEXT NULL REFERENCES `ra`(`email`),
`ra_email` TEXT NULL, -- REFERENCES `ra`(`email`)
`confidential` boolean NOT NULL,
`created` TEXT, -- DateTime
`updated` TEXT, -- DateTime
74,7 → 74,7
DROP TABLE IF EXISTS `log_user`;
CREATE TABLE `log_user` (
`id` INTEGER PRIMARY KEY AUTOINCREMENT,
`log_id` INTEGER NOT NULL REFERENCES `log`(`id`),
`log_id` INTEGER NOT NULL, -- REFERENCES `log`(`id`)
`username` TEXT NOT NULL,
`severity` INTEGER NOT NULL,
UNIQUE (`log_id`,`username`)
83,7 → 83,7
DROP TABLE IF EXISTS `log_object`;
CREATE TABLE `log_object` (
`id` INTEGER PRIMARY KEY AUTOINCREMENT,
`log_id` INTEGER NOT NULL REFERENCES `log`(`id`),
`log_id` INTEGER NOT NULL, -- REFERENCES `log`(`id`)
`object` TEXT NOT NULL,
`severity` INTEGER NOT NULL,
UNIQUE (`log_id`,`object`)