Kcchouette

# Plowshare uptobox.com module
# Copyright (c) 2012-2017 Plowshare team
#
# This file is part of Plowshare.
#
# Plowshare is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#

Kcchouette

# http://across.eliteheberg.fr/upload/original/1399487731.png


# use picture ;  

CREATE TABLE User (user_ID int AUTO_INCREMENT(10) NOT NULL, username VARCHAR(20), password VARCHAR(30), PRIMARY KEY (user_ID) );  
 
CREATE TABLE Picture (picture_ID int AUTO_INCREMENT(10) NOT NULL, description TEXT, public BOOL, name VARCHAR(60), hash CHAR(128), PRIMARY KEY (picture_ID) ) ENGINE=InnoDB;  

CREATE TABLE Tag (tag_ID int AUTO_INCREMENT NOT NULL, tags VARCHAR(100), hits INT(10), PRIMARY KEY (tag_ID) );