blob: 3820ef1ee6485c5f6ebd300022b48abdeb540c0f (
plain) (
blame)
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
|
<?php
namespace Zotlabs\Update;
class _1133 {
function run() {
if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) {
$r1 = q("CREATE TABLE xperm (
xp_id serial NOT NULL,
xp_client varchar( 20 ) NOT NULL DEFAULT '',
xp_channel bigint NOT NULL DEFAULT '0',
xp_perm varchar( 64 ) NOT NULL DEFAULT '',
PRIMARY KEY (xp_id) )");
$r2 = 0;
foreach(array('xp_client', 'xp_channel', 'xp_perm') as $fld)
$r2 += ((q("create index $fld on xperm ($fld)") == false) ? 0 : 1);
$r = (($r1 && $r2) ? true : false);
}
else {
$r = q("CREATE TABLE IF NOT EXISTS `xperm` (
`xp_id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`xp_client` VARCHAR( 20 ) NOT NULL DEFAULT '',
`xp_channel` INT UNSIGNED NOT NULL DEFAULT '0',
`xp_perm` VARCHAR( 64 ) NOT NULL DEFAULT '',
KEY `xp_client` (`xp_client`),
KEY `xp_channel` (`xp_channel`),
KEY `xp_perm` (`xp_perm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ");
}
if($r)
return UPDATE_SUCCESS;
return UPDATE_FAILED;
}
}
|
