#
# Table structure for table 'tx_lunabamusic_domain_model_song'
#
CREATE TABLE tx_lunabamusic_domain_model_song
(
    uid        INT(11)                  NOT NULL AUTO_INCREMENT,
    pid        INT(11)      DEFAULT '0' NOT NULL,
    tstamp     INT(11)      DEFAULT '0' NOT NULL,
    crdate     INT(11)      DEFAULT '0' NOT NULL,
    cruser_id  INT(11)      DEFAULT '0' NOT NULL,
    deleted    TINYINT(4)   DEFAULT '0' NOT NULL,
    hidden     TINYINT(4)   DEFAULT '0' NOT NULL,
    starttime  INT(11)      DEFAULT '0' NOT NULL,
    endtime    INT(11)      DEFAULT '0' NOT NULL,
    top        INT(11)      DEFAULT '0' NOT NULL,
    title      VARCHAR(255) DEFAULT ''  NOT NULL,
    artist     VARCHAR(255) DEFAULT ''  NOT NULL,
    music_file varchar(255) DEFAULT ''  NOT NULL,
    link       TINYTEXT,
    facebook   TINYTEXT,
    twitter    TINYTEXT,
    youtube    TINYTEXT,
    draugiem   TINYTEXT,
    google     TINYTEXT,
    info       TEXT,

    PRIMARY KEY (uid),
    KEY parent (pid)
);

#
# Table structure for table 'tx_lunabamusic_domain_model_top'
#
CREATE TABLE tx_lunabamusic_domain_model_top (
  uid       INT(11)                 NOT NULL AUTO_INCREMENT,
  pid       INT(11) DEFAULT '0'     NOT NULL,
  tstamp    INT(11) DEFAULT '0'     NOT NULL,
  crdate    INT(11) DEFAULT '0'     NOT NULL,
  cruser_id INT(11) DEFAULT '0'     NOT NULL,
  deleted   TINYINT(4) DEFAULT '0'  NOT NULL,
  hidden    TINYINT(4) DEFAULT '0'  NOT NULL,
  starttime INT(11) DEFAULT '0'     NOT NULL,
  endtime   INT(11) DEFAULT '0'     NOT NULL,
  fe_group  INT(11) DEFAULT '0'     NOT NULL,
  title     VARCHAR(255) DEFAULT '' NOT NULL,

  PRIMARY KEY (uid),
  KEY parent (pid)
);

#
# Table structure for table 'tx_lunabamusic_domain_model_vote'
#
CREATE TABLE tx_lunabamusic_domain_model_vote (
  uid       INT(11)                 NOT NULL AUTO_INCREMENT,
  pid       INT(11) DEFAULT '0'     NOT NULL,
  tstamp    INT(11) DEFAULT '0'     NOT NULL,
  crdate    INT(11) DEFAULT '0'     NOT NULL,
  cruser_id INT(11) DEFAULT '0'     NOT NULL,
  deleted   TINYINT(4) DEFAULT '0'  NOT NULL,
  song_id   INT(11) DEFAULT '0'     NOT NULL,
  voter_ip  VARCHAR(255) DEFAULT '' NOT NULL,

  PRIMARY KEY (uid),
  KEY parent (pid)
);

#
# Table structure for table `tx_lunabamusic_domain_model_play`
#
CREATE TABLE tx_lunabamusic_domain_model_play (
  uid     INT(11)                 NOT NULL AUTO_INCREMENT,
  pid     INT(11)      DEFAULT 0  NOT NULL,
  time    INT(11)      DEFAULT 0  NOT NULL,
  endtime INT(11)      DEFAULT 0  NOT NULL,
  artist  VARCHAR(100) DEFAULT '' NOT NULL,
  title   VARCHAR(100) DEFAULT '' NOT NULL,
  prev    INT(11)      DEFAULT 0  NOT NULL,
  first   INT(11)      DEFAULT 0  NOT NULL,
  checked TINYINT(4)   DEFAULT 0  NOT NULL,
  cron    TINYINT(4)   DEFAULT 0  NOT NULL,

  PRIMARY KEY (uid),
  KEY skantime (time),
  KEY skanartist (artist),
  KEY skantitle (title),
  KEY artisttitle (artist)
);

#
# Table structure for table 'tx_lunabamusic_cache'
#
CREATE TABLE tx_lunabamusic_cache
(
    `id`         INT(11) UNSIGNED DEFAULT 0  NOT NULL AUTO_INCREMENT,
    `crdate`     INT(11)          DEFAULT 0  NOT NULL,
    `identifier` VARCHAR(250)     DEFAULT '' NOT NULL,
    `content`    LONGBLOB         DEFAULT '' NOT NULL,

    PRIMARY KEY (id)
);