Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #REVISO SI EXISTE LA TABLA
- SELECT table_name
- FROM information_schema.tables
- WHERE table_schema = 'senu'
- AND table_name = 'abono';
- #EL SELECT NO RETORNA NADA
- #CREO LA TABLA
- SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
- SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
- SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
- CREATE TABLE IF NOT EXISTS `senu`.`abono` (
- `id` INT(11) NOT NULL AUTO_INCREMENT ,
- `nfact` INT(11) NOT NULL ,
- `fecha` DATETIME NULL DEFAULT NULL ,
- `abono` DECIMAL(19,4) NULL DEFAULT NULL ,
- PRIMARY KEY (`id`) ,
- CONSTRAINT `fk_abono_factura1`
- FOREIGN KEY (`nfact` )
- REFERENCES `senu`.`factura` (`nfact` )
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB
- DEFAULT CHARACTER SET = latin1
- COLLATE = latin1_swedish_ci;
- SET SQL_MODE=@OLD_SQL_MODE;
- SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
- SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
- #RETORNA: ERROR: Error 1050: Table '`senu`.`abono`' already exists
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement