diff options
| author | Eliot Whalan <ewhal@pantsu.cat> | 2016-06-24 12:08:15 +0200 |
|---|---|---|
| committer | Eliot Whalan <ewhal@pantsu.cat> | 2016-06-24 12:08:15 +0200 |
| commit | c28e5cb54469d514c08b7a44e6abceb4045e7041 (patch) | |
| tree | d4bb88a341d8d3e77504afcd3ef10b3c22b9ac90 /sqlite_schema.sql | |
| parent | fe69cdbb29939f99817643f94eb7396c8cfe5285 (diff) | |
| parent | 424eea4f630d25158ec033a004666ecd0107f8b8 (diff) | |
Merge branch 'master' of github.com:pomf/pomf
Diffstat (limited to 'sqlite_schema.sql')
| -rw-r--r-- | sqlite_schema.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sqlite_schema.sql b/sqlite_schema.sql new file mode 100644 index 0000000..414719c --- /dev/null +++ b/sqlite_schema.sql @@ -0,0 +1,16 @@ +PRAGMA synchronous = OFF; +PRAGMA journal_mode = MEMORY; +BEGIN TRANSACTION; +CREATE TABLE `files` ( + `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT +, `hash` char(40) default NULL +, `originalname` varchar(255) default NULL +, `filename` varchar(30) default NULL +, `size` integer default NULL +, `date` date default NULL +, `expire` date default NULL +, `delid` char(40) default NULL +, `user` integer default '0' +, `dir` integer default '0' +); +END TRANSACTION; |