foodapp_db.sql

CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name_cat` varchar(255) NOT NULL,
  `image_cat` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Contenu de la table `categories`
--

INSERT INTO `categories` (`id`, `name_cat`, `image_cat`) VALUES
(1, 'Pizza', 'http://img15.hostingpics.net/pics/698338pizza.png'),
(2, 'Hamburger ', 'http://img15.hostingpics.net/pics/516336hambruger.png'),
(3, 'Coffee', 'http://img15.hostingpics.net/pics/674530coffee.png'),
(4, 'Cake', 'http://img15.hostingpics.net/pics/134340donuts.png'),
(5, 'Food', 'http://img15.hostingpics.net/pics/559109food.png'),
(6, 'Jus', 'http://img15.hostingpics.net/pics/610978appledrink.png');

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

--
-- Structure de la table `products`
--

CREATE TABLE IF NOT EXISTS `products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name_prod` varchar(255) NOT NULL,
  `desc_prod` varchar(255) DEFAULT NULL,
  `price_prod` varchar(255) NOT NULL,
  `image_prod` varchar(255) NOT NULL,
  `id_cat` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_cat` (`id_cat`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Contenu de la table `products`
--

INSERT INTO `products` (`id`, `name_prod`, `desc_prod`, `price_prod`, `image_prod`, `id_cat`) VALUES
(1, 'pizza neptune', 'pizza neptune', '2500', 'http://img15.hostingpics.net/pics/698338pizza.png', 1);