[thirdparty/pdns.git] / pdns / bind-dnssec.4.2.0_to_4.3.0_schema.sqlite3.sql

BEGIN TRANSACTION;
  CREATE TABLE cryptokeys_temp (
    id                  INTEGER PRIMARY KEY,
    domain              VARCHAR(255) COLLATE NOCASE,
    flags               INT NOT NULL,
    active              BOOL,
    published           BOOL DEFAULT 1,
    content             TEXT
  );

  INSERT INTO cryptokeys_temp SELECT id,domain,flags,active,1,content FROM cryptokeys;
  DROP TABLE cryptokeys;
  ALTER TABLE cryptokeys_temp RENAME TO cryptokeys;

  CREATE INDEX domainnameindex ON cryptokeys(domain);
COMMIT;
Commit	Line	Data
2af952b4 KM	1	BEGIN TRANSACTION;
	2	CREATE TABLE cryptokeys_temp (
	3	id INTEGER PRIMARY KEY,
	4	domain VARCHAR(255) COLLATE NOCASE,
	5	flags INT NOT NULL,
	6	active BOOL,
	7	published BOOL DEFAULT 1,
	8	content TEXT
	9	);
	10
	11	INSERT INTO cryptokeys_temp SELECT id,domain,flags,active,1,content FROM cryptokeys;
	12	DROP TABLE cryptokeys;
	13	ALTER TABLE cryptokeys_temp RENAME TO cryptokeys;
	14
	15	CREATE INDEX domainnameindex ON cryptokeys(domain);
	16	COMMIT;