From c1e6c0c182102e5d61a8ac26b403b42c5fd40591 Mon Sep 17 00:00:00 2001 From: pepper 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') 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