1 files changed, 16 insertions, 0 deletions
diff --git a/src/main/resources/ddl.sql b/src/main/resources/ddl.sql
new file mode 100644
index 0000000..f545efd
--- /dev/null
+++ b/src/main/resources/ddl.sql
@@ -0,0 +1,16 @@
+BEGIN;
+
+DROP TABLE IF EXISTS gitorious_change;
+DROP TABLE IF EXISTS atom_feed;
+
+CREATE TABLE atom_feed (
+  url VARCHAR(1000) PRIMARY KEY,
+  last_update TIMESTAMP NOT NULL
+);
+
+CREATE TABLE gitorious_change (
+  entry_id VARCHAR(1000) PRIMARY KEY,
+  text VARCHAR(1000)
+);
+
+COMMIT;