--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/owners/ad_owners.install	Fri Feb 20 14:04:09 2009 +0000
@@ -0,0 +1,86 @@
+<?php
+// $Id: ad_owners.install,v 1.1.2.2 2009/02/16 17:06:49 jeremy Exp $
+
+/**
+ * @file
+ * Ad_owners module database schema.
+ *
+ * Copyright (c) 2009.
+ *   Jeremy Andrews <jeremy@tag1consulting.com>.
+ */
+
+/**
+ * Implementation of hook_schema().
+ */
+function ad_owners_schema() {
+  $schema['ad_owners'] = array(
+    'description' => 'Stores information about ad owners. Every ad can have one or more owners.',
+    'fields' => array(
+      'oid' => array(
+        'type' => 'serial',
+        'not null' => TRUE,
+        'unsigned' => TRUE,
+        'description' => 'Unique owner pair ID.',
+      ),
+      'aid' => array(
+        'type' => 'int',
+        'not null' => TRUE,
+        'unsigned' => TRUE,
+        'default' => 0,
+        'description' => 'Ad id.',
+      ),
+      'uid' => array(
+        'type' => 'int',
+        'not null' => TRUE,
+        'unsigned' => TRUE,
+        'default' => 0,
+        'description' => 'The {users}.uid that owns ad.',
+      ),
+    ),
+    'primary key' => array('oid'),
+    'indexes' => array(
+      'aid' => array('aid'),
+      'uid' => array('uid'),
+    ),
+  );
+
+ /**
+  * Permissions can be granted to each owner of each ad.  The same owner
+  * can own multiple ads, and can have different permissions for each ad.
+  */
+  $schema['ad_permissions'] = array(
+    'description' => 'Permissions can be granted to each owner of each ad. The same owner can own multiple ads, and can have different permissions for each ad.',
+    'fields' => array(
+      'oid' => array(
+        'type' => 'int',
+        'not null' => TRUE,
+        'unsigned' => TRUE,
+        'default' => 0,
+        'description' => 'Owner pair ID.',
+      ),
+      'permissions' => array(
+        'type' => 'text',
+        'not null' => FALSE,
+        'size' => 'big',
+        'description' => 'Ad permission info.',
+      ),
+    ),
+    'primary key' => array('oid'),
+  );
+
+  return $schema;
+}
+
+/**
+ * ad_external module installation.
+ */
+function ad_owners_install() {
+  drupal_install_schema('ad_owners');
+}
+
+/**
+ * Allow complete uninstallation of the ad_external module.
+ */
+function ad_owners() {
+  drupal_uninstall_schema('ad_owners');
+}