1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
// $Id$
UPGRADING FROM 4.6 TO 4.7
1 - Backup your database and your drupal directory
2 - Using your favorite mysql client run the following SQL queries:
If upgrading from video.module for drupal 4.6:
ALTER TABLE `video`
CHANGE `videox` `videox` smallint(4) unsigned NOT NULL default '0',
CHANGE `videoy` `videoy` smallint(4) unsigned NOT NULL default '0',
CHANGE `size` `size` bigint(13) unsigned default NULL,
CHANGE `clicks` `download_counter` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
ADD play_counter int(10) unsigned NOT NULL default '0',
ADD video_bitrate int(11) unsigned default NULL,
ADD audio_bitrate int(11) unsigned default NULL,
ADD audio_sampling_rate int(11) unsigned default NULL,
ADD audio_channels enum('','5.1','stereo','mono') default NULL,
ADD playtime_seconds int(11) unsigned default NULL,
ADD download_folder varchar(255) NULL default NULL,
ADD disable_multidownload tinyint(1) unsigned NOT NULL default '0',
ADD use_play_folder tinyint(1) unsigned NOT NULL default '0',
ADD custom_field_1 varchar(255) NULL default NULL,
ADD custom_field_2 varchar(255) NULL default NULL,
ADD custom_field_3 varchar(255) NULL default NULL,
ADD custom_field_4 varchar(255) NULL default NULL,
ADD custom_field_5 varchar(255) NULL default NULL,
ADD custom_field_6 varchar(255) NULL default NULL
;
If upgrading from video.module v1.8 database scheme:
ALTER TABLE `video` CHANGE `clicks` `download_counter` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `video` CHANGE `audio_channels` `audio_channels` ENUM( '', '5.1', 'stereo', 'mono' ) NULL DEFAULT NULL;
ALTER TABLE video ADD play_counter int(10) unsigned NOT NULL default '0';
ALTER TABLE video ADD download_folder varchar(255) NULL default NULL;
ALTER TABLE video ADD disable_multidownload tinyint(1) unsigned NOT NULL default '0';
ALTER TABLE video ADD use_play_folder tinyint(1) unsigned NOT NULL default '0';
ALTER TABLE video ADD custom_field_1 varchar(255) NULL default NULL;
ALTER TABLE video ADD custom_field_2 varchar(255) NULL default NULL;
ALTER TABLE video ADD custom_field_3 varchar(255) NULL default NULL;
ALTER TABLE video ADD custom_field_4 varchar(255) NULL default NULL;
ALTER TABLE video ADD custom_field_5 text NULL default NULL;
ALTER TABLE video ADD custom_field_6 text NULL default NULL;
3 - Replace video.module file for 4.6 with video.module for 4.7
4 - Your video.module installation is upgraded
5 - Report any problems to
Fabio Varesano - fvaresano at yahoo dot it
or
Luke Last - luke [at] lukelast dot com
|