Newer
Older
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
<?php
function gmap_location_install() {
drupal_set_message('Installing location');
switch ($GLOBALS['db_type']) {
case 'mysql':
case 'mysqli':
db_query("
CREATE TABLE {location} (
eid int unsigned NOT NULL default '0',
type varchar(6) NOT NULL default '',
name varchar(255) default NULL,
street varchar(255) default NULL,
additional varchar(255) default NULL,
city varchar(255) default NULL,
province varchar(16) default NULL,
postal_code varchar(16) default NULL,
country char(2) default NULL,
latitude decimal(10,6) default NULL,
longitude decimal(10,6) default NULL,
source tinyint default '0',
PRIMARY KEY (type,eid)
) /*!40100 DEFAULT CHARACTER SET utf8 */;
");
$success = TRUE;
break;
case 'pgsql':
db_query("CREATE TABLE {location} (
eid int NOT NULL default '0' CHECK (eid >= 0),
type varchar(6) NOT NULL default '',
name varchar(255) default NULL,
street varchar(255) default NULL,
additional varchar(255) default NULL,
city varchar(255) default NULL,
province varchar(16) default NULL,
postal_code varchar(16) default NULL,
country char(2) default NULL,
latitude decimal(10,6) default NULL,
longitude decimal(10,6) default NULL,
source smallint default '0',
PRIMARY KEY (type,eid)
)");
$success = TRUE;
break;
default:
break;
} // End case
if ($success) {
drupal_set_message(t('GMap module installed location tables successfully.'));
}
else {
drupal_set_message(t('The installation of GMap module was unsuccessful.'), 'error');
}
}
function gmap_location_update_1() {
return _system_update_utf8(array('location'));
}
function gmap_location_update_2() {
$ret = array();
switch ($GLOBALS['db_type']) {
case 'mysql':
case 'mysqli':
$ret[] = update_sql("ALTER TABLE {location} CHANGE oid eid int unsigned NOT NULL default '0'");
break;
}
drupal_set_message("The schema for gmap module (location table) has been updated. The update is such that you may want to re-resave any views you have that may include locations.");
if(function_exists('views_invalidate_cache')) {
views_invalidate_cache();
}
return $ret;
}
/***************************************************************
PostgreSQL must be supported in all updates after this comment
***************************************************************/