hS0cnesB

1CREATE DATABASE `aplicativo` /*!40100 DEFAULT CHARACTER SET utf8 */;
2
3DROP TABLE IF EXISTS `role`;
4CREATE TABLE  `role` (
5  `role_id` int(11) NOT NULL auto_increment,
6  `role` varchar(255) default NULL,
7  PRIMARY KEY  (`role_id`)
8) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
9
10DROP TABLE IF EXISTS `user`;
11CREATE TABLE  `user` (
12  `id` int(11) NOT NULL auto_increment,
13  `firstname` varchar(255) NOT NULL,
14  `lastname` varchar(255) NOT NULL,
15  `email` varchar(255) NOT NULL,
16  `password` varchar(255) NOT NULL,
17  `active` int(11) default NULL,
18  PRIMARY KEY  (`id`)
19) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
20
21DROP TABLE IF EXISTS `user_role`;
22CREATE TABLE  `user_role` (
23  `user_id` int(11) NOT NULL,
24  `role_id` int(11) NOT NULL,
25  PRIMARY KEY  (`user_id`,`role_id`),
26  KEY `user_role_key` (`role_id`),
27  CONSTRAINT `user_userrole` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
28  CONSTRAINT `role_userrole` FOREIGN KEY (`role_id`) REFERENCES `role` (`role_id`)
29) ENGINE=InnoDB DEFAULT CHARSET=utf8;
30
31DROP TABLE IF EXISTS `persistent_logins`;
32CREATE TABLE  `persistent_logins` (
33  `username` varchar(64) NOT NULL,
34  `series` varchar(64) NOT NULL,
35  `token` varchar(64) NOT NULL,
36  `last_used` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
37  PRIMARY KEY  (`series`)
38) ENGINE=InnoDB DEFAULT CHARSET=utf8;
39
40INSERT INTO `role` VALUES (1,'ADMIN');