En desarrollo la consulta de usuarios

[mecon/samurai.git] / script / SAMURAI_SQL_Datos_Prueba.txt

diff --git a/script/SAMURAI_SQL_Datos_Prueba.txt b/script/SAMURAI_SQL_Datos_Prueba.txt
index f8f9e9ed19799444c0bb9dbb22d022ebb12d4db2..e26a8475ed42df89e5322835121f9e53c27d5651 100644 (file)
--- 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 <sotton@mecon.gov.ar>',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 <sotton@mecon.gov.ar>',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);