From 7767a1b6b4731007b1a41b285792dc61d76d3047 Mon Sep 17 00:00:00 2001 From: David Norman Date: Thu, 20 Apr 2006 20:07:36 +0000 Subject: New upgrade process for 4.7 --- INSTALL.txt | 189 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++--- 1 file changed, 182 insertions(+), 7 deletions(-) (limited to 'INSTALL.txt') diff --git a/INSTALL.txt b/INSTALL.txt index 5b51cd0..b47cff8 100644 --- a/INSTALL.txt +++ b/INSTALL.txt @@ -1,14 +1,189 @@ // $Id$ INSTALL INSTRUCTIONS FOR VIDEO.MODULE ----- +------------------------------------- -1-Copy video folder to modules/ -2-Create database table using video.mysql file -3-Login as site administrator -4-Activate video.module as usual (administer->modules) -5-Set access control as you like (administer->access control) -6-(optional) Activate video.module blocks (administer->blocks) +- 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 */; \ No newline at end of file -- cgit v1.2.3