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;
|
