You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
24 lines
999 B
24 lines
999 B
CREATE TABLE zerobin ( |
|
id INTEGER AUTO_INCREMENT, |
|
created INT(11) UNSIGNED NOT NULL DEFAULT 0, |
|
expire INT(11) UNSIGNED NOT NULL DEFAULT 0, |
|
syntax VARCHAR(255) DEFAULT 'plaintext', |
|
PRIMARY KEY (id), |
|
UNIQUE KEY zerobin_uniq (created) |
|
) ENGINE=InnoDB; |
|
|
|
CREATE TABLE filebin ( |
|
id INTEGER AUTO_INCREMENT, |
|
created INT(11) UNSIGNED NOT NULL DEFAULT 0, |
|
expire INT(11) UNSIGNED NOT NULL DEFAULT 0, |
|
hidden TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
|
ftype CHAR(1) NOT NULL DEFAULT 'b', -- 'b' for generic binary, 't' for text, 'i' for image, 'v' for video, 'a' for audio |
|
fname VARCHAR(255) NOT NULL DEFAULT '', -- original filename |
|
fext VARCHAR(16) NOT NULL DEFAULT '', -- separate file extension |
|
fmime VARCHAR(32) NOT NULL DEFAULT '', |
|
fsize INT(11) UNSIGNED NOT NULL DEFAULT 0, |
|
res_w INT(11) UNSIGNED NOT NULL DEFAULT 0, |
|
res_h INT(11) UNSIGNED NOT NULL DEFAULT 0, |
|
PRIMARY KEY (id), |
|
UNIQUE KEY filebin_uniq (created) |
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|