diff options
| author | Fabio Varesano <fax8@13637.no-reply.drupal.org> | 2005-10-28 19:00:26 +0000 |
|---|---|---|
| committer | Fabio Varesano <fax8@13637.no-reply.drupal.org> | 2005-10-28 19:00:26 +0000 |
| commit | 1df2c54de6446ad57f44040ba992e0e84a9f89c3 (patch) | |
| tree | 651f87595147e349631bf72d24d4db9d3d80dbbd | |
| parent | 8a9e38d1c49024b0fdcdde64615b23c20948eb27 (diff) | |
| download | video-1df2c54de6446ad57f44040ba992e0e84a9f89c3.tar.gz video-1df2c54de6446ad57f44040ba992e0e84a9f89c3.tar.bz2 | |
Added $Id$ to track versions.
Added informations on database upgrading from 4.6 to 4.7 scheme.
| -rw-r--r-- | UPGRADE.txt | 31 |
1 files changed, 29 insertions, 2 deletions
diff --git a/UPGRADE.txt b/UPGRADE.txt index 1844408..f347e0f 100644 --- a/UPGRADE.txt +++ b/UPGRADE.txt @@ -1,15 +1,42 @@ +// $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) NOT NULL default '0'; -ALTER TABLE video ADD use_play_folder tinyint(1) NOT NULL default '0'; +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; |