search

claytical / Queso-Multisite

Gameful Classroom Management System
Other
9 stars 3 forks source link

Add Expiration Dates to Quests #83

Closed claytical closed 9 years ago

claytical commented 9 years ago

new fields in quests table:

allow_revisions (bool) expiration_date (datetime) youtube_id (varchar) online_redemption (bool)

quest controller updates: index available available_online available_in_class

user controller updates: profile

claytical commented 9 years ago

SQL: ALTER TABLE quests ADD allow_revisions BOOL NOT NULL DEFAULT '1' AFTER allow_text , ADD allow_instant BOOL NOT NULL DEFAULT '0' AFTER allow_revisions , ADD youtube_id VARCHAR( 255 ) NULL AFTER allow_instant , ADD expires DATE NULL AFTER youtube_id