projects
/
backups
/
.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Clean up the usage message.
[backups/.git]
/
schema.sql
diff --git
a/schema.sql
b/schema.sql
index 42bf81168517fc3ede726c710e89c5e6abeae836..5022b71e9e1b07cb35c36f1ca0d297e9b69cb748 100644
(file)
--- a/
schema.sql
+++ b/
schema.sql
@@
-6,5
+6,7
@@
CREATE TABLE filedata (
filesize INTEGER,
modified_date INTEGER, -- e.g. 20051016194000 for Oct 10, 2005 at 7:40pm
filename VARCHAR,
filesize INTEGER,
modified_date INTEGER, -- e.g. 20051016194000 for Oct 10, 2005 at 7:40pm
filename VARCHAR,
- last_backup_date INTEGER
+ last_backup_date INTEGER
-- same format as modified_date
);
);
+
+CREATE UNIQUE INDEX filename ON filedata( filename );