fixed upload, view bug, added sql statementspepper

1 files changed, 9 insertions, 0 deletions

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;