CREATE TABLE [config](
[name] VARCHAR(50) NOT NULL,
[VALUE] text NOT NULL,
[description] VARCHAR(255) NULL,
[protected] bit NOT NULL,
[visible] bit NOT NULL,
PRIMARY KEY
(
[name]
)
);
CREATE TABLE [asn1id](
[lfd] AUTOINCREMENT,
[oid] VARCHAR(255) NOT NULL,
[name] VARCHAR(255) NOT NULL,
[standardized] bit NOT NULL,
[well_known] bit NOT NULL,
PRIMARY KEY
(
[lfd]
)
);
CREATE TABLE [iri](
[lfd] AUTOINCREMENT,
[oid] VARCHAR(255) NOT NULL,
[name] VARCHAR(255) NOT NULL,
[longarc] bit NOT NULL,
[well_known] bit NOT NULL,
PRIMARY KEY
(
[lfd]
)
);
CREATE TABLE [objects](
[id] VARCHAR(255) NOT NULL,
[parent] VARCHAR(255) NULL,
[title] VARCHAR(255) NULL,
[description] text NULL,
[ra_email] VARCHAR(100) NULL,
[confidential] bit NOT NULL,
[created] datetime NULL,
[updated] datetime NULL,
[comment] VARCHAR(255) NULL,
PRIMARY KEY
(
[id]
)
);
CREATE TABLE [ra](
[ra_id] AUTOINCREMENT,
[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] bit NOT NULL,
[salt] VARCHAR(100) NULL,
[authkey] VARCHAR(100) NULL,
[registered] datetime NULL,
[updated] datetime NULL,
[last_login] datetime NULL,
PRIMARY KEY
(
[ra_id]
),
CONSTRAINT [IX_ra_email] UNIQUE (
[email]
)
);
CREATE TABLE [log](
[id] AUTOINCREMENT,
[unix_ts] long NOT NULL,
[addr] VARCHAR(45) NOT NULL,
[event] text NOT NULL,
PRIMARY KEY
(
[id]
)
);
CREATE TABLE [log_user](
[id] AUTOINCREMENT,
[log_id] INTEGER NOT NULL,
[username] VARCHAR(255) NOT NULL,
[severity] INTEGER NOT NULL,
PRIMARY KEY
(
[id]
),
CONSTRAINT [IX_log_user_log_id_username] UNIQUE
(
[log_id],
[username]
)
);
CREATE TABLE [log_object](
[id] AUTOINCREMENT,
[log_id] INTEGER NOT NULL,
[object] VARCHAR(255) NOT NULL,
[severity] INTEGER NOT NULL,
PRIMARY KEY
(
[id]
),
CONSTRAINT [IX_log_object_log_id_object] UNIQUE
(
[log_id],
[object]
)
);
INSERT INTO [config] ([name], [description], [VALUE], [protected], [visible]) VALUES ('database_version', 'Version of the database tables', '1000', '1', '0');