 CREATE TABLE IF NOT EXISTS `orders` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `product_id` int(11) NOT NULL,
-  `user_id` int(11) NOT NULL,
+  `user_id` int(11) DEFAULT NULL,
   `colors` text NOT NULL COMMENT 'Set of colors',
   `email` varchar(255) NOT NULL,
   `fullname` varchar(255) NOT NULL,

  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `email`, `password`, `fullname`, `address_1`, `address_2`, `postal_code`, `city`, `country_id`, `state`, `phone`, `is_actived`, `type`, `created_at`, `updated_at`) VALUES
(1, 'namthanh174@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', 'Thanh Vo', 'Cu Chi', NULL, '12345', 'HCM', 1, 'Cu Chi', '123456789', 1, 1, '2016-08-06 00:00:00', '2016-08-06 00:00:00');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 11, 2016 at 02:17 AM
-- Server version: 5.5.50-0ubuntu0.14.04.1
-- PHP Version: 5.6.23-1+deprecated+dontuse+deb.sury.org~trusty+1

