From: Leandro Lucarella Date: Mon, 29 Mar 2004 15:32:26 +0000 (+0000) Subject: Actualizo el script de generaciĆ³n del MySQL. X-Git-Tag: svn_import~29 X-Git-Url: https://git.llucax.com/mecon/yatta.git/commitdiff_plain/987c52c152a00b4361d1175267e602db27fae505?hp=da57f3c2acc48c5d0f0ff068599eef7ddf488388 Actualizo el script de generaciĆ³n del MySQL. --- 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; +