comparison notify/ad_notify.install @ 0:d8a3998dac8e ad

ajout module ad
author pierre
date Fri, 20 Feb 2009 14:04:09 +0000
parents
children 948362c2a207
comparison
equal deleted inserted replaced
-1:000000000000 0:d8a3998dac8e
1 <?php
2 // $Id: ad_notify.install,v 1.1.2.2.2.6.2.3 2009/02/16 17:06:49 jeremy Exp $
3
4 /**
5 * @file
6 * Ad_notify module database schema.
7 *
8 * Copyright (c) 2005-2009.
9 * Jeremy Andrews <jeremy@tag1consulting.com>.
10 */
11
12 /**
13 * Implementation of hook_schema().
14 */
15 function ad_notify_schema() {
16 $schema['ad_notify'] = array(
17 'description' => 'The ad_notify table stores notifications data such as recepient, message body, event, etc.',
18 'fields' => array(
19 'notid' => array(
20 'type' => 'serial',
21 'unsigned' => TRUE,
22 'not null' => TRUE,
23 ),
24 'aid' => array(
25 'type' => 'int',
26 'unsigned' => TRUE,
27 'not null' => TRUE,
28 'default' => 0,
29 ),
30 'oid' => array(
31 'type' => 'int',
32 'unsigned' => TRUE,
33 'not null' => TRUE,
34 'default' => 0,
35 ),
36 'event' => array(
37 'type' => 'varchar',
38 'length' => '255',
39 'not null' => TRUE,
40 'default' => ''
41 ),
42 'delay' => array(
43 'type' => 'int',
44 'not null' => TRUE,
45 'default' => 0,
46 ),
47 'queued' => array(
48 'type' => 'int',
49 'not null' => TRUE,
50 'default' => 0,
51 ),
52 'sent' => array(
53 'type' => 'int',
54 'not null' => TRUE,
55 'default' => 0,
56 ),
57 'counter' => array(
58 'type' => 'int',
59 'unsigned' => TRUE,
60 'not null' => TRUE,
61 'default' => 0,
62 ),
63 'locked' => array(
64 'type' => 'int',
65 'unsigned' => TRUE,
66 'size' => 'tiny',
67 'not null' => TRUE,
68 'default' => 0,
69 ),
70 'expire' => array(
71 'type' => 'int',
72 'unsigned' => TRUE,
73 'size' => 'tiny',
74 'not null' => TRUE,
75 'default' => 0,
76 ),
77 'status' => array(
78 'type' => 'int',
79 'unsigned' => TRUE,
80 'size' => 'tiny',
81 'not null' => TRUE,
82 'default' => 0,
83 ),
84 'address' => array(
85 'type' => 'varchar',
86 'length' => '255',
87 'not null' => TRUE,
88 'default' => '',
89 ),
90 'subject' => array(
91 'type' => 'varchar',
92 'length' => '255',
93 'not null' => TRUE,
94 'default' => '',
95 ),
96 'body' => array(
97 'type' => 'text',
98 'not null' => FALSE,
99 ),
100 ),
101 'primary key' => array('notid'),
102 'unique keys' => array(
103 'oid' => array('oid', 'event', 'delay'),
104 ),
105 'indexes' => array(
106 'delay' => array('delay'),
107 'event' => array('event'),
108 'oid_2' => array('oid'),
109 'queued' => array('queued'),
110 'sent' => array('sent'),
111 'status' => array('status'),
112 ),
113 );
114
115 return $schema;
116 }
117
118 /**
119 * ad_notify module installation.
120 */
121 function ad_notify_install() {
122 drupal_install_schema('ad_notify');
123 }
124
125
126 /**
127 * Allow complete uninstallation of the ad_notify module.
128 */
129 function ad_notify_uninstall() {
130 // Remove tables.
131 drupal_uninstall_schema('ad_notify');
132 }