aboutsummaryrefslogtreecommitdiff
path: root/scripts/Old/resource-set.py
diff options
context:
space:
mode:
authorRob Austein <sra@hactrn.net>2011-07-11 22:39:36 +0000
committerRob Austein <sra@hactrn.net>2011-07-11 22:39:36 +0000
commit169662c9d9cd26423321872c5dcf8afdba54df40 (patch)
tree7878b96adb7515f54bf885595bfcb52ea39730a7 /scripts/Old/resource-set.py
parentb972bd63fa3ab0533e13c5ace26788242d7c1755 (diff)
Make problems reading trust anchors non-fatal
svn path=/rcynic-ng/rcynic.c; revision=3928
Diffstat (limited to 'scripts/Old/resource-set.py')
0 files changed, 0 insertions, 0 deletions
mmit/docs/sample-irdb.sql?id=20f735ac7884111b47bd8ba974ed3e8fd1242e89'>20f735ac
486c91ea
3b1ad8f9


20f735ac

ef205774


f09fbb9d
ef205774

f09fbb9d
66023622
c63194c5
f09fbb9d
66023622


3b1ad8f9
6192e5fc
3b1ad8f9

66023622
c63194c5
f09fbb9d
f09fbb9d

66023622

3b1ad8f9
6192e5fc
3b1ad8f9

66023622
f09fbb9d


3b1ad8f9
5199aa55
f09fbb9d
66023622
f09fbb9d


dda9a127


66023622
f09fbb9d
6192e5fc
3b1ad8f9

66023622
4ce736d4
486c91ea

3b1ad8f9

42b211b6
486c91ea
42b211b6

3b1ad8f9


065c44e9
3b1ad8f9
ce5fd146
de95fb95
ce5fd146
3b1ad8f9

























4ce736d4
8f6d3dad
4ce736d4
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
       
 
                                                                











                                                                              
                                                                            











                                                                              



                                                                      





                                                                    
                                
                                         

                                        
                         

                                                      
                                             
                                                  
                                                                    
                
 
                             

                                                         
                                                                  
                                                            
                                                                                     
                
 
                             
                                                     
                                                          
                                                                           
                                                            
                                                                                     
                

                                                
                                                      
                                                         
                                                
                

                                                     

                                                          
                                                         
                                                                                   
                                                                 
                                                                                        
                
 
                                                
                                                      
                                                  
                                                        
                

                                                      
                                                  
                                                     
                                                     
                                            
                                              
























                                                                                                 
                   
                        
       
-- $Id$

-- Copyright (C) 2009--2011  Internet Systems Consortium ("ISC")
--
-- Permission to use, copy, modify, and distribute this software for any
-- purpose with or without fee is hereby granted, provided that the above
-- copyright notice and this permission notice appear in all copies.
--
-- THE SOFTWARE IS PROVIDED "AS IS" AND ISC DISCLAIMS ALL WARRANTIES WITH
-- REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY
-- AND FITNESS.  IN NO EVENT SHALL ISC BE LIABLE FOR ANY SPECIAL, DIRECT,
-- INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM
-- LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE
-- OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR
-- PERFORMANCE OF THIS SOFTWARE.

-- Copyright (C) 2007--2008  American Registry for Internet Numbers ("ARIN")
--
-- Permission to use, copy, modify, and distribute this software for any
-- purpose with or without fee is hereby granted, provided that the above
-- copyright notice and this permission notice appear in all copies.
--
-- THE SOFTWARE IS PROVIDED "AS IS" AND ARIN DISCLAIMS ALL WARRANTIES WITH
-- REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY
-- AND FITNESS.  IN NO EVENT SHALL ARIN BE LIABLE FOR ANY SPECIAL, DIRECT,
-- INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM
-- LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE
-- OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR
-- PERFORMANCE OF THIS SOFTWARE.

-- SQL objects needed by irdbd.py.  You only need this if you're using
-- irdbd.py as your IRDB; if you have a "real" backend you can do
-- anything you like so long as you implement the relevant portion of
-- the left-right protocol.

-- DROP TABLE commands must be in correct (reverse dependency) order
-- to satisfy FOREIGN KEY constraints.

DROP TABLE IF EXISTS roa_request_prefix;
DROP TABLE IF EXISTS roa_request;
DROP TABLE IF EXISTS registrant_net;
DROP TABLE IF EXISTS registrant_asn;
DROP TABLE IF EXISTS registrant;
DROP TABLE IF EXISTS ghostbuster_request;
DROP TABLE IF EXISTS ee_certificate_asn;
DROP TABLE IF EXISTS ee_certificate_net;
DROP TABLE IF EXISTS ee_certificate;

CREATE TABLE registrant (
        registrant_id           SERIAL NOT NULL,
        registrant_handle       VARCHAR(255) NOT NULL,
        registrant_name         TEXT,
        registry_handle         VARCHAR(255),
        valid_until             DATETIME NOT NULL,
        PRIMARY KEY             (registrant_id),
        UNIQUE                  (registry_handle, registrant_handle)
) ENGINE=InnoDB;

CREATE TABLE registrant_asn (
        start_as                BIGINT UNSIGNED NOT NULL,
        end_as                  BIGINT UNSIGNED NOT NULL,
        registrant_id           BIGINT UNSIGNED NOT NULL,
        PRIMARY KEY             (registrant_id, start_as, end_as),
        CONSTRAINT              registrant_asn_registrant_id
        FOREIGN KEY             (registrant_id) REFERENCES registrant (registrant_id)
                                ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB;

CREATE TABLE registrant_net (
        start_ip                VARCHAR(40) NOT NULL,
        end_ip                  VARCHAR(40) NOT NULL,
        version                 TINYINT UNSIGNED NOT NULL,
        registrant_id           BIGINT UNSIGNED NOT NULL,
        PRIMARY KEY             (registrant_id, version, start_ip, end_ip),
        CONSTRAINT              registrant_net_registrant_id
        FOREIGN KEY             (registrant_id) REFERENCES registrant (registrant_id)
                                ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB;

CREATE TABLE roa_request (
        roa_request_id          SERIAL NOT NULL,
        self_handle             VARCHAR(255) NOT NULL,
        asn                     BIGINT UNSIGNED NOT NULL,
        PRIMARY KEY             (roa_request_id)
) ENGINE=InnoDB;

CREATE TABLE roa_request_prefix (
        prefix                  VARCHAR(40) NOT NULL,
        prefixlen               TINYINT UNSIGNED NOT NULL,
        max_prefixlen           TINYINT UNSIGNED NOT NULL,
        version                 TINYINT UNSIGNED NOT NULL,
        roa_request_id          BIGINT UNSIGNED NOT NULL,
        PRIMARY KEY             (roa_request_id, prefix, prefixlen, max_prefixlen),
        CONSTRAINT              roa_request_prefix_roa_request_id
        FOREIGN KEY             (roa_request_id) REFERENCES roa_request (roa_request_id)
                                ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB;

CREATE TABLE ghostbuster_request (
        ghostbuster_request_id  SERIAL NOT NULL,
        self_handle             VARCHAR(255) NOT NULL,
        parent_handle           VARCHAR(255),
        vcard                   LONGBLOB NOT NULL,
        PRIMARY KEY             (ghostbuster_request_id)
) ENGINE=InnoDB;

CREATE TABLE ee_certificate (
        ee_certificate_id       SERIAL NOT NULL,
        self_handle             VARCHAR(255) NOT NULL,
        pkcs10                  LONGBLOB NOT NULL,
        gski                    VARCHAR(27) NOT NULL,
        cn                      VARCHAR(64) NOT NULL,
        sn                      VARCHAR(64),
        eku                     TEXT NOT NULL,
        valid_until             DATETIME NOT NULL,
        PRIMARY KEY             (ee_certificate_id),
        UNIQUE                  (self_handle, gski)
) ENGINE=InnoDB;

CREATE TABLE ee_certificate_asn (
        start_as                BIGINT UNSIGNED NOT NULL,
        end_as                  BIGINT UNSIGNED NOT NULL,
        ee_certificate_id       BIGINT UNSIGNED NOT NULL,
        PRIMARY KEY             (ee_certificate_id, start_as, end_as),
        CONSTRAINT              ee_certificate_asn_ee_certificate_id
        FOREIGN KEY             (ee_certificate_id) REFERENCES ee_certificate (ee_certificate_id)
                                ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB;

CREATE TABLE ee_certificate_net (
        version                 TINYINT UNSIGNED NOT NULL,
        start_ip                VARCHAR(40) NOT NULL,
        end_ip                  VARCHAR(40) NOT NULL,
        ee_certificate_id       BIGINT UNSIGNED NOT NULL,
        PRIMARY KEY             (ee_certificate_id, version, start_ip, end_ip),
        CONSTRAINT              ee_certificate_net_ee_certificate_id
        FOREIGN KEY             (ee_certificate_id) REFERENCES ee_certificate (ee_certificate_id)
                                ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB;

-- Local Variables:
-- indent-tabs-mode: nil
-- End: