s3db/alterTable.php at master · ebadedude/s3db · GitHub

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
<?php
function updateTables($db)
{
$sql = "ALTER TABLE s3db_permission
   ADD COLUMN PL_view integer;";

$db->query($sql, __FILE__, __LINE__);

$sql = "ALTER TABLE s3db_permission
   ADD COLUMN PL_change integer";
$db->query($sql, __FILE__, __LINE__);

$sql = "ALTER TABLE s3db_permission
   ADD COLUMN PL_use integer;";
$db->query($sql, __FILE__, __LINE__);

$sql = "ALTER TABLE s3db_permission
   ADD COLUMN id_num text;";
$db->query($sql, __FILE__, __LINE__);

$sql = "ALTER TABLE s3db_permission
   ADD COLUMN id_code text;";
$db->query($sql, __FILE__, __LINE__);

$sql = "ALTER TABLE s3db_permission
   ADD COLUMN shared_with_num text;";
$db->query($sql, __FILE__, __LINE__);

$sql = "ALTER TABLE s3db_permission
   ADD COLUMN shared_with_code text;";
$db->query($sql, __FILE__, __LINE__);
 }

?>