Table music genre

From Zen Cart(tm) Wiki
Jump to: navigation, search

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 Primary Key

A unique, auto incremented value, to identify each music genre record.
Type: int(11)
Null: No
Default:
Extra: auto_increment


music_genre_name Index

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