| Server IP : 103.233.192.212 / Your IP : 18.217.171.249 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`) ) engine InnoDB; 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 ) engine InnoDB; 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 ) engine InnoDB;