gistfile1.txt

--
-- Constraints for table `roles_users`
--
ALTER TABLE `roles_users`
  ADD CONSTRAINT `roles_users_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `roles_users_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `user_tokens`
--
ALTER TABLE `user_tokens`
  ADD CONSTRAINT `user_tokens_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;


--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES(1, 'login', 'login role');
INSERT INTO `roles` VALUES(2, 'admin', 'admin role');

--
-- Dumping data for table `vat`
--

INSERT INTO `vat` VALUES(1, 'Zero Rate', 0, NULL);
INSERT INTO `vat` VALUES(2, 'Low Band', 5, NULL);
INSERT INTO `vat` VALUES(3, 'Normal Rate', 20, NULL);