Skip to content

Instantly share code, notes, and snippets.

@tmdvs
Created August 3, 2011 14:30
Show Gist options
  • Save tmdvs/1122767 to your computer and use it in GitHub Desktop.
Save tmdvs/1122767 to your computer and use it in GitHub Desktop.
--
-- 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);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment