DROP TABLE DATA;
CREATE TABLE DATA(
indice VARCHAR(50),
noticia VARCHAR(500),
link VARCHAR(300),
web VARCHAR(300),
usuario VARCHAR(300),
id VARCHAR(300),
fecha VARCHAR(300),
fecha_pub VARCHAR(300),
meneos VARCHAR(30),
clicks VARCHAR(30),
comentarios VARCHAR(300),
votos VARCHAR(30),
votos_anonimos VARCHAR(30),
votos_negativos VARCHAR(30),
karma VARCHAR(30),
sub VARCHAR(300),
extracto TEXT);
create table meneame as
select * from data;
data -> poner motor innodb
meneame -> poner motor MyISAM
-- no funciona ya que hay registros erroneos de origen.
-- pendiente de arreglar
drop if exists TABLE meneame;
CREATE TABLE meneame as
SELECT cast(indice AS INT) id,
noticia,
link,
web,
usuario,
cast(id AS INT) AS id2,
FROM_UNIXTIME(fecha) AS fecha,
FROM_UNIXTIME(fecha_pub) AS fecha_pub,
cast(meneos AS INT) AS meneos,
cast(clicks AS INT) AS clicks,
cast(comentarios AS iNT) AS comentarios,
cast(votos AS INT) AS votos,
cast(votos_anonimos AS INT) AS votos_anonimos,
cast(votos_negativos AS INT) AS votos_negativos,
cast(karma AS INT) AS karma,
sub,
extracto FROM data;