blob: 720252bf829dded2ef595509b01693eb46dcc2ea (
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
39
40
41
42
43
44
45
|
<?php
namespace Zotlabs\Update;
class _1196 {
function run() {
if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) {
$r1 = q("CREATE TABLE \"pchan\" (
\"pchan_id\" serial NOT NULL,
\"pchan_guid\" text NOT NULL,
\"pchan_hash\" text NOT NULL,
\"pchan_pubkey\" text NOT NULL,
\"pchan_prvkey\" text NOT NULL,
PRIMARY KEY (\"pchan_id\")
)");
$r2 = q("create index \"pchan_guid\" on pchan (\"pchan_guid\")");
$r3 = q("create index \"pchan_hash\" on pchan (\"pchan_hash\")");
if($r1 && $r2 && $r3) {
return UPDATE_SUCCESS;
}
}
else {
$r1 = q("CREATE TABLE IF NOT EXISTS pchan (
pchan_id int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
pchan_guid char(191) NOT NULL DEFAULT '',
pchan_hash char(191) NOT NULL DEFAULT '',
pchan_pubkey text NOT NULL,
pchan_prvkey text NOT NULL,
PRIMARY KEY (pchan_id),
KEY pchan_guid (pchan_guid),
KEY pchan_hash (pchan_hash)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4");
if($r1) {
return UPDATE_SUCCESS;
}
}
return UPDATE_FAILED;
}
}
|
