Wednesday, November 3, 2010

Database: Setup Reminders Table

Create reminders table
CREATE TABLE IF NOT EXISTS `reminders` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `drug_id` int(11) NOT NULL,
  `days_of_week` varchar(7) NOT NULL,
  `time` time NOT NULL,
  `created` datetime NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

No comments:

Post a Comment