Blame | Last modification | View Log | RSS feed
SQLite format 3 @ .O} É ç·» r <¨
µaY
x3OÈæ A))=tableoidplus_asn1idoidplus_asn1idCREATE TABLE `oidplus_asn1id` (
`lfd` INTEGER PRIMARY KEY AUTOINCREMENT,
`oid` TEXT NOT NULL, -- REFERENCES `oidplus_objects`(`id`)
`name` TEXT NOT NULL,
`standardized` INTEGER NOT NULL DEFAULT 0,
`well_known` INTEGER NOT NULL DEFAULT 0,
UNIQUE (`oid`,`name`)
)+ ÿ11[tableoidplus_log_objectoidplus_log_objectCREATE TABLE `oidplus_log_object` (
`id` INTEGER PRIMARY KEY AUTOINCREMENT,
`log_id` INTEGER NOT NULL REFERENCES `oidplus_log`(`id`),
`object` TEXT NOT NULL,
`severity` INTEGER NOT NULL,
U11atableoidplus_log_objectoidplus_log_objectCREATE TABLE `oidplus_log_object` (
`id` INTEGER PRIMARY KEY AUTOINCREMENT,
`log_id` INTEGER NOT NULL, -- REFERENCES `oidplus_log`(`id`)
`object` TEXT NOT NULL,
`severity` INTEGER NOT NULL,
UNIQUE (`log_id`,`object`)
)CW1 indexsqlite_autoindex_oidplus_log_object_1oidplus_log_object --etableoidplus_log_useroidplus_log_userCREATE TABLE `oidplus_log_user` (
`id` INTEGER PRIMARY KEY AUTOINCREMENT,
`log_id` INTEGER NOT NULL, -- REFERENCES `oidplus_log`(`id`)
`username` TEXT NOT NULL,
`severity` INTEGER NOT NULL,
UNIQUE (`log_id`,`username`)
)?S- indexsqlite_autoindex_oidplus_log_user_1oidplus_log_user
>##Ctableoidplus_logoidplus_log CREATE TABLE `oidplus_log` (
`id` INTEGER PRIMARY KEY AUTOINCREMENT,
`unix_ts` INTEGER NOT NULL,
`addr` TEXT NOT NULL,
`event` TEXT NOT NULL
)!!tableoidplus_raoidplus_raCREATE TABLE `oidplus_ra` (
`ra_id` INTEGER PRIMARY KEY AUTOINCREMENT,
`email` TEXT NOT NULL UNIQUE,
`ra_name` TEXT NULL,
`personal_name` TEXT NULL,
`organization` TEXT NULL,
`office` TEXT NULL,
`street` TEXT NULL,
`zip_town` TEXT NULL,
`country` TEXT NULL,
`phone` TEXT NULL,
`mobile` TEXT NULL,
`fax` TEXT NULL,
`privacy` INTEGER NOT NULL DEFAULT 0,
`authkey` TEXT NULL,
`registered` TEXT, -- DateTime
`updated` TEXT, -- DateTime
`last_login` datetime
)3G! indexsqlite_autoindex_oidplus_ra_1oidplus_ra )++ tableoidplus_objectsoidplus_objects CREATE TABLE `oidplus_objects` (
`id` TEXT NOT NULL,
`parent` TEXT DEFAULT NULL, -- REFERENCES `oidplus_objects`(`id`)
`title` TEXT NULL,
`description` TEXT NULL,
`ra_email` TEXT NULL, -- REFERENCES `oidplus_ra`(`email`)
`confidential` boolean NOT NULL,
`created` TEXT, -- DateTime
`updated` TEXT, -- DateTime
`comment` TEXT NULL,
PRIMARY KEY (`id`)
)=Q+ indexsqlite_autoindex_oidplus_objects_1oidplus_objects
ß 5I# indexsqlite_autoindex_oidplus_iri_1oidplus_iri¯ P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)¯3##-tableoidplus_irioidplus_iriCREATE TABLE `oidplus_iri` (
`lfd` INTEGER PRIMARY KEY AUTOINCREMENT,
`oid` TEXT NOT NULL, -- REFERENCES `oidplus_objects`(`id`)
`name` TEXT NOT NULL,
`longarc` INTEGER NOT NULL DEFAULT 0,
`well_known` INTEGER NOT NULL DEFAULT 0,
UNIQUE (`oid`,`name`)
);O) indexsqlite_autoindex_oidplus_asn1id_1oidplus_asn1idø ))=tableoidplus_configoidplus_configCREATE TABLE `oidplus_config` (
`name` TEXT NOT NULL,
`value` TEXT NOT NULL,
`description` TEXT,
`protected` INTEGER NOT NULL DEFAULT 0,
`visible` INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY (`name`)
);O) indexsqlite_autoindex_oidplus_config_1oidplus_config Æ Æ