OpenDNSSEC-enforcer 2.1.13
db_schema_sqlite.c
Go to the documentation of this file.
1/*
2 * Copyright (c) 2014 Jerry Lundström <lundstrom.jerry@gmail.com>
3 * Copyright (c) 2014 .SE (The Internet Infrastructure Foundation).
4 * Copyright (c) 2014 OpenDNSSEC AB (svb)
5 * All rights reserved.
6 *
7 * Redistribution and use in source and binary forms, with or without
8 * modification, are permitted provided that the following conditions
9 * are met:
10 * 1. Redistributions of source code must retain the above copyright
11 * notice, this list of conditions and the following disclaimer.
12 * 2. Redistributions in binary form must reproduce the above copyright
13 * notice, this list of conditions and the following disclaimer in the
14 * documentation and/or other materials provided with the distribution.
15 *
16 * THIS SOFTWARE IS PROVIDED BY THE AUTHOR ``AS IS'' AND ANY EXPRESS OR
17 * IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
18 * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
19 * ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY
20 * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
21 * DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE
22 * GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
23 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER
24 * IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
25 * OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN
26 * IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
27 */
28
29const char* db_schema_sqlite_create[] = {
30 "CREATE TABLE zone ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rev INTEGER NOT NULL DEFAULT 1, policyId INTEGER NOT NULL, name TEXT NOT NULL, signconfNeedsWriting UNSIGNED INT NOT NULL, signconfPath TEXT NOT NULL, nextChange INT NOT NULL, ttlEndDs UNSIGNED INT NOT NULL, ttlEndDk UNSIGNED INT NOT NULL, ttlEndRs UNSIGNED INT NOT NULL, rollKskNow UNSIGNED INT NOT NULL, rollZskNow UNSIGNED INT NOT NULL, rollCskNow UNSIGNED INT NOT NULL, inputAdapterType TEXT NOT NULL, inputAdapterU",
31 "ri TEXT NOT NULL, outputAdapterType TEXT NOT NULL, outputAdapterUri TEXT NOT NULL, nextKskRoll UNSIGNED INT NOT NULL, nextZskRoll UNSIGNED INT NOT NULL, nextCskRoll UNSIGNED INT NOT NULL)",
32 0,
33 "CREATE INDEX zonePolicyId ON zone ( policyId )",
34 0,
35 "CREATE UNIQUE INDEX zoneName ON zone ( name )",
36 0,
37 "CREATE TABLE keyData ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rev INTEGER NOT NULL DEFAULT 1, zoneId INTEGER NOT NULL, hsmKeyId INTEGER NOT NULL, algorithm UNSIGNED INT NOT NULL, inception UNSIGNED INT NOT NULL, role INT NOT NULL, introducing UNSIGNED INT NOT NULL, shouldRevoke UNSIGNED INT NOT NULL, standby UNSIGNED INT NOT NULL, activeZsk UNSIGNED INT NOT NULL, publish UNSIGNED INT NOT NULL, activeKsk UNSIGNED INT NOT NULL, dsAtParent INT NOT NULL, keytag UNSIGNED INT NOT",
38 " NULL, minimize UNSIGNED INT NOT NULL)",
39 0,
40 "CREATE INDEX keyDataZoneId ON keyData ( zoneId )",
41 0,
42 "CREATE INDEX keyDataHsmKeyId ON keyData ( hsmKeyId )",
43 0,
44 "CREATE TABLE keyState ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rev INTEGER NOT NULL DEFAULT 1, keyDataId INTEGER NOT NULL, type INT NOT NULL, state INT NOT NULL, lastChange UNSIGNED INT NOT NULL, minimize UNSIGNED INT NOT NULL, ttl UNSIGNED INT NOT NULL)",
45 0,
46 "CREATE INDEX keyStateKeyDataId ON keyState ( keyDataId )",
47 0,
48 "CREATE TABLE keyDependency ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rev INTEGER NOT NULL DEFAULT 1, zoneId INTEGER NOT NULL, fromKeyDataId INTEGER NOT NULL, toKeyDataId INTEGER NOT NULL, type INT NOT NULL)",
49 0,
50 "CREATE INDEX keyDependencyZoneId ON keyDependency ( zoneId )",
51 0,
52 "CREATE INDEX keyDependencyFromKeyDataId ON keyDependency ( fromKeyDataId )",
53 0,
54 "CREATE INDEX keyDependencyToKeyDataId ON keyDependency ( toKeyDataId )",
55 0,
56 "CREATE TABLE hsmKey ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rev INTEGER NOT NULL DEFAULT 1, policyId INTEGER NOT NULL, locator TEXT NOT NULL, state INT NOT NULL, bits UNSIGNED INT NOT NULL, algorithm UNSIGNED INT NOT NULL, role INT NOT NULL, inception UNSIGNED INT NOT NULL, isRevoked UNSIGNED INT NOT NULL, keyType INT NOT NULL, repository TEXT NOT NULL, backup INT NOT NULL)",
57 0,
58 "CREATE INDEX hsmKeyPolicyId ON hsmKey ( policyId )",
59 0,
60 "CREATE UNIQUE INDEX hsmKeyLocator ON hsmKey ( locator )",
61 0,
62 "CREATE TABLE policy ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rev INTEGER NOT NULL DEFAULT 1, name TEXT NOT NULL, description TEXT NOT NULL, signaturesResign UNSIGNED INT NOT NULL, signaturesRefresh UNSIGNED INT NOT NULL, signaturesJitter UNSIGNED INT NOT NULL, signaturesInceptionOffset UNSIGNED INT NOT NULL, signaturesValidityDefault UNSIGNED INT NOT NULL, signaturesValidityDenial UNSIGNED INT NOT NULL, signaturesValidityKeyset UNSIGNED INT, signaturesMaxZoneTtl UNSIGNED INT NOT NULL, denialType INT NOT NULL, deni",
63 "alOptout UNSIGNED INT NOT NULL, denialTtl UNSIGNED INT NOT NULL, denialResalt UNSIGNED INT NOT NULL, denialAlgorithm UNSIGNED INT NOT NULL, denialIterations UNSIGNED INT NOT NULL, denialSaltLength UNSIGNED INT NOT NULL, denialSalt TEXT NOT NULL, denialSaltLastChange UNSIGNED INT NOT NULL, keysTtl UNSIGNED INT NOT NULL, keysRetireSafety UNSIGNED INT NOT NULL, keysPublishSafety UNSIGNED INT NOT NULL, keysShared UNSIGNED INT NOT NULL, keysPurgeAfter UNSIGNED INT NOT NULL, zonePropagati",
64 "onDelay UNSIGNED INT NOT NULL, zoneSoaTtl UNSIGNED INT NOT NULL, zoneSoaMinimum UNSIGNED INT NOT NULL, zoneSoaSerial INT NOT NULL, parentRegistrationDelay UNSIGNED INT NOT NULL, parentPropagationDelay UNSIGNED INT NOT NULL, parentDsTtl UNSIGNED INT NOT NULL, parentSoaTtl UNSIGNED INT NOT NULL, parentSoaMinimum UNSIGNED INT NOT NULL, passthrough UNSIGNED INT NOT NULL)",
65 0,
66 "CREATE UNIQUE INDEX policyName ON policy ( name )",
67 0,
68 "CREATE TABLE policyKey ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rev INTEGER NOT NULL DEFAULT 1, policyId INTEGER NOT NULL, role INT NOT NULL, algorithm UNSIGNED INT NOT NULL, bits UNSIGNED INT NOT NULL, lifetime UNSIGNED INT NOT NULL, repository TEXT NOT NULL, standby UNSIGNED INT NOT NULL, manualRollover UNSIGNED INT NOT NULL, rfc5011 UNSIGNED INT NOT NULL, minimize UNSIGNED INT NOT NULL)",
69 0,
70 "CREATE INDEX policyKeyPolicyId ON policyKey ( policyId )",
71 0,
72 "CREATE TABLE databaseVersion ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rev INTEGER NOT NULL DEFAULT 1, version UNSIGNED INT NOT NULL)",
73 0,
74 0
75};
76
77const char* db_schema_sqlite_drop[] = {
78 "DROP TABLE IF EXISTS zone",
79 0,
80 "DROP TABLE IF EXISTS keyData",
81 0,
82 "DROP TABLE IF EXISTS keyState",
83 0,
84 "DROP TABLE IF EXISTS keyDependency",
85 0,
86 "DROP TABLE IF EXISTS hsmKey",
87 0,
88 "DROP TABLE IF EXISTS policy",
89 0,
90 "DROP TABLE IF EXISTS policyKey",
91 0,
92 "DROP TABLE IF EXISTS databaseVersion",
93 0,
94 0
95};
const char * db_schema_sqlite_drop[]
const char * db_schema_sqlite_create[]