X-Git-Url: https://git.llucax.com/mecon/samurai.git/blobdiff_plain/d7bfcaefea9dad24808570a7369bfbb93e581eb0..5dcf8b5c022fcab918882187fbfeeecca836e642:/script/SAMURAI_SQL_Datos_Prueba.txt?ds=inline diff --git a/script/SAMURAI_SQL_Datos_Prueba.txt b/script/SAMURAI_SQL_Datos_Prueba.txt index f8f9e9e..e26a847 100644 --- a/script/SAMURAI_SQL_Datos_Prueba.txt +++ b/script/SAMURAI_SQL_Datos_Prueba.txt @@ -1,40 +1,73 @@ -INSERT INTO perfil VALUES (1,'ABM Usuarios','E',NOW()); -INSERT INTO perfil VALUES (2,'ABM Permisos','E',NOW()); -INSERT INTO perfil VALUES (3,'ABM Perfiles','E',NOW()); -INSERT INTO perfil_sist VALUES (1,1,NOW()); -INSERT INTO perfil_sist VALUES (2,1,NOW()); -INSERT INTO perfil_sist VALUES (3,1,NOW()); -INSERT INTO perfil_sist_usuario VALUES ('mdegan@mecon',1,1,NOW()); -INSERT INTO perfil_sist_usuario VALUES ('mmarre@mecon',1,1,NOW()); -INSERT INTO perfil_sist_usuario VALUES ('mmarre@mecon',2,1,NOW()); -INSERT INTO perfil_sist_usuario VALUES ('mmarre@mecon',3,1,NOW()); -INSERT INTO perm_perfil_sist VALUES (1,1,1,NOW()); -INSERT INTO perm_perfil_sist VALUES (1,3,1,NOW()); -INSERT INTO perm_perfil_sist VALUES (2,1,1,NOW()); -INSERT INTO perm_perfil_sist VALUES (3,1,1,NOW()); -INSERT INTO perm_perfil_sist VALUES (4,2,1,NOW()); -INSERT INTO perm_perfil_sist VALUES (5,2,1,NOW()); -INSERT INTO perm_perfil_sist VALUES (6,2,1,NOW()); -INSERT INTO perm_perfil_sist VALUES (7,3,1,NOW()); -INSERT INTO perm_perfil_sist VALUES (8,3,1,NOW()); -INSERT INTO perm_perfil_sist VALUES (9,3,1,NOW()); -INSERT INTO perm_sist VALUES (1,1,'',NOW()); -INSERT INTO perm_sist VALUES (2,1,'',NOW()); -INSERT INTO perm_sist VALUES (3,1,'',NOW()); -INSERT INTO perm_sist VALUES (4,1,'',NOW()); -INSERT INTO perm_sist VALUES (5,1,'',NOW()); -INSERT INTO perm_sist VALUES (6,1,'',NOW()); -INSERT INTO perm_sist VALUES (7,1,'',NOW()); -INSERT INTO perm_sist VALUES (8,1,'',NOW()); -INSERT INTO perm_sist VALUES (9,1,'',NOW()); -INSERT INTO permiso VALUES (1,'Agregar Usuario',NOW()); -INSERT INTO permiso VALUES (2,'Modificar Usuario',NOW()); -INSERT INTO permiso VALUES (3,'Eliminar Usuario',NOW()); -INSERT INTO permiso VALUES (4,'Agregar Permiso',NOW()); -INSERT INTO permiso VALUES (5,'Modificar Permiso',NOW()); -INSERT INTO permiso VALUES (6,'Eliminar Permiso',NOW()); -INSERT INTO permiso VALUES (7,'Agregar Perfil',NOW()); -INSERT INTO permiso VALUES (8,'Modificar Perfil',NOW()); -INSERT INTO permiso VALUES (9,'Eliminar Perfil',NOW()); -INSERT INTO sistema VALUES (1,'SAMURAI','Sistema de Administracion y Mantenimiento de Usuarios Relativo A Intranet','2003-03-06',NULL,NULL,'Silvina Ottonello ',NOW()); -INSERT INTO usuario VALUES ('mmarre',28924563,'Martin Marrese','2003-03-10 15:52:40',NOW()); +-- +-- Dumping data for table 'perfil' +-- +INSERT INTO perfil VALUES (1,'ABM Usuarios','E',20030321132624,NULL); +INSERT INTO perfil VALUES (2,'ABM Permisos','E',20030321132624,NULL); +INSERT INTO perfil VALUES (3,'ABM Perfiles','E',20030321132624,NULL); + +-- +-- Dumping data for table 'perfil_sist' +-- +INSERT INTO perfil_sist VALUES (1,1,20030321132624,''); +INSERT INTO perfil_sist VALUES (2,1,20030321132624,''); +INSERT INTO perfil_sist VALUES (3,1,20030321132624,''); + +-- +-- Dumping data for table 'perfil_sist_usuario' +-- +INSERT INTO perfil_sist_usuario VALUES ('mdegan@mecon',1,1,20030321132624,''); +INSERT INTO perfil_sist_usuario VALUES ('mmarre@mecon',1,1,20030321132624,''); +INSERT INTO perfil_sist_usuario VALUES ('mmarre@mecon',2,1,20030321132624,''); +INSERT INTO perfil_sist_usuario VALUES ('mmarre@mecon',3,1,20030321132624,''); + +-- +-- Dumping data for table 'perm_perfil_sist' +-- +INSERT INTO perm_perfil_sist VALUES (1,1,1,20030321132624,''); +INSERT INTO perm_perfil_sist VALUES (1,3,1,20030321132624,''); +INSERT INTO perm_perfil_sist VALUES (2,1,1,20030321132624,''); +INSERT INTO perm_perfil_sist VALUES (3,1,1,20030321132624,''); +INSERT INTO perm_perfil_sist VALUES (4,2,1,20030321132624,''); +INSERT INTO perm_perfil_sist VALUES (5,2,1,20030321132624,''); +INSERT INTO perm_perfil_sist VALUES (6,2,1,20030321132624,''); +INSERT INTO perm_perfil_sist VALUES (7,3,1,20030321132624,''); +INSERT INTO perm_perfil_sist VALUES (8,3,1,20030321132624,''); +INSERT INTO perm_perfil_sist VALUES (9,3,1,20030321132624,''); + +-- +-- Dumping data for table 'perm_sist' +-- +INSERT INTO perm_sist VALUES (1,1,'',20030321132624,''); +INSERT INTO perm_sist VALUES (2,1,'',20030321132624,''); +INSERT INTO perm_sist VALUES (3,1,'',20030321132624,''); +INSERT INTO perm_sist VALUES (4,1,'',20030321132624,''); +INSERT INTO perm_sist VALUES (5,1,'',20030321132624,''); +INSERT INTO perm_sist VALUES (6,1,'',20030321132624,''); +INSERT INTO perm_sist VALUES (7,1,'',20030321132624,''); +INSERT INTO perm_sist VALUES (8,1,'',20030321132624,''); +INSERT INTO perm_sist VALUES (9,1,'',20030321132624,''); + +-- +-- Dumping data for table 'permiso' +-- +INSERT INTO permiso VALUES (1,'Agregar Usuario',20030321132624,''); +INSERT INTO permiso VALUES (2,'Modificar Usuario',20030321132624,''); +INSERT INTO permiso VALUES (3,'Eliminar Usuario',20030321132624,''); +INSERT INTO permiso VALUES (4,'Agregar Permiso',20030321132624,''); +INSERT INTO permiso VALUES (5,'Modificar Permiso',20030321132624,''); +INSERT INTO permiso VALUES (6,'Eliminar Permiso',20030321132624,''); +INSERT INTO permiso VALUES (7,'Agregar Perfil',20030321132624,''); +INSERT INTO permiso VALUES (8,'Modificar Perfil',20030321132624,''); +INSERT INTO permiso VALUES (9,'Eliminar Perfil',20030321132624,''); + +-- +-- Dumping data for table 'sistema' +-- +INSERT INTO sistema VALUES (1,'SAMURAI','Sistema de Administracion y Mantenimiento de Usuarios Relativo A Intranet','2003-03-06',NULL,NULL,'Silvina Ottonello ',20030321132624,'',''); +INSERT INTO sistema VALUES (2,'PRUEBA','Esto es para hacer pruebas',NULL,NULL,NULL,'MARTIN',20030327174008,'',''); + +-- +-- Dumping data for table 'usuario' +-- +INSERT INTO usuario VALUES ('mmarre',28924563,'Martin Marrese',20030321132624); +INSERT INTO usuario VALUES ('mdegan',25943498,'Myrna Degano' ,00000000000000);