-- recrear la tabla dime
DROP TABLE dime;
CREATE TABLE  dime  (
   dime_id  mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
    primera_fecha  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   fecha  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   script  varchar(256)  NOT NULL,
   dime  longtext ,
   linea  smallint(5) unsigned NOT NULL DEFAULT '0',
   tipo  varchar(6) NOT NULL DEFAULT '',
   usuario  varchar(32)  NOT NULL,
  PRIMARY KEY ( dime_id ),
  UNIQUE KEY  reprotador  ( script , linea , tipo )
) ENGINE=MyISAM;


 ALTER TABLE cuentat_transfer
 	ADD COLUMN revisado  enum('No Aplica','Por revisar','Revisado') COLLATE latin1_spanish_ci NOT NULL DEFAULT 'No Aplica',
 	ADD COLUMN revisado_el  timestamp NULL DEFAULT NULL;
CREATE INDEX para_avisos ON cuentat_transfer(revisado);
