gistfile1.sql

CREATE TABLE IF NOT EXISTS `checkin`
(
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`user_Id` INT UNSIGNED NOT NULL,
`location_id` BIGINT UNSIGNED NOT NULL,
`checkin_description` VARCHAR(255),
`checkin_date` DATETIME NOT NULL,
`checkin_auto` ENUM('0','1') DEFAULT '0',
PRIMARY KEY (`id`)
);