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)",
33 "CREATE INDEX zonePolicyId ON zone ( policyId )",
35 "CREATE UNIQUE INDEX zoneName ON zone ( name )",
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)",
40 "CREATE INDEX keyDataZoneId ON keyData ( zoneId )",
42 "CREATE INDEX keyDataHsmKeyId ON keyData ( hsmKeyId )",
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)",
46 "CREATE INDEX keyStateKeyDataId ON keyState ( keyDataId )",
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)",
50 "CREATE INDEX keyDependencyZoneId ON keyDependency ( zoneId )",
52 "CREATE INDEX keyDependencyFromKeyDataId ON keyDependency ( fromKeyDataId )",
54 "CREATE INDEX keyDependencyToKeyDataId ON keyDependency ( toKeyDataId )",
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)",
58 "CREATE INDEX hsmKeyPolicyId ON hsmKey ( policyId )",
60 "CREATE UNIQUE INDEX hsmKeyLocator ON hsmKey ( locator )",
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)",
66 "CREATE UNIQUE INDEX policyName ON policy ( name )",
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)",
70 "CREATE INDEX policyKeyPolicyId ON policyKey ( policyId )",
72 "CREATE TABLE databaseVersion ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rev INTEGER NOT NULL DEFAULT 1, version UNSIGNED INT NOT NULL)",
78 "DROP TABLE IF EXISTS zone",
80 "DROP TABLE IF EXISTS keyData",
82 "DROP TABLE IF EXISTS keyState",
84 "DROP TABLE IF EXISTS keyDependency",
86 "DROP TABLE IF EXISTS hsmKey",
88 "DROP TABLE IF EXISTS policy",
90 "DROP TABLE IF EXISTS policyKey",
92 "DROP TABLE IF EXISTS databaseVersion",
const char * db_schema_sqlite_create[]
const char * db_schema_sqlite_drop[]