Table media clips

From Zen Cart(tm) Wiki
Revision as of 13:02, 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 media-clips that have been configured and made available to music-type products.


Table Details

Primary Key

clip_id

Indexed Fields

media_id
clip_type


Columns

clip_id Primary Key

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


media_id Index

Cross-reference link to the media_types table.
Type: int(11)
Null: No
Default: 0


clip_type Index

Cross-reference link to the media_types table.
Type: smallint(6)
Null: No
Default: 0


clip_filename

The filename of the media clip.
Type: text
Null: No
Default:


date_added

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


last_modified

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


Default Entries

clip_id: 1
media_id: 1
clip_type: 1
clip_filename: thehunter.mp3
date_added: 2004-06-01 20:57:43
last_modified: 0000-00-00 00:00:00


clip_id: 6
media_id: 2
clip_type: 1
clip_filename: thehunter.mp3
date_added: 2004-07-13 00:45:09
last_modified: 0000-00-00 00:00:00