X-Git-Url: http://git.pippins.net/embedvideo/.git/static/git-logo.png?a=blobdiff_plain;f=schema.sql;h=5022b71e9e1b07cb35c36f1ca0d297e9b69cb748;hb=4d43b38a139fcc3ef784f7fe3cab00019f679b54;hp=d1515d9763f1c2819b76201cc4b2546911b6ec6c;hpb=3694170c2e81e735ea3376108e2ef40d203c4e0f;p=backups%2F.git

diff --git a/schema.sql b/schema.sql
index d1515d9..5022b71 100644
--- a/schema.sql
+++ b/schema.sql
@@ -1,9 +1,12 @@
-CREATE TABLE file (
-  CHAR type,
-  VARCHAR permissions,
-  VARCHAR user,
-  VARCHAR group,
-  INTEGER size,
-  INTEGER modified_date,
-  VARCHAR name
-)
+CREATE TABLE filedata (
+  filetype         CHAR,
+  permissions      VARCHAR,
+  username         VARCHAR,
+  groupname        VARCHAR,
+  filesize         INTEGER,
+  modified_date    INTEGER, -- e.g. 20051016194000 for Oct 10, 2005 at 7:40pm
+  filename         VARCHAR,
+  last_backup_date INTEGER  -- same format as modified_date
+);
+
+CREATE UNIQUE INDEX filename ON filedata( filename );