adding sql file for storing and reading chat commands

HardlyDifficult / HardlyBot

A Twitch.tv ChatBot

http://www.twitch.tv/hardlysober/

11 stars 11 forks source link

adding sql file for storing and reading chat commands #30

Closed DarkDevelCoding closed 8 years ago

DarkDevelCoding commented 8 years ago

Can you review this Hardlysober ?

HardlyDifficult commented 8 years ago

Consider storing channel via link to twitch_connections. Maybe store the user that created the command (also last edited?) Change time to DateTime.... if time was meant to be time created. If it's a TimeSpan, consider naming the column something like cooldownTimeInMilliseconds. Discription typo Aliases --- is this a CSV? How does it hold multiple? SqlTable("twitch_Command") -- table names must be lowercase

Setting ID is incorrect.

set
{
Set(3, value);
} Why only have a setter on Mod?

HardlyDifficult commented 8 years ago

Also, when submitting a new Sql table class please include the new schema by adding to DBSchema.txt