--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/image/ad_image.install	Fri Feb 20 14:04:09 2009 +0000
@@ -0,0 +1,119 @@
+<?php
+// $Id: ad_image.install,v 1.2.2.2.2.6.2.4 2009/02/16 17:06:49 jeremy Exp $
+
+/**
+ * @file
+ * Ad_image module database schema.
+ *
+ * Copyright (c) 2005-2009.
+ *   Jeremy Andrews <jeremy@tag1consulting.com>.
+ */
+
+/**
+ * Implementation of hook_schema().
+ */
+function ad_image_schema() {
+  $schema['ad_image'] = array(
+    'description' => 'The ad_image table stores image information such as file ID, title, width, height of corresponding image ads.',
+    'fields' => array(
+      'aid' => array(
+        'type' => 'int',
+        'unsigned' => TRUE,
+        'not null' => TRUE,
+        'default' => 0,
+      ),
+      'fid' => array(
+        'type' => 'int',
+        'unsigned' => TRUE,
+        'not null' => TRUE,
+        'default' => 0,
+      ),
+      'url' => array(
+        'type' => 'varchar',
+        'length' => '255',
+        'not null' => TRUE,
+        'default' => '',
+      ),
+      'tooltip' => array(
+        'type' => 'varchar',
+        'length' => '255',
+        'not null' => TRUE,
+        'default' => '',
+      ),
+      'width' => array(
+        'type' => 'int',
+        'unsigned' => TRUE,
+        'not null' => TRUE,
+        'default' => 0,
+      ),
+      'height' => array(
+        'type' => 'int',
+        'unsigned' => TRUE,
+        'not null' => TRUE,
+        'default' => 0,
+      ),
+    ),
+    'unique keys' => array(
+      'aid' => array('aid')
+    ),
+  );
+  $schema['ad_image_format'] = array(
+    'description' => 'The ad_image_format table stores dimensions for image ads.',
+    'fields' => array(
+      'gid' => array(
+        'type' => 'int',
+        'unsigned' => TRUE,
+        'not null' => TRUE,
+      ),
+      'min_width' => array(
+        'type' => 'int',
+        'unsigned' => TRUE,
+        'not null' => TRUE,
+        'default' => 0,
+      ),
+      'max_width' => array(
+        'type' => 'int',
+        'unsigned' => TRUE,
+        'not null' => TRUE,
+        'default' => 0,
+      ),
+      'min_height' => array(
+        'type' => 'int',
+        'unsigned' => TRUE,
+        'not null' => TRUE,
+        'default' => 0,
+      ),
+      'max_height' => array(
+        'type' => 'int',
+        'unsigned' => TRUE,
+        'not null' => TRUE,
+        'default' => 0,
+      ),
+    ),
+    'primary key' => array('gid'),
+  );
+
+  return $schema;
+}
+
+
+/**
+ * ad_image module installation.
+ */
+function ad_image_install() {
+  drupal_install_schema('ad_image');
+}
+
+/**
+ * Allow complete uninstallation of the ad_image module.
+ */
+function ad_image_uninstall() {
+  // Delete all ad_image content.
+  $result = db_query("SELECT aid FROM {ad_image}");
+  while ($aid = db_result($result)) {
+    node_delete($aid);
+  }
+
+  // Remove tables.
+  drupal_uninstall_schema('ad_image');
+}