sGftik47

1SET NAMES utf8;
2SET time_zone = '+00:00';
3SET foreign_key_checks = 0;
4SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
5
6DROP TABLE IF EXISTS `Notice`;
7CREATE TABLE `Notice` (
8  `id` int(11) NOT NULL AUTO_INCREMENT,
9  `id_user` varchar(255) NOT NULL,
10  `comment` varchar(255) NOT NULL,
11  `note` int(3) NOT NULL,
12  PRIMARY KEY (`id`)
13) ENGINE=InnoDB DEFAULT CHARSET=latin1;
14
15
16DROP TABLE IF EXISTS `User`;
17CREATE TABLE `User` (
18  `id` int(11) NOT NULL AUTO_INCREMENT,
19  `firstName` varchar(255) NOT NULL,
20  `lastName` varchar(255) NOT NULL,
21  `email` varchar(255) NOT NULL,
22  `password` varchar(255) NOT NULL,
23  PRIMARY KEY (`id`)
24) ENGINE=InnoDB DEFAULT CHARSET=latin1;