From: Martín Marrese <marrese@gmail.com>
Date: Fri, 8 Aug 2003 21:21:10 +0000 (+0000)
Subject: Agrego el script de generacion de la base de datos.
X-Git-Tag: svn_import~94
X-Git-Url: https://git.llucax.com/mecon/samurai.git/commitdiff_plain/2df1836a563b51d6c39d21b56bd06410451fba94?ds=sidebyside

Agrego el script de generacion de la base de datos.
---

diff --git a/script/SAMURAI_SQL_Generacion_Base.sql b/script/SAMURAI_SQL_Generacion_Base.sql
new file mode 100644
index 0000000..164603b
--- /dev/null
+++ b/script/SAMURAI_SQL_Generacion_Base.sql
@@ -0,0 +1,142 @@
+-- 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;