From 1ba859d4f6b4fc64ac51eadc6bc1a5fa40869590 Mon Sep 17 00:00:00 2001
From: prashant
Date: Wed, 4 Nov 2015 19:06:22 +0530
Subject: changed mail functions and formated the code

---
 lab_migration.install | 844 +++++++++++++++++++++++++-------------------------
 1 file changed, 424 insertions(+), 420 deletions(-)

(limited to 'lab_migration.install')

diff --git a/lab_migration.install b/lab_migration.install
index 6589a42..cec3600 100755
--- a/lab_migration.install
+++ b/lab_migration.install
@@ -1,431 +1,435 @@
 <?php
 // $Id$
-
 /**
  * Implementation of hook_install().
  */
-function lab_migration_install() {
-  // Create tables.
-  drupal_install_schema('lab_migration');
-  variable_set('lab_migration_emails', '');
-  variable_set('lab_migration_from_email', '');
-  variable_set('lab_migration_source_extensions', '');
-  variable_set('lab_migration_dependency_extensions', '');
-  variable_set('lab_migration_result_extensions', '');
-  variable_set('lab_migration_xcos_extensions', '');
-
-  // create uploads folder
-  $upload_path = $_SERVER['DOCUMENT_ROOT'] . base_path() . 'lab_migration_uploads';
-  if (!is_dir($upload_path))
-    mkdir($upload_path);
-  if (!is_dir($upload_path . '/latex'))
-    mkdir($upload_path . '/latex');
-  if (!is_dir($upload_path . '/DEPENDENCIES'))
-    mkdir($upload_path . '/DEPENDENCIES');
-}
-
+function lab_migration_install()
+  {
+    // Create tables.
+    drupal_install_schema('lab_migration');
+    variable_set('lab_migration_emails', '');
+    variable_set('lab_migration_from_email', '');
+    variable_set('lab_migration_source_extensions', '');
+    variable_set('lab_migration_dependency_extensions', '');
+    variable_set('lab_migration_result_extensions', '');
+    variable_set('lab_migration_xcos_extensions', '');
+    // create uploads folder
+    $upload_path = $_SERVER['DOCUMENT_ROOT'] . base_path() . 'lab_migration_uploads';
+    if (!is_dir($upload_path))
+        mkdir($upload_path);
+    if (!is_dir($upload_path . '/latex'))
+        mkdir($upload_path . '/latex');
+    if (!is_dir($upload_path . '/DEPENDENCIES'))
+        mkdir($upload_path . '/DEPENDENCIES');
+  }
 /**
  * Implementation of hook_uninstall().
  */
-function lab_migration_uninstall() {
-  // Remove tables.
-  drupal_uninstall_schema('lab_migration');
-  // Remove variables
-  variable_del('lab_migration_emails');
-  variable_del('lab_migration_from_email');
-  variable_del('lab_migration_source_extensions');
-  variable_del('lab_migration_dependency_extensions');
-  variable_del('lab_migration_result_extensions');
-  variable_del('lab_migration_xcos_extensions');
-}
-
+function lab_migration_uninstall()
+  {
+    // Remove tables.
+    drupal_uninstall_schema('lab_migration');
+    // Remove variables
+    variable_del('lab_migration_emails');
+    variable_del('lab_migration_from_email');
+    variable_del('lab_migration_source_extensions');
+    variable_del('lab_migration_dependency_extensions');
+    variable_del('lab_migration_result_extensions');
+    variable_del('lab_migration_xcos_extensions');
+  }
 /**
  * Implementation of hook_schema().
  */
-function lab_migration_schema() {
-
-	/* proposal */
-	$schema['lab_migration_proposal'] = array(
-		'description' => t('TODO: please describe this table!'),
-		'fields' => array(
-			'id' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'serial',
-				'not null' => TRUE,
-			),
-			'uid' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'approver_uid' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'solution_provider_uid' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'name_title' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '5',
-				'not null' => TRUE,
-			),
-			'name' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '255',
-				'not null' => TRUE,
-			),
-			'contact_ph' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '15',
-				'not null' => TRUE,
-			),
-			'department' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '255',
-				'not null' => TRUE,
-			),
-			'university' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '255',
-				'not null' => TRUE,
-			),
-			'lab_title' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '255',
-				'not null' => TRUE,
-			),
-			'category' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'approval_status' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'solution_status' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'solution_display' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'creation_date' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'approval_date' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'solution_date' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'expected_completion_date' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'message' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'text',
-				'size' => 'medium',
-				'not null' => TRUE,
-			),
-			'solution_provider_name_title' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '5',
-				'not null' => TRUE,
-			),
-			'solution_provider_name' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '255',
-				'not null' => TRUE,
-			),
-			'solution_provider_contact_ph' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '15',
-				'not null' => TRUE,
-			),
-			'solution_provider_department' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '255',
-				'not null' => TRUE,
-			),
-			'solution_provider_university' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '255',
-				'not null' => TRUE,
-			),
-		),
-		'primary key' => array('id'),
-	);
-
-  /* experiment */
-	$schema['lab_migration_experiment'] = array(
-		'description' => t('TODO: please describe this table!'),
-		'fields' => array(
-			'id' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'serial',
-				'not null' => TRUE,
-			),
-			'proposal_id' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'number' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'title' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '500',
-				'not null' => TRUE,
-			),
-		),
-		'primary key' => array('id'),
-	);
-
-  /* solution */
-	$schema['lab_migration_solution'] = array(
-		'description' => t('TODO: please describe this table!'),
-		'fields' => array(
-			'id' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'serial',
-				'not null' => TRUE,
-			),
-			'experiment_id' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'approver_uid' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'code_number' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '10',
-				'not null' => TRUE,
-			),
-			'caption' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '255',
-				'not null' => TRUE,
-			),
-			'approval_date' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'approval_status' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'timestamp' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-		),
-		'primary key' => array('id'),
-	);
-
-  /* solution files */
-	$schema['lab_migration_solution_files'] = array(
-		'description' => t('TODO: please describe this table!'),
-		'fields' => array(
-			'id' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'serial',
-				'not null' => TRUE,
-			),
-			'solution_id' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'filename' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '255',
-				'not null' => TRUE,
-			),
-			'filepath' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '500',
-				'not null' => TRUE,
-			),
-			'filemime' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '255',
-				'not null' => TRUE,
-			),
-			'filesize' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'filetype' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '1',
-				'not null' => TRUE,
-			),
-			'caption' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '100',
-				'not null' => TRUE,
-			),
-			'timestamp' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-		),
-		'primary key' => array('id'),
-	);
-
-  /* depedency files */
-	$schema['lab_migration_dependency_files'] = array(
-		'description' => t('TODO: please describe this table!'),
-		'fields' => array(
-			'id' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'serial',
-				'not null' => TRUE,
-			),
-			'proposal_id' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'filename' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '255',
-				'not null' => TRUE,
-			),
-			'filepath' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '500',
-				'not null' => TRUE,
-			),
-			'filemime' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '255',
-				'not null' => TRUE,
-			),
-			'filesize' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'caption' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'varchar',
-				'length' => '100',
-				'not null' => TRUE,
-			),
-			'description' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'text',
-				'size' => 'medium',
-				'not null' => TRUE,
-			),
-			'timestamp' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-		),
-		'primary key' => array('id'),
-	);
-
-  /* dependency files - links */
-	$schema['lab_migration_solution_dependency'] = array(
-		'description' => t('TODO: please describe this table!'),
-		'fields' => array(
-			'id' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'serial',
-				'not null' => TRUE,
-			),
-			'solution_id' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'dependency_id' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-		),
-		'primary key' => array('id'),
-	);
-
-	/* notes */
-	$schema['lab_migration_notes'] = array(
-		'description' => t('TODO: please describe this table!'),
-		'fields' => array(
-			'id' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'serial',
-				'not null' => TRUE,
-			),
-			'proposal_id' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'int',
-				'not null' => TRUE,
-			),
-			'notes' => array(
-				'description' => t('TODO: please describe this field!'),
-				'type' => 'text',
-				'size' => 'medium',
-				'not null' => TRUE,
-			),
-		),
-		'primary key' => array('id'),
-	);
-
-  return $schema;
-}
-
+function lab_migration_schema()
+  {
+    /* proposal */
+    $schema['lab_migration_proposal'] = array(
+        'description' => t('TODO: please describe this table!'),
+        'fields' => array(
+            'id' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'serial',
+                'not null' => TRUE
+            ),
+            'uid' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'approver_uid' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'solution_provider_uid' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'name_title' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '5',
+                'not null' => TRUE
+            ),
+            'name' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '255',
+                'not null' => TRUE
+            ),
+            'contact_ph' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '15',
+                'not null' => TRUE
+            ),
+            'department' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '255',
+                'not null' => TRUE
+            ),
+            'university' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '255',
+                'not null' => TRUE
+            ),
+            'lab_title' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '255',
+                'not null' => TRUE
+            ),
+            'category' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'approval_status' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'solution_status' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'solution_display' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'creation_date' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'approval_date' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'solution_date' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'expected_completion_date' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'message' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'text',
+                'size' => 'medium',
+                'not null' => TRUE
+            ),
+            'solution_provider_name_title' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '5',
+                'not null' => TRUE
+            ),
+            'solution_provider_name' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '255',
+                'not null' => TRUE
+            ),
+            'solution_provider_contact_ph' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '15',
+                'not null' => TRUE
+            ),
+            'solution_provider_department' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '255',
+                'not null' => TRUE
+            ),
+            'solution_provider_university' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '255',
+                'not null' => TRUE
+            )
+        ),
+        'primary key' => array(
+            'id'
+        )
+    );
+    /* experiment */
+    $schema['lab_migration_experiment'] = array(
+        'description' => t('TODO: please describe this table!'),
+        'fields' => array(
+            'id' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'serial',
+                'not null' => TRUE
+            ),
+            'proposal_id' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'number' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'title' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '500',
+                'not null' => TRUE
+            )
+        ),
+        'primary key' => array(
+            'id'
+        )
+    );
+    /* solution */
+    $schema['lab_migration_solution'] = array(
+        'description' => t('TODO: please describe this table!'),
+        'fields' => array(
+            'id' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'serial',
+                'not null' => TRUE
+            ),
+            'experiment_id' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'approver_uid' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'code_number' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '10',
+                'not null' => TRUE
+            ),
+            'caption' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '255',
+                'not null' => TRUE
+            ),
+            'approval_date' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'approval_status' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'timestamp' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            )
+        ),
+        'primary key' => array(
+            'id'
+        )
+    );
+    /* solution files */
+    $schema['lab_migration_solution_files'] = array(
+        'description' => t('TODO: please describe this table!'),
+        'fields' => array(
+            'id' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'serial',
+                'not null' => TRUE
+            ),
+            'solution_id' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'filename' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '255',
+                'not null' => TRUE
+            ),
+            'filepath' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '500',
+                'not null' => TRUE
+            ),
+            'filemime' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '255',
+                'not null' => TRUE
+            ),
+            'filesize' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'filetype' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '1',
+                'not null' => TRUE
+            ),
+            'caption' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '100',
+                'not null' => TRUE
+            ),
+            'timestamp' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            )
+        ),
+        'primary key' => array(
+            'id'
+        )
+    );
+    /* depedency files */
+    $schema['lab_migration_dependency_files'] = array(
+        'description' => t('TODO: please describe this table!'),
+        'fields' => array(
+            'id' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'serial',
+                'not null' => TRUE
+            ),
+            'proposal_id' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'filename' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '255',
+                'not null' => TRUE
+            ),
+            'filepath' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '500',
+                'not null' => TRUE
+            ),
+            'filemime' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '255',
+                'not null' => TRUE
+            ),
+            'filesize' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'caption' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'varchar',
+                'length' => '100',
+                'not null' => TRUE
+            ),
+            'description' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'text',
+                'size' => 'medium',
+                'not null' => TRUE
+            ),
+            'timestamp' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            )
+        ),
+        'primary key' => array(
+            'id'
+        )
+    );
+    /* dependency files - links */
+    $schema['lab_migration_solution_dependency'] = array(
+        'description' => t('TODO: please describe this table!'),
+        'fields' => array(
+            'id' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'serial',
+                'not null' => TRUE
+            ),
+            'solution_id' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'dependency_id' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            )
+        ),
+        'primary key' => array(
+            'id'
+        )
+    );
+    /* notes */
+    $schema['lab_migration_notes'] = array(
+        'description' => t('TODO: please describe this table!'),
+        'fields' => array(
+            'id' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'serial',
+                'not null' => TRUE
+            ),
+            'proposal_id' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'int',
+                'not null' => TRUE
+            ),
+            'notes' => array(
+                'description' => t('TODO: please describe this field!'),
+                'type' => 'text',
+                'size' => 'medium',
+                'not null' => TRUE
+            )
+        ),
+        'primary key' => array(
+            'id'
+        )
+    );
+    return $schema;
+  }
-- 
cgit