summaryrefslogtreecommitdiff
path: root/bin/sql_build.sql
diff options
context:
space:
mode:
Diffstat (limited to 'bin/sql_build.sql')
-rw-r--r--bin/sql_build.sql9
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;