Table music genre

From Zen Cart(tm) Wiki
Revision as of 13:10, 8 September 2006 by Allcanadiansearch.ca (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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