/dd/ -> 0_0030_inc.php
1 <?php
2
3 // 0_0030_inc.php - Adds table trust to refine access rights
4 // 0_0030_inc.php - author: Nico Stuurman
5
6 /***************************************************************************
7 * Copyright (c) 2002 by Nico Stuurman *
8 * ------------------------------------------------------------------------ *
9 * This code is part of phplabware (http://phplabware.sf.net) *
10 * *
11 * *
12 * This program is free software; you can redistribute it and/or modify it *
13 * under the terms of the GNU General Public License as published by the *
14 * Free Software Foundation; either version 2 of the License, or (at your *
15 * option) any later version. *
16 \**************************************************************************/
17
18 if ($db_type=="mysql")
19 $db->Execute("CREATE TABLE trust (
20 tableid int,
21 recordid int,
22 trusteduserid int,
23 rw char,
24 UNIQUE (tableid,recordid,trusteduserid,rw))");
25 else
26 $db->Execute("CREATE TABLE trust (
27 tableid int,
28 recordid int,
29 trusteduserid int,
30 rw char,
31 CONSTRAINT special PRIMARY KEY (tableid,recordid,trusteduserid,rw))");
32
33
34 ?>