{\rtf1\ansi\ansicpg1252\uc1 \deff28\deflang3082\deflangfe3082{\fonttbl{\f0\froman\fcharset0\fprq2{\*\panose 02020603050405020304}Times New Roman;}{\f2\fmodern\fcharset0\fprq1{\*\panose 02070309020205020404}Courier New;}\r
{\f3\froman\fcharset2\fprq2{\*\panose 05050102010706020507}Symbol;}{\f14\fnil\fcharset2\fprq2{\*\panose 05000000000000000000}Wingdings;}{\f28\fswiss\fcharset0\fprq2{\*\panose 020b0604030504040204}Verdana;}\r
-{\f124\froman\fcharset238\fprq2 Times New Roman CE;}{\f125\froman\fcharset204\fprq2 Times New Roman Cyr;}{\f127\froman\fcharset161\fprq2 Times New Roman Greek;}{\f128\froman\fcharset162\fprq2 Times New Roman Tur;}\r
-{\f129\froman\fcharset177\fprq2 Times New Roman (Hebrew);}{\f130\froman\fcharset178\fprq2 Times New Roman (Arabic);}{\f131\froman\fcharset186\fprq2 Times New Roman Baltic;}{\f140\fmodern\fcharset238\fprq1 Courier New CE;}\r
-{\f141\fmodern\fcharset204\fprq1 Courier New Cyr;}{\f143\fmodern\fcharset161\fprq1 Courier New Greek;}{\f144\fmodern\fcharset162\fprq1 Courier New Tur;}{\f145\fmodern\fcharset177\fprq1 Courier New (Hebrew);}\r
-{\f146\fmodern\fcharset178\fprq1 Courier New (Arabic);}{\f147\fmodern\fcharset186\fprq1 Courier New Baltic;}{\f348\fswiss\fcharset238\fprq2 Verdana CE;}{\f349\fswiss\fcharset204\fprq2 Verdana Cyr;}{\f351\fswiss\fcharset161\fprq2 Verdana Greek;}\r
-{\f352\fswiss\fcharset162\fprq2 Verdana Tur;}{\f355\fswiss\fcharset186\fprq2 Verdana Baltic;}}{\colortbl;\red0\green0\blue0;\red0\green0\blue255;\red0\green255\blue255;\red0\green255\blue0;\red255\green0\blue255;\red255\green0\blue0;\r
+{\f33\froman\fcharset238\fprq2 Times New Roman CE;}{\f34\froman\fcharset204\fprq2 Times New Roman Cyr;}{\f36\froman\fcharset161\fprq2 Times New Roman Greek;}{\f37\froman\fcharset162\fprq2 Times New Roman Tur;}\r
+{\f38\froman\fcharset177\fprq2 Times New Roman (Hebrew);}{\f39\froman\fcharset178\fprq2 Times New Roman (Arabic);}{\f40\froman\fcharset186\fprq2 Times New Roman Baltic;}{\f49\fmodern\fcharset238\fprq1 Courier New CE;}\r
+{\f50\fmodern\fcharset204\fprq1 Courier New Cyr;}{\f52\fmodern\fcharset161\fprq1 Courier New Greek;}{\f53\fmodern\fcharset162\fprq1 Courier New Tur;}{\f54\fmodern\fcharset177\fprq1 Courier New (Hebrew);}\r
+{\f55\fmodern\fcharset178\fprq1 Courier New (Arabic);}{\f56\fmodern\fcharset186\fprq1 Courier New Baltic;}{\f257\fswiss\fcharset238\fprq2 Verdana CE;}{\f258\fswiss\fcharset204\fprq2 Verdana Cyr;}{\f260\fswiss\fcharset161\fprq2 Verdana Greek;}\r
+{\f261\fswiss\fcharset162\fprq2 Verdana Tur;}{\f264\fswiss\fcharset186\fprq2 Verdana Baltic;}}{\colortbl;\red0\green0\blue0;\red0\green0\blue255;\red0\green255\blue255;\red0\green255\blue0;\red255\green0\blue255;\red255\green0\blue0;\r
\red255\green255\blue0;\red255\green255\blue255;\red0\green0\blue128;\red0\green128\blue128;\red0\green128\blue0;\red128\green0\blue128;\red128\green0\blue0;\red128\green128\blue0;\red128\green128\blue128;\red192\green192\blue192;\red230\green230\blue230;\r
\red255\green255\blue255;}{\stylesheet{\qj \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \f28\fs20\lang3082\langfe3082\cgrid\langnp3082\langfenp3082 \snext0 Normal;}{\r
\s1\qj \li0\ri0\keepn\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \b\f28\fs20\ul\lang3082\langfe3082\cgrid\langnp3082\langfenp3082 \sbasedon0 \snext0 heading 1;}{\r
\fi-360\li5040\jclisttab\tx5040 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid201981955\'01o;}{\levelnumbers;}\f2\chbrdr\brdrnone\brdrcf1 \r
\chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li5760\jclisttab\tx5760 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid201981957\'01\u-3929 ?;}{\levelnumbers;}\f14\chbrdr\r
\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li6480\jclisttab\tx6480 }{\listname ;}\listid1648389061}}{\*\listoverridetable{\listoverride\listid1648389061\listoverridecount0\ls1}}{\info{\title ADMINISTRACI\'d3N DE USUARIOS}\r
-{\author Dir. Gral. de Inform\'e1tica}{\operator Dir. Gral. de Inform\'e1tica}{\creatim\yr2003\mo3\dy6\hr19\min20}{\revtim\yr2003\mo3\dy24\hr12\min37}{\printim\yr2003\mo2\dy6\hr11\min4}{\version15}{\edmins21}{\nofpages7}{\nofwords513}{\nofchars2927}\r
-{\*\company Ministerio de Econom\'eda}{\nofcharsws0}{\vern8249}}\paperw11907\paperh16840\margl1134\margr1134\margt1134\margb1134 \r
+{\author Dir. Gral. de Inform\'e1tica}{\operator Dir. Gral. de Inform\'e1tica}{\creatim\yr2003\mo3\dy6\hr19\min20}{\revtim\yr2003\mo6\dy6\hr13\min33}{\printim\yr2003\mo2\dy6\hr11\min4}{\version18}{\edmins32}{\nofpages8}{\nofwords1101}{\nofchars6280}\r
+{\*\company Ministerio de Econom\'eda}{\nofcharsws7712}{\vern8249}}\paperw11907\paperh16840\margl1134\margr1134\margt1134\margb1134 \r
\deftab708\widowctrl\ftnbj\aenddoc\hyphhotz425\noxlattoyen\expshrtn\noultrlspc\dntblnsbdb\nospaceforul\hyphcaps0\formshade\horzdoc\dgmargin\dghspace180\dgvspace180\dghorigin1134\dgvorigin1134\dghshow1\dgvshow1\r
-\jexpand\viewkind1\viewscale75\pgbrdrhead\pgbrdrfoot\splytwnine\ftnlytwnine\htmautsp\nolnhtadjtbl\useltbaln\alntblind\lytcalctblwd\lyttblrtgr\lnbrkrule \fet0\sectd \psz9\linex0\headery680\footery680\colsx708\endnhere\sectlinegrid360\sectdefaultcl \r
+\jexpand\viewkind1\viewscale100\pgbrdrhead\pgbrdrfoot\splytwnine\ftnlytwnine\htmautsp\nolnhtadjtbl\useltbaln\alntblind\lytcalctblwd\lyttblrtgr\lnbrkrule \fet0\sectd \psz9\linex0\headery680\footery680\colsx708\endnhere\sectlinegrid360\sectdefaultcl \r
{\header \trowd \trgaph70\trleft-70\trbrdrb\brdrs\brdrw10 \trbrdrh\brdrs\brdrw10 \trftsWidth1\trautofit1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrs\brdrw10 \clbrdrr\brdrnone \r
\cltxlrtb\clftsWidth3\clwWidth4889 \cellx4819\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrs\brdrw10 \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth4890 \cellx9709\pard\plain \s15\qj \li0\ri0\widctlpar\intbl\r
\tqc\tx4419\tqr\tx8838\aspalpha\aspnum\faauto\adjustright\rin0\lin0 \f28\fs20\lang3082\langfe3082\cgrid\langnp3082\langfenp3082 {\fs18 Intranet\cell }\pard \s15\qr \li0\ri0\widctlpar\intbl\r
\par }}{\footer \trowd \trgaph70\trleft-70\trbrdrt\brdrs\brdrw10 \trbrdrh\brdrs\brdrw10 \trftsWidth1\trautofit1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrs\brdrw10 \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone \r
\cltxlrtb\clftsWidth3\clwWidth4889 \cellx4819\clvertalt\clbrdrt\brdrs\brdrw10 \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth4890 \cellx9709\pard\plain \s16\qj \li0\ri0\widctlpar\intbl\r
\tqc\tx4419\tqr\tx8838\aspalpha\aspnum\faauto\adjustright\rin0\lin0 \f28\fs20\lang3082\langfe3082\cgrid\langnp3082\langfenp3082 {\fs18 06-03-2003\cell }\pard \s16\qr \li0\ri0\widctlpar\intbl\r
-\tqc\tx4419\tqr\tx8838\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\fs18 P\'e1gina }{\field{\*\fldinst {\fs18 PAGE }}{\fldrslt {\fs18\lang1024\langfe1024\noproof 6}}}{\fs18 de }{\field{\*\fldinst {\fs18 NUMPAGES }}{\fldrslt {\r
-\fs18\lang1024\langfe1024\noproof 7}}}{\fs18 \cell }\pard\plain \qj \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 \f28\fs20\lang3082\langfe3082\cgrid\langnp3082\langfenp3082 {\trowd \trgaph70\trleft-70\trbrdrt\brdrs\brdrw10 \r
+\tqc\tx4419\tqr\tx8838\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\fs18 P\'e1gina }{\field{\*\fldinst {\fs18 PAGE }}{\fldrslt {\fs18\lang1024\langfe1024\noproof 7}}}{\fs18 de }{\field{\*\fldinst {\fs18 NUMPAGES }}{\fldrslt {\r
+\fs18\lang1024\langfe1024\noproof 8}}}{\fs18 \cell }\pard\plain \qj \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 \f28\fs20\lang3082\langfe3082\cgrid\langnp3082\langfenp3082 {\trowd \trgaph70\trleft-70\trbrdrt\brdrs\brdrw10 \r
\trbrdrh\brdrs\brdrw10 \trftsWidth1\trautofit1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrs\brdrw10 \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth4889 \cellx4819\clvertalt\clbrdrt\brdrs\brdrw10 \r
\clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth4890 \cellx9709\row }\pard\plain \s16\qj \li0\ri0\widctlpar\tqc\tx4419\tqr\tx8838\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \r
\f28\fs20\lang3082\langfe3082\cgrid\langnp3082\langfenp3082 {\r
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff\r
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff\r
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff\r
-ffffffffffffffffffffffffffffffff52006f006f007400200045006e00740072007900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016000500ffffffffffffffff02000000111a020000000000c0000000000000460000000000000000000000002030\r
-45521bf2c20103000000000200000000000001004f006c00650000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a000201ffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000\r
+ffffffffffffffffffffffffffffffff52006f006f007400200045006e00740072007900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016000500ffffffffffffffff02000000111a020000000000c00000000000004600000000000000000000000020cd\r
+db51492cc30103000000000200000000000001004f006c00650000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a000201ffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000\r
0000000000000000000000001400000000000000010043006f006d0070004f0062006a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000120002010100000004000000ffffffff0000000000000000000000000000000000000000000000000000\r
0000000000000000000001000000690000000000000003004f0062006a0049006e0066006f0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012000201ffffffffffffffffffffffff000000000000000000000000000000000000000000000000\r
000000000000000000000000030000000400000000000000feffffff02000000fefffffffefffffffeffffff0600000007000000feffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff\r
2d0104000300000000000000}{\result {{\pict{\*\picprop\shplid1025{\sp{\sn shapeType}{\sv 75}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}{\sp{\sn pictureGray}{\sv 0}}{\sp{\sn pictureBiLevel}{\sv 0}}\r
{\sp{\sn pictureActive}{\sv 0}}{\sp{\sn fFilled}{\sv 0}}{\sp{\sn fHitTestFill}{\sv 1}}{\sp{\sn fillShape}{\sv 1}}{\sp{\sn fillUseRect}{\sv 0}}{\sp{\sn fNoFillHitTest}{\sv 0}}\r
{\sp{\sn fLine}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 1}}{\sp{\sn fReallyHidden}{\sv 0}}{\sp{\sn fScriptAnchor}{\sv 0}}{\sp{\sn fFakeMaster}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 1}}}\picscalex85\picscaley85\piccropl0\piccropr0\piccropt0\piccropb0\r
-\picw19798\pich9320\picwgoal11224\pichgoal5284\wmetafile8\bliptag-375662658\blipupi-109{\*\blipuid e99bd7bee9998690563308cdb4574b6b}\r
+\picw19798\pich9320\picwgoal11224\pichgoal5284\wmetafile8\bliptag611010535\blipupi-109{\*\blipuid 246b47e798a40288a712262972c0f865}\r
010009000003d90a00000800560000000000050000000b0200000000050000000c024d042209050000000902ffffff0005000000010200000000040000000201\r
02000500000001020000000007000000fc020000ffffff000000040000002d01000009000000fa02000001000000000000002200040000002d0101000e000000\r
240305000700c2003301c20033010700070007000700c20009000000fa02000000000000000000002200040000002d01020007000000fc020100000000000000\r
020048012602330126020800000025030200480126023301310208000000250302004801260233011c02080000002503020089021c0289023102080000002503\r
020094021c0294023102040000002d01020004000000f0010700040000002d010500040000002d010400040000002d010000040000002d0106000c0000002403\r
0400d6010f02d6013d0206023d0206020f02040000002d010200040000002d0103000400000008010000050000000a0200000000040000000201010004000000\r
-2e01180005000000090200000000040000002d010500070000002105020052323002d901040000002d010400030000000000000000000000000000000000000000000000}}}}}{\r
+2e01180005000000090200000000040000002d010500070000002105020052323002d901040000002d01040003000000000000000000000000000000000000000000000000000000}}}}}{\r
\par \r
\par \r
\par }{\ul \r
\par contacto *\r
\par fecha\r
\par responsable\r
+\par estado *\r
\par }{\ul \r
\par \r
\par }\pard\plain \s2\qj \li0\ri0\keepn\widctlpar\aspalpha\aspnum\faauto\outlinelevel1\adjustright\rin0\lin0\itap0 \b\f28\fs20\lang3082\langfe3082\cgrid\langnp3082\langfenp3082 {USUARIO }{\b0 (ENT)}{\r
\par El atributo }{\i fecha}{ contiene el momento del \'faltimo logueo del usuario a Intranet. (cada login reemplaza al anterior)\r
\par De esta forma, la descentralizaci\'f3n de la asignaci\'f3n de permisos, permite que el usuario administrador de un determinado sistema asigne permisos a nuevos usuarios sin necesidad de conocer otra dato m\'e1\r
s que el login del usuario. (el resto de los datos son obtenidos de la entidad }{\i USUARIO}{, previamente cargada)\r
-\par }\pard\plain \s17\qj \li708\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin708\itap0 \f28\fs20\lang3082\langfe3082\cgrid\langnp3082\langfenp3082 {Obviamente esto im\r
-plica que los usuarios a los que se le asignen permisos deben haberse logueado previamente en Intranet.\r
+\par }\pard\plain \s17\qj \li708\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin708\itap0 \f28\fs20\lang3082\langfe3082\cgrid\langnp3082\langfenp3082 {Obviament\r
+e esto implica que los usuarios a los que se le asignen permisos deben haberse logueado previamente en Intranet.\r
\par }\pard\plain \qj \li708\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin708\itap0 \f28\fs20\lang3082\langfe3082\cgrid\langnp3082\langfenp3082 {\r
\par El atributo }{\i fecha }{de la entidad }{\i USUARIO}{ es necesario porque, peri\'f3dicamente, la entidad es depurada, eliminando todos aquellos usuarios que no tengan ning\'fa\r
n permiso asignado y que no se hayan logueado a Intranet desde un determinado tiempo (por ejemplo, un mes).\r
\par {\listtext\pard\plain\fs20 \hich\af0\dbch\af0\loch\f0 -\tab}}\pard \qj \fi-360\li720\ri0\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls1\adjustright\rin0\lin720\itap0 {Los datos del personal de la Ex \endash Coordinaci\'f3n \'c1\r
rea Desarrollo y Mantenimiento involucrado en el desarrollo de cada uno de los sistemas, forman parte de la entidad }{\i USUARIO,}{ relacionada al sistema correspondiente mediante la asignaci\'f3n de un perfil, identificando el rol que desempe\'f1\'f3\r
la persona (ejs.: programador, dise\'f1ador gr\'e1fico, analista de sistemas, etc.).\r
-\par }\pard \qj \li708\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin708\itap0 {El atributo }{\i tipo_perfil}{ de la entidad }{\i PERFIL}{ diferencia perfiles internos y externos, es decir, si se trata de perfiles d\r
-efinidos para usuarios de los sistemas, o bien de roles desempe\'f1ados durante el desarrollo del proyecto (perfiles privados).\r
+\par }\pard \qj \li708\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin708\itap0 {El atributo }{\i tipo_perfil}{ de la entidad }{\i PERFIL}{ diferencia perfiles internos y externos, es decir, si se trata de p\r
+erfiles definidos para usuarios de los sistemas, o bien de roles desempe\'f1ados durante el desarrollo del proyecto (perfiles privados).\r
\par }\pard \qj \li360\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin360\itap0 {\r
\par {\listtext\pard\plain\fs20 \hich\af0\dbch\af0\loch\f0 -\tab}}\pard \qj \fi-360\li720\ri0\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls1\adjustright\rin0\lin720\itap0 {El atributo }{\i contacto}{ de la entidad }{\i SISTEMA}{\r
contiene todos los datos necesarios a fin de poder identificar a las personas que solicitaron el sistema.\r
\par {\listtext\pard\plain\fs20 \hich\af0\dbch\af0\loch\f0 -\tab}}\pard \qj \fi-360\li720\ri0\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls1\adjustright\rin0\lin720\itap0 {Cada una de las entidades contiene los atributos }{\i fecha}{ y }{\i responsable}{\r
que representan el momento en que se realiz\'f3 el \'faltimo cambio en el registro y el usuario que lo llev\'f3 a cabo.\r
\par }\pard \qj \li708\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin708\itap0 {Estos dos campos sirven para llevar un control de qui\'e9n y en qu\'e9 momento se asignan nuevos permisos, se crean nuevos perfiles, etc. \r
+\par \r
+\par {\listtext\pard\plain\fs20 \hich\af0\dbch\af0\loch\f0 -\tab}}\pard \qj \fi-360\li720\ri0\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls1\adjustright\rin0\lin720\itap0 {\r
+El atributo estado de la entidad SISTEMA indica el estado en que se encuentra el sistema (activo o no). Los sistemas no pueden ser eliminados de la base de datos, sino que son dados de baja. Al dar de baja un sistema, \'e9ste deja de estar activo.\r
+\r
+\par }\pard \qj \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\r
+\par \r
\par }\pard\plain \s2\qj \li0\ri0\keepn\widctlpar\aspalpha\aspnum\faauto\outlinelevel1\adjustright\rin0\lin0\itap0 \b\f28\fs20\lang3082\langfe3082\cgrid\langnp3082\langfenp3082 {\r
\par \page \r
\par Dise\'f1o F\'edsico\r
\par \r
\par CREATE TABLE perfil (\r
\par id_perfil bigint(20) NOT NULL auto_increment,\r
-\par }{\f2\fs22\lang2058\langfe3082\langnp2058 desc_perfil varchar(50),\r
+\par }{\f2\fs22\lang2058\langfe3082\langnp2058 desc_perfil varchar(50),\r
\par tipo_perfil char(1), \r
-\par }{\f2\fs22\lang1033\langfe3082\langnp1033 fch_ult_modif timestamp,\r
-\par responsable varchar(20),\r
+\par }{\f2\fs22\lang1033\langfe3082\langnp1033 fch_ult_modif timestamp,\r
+\par }{\f2\fs22\lang2058\langfe3082\langnp2058 responsable varchar(20),\r
\par PRIMARY KEY (id_perfil)\r
-\par }{\f2\fs22\lang2058\langfe3082\langnp2058 ); \r
+\par ); \r
\par \r
\par \r
\par #\r
\par id_perfil bigint(20) NOT NULL,\r
\par id_sistema bigint(20) NOT NULL,\r
\par fch_ult_modif timestamp,\r
-\par responsable varchar(20),\r
+\par }{\f2\fs22\lang2058\langfe3082\langnp2058 responsable varchar(20),\r
\par PRIMARY KEY (id_perfil, id_sistema)\r
-\par }{\f2\fs22\lang2058\langfe3082\langnp2058 ); \r
+\par ); \r
\par \r
\par \r
\par #\r
\par id_perfil bigint(20) NOT NULL,\r
\par id_sistema bigint(20) NOT NULL,\r
\par fch_ult_modif timestamp,\r
-\par responsable varchar(20),\r
+\par }{\f2\fs22\lang2058\langfe3082\langnp2058 responsable varchar(20),\r
\par PRIMARY KEY (login, id_perfil, id_sistema)\r
-\par }{\f2\fs22\lang2058\langfe3082\langnp2058 ); \r
+\par ); \r
\par \r
\par \r
\par #\r
\par id_perfil bigint(20) NOT NULL,\r
\par id_sistema bigint(20) NOT NULL,\r
\par fch_ult_modif timestamp,\r
-\par responsable varchar(20),\r
+\par }{\f2\fs22\lang2058\langfe3082\langnp2058 responsable varchar(20),\r
\par PRIMARY KEY (id_permiso, id_perfil, id_sistema)\r
-\par }{\f2\fs22\lang2058\langfe3082\langnp2058 ); \r
+\par ); \r
\par \r
\par \r
\par #\r
\par CREATE TABLE perm_sist (\r
\par id_permiso bigint(20) NOT NULL,\r
\par id_sistema bigint(20) NOT NULL,\r
-\par }{\f2\fs22\lang2058\langfe3082\langnp2058 observaciones varchar(255),\r
+\par }{\f2\fs22\lang2058\langfe3082\langnp2058 observaciones varchar(255),\r
\par fch_ult_modif timestamp,\r
\par responsable varchar(20),\r
\par PRIMARY KEY (id_permiso, id_sistema, observaciones)\r
\par \r
\par CREATE TABLE permiso (\r
\par id_permiso bigint(20) NOT NULL auto_increment,\r
-\par }{\f2\fs22\lang2058\langfe3082\langnp2058 desc_permiso varchar(50),\r
-\par }{\f2\fs22\lang1033\langfe3082\langnp1033 fch_ult_modif timestamp,\r
-\par responsable varchar(20),\r
+\par }{\f2\fs22\lang2058\langfe3082\langnp2058 desc_permiso varchar(50),\r
+\par }{\f2\fs22\lang1033\langfe3082\langnp1033 fch_ult_modif timestamp,\r
+\par }{\f2\fs22\lang2058\langfe3082\langnp2058 responsable varchar(20),\r
\par PRIMARY KEY (id_permiso)\r
-\par }{\f2\fs22\lang2058\langfe3082\langnp2058 ); \r
+\par ); \r
\par \r
\par \r
\par #\r
\par \r
\par CREATE TABLE sistema (\r
\par id_sistema bigint(20) NOT NULL auto_increment,\r
-\par }{\f2\fs22\lang2058\langfe3082\langnp2058 nombre_sistema varchar(50),\r
+\par }{\f2\fs22\lang2058\langfe3082\langnp2058 nombre_sistema varchar(50),\r
\par desc_sistema text,\r
\par fecha_inicio date,\r
\par fecha_fin date,\r
\par fecha_implementacion date,\r
\par }{\f2\fs22\lang1033\langfe3082\langnp1033 contacto text, \r
\par fch_ult_modif timestamp,\r
-\par responsable varchar(20),\r
+\par }{\f2\fs22\lang2058\langfe3082\langnp2058 responsable varchar(20),\r
+\par estado tinyint, \tab \r
\par PRIMARY KEY (id_sistema)\r
-\par }{\f2\fs22\lang2058\langfe3082\langnp2058 ); \r
+\par ); \r
\par \r
\par }\pard \qj \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f2\ul \r
\par }\pard \ql \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 {\f2\fs22\lang2058\langfe3082\langnp2058 #\r
\par \r
\par CREATE TABLE usuario (\r
\par login varchar(20) NOT NULL,\r
-\par }{\f2\fs22\lang2058\langfe3082\langnp2058 nrodoc int(11),\r
+\par }{\f2\fs22\lang2058\langfe3082\langnp2058 nrodoc int(11),\r
\par nombre varchar(50),\r
-\par }{\f2\fs22\lang1033\langfe3082\langnp1033 fch_ult_modif timestamp,\r
+\par }{\f2\fs22\lang1033\langfe3082\langnp1033 fch_ult_modif timestamp,\r
\par PRIMARY KEY (login)\r
\par );}{ \r
\par }}
\ No newline at end of file
projects / mecon / samurai.git / blobdiff