init.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

-- Hypo -- Quickly share stuff
-- Copyright (C) 2013  Tom Willemse

-- Hypo is free software: you can redistribute it and/or modify it
-- under the terms of the GNU Affero General Public License as
-- published by the Free Software Foundation, either version 3 of the
-- License, or (at your option) any later version.

-- Hypo is distributed in the hope that it will be useful, but WITHOUT
-- ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
-- or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU Affero General
-- Public License for more details.

-- You should have received a copy of the GNU Affero General Public
-- License along with Hypo.  If not, see <http://www.gnu.org/licenses/>.

CREATE TABLE hfile (shash CHAR(7) PRIMARY KEY,
                    hash CHAR(40) NOT NULL,
                    filename VARCHAR(255) NOT NULL,
                    type VARCHAR(50) NOT NULL);