migration sql to create archive database

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@179 8392b6e1-25fa-0310-8288-cc32f8e212ea

diff --git a/sql/02d_archive.sql b/sql/02d_archive.sql
new file mode 100644 (file)
index 0000000..50656e9
--- /dev/null
+++ b/sql/02d_archive.sql
@@ -0,0 +1,9 @@
+create table archive (
+       id              serial,
+       dvd_nr          int not null,
+       total_size      bigint default -1,
+       note            text,
+       username        varchar(20) not null,
+       date            timestamp default now(),
+       primary key(id)
+);