-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathCATALOGO.SQL
More file actions
32 lines (26 loc) · 3.09 KB
/
Copy pathCATALOGO.SQL
File metadata and controls
32 lines (26 loc) · 3.09 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
INSERT INTO `middleware`.`USER` (`ACTIVE`, `ALIAS`, `DESCRIPTION`, `IDGROUP`, `NAME`, `NUMTICKS`, `PASSWORD`, `PREFERENCES`) VALUES (1, '1', 'WMQ MANAGER USER', 1, 'VICTOR M ROMERO', 1, '1', 'WMQ MANAGER ROLE');
INSERT INTO `middleware`.`USERGROUP` (`COLOR`, `DESCRIPTION`, `MENU`, `NAME`) VALUES ('RED', 'WMQ MANAGER GROUP', '1', 'WMQ MANAGER');
INSERT INTO `middleware`.`USERGROUP` (`COLOR`, `DESCRIPTION`, `MENU`, `NAME`) VALUES ('BLUE', 'WMQ TECHNICIAN GROUP', '2', 'WMQ TECHNICIAN');
INSERT INTO `middleware`.`MENU` (`DESCRIPTION`, `IDDEPARMENT`, `IMAGE`, `MENU_LEVEL`, `SUBMENU`, `WIDTH`) VALUES ('Administration', 1, '1', 1, 0, 80);
INSERT INTO `middleware`.`MENU` (`DESCRIPTION`, `IDDEPARMENT`, `IMAGE`, `MENU_LEVEL`, `SUBMENU`, `URL`, `WIDTH`) VALUES ('Importar Obras', 1, '1', 2, 1, 'fileImport', 80);
INSERT INTO `middleware`.`MENU` (`DESCRIPTION`, `IDDEPARMENT`, `IMAGE`, `MENU_LEVEL`, `SUBMENU`, `URL`, `WIDTH`) VALUES ('Users', 1, '1', 2, 1, 'User.action', 80);
INSERT INTO `middleware`.`MENU` (`DESCRIPTION`, `IDDEPARMENT`, `IMAGE`, `MENU_LEVEL`, `SUBMENU`, `URL`, `WIDTH`) VALUES ('Logout', 1, '1', 1, 0,'logout', 80);
INSERT INTO `middleware`.`MENU` (`DESCRIPTION`, `IDDEPARMENT`, `IMAGE`, `MENU_LEVEL`, `SUBMENU`, `URL`, `WIDTH`) VALUES ('Logoff', 1, '1', 2, 4, 'logout', 80);
INSERT INTO `middleware`.`MENUGROUPDEPARMENT` (`IDMENU`, `IDGROUP`, `IDDEPARMENT`) VALUES (1, 1, 1);
INSERT INTO `middleware`.`MENUGROUPDEPARMENT` (`IDMENU`, `IDGROUP`, `IDDEPARMENT`) VALUES (2, 1, 1);
INSERT INTO `middleware`.`MENUGROUPDEPARMENT` (`IDMENU`, `IDGROUP`, `IDDEPARMENT`) VALUES (3, 1, 1);
INSERT INTO `middleware`.`MENUGROUPDEPARMENT` (`IDMENU`, `IDGROUP`, `IDDEPARMENT`) VALUES (4, 1, 1);
INSERT INTO `middleware`.`MENUGROUPDEPARMENT` (`IDMENU`, `IDGROUP`, `IDDEPARMENT`) VALUES (5, 1, 1);
INSERT INTO `middleware`.`MENUGROUPDEPARMENT` (`IDMENU`, `IDGROUP`, `IDDEPARMENT`) VALUES (6, 1, 1);
INSERT INTO `middleware`.`MENUGROUPDEPARMENT` (`IDMENU`, `IDDEPARMENT`, `IDGROUP`) VALUES (7, 1, 1);
INSERT INTO `middleware`.`MENUGROUPDEPARMENT` (`IDMENU`, `IDDEPARMENT`, `IDGROUP`) VALUES (8, 1, 1);
INSERT INTO `middleware`.`MENUGROUPDEPARMENT` (`IDMENU`, `IDDEPARMENT`, `IDGROUP`) VALUES (9, 1, 1);
INSERT INTO `middleware`.`MENUGROUPDEPARMENT` (`IDMENU`, `IDDEPARMENT`, `IDGROUP`) VALUES (10, 1, 1);
INSERT INTO `middleware`.`MENUGROUPDEPARMENT` (`IDMENU`, `IDDEPARMENT`, `IDGROUP`) VALUES (11, 1, 1);
INSERT INTO `middleware`.`MENUGROUPDEPARMENT` (`IDMENU`, `IDDEPARMENT`, `IDGROUP`) VALUES (12, 1, 1);
INSERT INTO `middleware`.`MENUGROUPDEPARMENT` (`IDMENU`, `IDDEPARMENT`, `IDGROUP`) VALUES (13, 1, 1);
INSERT INTO `middleware`.`MENUGROUPDEPARMENT` (`IDMENU`, `IDDEPARMENT`, `IDGROUP`) VALUES (14, 1, 1);
INSERT INTO `middleware`.`MENUGROUPDEPARMENT` (`IDMENU`, `IDDEPARMENT`, `IDGROUP`) VALUES (15, 1, 1);
INSERT INTO `middleware`.`MENUGROUPDEPARMENT` (`IDMENU`, `IDDEPARMENT`, `IDGROUP`) VALUES (16, 1, 1);
INSERT INTO `middleware`.`MENUGROUPDEPARMENT` (`IDMENU`, `IDDEPARMENT`, `IDGROUP`) VALUES (17, 1, 1);
INSERT INTO `middleware`.`MENUGROUPDEPARMENT` (`IDMENU`, `IDDEPARMENT`, `IDGROUP`) VALUES (18, 1, 1);