songlist

 

 
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