friendly Drupal 4.7 upgrade path

1 files changed, 129 insertions, 0 deletions

diff --git a/video.install b/video.install
new file mode 100644
index 0000000..98a628d
--- /dev/null
+++ b/video.install
@@ -0,0 +1,129 @@
+<?php
+// $Id$
+
+function video_install() {
+  switch ($GLOBALS['db_type']) {
+    case 'mysql':
+    case 'mysqli':
+      db_query("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' /*!40100 DEFAULT CHARACTER SET utf8 */;");
+  }
+}
+
+/**
+ * Add audio details
+ *
+ * @return array
+ */
+function video_update_1() {
+  $ret = array();
+  switch ($GLOBALS['db_type']) {
+    case 'mysql':
+    case 'mysqli':
+      $ret[] = update_sql("ALTER TABLE {video} CHANGE videox videox smallint(4) NOT NULL default '0'");
+      $ret[] = update_sql("ALTER TABLE {video} CHANGE videoy videoy smallint(4) NOT NULL default '0'");
+      $ret[] = update_sql('ALTER TABLE {video} CHANGE size size bigint(13) default NULL');
+      $ret[] = update_sql('ALTER TABLE {video} ADD video_bitrate int(11) default NULL');
+      $ret[] = update_sql('ALTER TABLE {video} ADD audio_bitrate int(11) default NULL');
+      $ret[] = update_sql('ALTER TABLE {video} ADD audio_sampling_rate int(11) default NULL');
+      $ret[] = update_sql("ALTER TABLE {video} ADD audio_channels enum('','stereo','mono') default NULL");
+      $ret[] = update_sql('ALTER TABLE {video} ADD playtime_seconds int(11) default NULL');
+  }
+  return $ret;
+}
+
+/**
+ * Rename counter, add custom fields, for video.module version 1.9
+ *
+ * @return array
+ */
+function video_update_2() {
+  $ret = array();
+  switch ($GLOBALS['db_type']) {
+    case 'mysql':
+    case 'mysqli':
+      $ret[] = update_sql("ALTER TABLE {video} CHANGE clicks download_counter int(10) unsigned NOT NULL default '0'");
+      $ret[] = update_sql("ALTER TABLE {video} ADD play_counter int(10) unsigned NOT NULL default '0' AFTER download_counter");
+      $ret[] = update_sql("ALTER TABLE {video} CHANGE audio_channels audio_channels enum('','5.1','stereo','mono') default NULL");
+      $ret[] = update_sql('ALTER TABLE {video} ADD download_folder varchar(255) NULL default NULL');
+      $ret[] = update_sql("ALTER TABLE {video} ADD disable_multidownload tinyint(1) NOT NULL default '0'");
+      $ret[] = update_sql("ALTER TABLE {video} ADD use_play_folder tinyint(1) NOT NULL default '0'");
+      $ret[] = update_sql('ALTER TABLE {video} ADD custom_field_1 varchar(255) NULL default NULL');
+      $ret[] = update_sql('ALTER TABLE {video} ADD custom_field_2 varchar(255) NULL default NULL');
+      $ret[] = update_sql('ALTER TABLE {video} ADD custom_field_3 varchar(255) NULL default NULL');
+      $ret[] = update_sql('ALTER TABLE {video} ADD custom_field_4 varchar(255) NULL default NULL');
+      $ret[] = update_sql('ALTER TABLE {video} ADD custom_field_5 text NULL default NULL');
+      $ret[] = update_sql('ALTER TABLE {video} ADD custom_field_6 text NULL default NULL');
+  }
+  return $ret;
+}
+
+/**
+ * Add unsigned to all int fields
+ *
+ * @return array
+ */
+function video_update_3() {
+  $ret = array();
+  switch ($GLOBALS['db_type']) {
+    case 'mysql':
+    case 'mysqli':
+      $ret[] = update_sql("ALTER TABLE {video} CHANGE videox videox smallint(4) unsigned NOT NULL default '0'");
+      $ret[] = update_sql("ALTER TABLE {video} CHANGE videoy videoy smallint(4) unsigned NOT NULL default '0'");
+      $ret[] = update_sql('ALTER TABLE {video} CHANGE size size bigint(13) unsigned default NULL');
+      $ret[] = update_sql('ALTER TABLE {video} CHANGE video_bitrate video_bitrate int(11) unsigned default NULL');
+      $ret[] = update_sql('ALTER TABLE {video} CHANGE audio_bitrate audio_bitrate int(11) unsigned default NULL');
+      $ret[] = update_sql('ALTER TABLE {video} CHANGE audio_sampling_rate audio_sampling_rate int(11) unsigned default NULL');
+      $ret[] = update_sql('ALTER TABLE {video} CHANGE playtime_seconds playtime_seconds int(11) unsigned default NULL');
+      $ret[] = update_sql("ALTER TABLE {video} CHANGE disable_multidownload disable_multidownload tinyint(1) unsigned NOT NULL default '0'");
+      $ret[] = update_sql("ALTER TABLE {video} CHANGE use_play_folder use_play_folder tinyint(1) unsigned NOT NULL default '0'");
+  }
+  return $ret;
+}
+
+/**
+ * Start of Drupal 4.7 support in video.module issue #40005, version 1.25
+ * updated revisions, db schema, forms api, form validation, permissions, added .swf and image support
+ *
+ * @return array
+ */
+function video_update_4() {
+  $ret = array();
+  switch ($GLOBALS['db_type']) {
+    case 'mysql':
+    case 'mysqli':
+      $ret[] = update_sql("ALTER TABLE {video} ADD vid int(10) unsigned NOT NULL default '0' FIRST");
+      $ret[] = update_sql('UPDATE {video} SET vid = nid');
+      $ret[] = update_sql('ALTER TABLE {video} CHANGE video_bitrate video_bitrate int(10) unsigned default NULL');
+      $ret[] = update_sql('ALTER TABLE {video} CHANGE audio_bitrate audio_bitrate int(10) unsigned default NULL');
+      $ret[] = update_sql('ALTER TABLE {video} CHANGE audio_sampling_rate audio_sampling_rate int(10) unsigned default NULL');
+      $ret[] = update_sql('ALTER TABLE {video} CHANGE playtime_seconds playtime_seconds int(10) unsigned default NULL');
+      $ret[] = update_sql('ALTER TABLE {video} ADD serialized_data text NULL default NULL');
+      $ret[] = update_sql('ALTER TABLE {video} DROP PRIMARY KEY, ADD PRIMARY KEY ( `vid` )');
+  }
+  return $ret;
+}