Skip to content

Instantly share code, notes, and snippets.

@walkline
Created September 14, 2015 13:34
Show Gist options
  • Save walkline/52338d40c9299087f1b9 to your computer and use it in GitHub Desktop.
Save walkline/52338d40c9299087f1b9 to your computer and use it in GitHub Desktop.
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment