dbtng_example.install
2.02 KB
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
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
<?php
/**
* @file
* Install, update and uninstall functions for the dbtng_example module.
*/
/**
* Implements hook_install().
*
* Creates some default entries on this module custom table.
*
* @see hook_install()
* @ingroup dbtng_example
*/
function dbtng_example_install() {
// Add a default entry.
$fields = array(
'name' => 'John',
'surname' => 'Doe',
'age' => 0,
);
db_insert('dbtng_example')
->fields($fields)
->execute();
// Add another entry.
$fields = array(
'name' => 'John',
'surname' => 'Roe',
'age' => 100,
'uid' => 1,
);
db_insert('dbtng_example')
->fields($fields)
->execute();
}
/**
* Implements hook_schema().
*
* Defines the database tables used by this module.
*
* @see hook_schema()
* @ingroup dbtng_example
*/
function dbtng_example_schema() {
$schema['dbtng_example'] = array(
'description' => 'Stores example person entries for demonstration purposes.',
'fields' => array(
'pid' => array(
'type' => 'serial',
'not null' => TRUE,
'description' => 'Primary Key: Unique person ID.',
),
'uid' => array(
'type' => 'int',
'not null' => TRUE,
'default' => 0,
'description' => "Creator user's {users}.uid",
),
'name' => array(
'type' => 'varchar',
'length' => 255,
'not null' => TRUE,
'default' => '',
'description' => 'Name of the person.',
),
'surname' => array(
'type' => 'varchar',
'length' => 255,
'not null' => TRUE,
'default' => '',
'description' => 'Surname of the person.',
),
'age' => array(
'type' => 'int',
'not null' => TRUE,
'default' => 0,
'size' => 'tiny',
'description' => 'The age of the person in years.',
),
),
'primary key' => array('pid'),
'indexes' => array(
'name' => array('name'),
'surname' => array('surname'),
'age' => array('age'),
),
);
return $schema;
}