diff options
author | David Norman <drupal@deekayen.net> | 2005-07-02 07:01:34 +0000 |
---|---|---|
committer | David Norman <drupal@deekayen.net> | 2005-07-02 07:01:34 +0000 |
commit | cce4df5a5631c9c1a96922baa116908357cd3e5c (patch) | |
tree | a9a3c046a148400819843818dd441b610aee2962 /video.mysql | |
parent | 96cc8c7cb96a9a92df114e1aa61acfd1ce26e0d1 (diff) | |
download | video-cce4df5a5631c9c1a96922baa116908357cd3e5c.tar.gz video-cce4df5a5631c9c1a96922baa116908357cd3e5c.tar.bz2 |
Add RM, FLV, & WMV support; configuration for displaying play/download links; new fields for metadata; filesize & playtime; documentation; code cleanup
Diffstat (limited to 'video.mysql')
-rw-r--r-- | video.mysql | 22 |
1 files changed, 13 insertions, 9 deletions
diff --git a/video.mysql b/video.mysql index 1ea6af5..0ef123b 100644 --- a/video.mysql +++ b/video.mysql @@ -1,10 +1,14 @@ CREATE TABLE video ( -nid int(10) unsigned NOT NULL default '0', -vidfile text NOT NULL default '', -videox int(4) NOT NULL default '', -videoy int(4) NOT NULL default '', -size varchar(30) NOT NULL default '', -clicks int(10) unsigned NOT NULL default '0', -PRIMARY KEY (nid) -); - + nid int(10) unsigned NOT NULL default '0', + vidfile text NOT NULL, + videox smallint(4) NOT NULL default '0', + videoy smallint(4) NOT NULL default '0', + size bigint(13) default NULL, + clicks int(10) unsigned NOT NULL default '0', + video_bitrate int(11) default NULL, + audio_bitrate int(11) default NULL, + audio_sampling_rate int(11) default NULL, + audio_channels enum('','stereo','mono') default NULL, + playtime_seconds int(11) default NULL, + PRIMARY KEY (nid) +) TYPE=MyISAM COMMENT='size is in bytes';
\ No newline at end of file |