· 7 years ago · Feb 01, 2019, 06:36 PM
1CREATE TABLE IF NOT EXISTS `mod_evento` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `client_id` int(11) NOT NULL,
4 `titulo` varchar(255) NOT NULL,
5 `user_id_created` int(11) NOT NULL,
6 `user_id_updated` int(11) NOT NULL,
7 `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
8 `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
9 `deleted` tinyint(1) NOT NULL DEFAULT '0',
10 PRIMARY KEY (`id`),
11 KEY `client_id` (`client_id`),
12 KEY `user_id_created` (`user_id_created`),
13 KEY `user_id_updated` (`user_id_updated`),
14 CONSTRAINT `mod_evento_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
15 CONSTRAINT `mod_evento_ibfk_2` FOREIGN KEY (`user_id_created`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
16 CONSTRAINT `mod_evento_ibfk_3` FOREIGN KEY (`user_id_updated`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
17) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;