Projekt

Obecné

Profil

Stáhnout (1.79 KB) Statistiky
| Větev: | Tag: | Revize:
1 46867cf8 David Friesecký
/* ---------------------------------------------------- */
2
/*  Generated by Enterprise Architect Version 13.5 		*/
3 0217ab3d David Friesecký
/*  Created On : 27-b?e-2021 17:17:14 				*/
4 46867cf8 David Friesecký
/*  DBMS       : SQLite 								*/
5
/* ---------------------------------------------------- */
6
7
/* Drop Tables */
8
9
DROP TABLE IF EXISTS 'CertificateType'
10
;
11
12
DROP TABLE IF EXISTS 'CertificateUsage'
13
;
14
15
DROP TABLE IF EXISTS 'PrivateKey'
16
;
17
18
DROP TABLE IF EXISTS 'Certificate'
19
;
20
21
/* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */
22
23
CREATE TABLE 'CertificateType'
24
(
25
	'certificate_type_id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
26
	'certificate_type' TEXT NOT NULL
27
)
28
;
29
30
CREATE TABLE 'CertificateUsage'
31
(
32
	'certificate_usage_id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
33
	'certificate_usage' TEXT NOT NULL
34
)
35
;
36
37
CREATE TABLE 'PrivateKey'
38
(
39
	'private_key_id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
40 0217ab3d David Friesecký
	'private_key' TEXT NOT NULL,
41
	'password' TEXT NULL
42 46867cf8 David Friesecký
)
43
;
44
45
CREATE TABLE 'Certificate'
46
(
47
	'certificate_id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
48
	'common_name' TEXT NOT NULL,
49
	'valid_from' TEXT NOT NULL,
50
	'valid_to' TEXT NOT NULL,
51
	'pem_data' TEXT NOT NULL,
52
	'type_id' INTEGER NULL,
53
	'private_key_id' INTEGER NULL,
54 0217ab3d David Friesecký
	'usage_id' INTEGER NULL,
55 46867cf8 David Friesecký
	CONSTRAINT 'FK_Certificate_Type' FOREIGN KEY ('type_id') REFERENCES 'CertificateType' ('certificate_type_id') ON DELETE No Action ON UPDATE No Action,
56
	CONSTRAINT 'FK_Certificate_Usage' FOREIGN KEY ('usage_id') REFERENCES 'CertificateUsage' ('certificate_usage_id') ON DELETE No Action ON UPDATE No Action,
57
	CONSTRAINT 'FK_Parent_Certificate' FOREIGN KEY ('certificate_id') REFERENCES 'Certificate' ('certificate_id') ON DELETE No Action ON UPDATE No Action,
58
	CONSTRAINT 'FK_Private_Key' FOREIGN KEY ('private_key_id') REFERENCES 'PrivateKey' ('private_key_id') ON DELETE No Action ON UPDATE No Action
59
)
60
;