search

claytical / Queso-Multisite

Gameful Classroom Management System
Other
9 stars 3 forks source link

Instant Quests #89

Closed claytical closed 9 years ago

claytical commented 9 years ago

instant_credits system, generate codes for redemption.

claytical commented 9 years ago

CREATE TABLE queso.quest_codes ( id INT NOT NULL AUTO_INCREMENT , quest_id INT NOT NULL , code VARCHAR( 255 ) NOT NULL , PRIMARY KEY ( id ) ) ENGINE = MYISAM ;

claytical commented 9 years ago

New Redemption Model

CREATE TABLE IF NOT EXISTS redemptions ( id int(11) NOT NULL AUTO_INCREMENT, quest_id int(11) NOT NULL, code varchar(255) NOT NULL, updated_at datetime NOT NULL, created_at datetime NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;