X-Git-Url: http://git.pippins.net/embedvideo/.git/?a=blobdiff_plain;f=schema.sql;fp=schema.sql;h=0000000000000000000000000000000000000000;hb=8523268ec9bc7366a8557540f2489fdc326ac434;hp=5022b71e9e1b07cb35c36f1ca0d297e9b69cb748;hpb=43c6310a463aee1c2cbd882b81a596e429bc7f6c;p=backups%2F.git diff --git a/schema.sql b/schema.sql deleted file mode 100644 index 5022b71..0000000 --- a/schema.sql +++ /dev/null @@ -1,12 +0,0 @@ -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 );