From cce4df5a5631c9c1a96922baa116908357cd3e5c Mon Sep 17 00:00:00 2001
From: David Norman <drupal@deekayen.net>
Date: Sat, 2 Jul 2005 07:01:34 +0000
Subject: Add RM, FLV,  & WMV support; configuration for displaying
 play/download links; new fields for metadata; filesize & playtime;
 documentation; code cleanup

---
 video.mysql | 22 +++++++++++++---------
 1 file changed, 13 insertions(+), 9 deletions(-)

(limited to 'video.mysql')

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
-- 
cgit v1.2.3