ext_tables.sql 3.19 KB
Newer Older
Dainis Abols's avatar
Dainis Abols committed
1
2
3
#
# Table structure for table 'tx_lunabamusic_domain_model_song'
#
Dainis Abols's avatar
Dainis Abols committed
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
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,
Dainis Abols's avatar
Dainis Abols committed
26

Dainis Abols's avatar
Dainis Abols committed
27
28
    PRIMARY KEY (uid),
    KEY parent (pid)
Dainis Abols's avatar
Dainis Abols committed
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
);

#
# 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,
75
  endtime INT(11)      DEFAULT 0  NOT NULL,
Dainis Abols's avatar
Dainis Abols committed
76
77
78
79
80
81
82
83
84
85
86
87
88
  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)
);
89
90
91
92
93
94
95
96
97
98
99
100
101

#
# 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)
);