Table media manager

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

Database version

1.3.0.2


Description

Stores the media-collections information, linking music-types, music-clips, and products so that clip info can be displayed on the product-info page.


Table Details

Primary Key

media_id

Indexed Fields

None.


Columns

media_id Primary Key

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


media_name

The name of the media collection.
Type: varchar(255)
Null: No
Default:


last_modified

The date and time the record was last modified.
Type: datetime
Null: No
Default: 0001-01-01 00:00:00


date_added

The date and time the record was first added.
Type: datetime
Null: No
Default: 0001-01-01 00:00:00


Default Entries

media_id: 1
media_name: Russ Tippins - The Hunter
last_modified: 2004-06-01 20:57:43
date_added: 2004-06-01 20:42:53


media_id: 2
media_name: Help!
last_modified: 2004-07-13 01:01:14
date_added: 2004-07-12 17:57:45