Server : nginx/1.22.1
System : Linux iZwz9daxib3w3i063fw434Z 3.10.0-1127.19.1.el7.x86_64 #1 SMP Tue Aug 25 17:23:54 UTC 2020 x86_64
User : www ( 1000)
PHP Version : 7.2.33
Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv
Directory :  /www/wwwroot/www.jkmold.com/phpcms/modules/banner/install/
Upload File :
Current Directory [ Writeable ] Root Directory [ Writeable ]


Current File : /www/wwwroot/www.jkmold.com/phpcms/modules/banner/install/banner.sql
DROP TABLE IF EXISTS `phpcms_banner_cate`;
DROP TABLE IF EXISTS `phpcms_banner`;
CREATE TABLE `phpcms_banner_cate` (
  `bannerid` int(10) NOT NULL AUTO_INCREMENT,
  `siteid` smallint(5) unsigned NOT NULL DEFAULT '1',
  `description` char(50) NOT NULL,
  `title` char(80) NOT NULL,
  `listorder` int(11) DEFAULT 0,
  PRIMARY KEY (`bannerid`),
  KEY `siteid` (`siteid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `phpcms_banner` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `bannerid` int(11) NOT NULL DEFAULT '1',
  `siteid` smallint(5) unsigned NOT NULL DEFAULT '1',
  `description` char(50) NOT NULL,
  `title` char(80) NOT NULL,
  `url` varchar(500) NOT NULL,
  `thum` varchar(500) NOT NULL,
  `addtime` int(10) NOT NULL DEFAULT 0,
  `status` int(1) NOT NULL DEFAULT 0,
  `listorder` int(11) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `siteid` (`siteid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `phpcms_banner_cate` VALUES (null, 1, '默认分类', '默认分类', 0);