songlist |
songlist_albums
songlist_artists
songlist_category
songlist_extra
songlist_field
songlist_songs
songlist_visibility
songlist_votes
songlist_albums |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
abid |
int(10) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
cid |
int(10) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
aids |
mediumtext |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
sids |
mediumtext |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
title |
varchar(128) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
image |
varchar(128) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
path |
varchar(128) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
artists |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
songs |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
hits |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
rank |
decimal(10,3) unsigned |
(NULL) |
YES |
|
0.000 |
|
select,insert,update,references |
|
votes |
int(10) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
created |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
updated |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
Indexes |
Back
songlist_artists |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
aid |
int(10) unsigned |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
cid |
int(10) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
name |
varchar(128) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
albums |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
songs |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
rank |
decimal(10,3) unsigned |
(NULL) |
YES |
|
0.000 |
|
select,insert,update,references |
|
votes |
int(10) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
created |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
updated |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
Indexes |
Back
songlist_category |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
cid |
int(10) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
pid |
int(10) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
weight |
int(10) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
name |
varchar(128) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
description |
mediumtext |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
image |
varchar(128) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
path |
varchar(128) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
artists |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
albums |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
songs |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
rank |
decimal(10,3) unsigned |
(NULL) |
YES |
|
0.000 |
|
select,insert,update,references |
|
votes |
int(10) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
hits |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
created |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
updated |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment | Index comment |
songlist_category |
0 |
PRIMARY |
1 |
cid |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back
songlist_extra |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
sid |
int(12) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment | Index comment |
songlist_extra |
0 |
PRIMARY |
1 |
sid |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back
songlist_field |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
field_id |
int(12) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
cids |
mediumtext |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
field_type |
varchar(30) |
utf8_general_ci |
NO |
|
|
|
select,insert,update,references |
|
field_valuetype |
tinyint(2) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
field_name |
varchar(255) |
utf8_general_ci |
NO |
|
|
|
select,insert,update,references |
|
field_title |
varchar(255) |
utf8_general_ci |
NO |
|
|
|
select,insert,update,references |
|
field_description |
text |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
field_required |
tinyint(1) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
field_maxlength |
smallint(6) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
field_weight |
smallint(6) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
field_default |
text |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
field_notnull |
tinyint(1) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
field_edit |
tinyint(1) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
field_show |
tinyint(1) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
field_config |
tinyint(1) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
field_options |
text |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment | Index comment |
songlist_field |
0 |
PRIMARY |
1 |
field_id |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back
songlist_songs |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
sid |
int(12) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
cid |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
aids |
mediumtext |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
abid |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
songid |
varchar(32) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
title |
varchar(128) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
lyrics |
mediumtext |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
hits |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
rank |
decimal(10,3) unsigned |
(NULL) |
YES |
|
0.000 |
|
select,insert,update,references |
|
votes |
int(10) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
tags |
varchar(255) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
created |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
updated |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment | Index comment |
songlist_songs |
0 |
PRIMARY |
1 |
sid |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back
songlist_visibility |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
field_id |
int(12) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
user_group |
smallint(5) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
profile_group |
smallint(5) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment | Index comment |
songlist_visibility |
0 |
PRIMARY |
1 |
field_id |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
songlist_visibility |
0 |
PRIMARY |
2 |
user_group |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
songlist_visibility |
0 |
PRIMARY |
3 |
profile_group |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
songlist_visibility |
1 |
visible |
1 |
user_group |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
songlist_visibility |
1 |
visible |
2 |
profile_group |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back
songlist_votes |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
vid |
int(23) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
sid |
int(10) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
uid |
int(12) unsigned |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
ip |
varchar(64) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
netaddy |
varchar(255) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
rank |
decimal(10,3) unsigned |
(NULL) |
YES |
|
0.000 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment | Index comment |
songlist_votes |
0 |
PRIMARY |
1 |
vid |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back