q6uMJnbV

1DROP TABLE IF EXISTS `note`;
2DROP TABLE IF EXISTS `user`;
3
4CREATE TABLE user (
5	id_user int(11) NOT NULL AUTO_INCREMENT, 
6    name_user varchar(25),
7    passwd_user  varchar(25),
8    PRIMARY KEY (id_user)
9);
10
11CREATE TABLE note (
12    id_note int(11) NOT NULL AUTO_INCREMENT,
13    valeur_note  varchar(45) NOT NULL,
14    id_user int(11),
15    PRIMARY KEY (id_note),
16    FOREIGN KEY (id_user) REFERENCES user(id_user) ON DELETE CASCADE ON UPDATE CASCADE
17);
18
19INSERT INTO user(name_user, passwd_user) VALUES("Jean-Charles", "ilove106")