Table media manager

• Introduction
• Resources | Standards

• Database
• Schema

• Developers API
• Resources | Overrides |
• Tutorials

• Modules
• Overview | Payment |
• Shipping | Order Total

• Miscellaneous
• Security | XML Schemas |
• Porting modules from osC | Manually entering products

Database version

1.3.5

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

media_name

Columns

media_id

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