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
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
|
// $Id$
INSTALL INSTRUCTIONS FOR VIDEO.MODULE
-------------------------------------
- Copy video folder to modules/
- Login as site administrator
- Activate video.module as usual (administer->modules)
- Set access control as you like (administer->access control)
- (optional) Activate video.module blocks (administer->blocks)
UPGRADING FROM DRUPAL 4.7 to CVS
--------------------------------
The upgrade process is automated by the video.install file, so
be sure you have the correct version of video.install to match
the version of video.module you intend to use. If you downloaded
a tarball of Video from drupal.org and over-wrote everything in
your Video module directory, you should be fine.
Run the update.php script that comes in the Drupal distribution
http://www.example.com/update.php
UPGRADING FROM 4.6 OR 4.6 CVS
-----------------------------
Starting in Drupal 4.7, the video module has an automated upgrade.
If you installed and used the stable video 4.6 release, the
update.php script that upgrades Drupal will also update the
video database schema. http://www.example.com/update.php
If you decided to use a CVS version of Video for Drupal 4.6, you
can still take advantage of the automated ugprade, but you will
need to select an update version number when you run update.php.
The following is a key of upgrade version numbers for Video CVS
database schemas between the Drupal 4.6 and Drupal 4.7
changes. When you find a database schema that matches your
existing schema, select the corresponding update.php version
number when you run update.php. You can get your current database
schema by looking at the old video.mysql file you used to create
your video table or execute the following SQL query:
`DESCRIBE video;`
Some differences between versions are subtle, but important, so
make sure you verify your video table is an actual fit, not just
"close enough".
VIDEO UPDATE.PHP VERSION 2
--------------------------
CREATE TABLE video (
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';
VIDEO UPDATE.PHP VERSION 3
--------------------------
CREATE TABLE video (
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,
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('','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';
VIDEO UPDATE.PHP VERSION 4
--------------------------
-- $Id$
CREATE TABLE video (
nid int(10) unsigned NOT NULL default '0',
vidfile text NOT NULL default '',
videox smallint(4) unsigned NOT NULL default '0',
videoy smallint(4) unsigned NOT NULL default '0',
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,
audio_channels enum('','5.1','stereo','mono') default NULL,
playtime_seconds int(11) 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',
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';
VIDEO UPDATE.PHP VERSION 5
--------------------------
-- $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',
videoy smallint(4) unsigned NOT NULL default '0',
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(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(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',
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,
serialized_data text NULL default NULL,
PRIMARY KEY (vid)
) TYPE=MyISAM COMMENT='size is in bytes';
VIDEO UPDATE.PHP VERSION 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',
videoy smallint(4) unsigned NOT NULL default '0',
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(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(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',
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,
serialized_data text NULL default NULL,
PRIMARY KEY (vid)
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;
|
