Saltar a contenido

MariaDB

Tabla songs

Esta tabla es requerida en el tutorial JDBCSink1

CREATE TABLE `songs` (
  `ids` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
  `album` varchar(100) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
  `duration` varchar(10) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
  `release` int(11) DEFAULT NULL,
  `artist` varchar(50) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
  `type` varchar(25) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
  `filename` varchar(50) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
  `fechreg` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ids`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Tablas albsong1 y albsong2

Estas tablas son requieridas en los tutoriales JDBCSink1 y JDBCSink2

-- Las dos tablas son idénticas pero reciben datos desde conectores diferentes
--
CREATE TABLE `albsong1` (
  `artist` varchar(100) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
  `album` varchar(100) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
  `n` integer NOT NULL,
  `fechreg` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`artist`,`album`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `albsong2` (
  `artist` varchar(100) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
  `album` varchar(100) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
  `n` integer NOT NULL,
  `fechreg` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`artist`,`album`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;