Table music genre

From Zen Cart(tm) Wiki

Contents 1 Database Version 2 Description 3 Table Details 3.1 Primary Key 3.2 Indexed Fields 4 Columns 4.1 music_genre_id 4.2 music_genre_name 4.3 date_added 4.4 last_modified 5 Default Entries

Database Version

1.3.5

Description

Stores the details of all the music genres that have been configured and made available.

Table Details

Primary Key

music_genre_id

Indexed Fields

music_genre_name

Columns

music_genre_id

A unique, auto incremented value, to identify each music genre record.

Type:	int(11)
Null:	No
Default:
Extra:	auto_increment

music_genre_name

The name of the music genre.

Type:	varchar(32)
Null:	No
Default:

date_added

The date and time the music genre record was first added.

Type:	datetime
Null:	Yes
Default:	NULL

last_modified

The date and time the music genre record was last modified.

Type:	datetime
Null:	Yes
Default:	NULL

Default Entries

music_genre_id:	1
music_genre_name:	Rock
date_added:	2004-06-01 20:53:26
last_modified:	NULL

music_genre_id:	2
music_genre_name:	Jazz
date_added:	2004-06-01 20:53:45
last_modified:	NULL