|
|
|
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;
|