Table media clips

• 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 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

A unique, auto incremented value, to identify each media clip record.

Type:	int(11)
Null:	No
Default:
Extra:	auto_increment

media_id

Cross-reference link to the media_types table.

Type:	int(11)
Null:	No
Default:	0

clip_type

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