diff options
Diffstat (limited to 'bin')
| -rw-r--r-- | bin/sql_build.sql | 9 |
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; |