cu.sql

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`);