Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `users` (
- `id` int NOT NULL AUTO_INCREMENT,
- `name` varchar(60) NOT NULL,
- `surname` varchar(60) NOT NULL,
- `email` varchar(60) NOT NULL,
- `phone` varchar(20) NOT NULL,
- PRIMARY KEY (`id`)
- );
- CREATE TABLE IF NOT EXISTS `clients` (
- `id` int NOT NULL,
- `name` varchar(60) NOT NULL,
- `surname` varchar(60) NOT NULL,
- `email` varchar(60) NOT NULL,
- `phone` varchar(20) NOT NULL,
- `age` int NOT NULL,
- `security_number` varchar(0) NOT NULL,
- `birthdate` date NOT NULL
- );
- ALTER TABLE `clients` ADD CONSTRAINT `id` FOREIGN KEY () REFERENCES `users` (`id`);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement