1 files changed, 135 insertions, 0 deletions
diff --git a/plugins/video_zencoder/video_zencoder.install b/plugins/video_zencoder/video_zencoder.install
new file mode 100644
index 0000000..a418815
--- /dev/null
+++ b/plugins/video_zencoder/video_zencoder.install
@@ -0,0 +1,135 @@
+<?php
+
+// $Id$
+
+/**
+ * @file
+ * Provides installation functions for video_s3.module.
+ */
+
+/**
+ * Implementation of hook_schema().
+ */
+function video_zencoder_schema() {
+  $schema['video_zencoder'] = array(
+    'description' => t('Store video s3 cdn and convert with zencoder webservice'),
+    'fields' => array(
+      'vid' => array(
+        'description' => t('Auto Increment id'),
+        'type' => 'serial',
+        'unsigned' => TRUE,
+        'not null' => TRUE,
+      ),
+      'fid' => array(
+        'description' => t('Original file id'),
+        'type' => 'int',
+        'unsigned' => TRUE,
+        'not null' => TRUE,
+        'default' => 0,
+      ),
+      'nid' => array(
+        'description' => t('Node id'),
+        'type' => 'int',
+        'unsigned' => TRUE,
+        'not null' => TRUE,
+        'default' => 0,
+      ),
+      'jobid' => array(
+        'description' => t('Job id'),
+        'type' => 'int',
+        'unsigned' => TRUE,
+        'not null' => TRUE,
+        'default' => 0,
+      ),
+      'status' => array(
+        'description' => t('Status of the cdn transfer'),
+        'type' => 'int',
+        'unsigned' => TRUE,
+        'not null' => TRUE,
+        'default' => 0,
+      ),
+      'dimensions' => array(
+        'type' => 'varchar',
+        'length' => '255',
+        'default' => '',
+        'description' => t('The dimensions of the video.'),
+      ),
+      'completed' => array(
+        'description' => t('Time of successful completion to amazon.'),
+        'type' => 'int',
+        'not null' => TRUE,
+        'default' => 0,
+      ),
+      'data' => array(
+        'type' => 'text',
+        'not null' => FALSE,
+        'size' => 'big',
+        'description' => 'A serialized array of converted files. Use of this field is discouraged and it will likely disappear in a future version of Drupal.',
+      ),
+    ),
+    'indexes' => array(
+      'status' => array('status'),
+      'file' => array('fid'),
+    ),
+    'primary key' => array('vid'),
+  );
+  return $schema;
+}
+
+/**
+ * Implementation of hook_install().
+ */
+function video_zencoder_install() {
+  drupal_install_schema('video_zencoder');
+  // set the module weight to low since we need this to load later time than in S3
+  db_query("UPDATE {system} SET weight = 50 WHERE name = 'video_zencoder'");
+}
+
+/**
+ * Implementation of hook_uninstall().
+ */
+function video_zencoder_uninstall() {
+  drupal_uninstall_schema('video_zencoder');
+  // TODO : Delete our variables.
+}
+
+// ALTER TABLE `video_zencoder` ADD `dimensions` VARCHAR( 255 ) NULL AFTER `filesize` ;
+/**
+ * Update 6401
+ * Adding new dimentaion row to the table
+ * @return <type>
+ */
+function video_zencoder_update_6401() {
+  $ret = array();
+  // set settings column to accept larger values
+  switch ($GLOBALS['db_type']) {
+    case 'mysql':
+    case 'mysqli':
+      $ret[] = update_sql('ALTER TABLE {video_zencoder} ADD dimensions VARCHAR( 255 ) NULL NULL AFTER filesize');
+      break;
+
+    case 'pgsql':
+      db_add_column($ret, 'video_zencoder', 'dimensions', 'VARCHAR', array('null' => TRUE));
+      break;
+  }
+
+  return $ret;
+}
+
+/**
+ * Update 6402
+ * Adding data field and remove unwanted fields from the table
+ * @return <type>
+ */
+function video_zencoder_update_6402() {
+  $ret = array();
+  // drop un wanted fields in video zencoder
+  db_drop_field($ret, 'video_zencoder', 'filesize');
+  db_drop_field($ret, 'video_zencoder', 'outputid');
+  db_drop_field($ret, 'video_zencoder', 'bucket');
+  db_drop_field($ret, 'video_zencoder', 'filename');
+  db_drop_field($ret, 'video_zencoder', 'filepath');
+  db_drop_field($ret, 'video_zencoder', 'filemime');
+  db_add_column($ret, 'video_zencoder', 'data', 'longtext', array('null' => TRUE));
+  return $ret;
+}