NPnr9tFe

1USE almidondemo;
2
3DROP TABLE IF EXISTS almform;
4CREATE TABLE almform (
5	idalmform integer PRIMARY KEY NOT NULL AUTO_INCREMENT,
6	almform varchar(100)
7);
8
9DROP TABLE IF EXISTS almrole;
10CREATE TABLE almrole (
11	idalmrole integer PRIMARY KEY NOT NULL AUTO_INCREMENT,
12	almrole varchar(100)
13);
14
15DROP TABLE IF EXISTS almuser;
16CREATE TABLE almuser (
17	idalmuser integer PRIMARY KEY NOT NULL AUTO_INCREMENT,
18	idalmrole integer,
19	almuser varchar(100),
20	password varchar(200) NOT NULL,
21	name varchar (200) NOT NULL,
22	email varchar(200),
23	FOREIGN KEY (idalmrole) REFERENCES almrole(idalmrole)
24);
25
26DROP TABLE IF EXISTS almaccess;
27CREATE TABLE almaccess (
28	idalmaccess integer PRIMARY KEY NOT NULL AUTO_INCREMENT,
29	idalmrole integer,
30	idalmuser integer,
31	idalmform integer,
32	FOREIGN KEY (idalmrole) REFERENCES almrole(idalmrole),
33	FOREIGN KEY (idalmuser) REFERENCES almuser(idalmuser),
34	FOREIGN KEY (idalmform) REFERENCES almform(idalmform)
35);
36
37INSERT INTO almrole VALUES (1, 'Control Total'),
38(2, 'Edicion'),
39(3, 'Correccion'),
40(4, 'Lectura'),
41(5, 'Sin Accesso');
42
43INSERT INTO almuser VALUES (1, 1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Admin', 'admin@example.com'),
44(2, 4, 'demo', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Demo', 'demo@example.com'),
45(3, NULL, 'alice', 'fe01ce2a7fbac8fafaed7c982a04e229', 'alice', 'alice@example.com');
46
47INSERT INTO almform VALUES (1, 'almaccess'),
48(2, 'almform'),
49(3, 'almrole'),
50(4, 'almuser'),
51(5, 'pagina'),
52(6, 'agenda'),
53(7, 'doc'),
54(8, 'enlace'),
55(9, 'foto'),
56(10, 'galeria'),
57(11, 'noticias');
58
59INSERT INTO almaccess VALUES (1, 3, 5, 1);