tables.sql

tables.sql

DROP TABLE IF EXISTS `wp_masterslunch_dishes`;

CREATE TABLE `wp_masterslunch_dishes` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text,
  `category` varchar(255) NOT NULL,
  `user_id` mediumint(9) NOT NULL,
  `price` int(11) NOT NULL,
  `weight` int(11) DEFAULT NULL,
  `caloric` int(11) DEFAULT NULL,
  `img_name` varchar(20) DEFAULT NULL,
  `time_created` datetime DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



DROP TABLE IF EXISTS `wp_masterslunch_menus`;

CREATE TABLE `wp_masterslunch_menus` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(9) NOT NULL,
  `dish_id` mediumint(9) NOT NULL,
  `office_name` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `date` datetime NOT NULL,
  `price` int(11) NOT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;