Rev 1090 | 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, |
||
1171 | daniel-mar | 4 | [VALUE] memo NOT NULL, |
502 | daniel-mar | 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, |
||
1171 | daniel-mar | 42 | [description] memo NULL, |
502 | daniel-mar | 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, |
||
1090 | daniel-mar | 68 | [authkey] VARCHAR(250) NULL, |
502 | daniel-mar | 69 | [registered] datetime NULL, |
70 | [updated] datetime NULL, |
||
71 | [last_login] datetime NULL, |
||
72 | PRIMARY KEY |
||
73 | ( |
||
74 | [ra_id] |
||
75 | ), |
||
76 | CONSTRAINT [IX_ra_email] UNIQUE ( |
||
77 | [email] |
||
78 | ) |
||
79 | ); |
||
80 | |||
81 | CREATE TABLE [log]( |
||
82 | [id] AUTOINCREMENT, |
||
83 | [unix_ts] long NOT NULL, |
||
84 | [addr] VARCHAR(45) NOT NULL, |
||
1171 | daniel-mar | 85 | [event] memo NOT NULL, |
502 | daniel-mar | 86 | PRIMARY KEY |
87 | ( |
||
88 | [id] |
||
89 | ) |
||
90 | ); |
||
91 | |||
92 | CREATE TABLE [log_user]( |
||
93 | [id] AUTOINCREMENT, |
||
94 | [log_id] INTEGER NOT NULL, |
||
95 | [username] VARCHAR(255) NOT NULL, |
||
96 | [severity] INTEGER NOT NULL, |
||
97 | PRIMARY KEY |
||
98 | ( |
||
99 | [id] |
||
100 | ), |
||
101 | CONSTRAINT [IX_log_user_log_id_username] UNIQUE |
||
102 | ( |
||
103 | [log_id], |
||
104 | [username] |
||
105 | ) |
||
106 | ); |
||
107 | |||
108 | CREATE TABLE [log_object]( |
||
109 | [id] AUTOINCREMENT, |
||
110 | [log_id] INTEGER NOT NULL, |
||
111 | [object] VARCHAR(255) NOT NULL, |
||
112 | [severity] INTEGER NOT NULL, |
||
113 | PRIMARY KEY |
||
114 | ( |
||
115 | [id] |
||
116 | ), |
||
117 | CONSTRAINT [IX_log_object_log_id_object] UNIQUE |
||
118 | ( |
||
119 | [log_id], |
||
120 | [object] |
||
121 | ) |
||
122 | ); |
||
123 | |||
1090 | daniel-mar | 124 | INSERT INTO [config] ([name], [description], [VALUE], [protected], [visible]) VALUES ('database_version', 'Version of the database tables', '1002', '1', '0'); |