 -- --------------------------------------------------------
 
 --
+-- Table structure for table `picture`
+--
+
+CREATE TABLE IF NOT EXISTS `picture` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `restaurant_id` int(11) NOT NULL,
+  `picture` blob NOT NULL,
+  `date_added` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `restaurant`
+--
+
+CREATE TABLE IF NOT EXISTS `restaurant` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `name` varchar(45) NOT NULL,
+  `type` varchar(32) NOT NULL,
+  `hrs_operation` time DEFAULT NULL,
+  `tel` varchar(32) NOT NULL,
+  `price_range` tinyint(4) DEFAULT NULL,
+  `take_reservation` tinyint(4) DEFAULT NULL,
+  `delivery` tinyint(4) DEFAULT NULL,
+  `take_out` tinyint(4) DEFAULT NULL,
+  `parking` tinyint(4) DEFAULT NULL,
+  `wifi` tinyint(4) DEFAULT NULL,
+  `tv` tinyint(4) DEFAULT NULL,
+  `alcohol` tinyint(4) DEFAULT NULL,
+  `description` tinyint(4) DEFAULT NULL,
+  `url` varchar(255) DEFAULT NULL,
+  `menu_url` varchar(255) DEFAULT NULL,
+  `sub_district` varchar(45) DEFAULT NULL,
+  `district` varchar(45) DEFAULT NULL,
+  `province` varchar(45) DEFAULT NULL,
+  `zip_code` varchar(8) DEFAULT NULL,
+  `country` varchar(32) DEFAULT NULL,
+  `date_added` datetime DEFAULT CURRENT_TIMESTAMP,
+  `date_last_modified` datetime DEFAULT CURRENT_TIMESTAMP,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `review`
+--
+
+CREATE TABLE IF NOT EXISTS `review` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `restaurant_id` int(11) NOT NULL,
+  `title` varchar(55) NOT NULL,
+  `content` text NOT NULL,
+  `rating` int(11) NOT NULL,
+  `date_added` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+-- --------------------------------------------------------
+
+--
 -- Table structure for table `temp_user`
 --
 

--
-- Database: `test`
--

-- --------------------------------------------------------


  `activation_key` varchar(255) NOT NULL,
  `active` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;

--
-- Dumping data for table `temp_user`
