From f253ce3c8007ddea27dbf2d8a3fb2ba10e289a06 Mon Sep 17 00:00:00 2001 From: Fabio Varesano Date: Wed, 31 Aug 2005 09:14:00 +0000 Subject: New db schema for video.module version 1.9 --- video.mysql | 14 ++++++++++++-- 1 file changed, 12 insertions(+), 2 deletions(-) diff --git a/video.mysql b/video.mysql index 0ef123b..a1ebf0e 100644 --- a/video.mysql +++ b/video.mysql @@ -4,11 +4,21 @@ CREATE TABLE video ( 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', + download_counter int(10) unsigned NOT NULL default '0', + play_counter 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, + audio_channels enum('','5.1','stereo','mono') default NULL, playtime_seconds int(11) default NULL, + download_folder varchar(255) NULL default NULL, + disable_multidownload tinyint(1) NOT NULL default '0', + use_play_folder tinyint(1) NOT NULL default '0', + custom_field_1 varchar(255) NULL default NULL, + custom_field_2 varchar(255) NULL default NULL, + custom_field_3 varchar(255) NULL default NULL, + custom_field_4 varchar(255) NULL default NULL, + custom_field_5 text NULL default NULL, + custom_field_6 text NULL default NULL, PRIMARY KEY (nid) ) TYPE=MyISAM COMMENT='size is in bytes'; \ No newline at end of file -- cgit v1.2.3