Projekt

Obecné

Profil

« Předchozí | Další » 

Revize 43439c9f

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

  • ID 43439c9f4b974ebdb14832cb8b911dbb89f9c52a
  • Rodič e1c31cac

Re #8590 - Migrated subjects fields to the table of certificates

Zobrazit rozdíly:

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

  		




  ......




  18
  18
  
    
DROP TABLE IF EXISTS 'PrivateKeys'


  		




  19
  19
  
    
;


  		




  20
  20
  
    

  		




  21
  
  
    
DROP TABLE IF EXISTS 'Subjects'


  		




  22
  
  
    
;


  		




  23
  
  
    

  		




  24
  21
  
    
DROP TABLE IF EXISTS 'UsageTypes'


  		




  25
  22
  
    
;


  		




  26
  23
  
    

  		




  ......




  32
  29
  
    
	'valid_from' TEXT NOT NULL,


  		




  33
  30
  
    
	'valid_to' TEXT NOT NULL,


  		




  34
  31
  
    
	'pem_data' TEXT NOT NULL,


  		




  
  32
  
    
	'common_name' TEXT NOT NULL,


  		




  
  33
  
    
	'country_code' TEXT NULL,


  		




  
  34
  
    
	'locality' TEXT NULL,


  		




  
  35
  
    
	'province' TEXT NULL,


  		




  
  36
  
    
	'organization' TEXT NULL,


  		




  
  37
  
    
	'organizational_unit' TEXT NULL,


  		




  
  38
  
    
	'email_address' TEXT NULL,


  		




  35
  39
  
    
	'revocation_date' TEXT NULL,


  		




  36
  
  
    
	'deletion_date' TEXT NULL,


  		




  37
  40
  
    
	'revocation_reason' TEXT NULL,


  		




  
  41
  
    
	'deletion_date' TEXT NULL,


  		




  38
  42
  
    
	'certificate_type_id' INTEGER NOT NULL,


  		




  39
  43
  
    
	'parent_certificate_id' INTEGER NOT NULL,


  		




  40
  
  
    
	'subject_id' INTEGER NOT NULL,


  		




  41
  44
  
    
	'private_key_id' INTEGER NOT NULL,


  		




  42
  45
  
    
	CONSTRAINT 'FK_Certificates' FOREIGN KEY ('parent_certificate_id') REFERENCES 'Certificates' ('id') ON DELETE No Action ON UPDATE No Action,


  		




  43
  46
  
    
	CONSTRAINT 'FK_CertificateTypes' FOREIGN KEY ('certificate_type_id') REFERENCES 'CertificateTypes' ('id') ON DELETE No Action ON UPDATE No Action,


  		




  44
  
  
    
	CONSTRAINT 'FK_PrivateKeys' FOREIGN KEY ('private_key_id') REFERENCES 'PrivateKeys' ('id') ON DELETE No Action ON UPDATE No Action,


  		




  45
  
  
    
	CONSTRAINT 'FK_Subjects' FOREIGN KEY ('subject_id') REFERENCES 'Subjects' ('id') ON DELETE No Action ON UPDATE No Action


  		




  
  47
  
    
	CONSTRAINT 'FK_PrivateKeys' FOREIGN KEY ('private_key_id') REFERENCES 'PrivateKeys' ('id') ON DELETE No Action ON UPDATE No Action


  		




  46
  48
  
    
)


  		




  47
  49
  
    
;


  		




  48
  50
  
    

  		




  ......




  71
  73
  
    
)


  		




  72
  74
  
    
;


  		




  73
  75
  
    

  		




  74
  
  
    
CREATE TABLE 'Subjects'


  		




  75
  
  
    
(


  		




  76
  
  
    
	'id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,


  		




  77
  
  
    
	'common_name' TEXT NULL,


  		




  78
  
  
    
	'country_code' TEXT NULL,


  		




  79
  
  
    
	'locality' TEXT NULL,


  		




  80
  
  
    
	'province' TEXT NULL,


  		




  81
  
  
    
	'organization' TEXT NULL,


  		




  82
  
  
    
	'organizational_unit' TEXT NULL,


  		




  83
  
  
    
	'email_address' TEXT NULL


  		




  84
  
  
    
)


  		




  85
  
  
    
;


  		




  86
  
  
    

  		




  87
  76
  
    
CREATE TABLE 'UsageTypes'


  		




  88
  77
  
    
(


  		




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


  		












Také k dispozici:  Unified diff