aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorFabio Varesano <fax8@13637.no-reply.drupal.org>2005-08-31 09:14:00 +0000
committerFabio Varesano <fax8@13637.no-reply.drupal.org>2005-08-31 09:14:00 +0000
commitf253ce3c8007ddea27dbf2d8a3fb2ba10e289a06 (patch)
treefd0b737e9ae7e3f7d3da2d0e4f1385d6a9aa9294
parentcdf7a51de9381833b888641c9f881ad7bda3208e (diff)
downloadvideo-f253ce3c8007ddea27dbf2d8a3fb2ba10e289a06.tar.gz
video-f253ce3c8007ddea27dbf2d8a3fb2ba10e289a06.tar.bz2
New db schema for video.module version 1.9
-rw-r--r--video.mysql14
1 files 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