A sample create DB SQL script has been released for Assignment #5. The three tables (Users, Places, Checkins) are also available in the SHARED database.
If you would like to update your existing database, just run the following SQL:
DROP TABLE Checkins; CREATE TABLE IF NOT EXISTS `Checkins` ( `userID` int(11) NOT NULL, `placeID` int(11) NOT NULL, `checkin` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `comment` varchar(200) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
There was an omission in this schema (the checkin timestamp was missing), please check the updated version for the corrected a5.createdb.sql file.
ReplyDeleteIf you would like to update your existing database, just run the following SQL:
ReplyDeleteDROP TABLE Checkins;
CREATE TABLE IF NOT EXISTS `Checkins` (
`userID` int(11) NOT NULL,
`placeID` int(11) NOT NULL,
`checkin` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`comment` varchar(200) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;