Last active
December 31, 2015 14:29
-
-
Save NuckChorris/8000250 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE files | |
( | |
id integer unsigned not null auto_increment, | |
hash_sha1 binary(160), | |
filename varchar(255), | |
size integer unsigned, | |
mime varchar(255), | |
unique index index_files_by_id (id), | |
index index_files_by_sha1 (hash_sha1), | |
primary key (id) | |
); | |
CREATE TABLE links | |
( | |
id integer unsigned not null auto_increment, | |
url varchar(31) not null, | |
deleted bit default 0, | |
deletion_key varchar(63), | |
deletion_time timestamp, | |
upload_time timestamp, | |
file_id integer unsigned, | |
owner_id integer unsigned, | |
original_filename varchar(255), | |
unique index index_links_by_id (id), | |
unique index index_links_by_url (url), | |
unique index index_links_by_deletion_key (deletion_key), | |
primary key(id) | |
); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE files ( | |
id INTEGER PRIMARY KEY AUTO_INCREMENT, | |
hash CHAR(40), # sha1($file) | |
orginalname VARCHAR(255), # YES TYPO I KNOW | |
filename VARCHAR(30), | |
size INTEGER, | |
date DATE, | |
expire DATE, | |
delid CHAR(40) # sha1($tempfilename) | |
); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment