diff options
| author | Trygve Laugstøl <trygvis@inamo.no> | 2012-11-08 11:45:08 +0100 |
|---|---|---|
| committer | Trygve Laugstøl <trygvis@inamo.no> | 2012-11-08 11:45:08 +0100 |
| commit | ff34cdc13bc8ba0943cded8009b9869a455894f6 (patch) | |
| tree | 52ecf63d0a223e11961c11c26aec5d747546daf3 /src/main/resources/ddl.sql | |
| parent | bddca73748f7eace28cdd76282fcfd33971e9995 (diff) | |
| download | esper-testing-ff34cdc13bc8ba0943cded8009b9869a455894f6.tar.gz esper-testing-ff34cdc13bc8ba0943cded8009b9869a455894f6.tar.bz2 esper-testing-ff34cdc13bc8ba0943cded8009b9869a455894f6.tar.xz esper-testing-ff34cdc13bc8ba0943cded8009b9869a455894f6.zip | |
o Basic gitorious atom importer.
Diffstat (limited to 'src/main/resources/ddl.sql')
| -rw-r--r-- | src/main/resources/ddl.sql | 16 |
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; |