Small updates - Githubissues

t2t2 / draft

MOVIES MOVIES MOVIES!

http://boxofficedraft.com/

MIT License

18 stars 8 forks source link

Small updates #9

Closed TheAntonioReyes closed 11 years ago

TheAntonioReyes commented 11 years ago

Updated some of the migration code as the tables where created without some defaults/nullables which was causing issues in MySQL 5.5 when seeding the tables. Also added in the 'Indicator of current date' closing #3

t2t2 commented 11 years ago

Weird about the lack of defaults & nullables causing bugs, I didn't have any problems.. Local server: 5.5.27 Live server: 5.5.30-MariaDB-mariadb1~quantal-log

TheAntonioReyes commented 11 years ago

Ah, MariaDB I think allows more flexibility. MySQL forces you to explicitly set a column as nullable or provide a default value, so for instance when it was seeding the user table no one has emails. I haven't played with MariaDB, maybe I should...

t2t2 commented 11 years ago

Yeah but that's the live server, local server is normal mysql...

I do know one weird thing about mysql is case sensitivity being on in linux but not in windows, might also be something like that.