Advertisement
christiansalazarh

demo1-sql

Aug 29th, 2013
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.78 KB | None | 0 0
  1. SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
  2. SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
  3. SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
  4.  
  5. -- -----------------------------------------------------
  6. -- Table `dscampanametro`
  7. -- -----------------------------------------------------
  8. DROP TABLE IF EXISTS `dscampanametro` ;
  9.  
  10. CREATE  TABLE IF NOT EXISTS `dscampanametro` (
  11.   `cedula` CHAR(11) NOT NULL ,
  12.   `nombres` VARCHAR(100) NULL ,
  13.   `direccion` VARCHAR(100) NULL ,
  14.   `telefono` VARCHAR(100) NULL ,
  15.   `fecha_act` CHAR(16) NULL ,
  16.   `cuotas` BLOB NULL ,
  17.   PRIMARY KEY (`cedula`) )
  18. ENGINE = InnoDB;
  19.  
  20. SET SQL_MODE=@OLD_SQL_MODE;
  21. SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
  22. SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement