From 081e4c047b542c7cab0682f4ed70f6817d8bb0ec Mon Sep 17 00:00:00 2001 From: Leandro Lucarella Date: Tue, 24 Jun 2003 20:30:21 +0000 Subject: [PATCH] Se agrega scripts SQL para crear las bases. --- sql/grupo_secciones.sql | 37 +++++++++++++++++++++++++++++ sql/grupo_secciones_seccion.sql | 33 ++++++++++++++++++++++++++ sql/servicio.sql | 42 +++++++++++++++++++++++++++++++++ sql/sistema.sql | 37 +++++++++++++++++++++++++++++ 4 files changed, 149 insertions(+) create mode 100644 sql/grupo_secciones.sql create mode 100644 sql/grupo_secciones_seccion.sql create mode 100644 sql/servicio.sql create mode 100644 sql/sistema.sql diff --git a/sql/grupo_secciones.sql b/sql/grupo_secciones.sql new file mode 100644 index 0000000..223f8ca --- /dev/null +++ b/sql/grupo_secciones.sql @@ -0,0 +1,37 @@ +-- vim: set expandtab tabstop=4 softtabstop=4 shiftwidth=4: +-- +--------------------------------------------------------------------+ +-- | Ministerio de Economía | +-- | AI (Administrador de Intranet) | +-- +--------------------------------------------------------------------+ +-- | This file is part of AI. | +-- | | +-- | AI is free software; you can redistribute it and/or modify | +-- | it under the terms of the GNU General Public License as published | +-- | by the Free Software Foundation; either version 2 of the License, | +-- | or (at your option) any later version. | +-- | | +-- | AI is distributed in the hope that it will be useful, but | +-- | WITHOUT ANY WARRANTY; without even the implied warranty of | +-- | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | +-- | General Public License for more details. | +-- | | +-- | You should have received a copy of the GNU General Public License | +-- | along with Hooks; if not, write to the Free Software Foundation, | +-- | Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA | +-- +--------------------------------------------------------------------+ +-- | Creado: mar jun 24 13:56:49 ART 2003 | +-- | Autor: Leandro Lucarella | +-- +--------------------------------------------------------------------+ +-- +-- $Id$ +-- + +CREATE TABLE grupo_secciones ( + grupo INTEGER(11) UNSIGNED NOT NULL default 0 AUTO_INCREMENT, + grupo_padre INTEGER(11) NOT NULL default 0, + nombre VARCHAR(50) NOT NULL default '', + habilitado TINYINT(1) NOT NULL default 1, + antiguedad INTEGER(2) NOT NULL default 0, -- En días + mostrar_hijos TINYINT(1) NOT NULL default 1, + PRIMARY KEY (grupo) +); diff --git a/sql/grupo_secciones_seccion.sql b/sql/grupo_secciones_seccion.sql new file mode 100644 index 0000000..d00eb68 --- /dev/null +++ b/sql/grupo_secciones_seccion.sql @@ -0,0 +1,33 @@ +-- vim: set expandtab tabstop=4 softtabstop=4 shiftwidth=4: +-- +--------------------------------------------------------------------+ +-- | Ministerio de Economía | +-- | AI (Administrador de Intranet) | +-- +--------------------------------------------------------------------+ +-- | This file is part of AI. | +-- | | +-- | AI is free software; you can redistribute it and/or modify | +-- | it under the terms of the GNU General Public License as published | +-- | by the Free Software Foundation; either version 2 of the License, | +-- | or (at your option) any later version. | +-- | | +-- | AI is distributed in the hope that it will be useful, but | +-- | WITHOUT ANY WARRANTY; without even the implied warranty of | +-- | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | +-- | General Public License for more details. | +-- | | +-- | You should have received a copy of the GNU General Public License | +-- | along with Hooks; if not, write to the Free Software Foundation, | +-- | Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA | +-- +--------------------------------------------------------------------+ +-- | Creado: mar jun 24 13:56:49 ART 2003 | +-- | Autor: Leandro Lucarella | +-- +--------------------------------------------------------------------+ +-- +-- $Id$ +-- + +CREATE TABLE grupo_secciones_seccion ( + grupo INTEGER(11) UNSIGNED NOT NULL default 0, + seccion INTEGER(11) NOT NULL default 0, + PRIMARY KEY (grupo, seccion) +); diff --git a/sql/servicio.sql b/sql/servicio.sql new file mode 100644 index 0000000..a0930d3 --- /dev/null +++ b/sql/servicio.sql @@ -0,0 +1,42 @@ +-- vim: set expandtab tabstop=4 softtabstop=4 shiftwidth=4: +-- +--------------------------------------------------------------------+ +-- | Ministerio de Economía | +-- | AI (Administrador de Intranet) | +-- +--------------------------------------------------------------------+ +-- | This file is part of AI. | +-- | | +-- | AI is free software; you can redistribute it and/or modify | +-- | it under the terms of the GNU General Public License as published | +-- | by the Free Software Foundation; either version 2 of the License, | +-- | or (at your option) any later version. | +-- | | +-- | AI is distributed in the hope that it will be useful, but | +-- | WITHOUT ANY WARRANTY; without even the implied warranty of | +-- | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | +-- | General Public License for more details. | +-- | | +-- | You should have received a copy of the GNU General Public License | +-- | along with Hooks; if not, write to the Free Software Foundation, | +-- | Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA | +-- +--------------------------------------------------------------------+ +-- | Creado: mar jun 24 13:49:04 ART 2003 | +-- | Autor: Leandro Lucarella | +-- +--------------------------------------------------------------------+ +-- +-- $Id$ +-- + +CREATE TABLE servicio ( + servicio INTEGER(11) UNSIGNED NOT NULL default 0 AUTO_INCREMENT, + servicio_padre INTEGER(11) NOT NULL default 0, + nombre VARCHAR(50) NOT NULL default '', + icono VARCHAR(255) NOT NULL default '', + link VARCHAR(255) NOT NULL default '', + link_ayuda VARCHAR(255) NOT NULL default '', + descripcion VARCHAR(255) NOT NULL default '', + necesita_logueo TINYINT(1) NOT NULL default 0, + habilitado TINYINT(1) NOT NULL default 1, + -- Para para determinar de que forma se muestran las cosas + -- control VARCHAR(255) NOT NULL default '', + PRIMARY KEY (servicio) +); diff --git a/sql/sistema.sql b/sql/sistema.sql new file mode 100644 index 0000000..d2cc0a5 --- /dev/null +++ b/sql/sistema.sql @@ -0,0 +1,37 @@ +-- vim: set expandtab tabstop=4 softtabstop=4 shiftwidth=4: +-- +--------------------------------------------------------------------+ +-- | Ministerio de Economía | +-- | AI (Administrador de Intranet) | +-- +--------------------------------------------------------------------+ +-- | This file is part of AI. | +-- | | +-- | AI is free software; you can redistribute it and/or modify | +-- | it under the terms of the GNU General Public License as published | +-- | by the Free Software Foundation; either version 2 of the License, | +-- | or (at your option) any later version. | +-- | | +-- | AI is distributed in the hope that it will be useful, but | +-- | WITHOUT ANY WARRANTY; without even the implied warranty of | +-- | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | +-- | General Public License for more details. | +-- | | +-- | You should have received a copy of the GNU General Public License | +-- | along with Hooks; if not, write to the Free Software Foundation, | +-- | Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA | +-- +--------------------------------------------------------------------+ +-- | Creado: mar jun 24 13:56:58 ART 2003 | +-- | Autor: Leandro Lucarella | +-- +--------------------------------------------------------------------+ +-- +-- $Id$ +-- + +CREATE TABLE sistema ( + -- ID del SAMURAI + sistema INTEGER(20) UNSIGNED NOT NULL default 0, + icono VARCHAR(255) NOT NULL default '', + link VARCHAR(255) NOT NULL default '', + link_ayuda VARCHAR(255) NOT NULL default '', + habilitado TINYINT(1) NOT NULL default 1, + PRIMARY KEY (sistema) +); -- 2.43.0