| Server IP : 103.233.192.212 / Your IP : 3.135.198.159 Web Server : Apache/2 System : Linux sv1.inde.co.th 3.10.0-1160.36.2.el7.x86_64 #1 SMP Wed Jul 21 11:57:15 UTC 2021 x86_64 User : sumpatuan ( 1058) PHP Version : 5.5.38 Disable Function : symlink,shell_exec,exec,proc_close,proc_open,popen,system,dl,putenv,passthru,escapeshellarg,escapeshellcmd,pcntl_exec,proc_get_status,proc_nice,proc_terminate,pclose,ini_alter,virtual,openlog,ini_restore MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/sumpatuan/public_html/backup/framework/web/auth/ |
Upload File : |
/** * 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 );