Database Table structure

Table users

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
uname	varchar(45)	YES		NULL
pwhash	varchar(255)	YES		NULL
email	varchar(255)	NO		NULL
lastlogin	varchar(10)	YES		NULL

SQL-Syntax for creation:

CREATE TABLE users (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
uname VARCHAR(45) null,
pwhash VARCHAR(255) null,
email VARCHAR(255) not null,
lastlogin VARCHAR(10) null
);

Table snippets

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
author_id	int(11)	NO		NULL
title	varchar(150)	NO		NULL
description	varchar(250)	YES		NULL
language	varchar(10)	NO		NULL
tags	varchar(250)	YES		NULL

CREATE TABLE snippets (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(150) not null,
description VARCHAR(250) null,
language VARCHAR(20) not null,
tags VARCHAR(250) null
);

Table reviews

Field	Type	Null	Key	Default	Extra
id	INT	NO	PRI	NULL	auto_increment
snippet_id	INT	NO		NULL
rating_security	FLOAT	YES		NULL
rating_cleanliness	FLOAT	YES		NULL
rating_total	FLOAT	NO		NULL
security_comment	TEXT	YES		NULL
cleanliness_comment	TEXT	YES		NULL
total_comment	TEXT	NO		NULL
author_id	INT	NO		NULL

CREATE TABLE reviews (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
snippet_id INT NOT NULL,
rating_security FLOAT null,
rating_cleanliness FLOAT null,
rating_total FLOAT null,
security_comment TEXT null,
cleanliness_comment TEXT null,
total_comment TEXT NOT NULL,
author_id INT NOT NULL
);