-
Notifications
You must be signed in to change notification settings - Fork 0
/
rsvplist.install
72 lines (68 loc) · 2.08 KB
/
rsvplist.install
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
<?php
/**
* @file
* Install, update and uninstall functions for the rsvplist module
*/
function rsvplist_schema() {
// Create a database table called 'rsvplist' with the following collumns:
// 1) id [serial], 2) uid [int], 3) nid [int], 4) mail [varchar], 5) created [int]
$schema['rsvplist'] = [
'description' => 'Stores email, timestamp, nid, and uid for an RSVP.',
'fields' => [
'id' => [
'description' => 'The primary identifier for the record',
'type' => 'serial', //increments automatically 😺
'size' => 'small', //tiny/small/medium/normal/big
'unsigned' => TRUE,
'not null' => TRUE,
],
'uid' => [
'description' => 'The {users}.uid that added this RSVP.',
'type' => 'int',
'not null' => TRUE,
'default' => 0,
],
'nid' => [
'description' => 'The {node}.nid for this RSVP.',
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
],
'mail' => [
'description' => 'User\'s email address',
'type' => 'varchar',
'length' => 64,
'not null' => FALSE,
'default' => '',
],
'created' => [
'description' => 'Timestamp for when RSVP was created.',
'type' => 'int',
'not null' => TRUE,
'default' => 0,
],
],
'primary key' => ['id'],
'indexes' => [
'node' => ['nid'],
'node_user' => ['nid', 'uid'],
]
];
//Create a database table named 'rsvplist_enabled' with the following fields:
// 1) nid [int]
$schema['rsvplist_enabled'] = [
'description' => 'Tracks wether RSVP is enabled or not for a node.',
'fields' => [
'nid' => [
'description' => 'The {node}.nid that has RSVPList enabled.',
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
],
],
'primary key' => ['nid'],
];
//we have to return the defined schema:
return $schema;
}