Projekt

Obecné

Profil

« Předchozí | Další » 

Revize 7ad820d0

Přidáno uživatelem David Friesecký před téměř 4 roky(ů)

Re #8927 - Improved loading scripts into DB

Zobrazit rozdíly:

SQLite_database.sql
1 
/* ---------------------------------------------------- */
2 
/*  Generated by Enterprise Architect Version 13.5 		*/
3 
/*  Created On : 29-dub-2021 11:55:46 				*/
4 
/*  DBMS       : SQLite 								*/
5 
/* ---------------------------------------------------- */
6 

  		




  7
  1
  
    
/* Drop Tables */


  		




  8
  
  
    

  		




  9
  
  
    
DROP TABLE IF EXISTS 'Certificates'


  		




  10
  
  
    
;


  		




  11
  
  
    

  		




  12
  2
  
    
DROP TABLE IF EXISTS 'CertificateTypes'


  		




  13
  3
  
    
;


  		




  14
  4
  
    

  		




  15
  5
  
    
DROP TABLE IF EXISTS 'CertificateUsages'


  		




  16
  6
  
    
;


  		




  17
  7
  
    

  		




  18
  
  
    
DROP TABLE IF EXISTS 'PrivateKeys'


  		




  19
  
  
    
;


  		




  20
  
  
    

  		




  21
  
  
    
DROP TABLE IF EXISTS 'UsageTypes'


  		




  22
  
  
    
;


  		




  23
  
  
    

  		




  24
  8
  
    
/* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */


  		




  25
  9
  
    

  		




  26
  
  
    
CREATE TABLE 'Certificates'


  		




  
  10
  
    
CREATE TABLE IF NOT EXISTS 'Certificates'


  		




  27
  11
  
    
(


  		




  28
  12
  
    
	'id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,


  		




  29
  13
  
    
	'valid_from' TEXT NOT NULL,


  		




  ......




  48
  32
  
    
)


  		




  49
  33
  
    
;


  		




  50
  34
  
    

  		




  51
  
  
    
CREATE TABLE 'CertificateTypes'


  		




  
  35
  
    
CREATE TABLE IF NOT EXISTS 'CertificateTypes'


  		




  52
  36
  
    
(


  		




  53
  37
  
    
	'id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,


  		




  54
  38
  
    
	'certificate_type' TEXT NOT NULL


  		




  55
  39
  
    
)


  		




  56
  40
  
    
;


  		




  57
  41
  
    

  		




  58
  
  
    
CREATE TABLE 'CertificateUsages'


  		




  
  42
  
    
CREATE TABLE IF NOT EXISTS 'CertificateUsages'


  		




  59
  43
  
    
(


  		




  60
  44
  
    
	'id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,


  		




  61
  45
  
    
	'certificate_id' INTEGER NOT NULL,


  		




  ......




  65
  49
  
    
)


  		




  66
  50
  
    
;


  		




  67
  51
  
    

  		




  68
  
  
    
CREATE TABLE 'PrivateKeys'


  		




  
  52
  
    
CREATE TABLE IF NOT EXISTS 'PrivateKeys'


  		




  69
  53
  
    
(


  		




  70
  54
  
    
	'id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,


  		




  71
  55
  
    
	'private_key' TEXT NOT NULL,


  		




  ......




  73
  57
  
    
)


  		




  74
  58
  
    
;


  		




  75
  59
  
    

  		




  76
  
  
    
CREATE TABLE 'UsageTypes'


  		




  
  60
  
    
CREATE TABLE IF NOT EXISTS 'UsageTypes'


  		




  77
  61
  
    
(


  		




  78
  62
  
    
	'id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,


  		




  79
  63
  
    
	'usage_type' TEXT NOT NULL


  		












Také k dispozici:  Unified diff