-- MySQL dump 8.22
--
-- Host: bal747f    Database: samurai
---------------------------------------------------------
-- Server version	4.0.12-log

--
-- Table structure for table 'perfil'
--

CREATE TABLE perfil (
  id_perfil bigint(20) NOT NULL auto_increment,
  desc_perfil varchar(50) default NULL,
  fch_ult_modif timestamp(14) NOT NULL,
  responsable varchar(20) default NULL,
  PRIMARY KEY  (id_perfil),
  UNIQUE KEY desc_perfil (desc_perfil)
) TYPE=MyISAM;

--
-- Table structure for table 'perfil_seq'
--

CREATE TABLE perfil_seq (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table 'perfil_sist'
--

CREATE TABLE perfil_sist (
  id_perfil bigint(20) NOT NULL default '0',
  id_sistema bigint(20) NOT NULL default '0',
  fch_ult_modif timestamp(14) NOT NULL,
  responsable varchar(20) default NULL,
  tipo_perfil char(1) default NULL,
  PRIMARY KEY  (id_perfil,id_sistema)
) TYPE=MyISAM;

--
-- Table structure for table 'perfil_sist_usuario'
--

CREATE TABLE perfil_sist_usuario (
  login varchar(20) NOT NULL default '',
  id_perfil bigint(20) NOT NULL default '0',
  id_sistema bigint(20) NOT NULL default '0',
  fch_ult_modif timestamp(14) NOT NULL,
  responsable varchar(20) default NULL,
  PRIMARY KEY  (login,id_perfil,id_sistema)
) TYPE=MyISAM;

--
-- Table structure for table 'perm_perfil_sist'
--

CREATE TABLE perm_perfil_sist (
  id_permiso bigint(20) NOT NULL default '0',
  id_perfil bigint(20) NOT NULL default '0',
  id_sistema bigint(20) NOT NULL default '0',
  fch_ult_modif timestamp(14) NOT NULL,
  responsable varchar(20) default NULL,
  observaciones varchar(255) NOT NULL default '',
  PRIMARY KEY  (id_permiso,id_perfil,id_sistema,observaciones)
) TYPE=MyISAM;

--
-- Table structure for table 'perm_sist'
--

CREATE TABLE perm_sist (
  id_permiso bigint(20) NOT NULL default '0',
  id_sistema bigint(20) NOT NULL default '0',
  observaciones varchar(255) NOT NULL default '',
  fch_ult_modif timestamp(14) NOT NULL,
  responsable varchar(20) default NULL,
  PRIMARY KEY  (id_permiso,id_sistema,observaciones)
) TYPE=MyISAM;

--
-- Table structure for table 'permiso'
--

CREATE TABLE permiso (
  id_permiso bigint(20) NOT NULL auto_increment,
  desc_permiso varchar(50) default NULL,
  fch_ult_modif timestamp(14) NOT NULL,
  responsable varchar(20) default NULL,
  PRIMARY KEY  (id_permiso),
  UNIQUE KEY desc_permiso (desc_permiso)
) TYPE=MyISAM;

--
-- Table structure for table 'permiso_seq'
--

CREATE TABLE permiso_seq (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table 'sistema'
--

CREATE TABLE sistema (
  id_sistema bigint(20) NOT NULL auto_increment,
  nombre_sistema varchar(50) default NULL,
  desc_sistema text,
  fecha_inicio date default NULL,
  fecha_fin date default NULL,
  fecha_implementacion date default NULL,
  contacto text,
  fch_ult_modif timestamp(14) NOT NULL,
  responsable varchar(20) default NULL,
  estado tinyint(4) default NULL,
  PRIMARY KEY  (id_sistema),
  UNIQUE KEY nombre_sistema (nombre_sistema)
) TYPE=MyISAM;

--
-- Table structure for table 'sistema_seq'
--

CREATE TABLE sistema_seq (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table 'usuario'
--

CREATE TABLE usuario (
  login varchar(20) NOT NULL default '',
  nrodoc int(11) default NULL,
  nombre varchar(50) default NULL,
  fch_ult_modif timestamp(14) NOT NULL,
  PRIMARY KEY  (login)
) TYPE=MyISAM;
