Files
Cockatrice/servatrice/migrations/servatrice_0018_to_0019.sql
woogerboy21 c9a8dafd01 Update sessions table columns for consistency (#2299)
* Update sessions table columns for consistency

Fix #2276
This update changes two columns in the sessions table to match the
column declartations in the users table.

* Update servatrice.sql

Update servatrice.sql to reflect new db schema version
2016-12-08 10:43:11 +01:00

7 lines
287 B
SQL

-- Servatrice db migration from version 18 to version 19
alter table cockatrice_sessions modify column `user_name` varchar(35) NOT NULL;
alter table cockatrice_sessions modify column `ip_address` varchar(255) NOT NULL;
UPDATE cockatrice_schema_version SET version=19 WHERE version=18;