Projekt

Obecné

Profil

« Předchozí | Další » 

Revize 0e7c3096

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

Re #8590 - Implemented all fields of subject into DB

Zobrazit rozdíly:

src/db/init_queries.py
1 1 
SCHEMA_SQL = """
2 2 
/* ---------------------------------------------------- */
3 3 
/*  Generated by Enterprise Architect Version 13.5 		*/
4 
/*  Created On : 27-dub-2021 11:31:54 				*/
4 
/*  Created On : 29-dub-2021 11:55:46 				*/
5 5 
/*  DBMS       : SQLite 								*/
6 6 
/* ---------------------------------------------------- */
7 7 

  		




  ......




  27
  27
  
    
CREATE TABLE 'Certificates'


  		




  28
  28
  
    
(


  		




  29
  29
  
    
	'id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,


  		




  30
  
  
    
	'common_name' TEXT NOT NULL,


  		




  31
  30
  
    
	'valid_from' TEXT NOT NULL,


  		




  32
  31
  
    
	'valid_to' TEXT NOT NULL,


  		




  33
  32
  
    
	'pem_data' TEXT NOT NULL,


  		




  
  33
  
    
	'common_name' TEXT NOT NULL,


  		




  
  34
  
    
	'country_code' TEXT NULL,


  		




  
  35
  
    
	'locality' TEXT NULL,


  		




  
  36
  
    
	'province' TEXT NULL,


  		




  
  37
  
    
	'organization' TEXT NULL,


  		




  
  38
  
    
	'organizational_unit' TEXT NULL,


  		




  
  39
  
    
	'email_address' TEXT NULL,


  		




  34
  40
  
    
	'revocation_date' TEXT NULL,


  		




  35
  41
  
    
	'revocation_reason' TEXT NULL,


  		




  36
  42
  
    
	'deletion_date' TEXT NULL,


  		




  37
  
  
    
	'private_key_id' INTEGER NOT NULL,


  		




  38
  43
  
    
	'certificate_type_id' INTEGER NOT NULL,


  		




  39
  44
  
    
	'parent_certificate_id' INTEGER NOT NULL,


  		




  
  45
  
    
	'private_key_id' INTEGER NOT NULL,


  		




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


  		




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


  		




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


  		












Také k dispozici:  Unified diff