Se agrega scripts SQL para crear las bases.

diff --git a/sql/grupo_secciones.sql b/sql/grupo_secciones.sql
new file mode 100644 (file)
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 <llucar@mecon.gov.ar>                    |
+-- +--------------------------------------------------------------------+
+--
+-- $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 (file)
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 <llucar@mecon.gov.ar>                    |
+-- +--------------------------------------------------------------------+
+--
+-- $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 (file)
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 <llucar@mecon.gov.ar>                    |
+-- +--------------------------------------------------------------------+
+--
+-- $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 (file)
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 <llucar@mecon.gov.ar>                    |
+-- +--------------------------------------------------------------------+
+--
+-- $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)
+);