Create Schedule Table in Database

[russleyshaw]

File: /db/init.sql

The scheduling functionality will basically work by having each played game reference a schedule column in the database.

Prefer to set NOT NULL with sensible default, over nullable with no default, over NOT NULL with no default Booleans should typically be not null with default

• [ ] id
• [ ] type (random, single elimination, triple elimination, swiss) NOT NULL
• [ ] include_eligible Boolean, scheduler should include eligible teams default TRUE
• [ ] include_dev Boolean, scheduler should include developer ais
• [ ] include_alum Boolean, scheduler should include alumni ais
• [ ] include_sponsor Boolean, scheduler should include sponsors
• [ ] inculde_all Boolean, scheduler should include all teams
• [ ] data - json/blob - contains data about the schedule progress specific to the schedule controller
• [ ] result - json/blob - contains the result of the completed schedule (bracket file, etc)
• [ ] created time
• [ ] modified time

child of #1

[russleyshaw]

Minor things I noticed

make data and result NULLable make include_all DEFAULT to false (include_all would override other settings) Make type not have a default. The type is pretty important and would have adverse effects if initiaalized to something by default by accident

[russleyshaw]

Fixed in #11