Author: hsanchez Date: 2007-02-28 17:17:38 -0300 (Wed, 28 Feb 2007) New Revision: 4345 Modified: prosistem/alba/trunk/alba/data/sql/actualizacion_1.0b_a_1.0rc.sql Log: Alter de los id para la base tipiva Modified: prosistem/alba/trunk/alba/data/sql/actualizacion_1.0b_a_1.0rc.sql =================================================================== --- prosistem/alba/trunk/alba/data/sql/actualizacion_1.0b_a_1.0rc.sql 2007-02-28 20:16:04 UTC (rev 4344) +++ prosistem/alba/trunk/alba/data/sql/actualizacion_1.0b_a_1.0rc.sql 2007-02-28 20:17:38 UTC (rev 4345) @@ -1,6 +1,7 @@ SET CHARACTER SET utf8; SET FOREIGN_KEY_CHECKS = 0; +update tipoiva set id=4 where id=3;update tipoiva set id=3 where id=2;update tipoiva set id=2 where id=1;update tipoiva set id=1 where id=0; ALTER TABLE `tipoiva` CHANGE `id` `id` INT( 11 ) NOT NULL AUTO_INCREMENT ; ALTER TABLE `responsable` ADD `observacion` VARCHAR( 255 ) NULL AFTER `relacion` ;