Rev 502 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed
Rev | Author | Line No. | Line |
---|---|---|---|
502 | daniel-mar | 1 | |
2 | CREATE TABLE [config]( |
||
3 | [name] VARCHAR(50) NOT NULL, |
||
4 | [VALUE] text NOT NULL, |
||
5 | [description] VARCHAR(255) NULL, |
||
6 | [protected] bit NOT NULL, |
||
7 | [visible] bit NOT NULL, |
||
8 | PRIMARY KEY |
||
9 | ( |
||
10 | [name] |
||
11 | ) |
||
12 | ); |
||
13 | |||
14 | CREATE TABLE [asn1id]( |
||
15 | [lfd] AUTOINCREMENT, |
||
16 | [oid] VARCHAR(255) NOT NULL, |
||
17 | [name] VARCHAR(255) NOT NULL, |
||
18 | [standardized] bit NOT NULL, |
||
19 | [well_known] bit NOT NULL, |
||
20 | PRIMARY KEY |
||
21 | ( |
||
22 | [lfd] |
||
23 | ) |
||
24 | ); |
||
25 | |||
26 | CREATE TABLE [iri]( |
||
27 | [lfd] AUTOINCREMENT, |
||
28 | [oid] VARCHAR(255) NOT NULL, |
||
29 | [name] VARCHAR(255) NOT NULL, |
||
30 | [longarc] bit NOT NULL, |
||
31 | [well_known] bit NOT NULL, |
||
32 | PRIMARY KEY |
||
33 | ( |
||
34 | [lfd] |
||
35 | ) |
||
36 | ); |
||
37 | |||
38 | CREATE TABLE [objects]( |
||
39 | [id] VARCHAR(255) NOT NULL, |
||
40 | [parent] VARCHAR(255) NULL, |
||
41 | [title] VARCHAR(255) NULL, |
||
42 | [description] text NULL, |
||
43 | [ra_email] VARCHAR(100) NULL, |
||
44 | [confidential] bit NOT NULL, |
||
45 | [created] datetime NULL, |
||
46 | [updated] datetime NULL, |
||
47 | [comment] VARCHAR(255) NULL, |
||
48 | PRIMARY KEY |
||
49 | ( |
||
50 | [id] |
||
51 | ) |
||
52 | ); |
||
53 | |||
54 | CREATE TABLE [ra]( |
||
55 | [ra_id] AUTOINCREMENT, |
||
56 | [email] VARCHAR(100) NOT NULL, |
||
57 | [ra_name] VARCHAR(100) NULL, |
||
58 | [personal_name] VARCHAR(100) NULL, |
||
59 | [organization] VARCHAR(100) NULL, |
||
60 | [office] VARCHAR(100) NULL, |
||
61 | [street] VARCHAR(100) NULL, |
||
62 | [zip_town] VARCHAR(100) NULL, |
||
63 | [country] VARCHAR(100) NULL, |
||
64 | [phone] VARCHAR(100) NULL, |
||
65 | [mobile] VARCHAR(100) NULL, |
||
66 | [fax] VARCHAR(100) NULL, |
||
67 | [privacy] bit NOT NULL, |
||
68 | [salt] VARCHAR(100) NULL, |
||
69 | [authkey] VARCHAR(100) NULL, |
||
70 | [registered] datetime NULL, |
||
71 | [updated] datetime NULL, |
||
72 | [last_login] datetime NULL, |
||
73 | PRIMARY KEY |
||
74 | ( |
||
75 | [ra_id] |
||
76 | ), |
||
77 | CONSTRAINT [IX_ra_email] UNIQUE ( |
||
78 | [email] |
||
79 | ) |
||
80 | ); |
||
81 | |||
82 | CREATE TABLE [log]( |
||
83 | [id] AUTOINCREMENT, |
||
84 | [unix_ts] long NOT NULL, |
||
85 | [addr] VARCHAR(45) NOT NULL, |
||
86 | [event] text NOT NULL, |
||
87 | PRIMARY KEY |
||
88 | ( |
||
89 | [id] |
||
90 | ) |
||
91 | ); |
||
92 | |||
93 | CREATE TABLE [log_user]( |
||
94 | [id] AUTOINCREMENT, |
||
95 | [log_id] INTEGER NOT NULL, |
||
96 | [username] VARCHAR(255) NOT NULL, |
||
97 | [severity] INTEGER NOT NULL, |
||
98 | PRIMARY KEY |
||
99 | ( |
||
100 | [id] |
||
101 | ), |
||
102 | CONSTRAINT [IX_log_user_log_id_username] UNIQUE |
||
103 | ( |
||
104 | [log_id], |
||
105 | [username] |
||
106 | ) |
||
107 | ); |
||
108 | |||
109 | CREATE TABLE [log_object]( |
||
110 | [id] AUTOINCREMENT, |
||
111 | [log_id] INTEGER NOT NULL, |
||
112 | [object] VARCHAR(255) NOT NULL, |
||
113 | [severity] INTEGER NOT NULL, |
||
114 | PRIMARY KEY |
||
115 | ( |
||
116 | [id] |
||
117 | ), |
||
118 | CONSTRAINT [IX_log_object_log_id_object] UNIQUE |
||
119 | ( |
||
120 | [log_id], |
||
121 | [object] |
||
122 | ) |
||
123 | ); |
||
124 | |||
830 | daniel-mar | 125 | INSERT INTO [config] ([name], [description], [VALUE], [protected], [visible]) VALUES ('database_version', 'Version of the database tables', '1000', '1', '0'); |