From c1e6c0c182102e5d61a8ac26b403b42c5fd40591 Mon Sep 17 00:00:00 2001
From: pepper <peppersclothescult@gmail.com>
Date: Wed, 29 Jan 2014 10:24:15 -0800
Subject: fixed upload, view bug, added sql statements

---
 bin/sql_build.sql | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'bin/sql_build.sql')

diff --git a/bin/sql_build.sql b/bin/sql_build.sql
index cab13c0..8badd66 100644
--- a/bin/sql_build.sql
+++ b/bin/sql_build.sql
@@ -6,3 +6,12 @@ create table IF NOT EXISTS shaders (id int(11) AUTO_INCREMENT NOT NULL, PRIMARY
 
 create table IF NOT EXISTS shader_ids (id int(11) AUTO_INCREMENT NOT NULL, PRIMARY KEY(id), username varchar(40));
 alter table shaders modify username varchar(30);
+
+IF EXISTS (
+  SELECT * 
+  FROM   sys.columns 
+  WHERE name = 'shaders'
+)
+begin
+  alter table shaders add name varchar(40);
+end;
-- 
cgit v1.2.3-70-g09d2

