diff options
| -rw-r--r-- | video.mysql | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/video.mysql b/video.mysql index e36af20..c47dafb 100644 --- a/video.mysql +++ b/video.mysql @@ -1,5 +1,6 @@ -- $Id$ CREATE TABLE video ( + vid int(10) unsigned NOT NULL default '0', nid int(10) unsigned NOT NULL default '0', vidfile text NOT NULL default '', videox smallint(4) unsigned NOT NULL default '0', @@ -7,11 +8,11 @@ CREATE TABLE video ( size bigint(13) unsigned default NULL, download_counter int(10) unsigned NOT NULL default '0', play_counter int(10) unsigned NOT NULL default '0', - video_bitrate int(11) unsigned default NULL, - audio_bitrate int(11) unsigned default NULL, - audio_sampling_rate int(11) unsigned default NULL, + video_bitrate int(10) unsigned default NULL, + audio_bitrate int(10) unsigned default NULL, + audio_sampling_rate int(10) unsigned default NULL, audio_channels enum('','5.1','stereo','mono') default NULL, - playtime_seconds int(11) unsigned default NULL, + playtime_seconds int(10) unsigned default NULL, download_folder varchar(255) NULL default NULL, disable_multidownload tinyint(1) unsigned NOT NULL default '0', use_play_folder tinyint(1) unsigned NOT NULL default '0', @@ -21,5 +22,6 @@ CREATE TABLE video ( custom_field_4 varchar(255) NULL default NULL, custom_field_5 text NULL default NULL, custom_field_6 text NULL default NULL, + serialized_data text NULL default NULL, PRIMARY KEY (nid) -) TYPE=MyISAM COMMENT='size is in bytes';
\ No newline at end of file +) TYPE=MyISAM COMMENT='size is in bytes'; |