[CVS] openbash-org openbash-org.mysql,1.5,1.6

[Juan C. D. R. <hn...@us...>]

Update of /cvsroot/openbash-org/openbash-org
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv6206

Modified Files:
	openbash-org.mysql 
Log Message:

 -- Añadidos INSERTs por defecto en las tablas `users` y `roles`
 -- Eliminado el campo id de la tabla `config`
 -- Corregidos varios 'typos' de formateo
 


Index: openbash-org.mysql
===================================================================
RCS file: /cvsroot/openbash-org/openbash-org/openbash-org.mysql,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** openbash-org.mysql	30 Jul 2004 16:24:40 -0000	1.5
--- openbash-org.mysql	12 Aug 2004 06:39:51 -0000	1.6
***************
*** 9,13 ****
  `purge` INT DEFAULT '0' NOT NULL ,
  `author` VARCHAR( 100 ) NOT NULL ,
! `pending` BOOL DEFAULT 1 NOT NULL,
  `ip` VARCHAR ( 12 ) NOT NULL ,
  PRIMARY KEY ( `id` )
--- 9,13 ----
  `purge` INT DEFAULT '0' NOT NULL ,
  `author` VARCHAR( 100 ) NOT NULL ,
! `pending` BOOL DEFAULT 1 NOT NULL ,
  `ip` VARCHAR ( 12 ) NOT NULL ,
  PRIMARY KEY ( `id` )
***************
*** 32,35 ****
--- 32,37 ----
  ) TYPE = InnoDB;
  
+ INSERT INTO `users` VALUES ('admin', '', 1);
+ INSERT INTO `users` VALUES ('moderator', '', 2);
  
  CREATE TABLE `roles` (
***************
*** 39,48 ****
  ) TYPE = InnoDB;
  
  
  CREATE TABLE `config` (
- `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `vble` VARCHAR( 255 ) ,
! `value` VARCHAR( 255) ,
! PRIMARY KEY ( `id` )
  ) TYPE = InnoDB;
  
--- 41,51 ----
  ) TYPE = InnoDB;
  
+ INSERT INTO `roles` VALUES (1, 'admin'); 
+ INSERT INTO `roles` VALUES (2, 'moderator'); 
  
  CREATE TABLE `config` (
  `vble` VARCHAR( 255 ) ,
! `value` VARCHAR( 255 ) ,
! PRIMARY KEY ( `vble` )
  ) TYPE = InnoDB;