From ff34cdc13bc8ba0943cded8009b9869a455894f6 Mon Sep 17 00:00:00 2001 From: Trygve Laugstøl Date: Thu, 8 Nov 2012 11:45:08 +0100 Subject: o Basic gitorious atom importer. --- src/main/resources/ddl.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 src/main/resources/ddl.sql (limited to 'src/main/resources') 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; -- cgit v1.2.3