diff options
Diffstat (limited to 'php/Attic/examples/sample-sp/setup.php')
| -rw-r--r-- | php/Attic/examples/sample-sp/setup.php | 22 |
1 files changed, 20 insertions, 2 deletions
diff --git a/php/Attic/examples/sample-sp/setup.php b/php/Attic/examples/sample-sp/setup.php index c6c44228..2886c88a 100644 --- a/php/Attic/examples/sample-sp/setup.php +++ b/php/Attic/examples/sample-sp/setup.php @@ -167,8 +167,22 @@ $query = "CREATE TABLE sessions ( id varchar(32) primary key, - expiry integer, - data text + lastupdate timestamp, + data text)"; + + $res =& $db->query($query); + if (DB::isError($res)) + die($res->getMessage()); + + print "OK"; + + print "<br>Create table 'sso_sessions' : "; + $query = "DROP TABLE sso_sessions CASCADE"; + $res =& $db->query($query); + + $query = "CREATE TABLE sso_sessions ( + name_identifier character varying(100), + session_id character varying(32) )"; $res =& $db->query($query); @@ -177,6 +191,7 @@ print "OK"; + $db->disconnect(); $keys = array_keys($config); @@ -375,6 +390,9 @@ </table> <input type='hidden' name='action' value='setup'> </form> +<p align='center'><a href='index.php'>Index</a> +</p> +<p>Copyright © 2004 Entr'ouvert</p> </body> </html> <?php |