30 lines
808 B
PHP
30 lines
808 B
PHP
|
<?php
|
||
|
|
|
||
|
|
$database = new SQLite3('db/scim-mock.sqlite');
|
||
|
|
|
||
|
|
// Reset
|
||
|
|
// $database->exec("DROP TABLE users");
|
||
|
|
// $database->exec("DROP TABLE groups");
|
||
|
|
|
||
|
|
$user_db_sql = "CREATE TABLE IF NOT EXISTS users (
|
||
|
|
id varchar(160) NOT NULL UNIQUE,
|
||
|
|
userName varchar(160) NOT NULL,
|
||
|
|
active BOOLEAN NOT NULL DEFAULT 1,
|
||
|
|
externalId varchar(160) NULL,
|
||
|
|
profileUrl varchar(160) NULL,
|
||
|
|
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
updated_at DATETIME NULL
|
||
|
|
)";
|
||
|
|
|
||
|
|
$database->exec($user_db_sql);
|
||
|
|
|
||
|
|
$group_db_sql = "CREATE TABLE IF NOT EXISTS groups (
|
||
|
|
id varchar(160) NOT NULL UNIQUE,
|
||
|
|
displayName varchar(160) NOT NULL DEFAULT '',
|
||
|
|
members TEXT NOT NULL DEFAULT '',
|
||
|
|
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
updated_at DATETIME NULL
|
||
|
|
)";
|
||
|
|
|
||
|
|
$database->exec($group_db_sql);
|