From 987c52c152a00b4361d1175267e602db27fae505 Mon Sep 17 00:00:00 2001 From: Leandro Lucarella Date: Mon, 29 Mar 2004 15:32:26 +0000 Subject: [PATCH 1/1] =?utf8?q?Actualizo=20el=20script=20de=20generaci?= =?utf8?q?=C3=B3n=20del=20MySQL.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- script/instalacion/generacion_base.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/script/instalacion/generacion_base.sql b/script/instalacion/generacion_base.sql index 8004742..2da426e 100644 --- a/script/instalacion/generacion_base.sql +++ b/script/instalacion/generacion_base.sql @@ -4,10 +4,19 @@ -- ------------------------------------------------------ -- Server version 4.0.12-log +-- +-- Current Database: yatta +-- + +CREATE DATABASE /*!32312 IF NOT EXISTS*/ yatta; + +USE yatta; + -- -- Table structure for table `cuotas` -- +DROP TABLE IF EXISTS cuotas; CREATE TABLE cuotas ( login varchar(20) NOT NULL default '', cuota smallint(6) NOT NULL default '0', @@ -18,6 +27,7 @@ CREATE TABLE cuotas ( -- Table structure for table `procesos` -- +DROP TABLE IF EXISTS procesos; CREATE TABLE procesos ( id bigint(20) NOT NULL auto_increment, script varchar(255) NOT NULL default '', @@ -43,6 +53,7 @@ CREATE TABLE procesos ( -- Table structure for table `servidores` -- +DROP TABLE IF EXISTS servidores; CREATE TABLE servidores ( id int(10) NOT NULL auto_increment, nombre varchar(20) NOT NULL default '', @@ -50,3 +61,4 @@ CREATE TABLE servidores ( procesos int(10) default '0', PRIMARY KEY (id) ) TYPE=MyISAM; + -- 2.43.0