search

deStrO / eBot-CSGO-Web

The eBot CS:GO panel
http://www.esport-tools.net/ebot
95 stars 71 forks source link

SQL Schema, Out of date #38

Closed gonace closed 8 years ago

gonace commented 10 years ago

The SQL Schema is out of date, missing multiple fields included:

Unknown column 'm.auto_start' in 'where clause'root@ebov3:/etc/eBot-CSGO# Unknown column 'm.startdate' in 'where clause'root@ebov3:/etc/eBot-CSGO# Unknown column 'm.auto_start_time' in 'where clause'root@ebov3:/etc/eBot-CSGO#

dschreck commented 10 years ago

I just ran ALTER TABLE matchs ADD COLUMN auto_start DATETIME; ALTER TABLE matchs ADD COLUMN startdate DATETIME; ALTER TABLE matchs ADD COLUMN auto_start_time DATETIME;

close enough?

dschreck commented 10 years ago

Also, alter table matchs add column is_paused tinyint(2); alter table seasons add column logo varchar(255); alter table seasons add column active bool;