REDROOM

Navigation

Breadcrumbs

Create

Edit File Size: 1.24 KB

/home/jambtst2015/www/framework/web/auth/schema-pgsql.sql

Text Base64

/**
 * Database schema required by CDbAuthManager.
 *
 * @author Qiang Xue <qiang.xue@gmail.com>
 * @link http://www.yiiframework.com/
 * @copyright 2008 Yii Software LLC
 * @license http://www.yiiframework.com/license/
 * @since 1.0
 */

drop table if exists "AuthAssignment";
drop table if exists "AuthItemChild";
drop table if exists "AuthItem";

create table "AuthItem"
(
   "name"                 varchar(64) not null,
   "type"                 integer not null,
   "description"          text,
   "bizrule"              text,
   "data"                 text,
   primary key ("name")
);

create table "AuthItemChild"
(
   "parent"               varchar(64) not null,
   "child"                varchar(64) not null,
   primary key ("parent","child"),
   foreign key ("parent") references "AuthItem" ("name") on delete cascade on update cascade,
   foreign key ("child") references "AuthItem" ("name") on delete cascade on update cascade
);

create table "AuthAssignment"
(
   "itemname"             varchar(64) not null,
   "userid"               varchar(64) not null,
   "bizrule"              text,
   "data"                 text,
   primary key ("itemname","userid"),
   foreign key ("itemname") references "AuthItem" ("name") on delete cascade on update cascade
);

Exit & Reset Text mode: syntax highlighting auto-detects file type.

Name	Size	Perms	Modified	Actions
CAccessControlFilter.php	12.00 KB	lrw-r--r--	2024-11-22 17:53:15	Edit Download recursive recursive
CAuthAssignment.php	2.45 KB	lrw-r--r--	2024-11-22 17:53:15	Edit Download recursive recursive
CAuthItem.php	7.41 KB	lrw-r--r--	2024-11-22 17:53:15	Edit Download recursive recursive
CAuthManager.php	6.49 KB	lrw-r--r--	2024-11-22 17:53:15	Edit Download recursive recursive
CBaseUserIdentity.php	3.93 KB	lrw-r--r--	2024-11-22 17:53:15	Edit Download recursive recursive
CDbAuthManager.php	18.90 KB	lrw-r--r--	2024-11-22 17:53:15	Edit Download recursive recursive
CPhpAuthManager.php	15.96 KB	lrw-r--r--	2024-11-22 17:53:15	Edit Download recursive recursive
CUserIdentity.php	2.20 KB	lrw-r--r--	2024-11-22 17:53:15	Edit Download recursive recursive
CWebUser.php	27.35 KB	lrw-r--r--	2024-11-22 17:53:15	Edit Download recursive recursive
error_log	34.28 KB	lrw-r--r--	2025-11-04 15:17:16	Edit Download recursive recursive
schema-mssql.sql	1.24 KB	lrw-r--r--	2024-11-22 17:53:15	Edit Download recursive recursive
schema-mysql.sql	1.28 KB	lrw-r--r--	2024-11-22 17:53:15	Edit Download recursive recursive
schema-oci.sql	1.24 KB	lrw-r--r--	2024-11-22 17:53:15	Edit Download recursive recursive
schema-pgsql.sql	1.24 KB	lrw-r--r--	2024-11-22 17:53:15	Edit Download recursive recursive
schema-sqlite.sql	1.24 KB	lrw-r--r--	2024-11-22 17:53:15	Edit Download recursive recursive

Directory Contents