From f72cac6e7736ee36a8accaebab9b0c692608a1e8 Mon Sep 17 00:00:00 2001
From: Bert Hubert <bert.hubert@netherlabs.nl>
Date: Sat, 1 Jan 2011 21:25:20 +0000
Subject: [PATCH] some helpful migration sql statements - still quite brief

git-svn-id: svn://svn.powerdns.com/pdns/trunk/pdns@1786 d19b8d6e-7fed-0310-83ef-9ca221ded41b
---
 pdns/dnssec.schema.mysql.sql   | 21 +++++++++++++++++++++
 pdns/dnssec.schema.sqlite3.sql | 15 +++++++++++++++
 2 files changed, 36 insertions(+)
 create mode 100644 pdns/dnssec.schema.mysql.sql
 create mode 100644 pdns/dnssec.schema.sqlite3.sql

diff --git a/pdns/dnssec.schema.mysql.sql b/pdns/dnssec.schema.mysql.sql
new file mode 100644
index 000000000..49d4aed42
--- /dev/null
+++ b/pdns/dnssec.schema.mysql.sql
@@ -0,0 +1,21 @@
+create table domainmetadata (
+ id		 INT auto_increment,
+ domain_id       INT NOT NULL,
+ kind		 VARCHAR(15),
+ content	TEXT,
+ primary key(id)
+);
+
+create table cryptokeys (
+ id		INT auto_increment,
+ domain_id      INT DEFAULT NULL,
+ flags		INT NOT NULL,
+ active		BOOL,
+ content	TEXT,
+ primary key(id)
+);		 
+
+alter table records add ordername      VARCHAR(255);
+alter table records add auth bool;
+create index orderindex on records(ordername);
+
diff --git a/pdns/dnssec.schema.sqlite3.sql b/pdns/dnssec.schema.sqlite3.sql
new file mode 100644
index 000000000..757f2f0b9
--- /dev/null
+++ b/pdns/dnssec.schema.sqlite3.sql
@@ -0,0 +1,15 @@
+create table domainmetadata (
+ id		 INTEGER PRIMARY KEY,
+ domain_id       INT NOT NULL,
+ kind		 VARCHAR(15),
+ content	TEXT
+);
+
+create table cryptokeys (
+ id		INTEGER PRIMARY KEY,
+ domain_id      INT DEFAULT NULL,
+ flags		INT NOT NULL,
+ active		BOOL,
+ content	TEXT
+);		 
+
-- 
2.50.1