--
-- Table structure for table `users_flat`
--
DROP TABLE IF EXISTS `users_flat`;
CREATE TABLE `users_flat` (
  `user_id` int(11) UNSIGNED NOT NULL,
  `timestamp` timestamp NULL DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `profession` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `occasion` text CHARACTER SET utf8 DEFAULT NULL,
  `style` text CHARACTER SET utf8 DEFAULT NULL,
  `budget` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `users_flat`
--
ALTER TABLE `users_flat`
  ADD PRIMARY KEY (`user_id`);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `users_flat`
--
ALTER TABLE `users_flat`
  ADD CONSTRAINT `users_flat_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Table structure for table `users_change_log`
--

DROP TABLE IF EXISTS `users_change_log`;
CREATE TABLE `users_change_log` (
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `users_change_log`
--
ALTER TABLE `users_change_log`
  ADD PRIMARY KEY (`user_id`);

