3 files changed, 46 insertions, 14 deletions
diff --git a/README.md b/README.md
index cc94285d..00d0294d 100644
--- a/README.md
+++ b/README.md
@@ -1,18 +1,46 @@
 # Invidious
 
-Alternative frontend for YouTube
+> Invidious is a web application that indexes popular video sites
 
 ## Installation
 
+### Installing [Crystal](https://github.com/crystal-lang/crystal):
+
+On Arch:
+```bash
+$ sudo pacman -Syu shards crystal
+$ crystal deps
+```
+
+On OSX:
+```bash
+$ brew update
+$ brew install shards crystal-lang
+$ crystal deps
+```
+
+### Installing Postgres:
+
+Onn Arch:
+Install according to the [wiki](https://wiki.archlinux.org/index.php/PostgreSQL), then setup database with:
+```bash
+$ ./setup.sh
+```
+On OSX:
+```bash
+$ brew install postgres
+```
+
+## Usage:
+
 ```bash
-pacman -Syu shards crystal
-crystal deps
+$ crystal src/invidious.cr
 ```
 
-## Usage
+Or for development:
 ```bash
-crystal deps
-./sentry
+$ curl -fsSLo- https://raw.githubusercontent.com/samueleaton/sentry/master/install.cr | crystal eval
+$ ./sentry
 ```
 
 ## Contributing
diff --git a/setup.sh b/setup.sh
new file mode 100755
index 00000000..f3ccfa07
--- /dev/null
+++ b/setup.sh
@@ -0,0 +1,6 @@
+#!/bin/bash
+
+dropdb invidious
+createdb invidious
+
+psql invidious < videos.sql
diff --git a/videos.sql b/videos.sql
index 1da62660..797a99be 100644
--- a/videos.sql
+++ b/videos.sql
@@ -1,6 +1,6 @@
 -- Table: public.videos
 
--- DROP TABLE public.videos;
+DROP TABLE videos;
 
 CREATE TABLE public.videos
 (
@@ -8,6 +8,11 @@ CREATE TABLE public.videos
     info text COLLATE pg_catalog."default",
     html text COLLATE pg_catalog."default",
     updated timestamp with time zone,
+    title text COLLATE pg_catalog."default",
+    views bigint,
+    likes integer,
+    dislikes integer,
+    wilson_score double precision,
     CONSTRAINT videos_pkey PRIMARY KEY (id)
 )
 WITH (
@@ -15,17 +20,10 @@ WITH (
 )
 TABLESPACE pg_default;
 
-ALTER TABLE public.videos
-    OWNER to omar;
-
 GRANT ALL ON TABLE public.videos TO kemal;
 
-GRANT ALL ON TABLE public.videos TO omar;
-
 -- Index: id_idx
 
--- DROP INDEX public.id_idx;
-
 CREATE UNIQUE INDEX id_idx
     ON public.videos USING btree
     (id COLLATE pg_catalog."default")