ZfEw5GKd

1public void createTables(){
2        try {
3            Statement st = ds.getConnection().createStatement();
4            String sql = "CREATE TABLE IF NOT EXISTS clans (Name varbinary(16), Leader varbinary(16));";
5            st.execute(sql);
6            st.execute("IF EXISTS " +
7                    "(SELECT * FROM Information_Schema.Columns WHERE Table_Name = '<clans>' AND Column_Name = '<test>')" +
8                    "exec ('ALTER TABLE clans ADD (test varbinary(16)')");
9        } catch (SQLException e) {
10            e.printStackTrace();
11        }
12    }