sql_20141001233941_1.php 812 B

123456789101112131415
  1. <?php die('forbidden'); ?>
  2. DROP TABLE IF EXISTS yehnet_admin;
  3. CREATE TABLE `yehnet_admin` (
  4. `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID号',
  5. `name` varchar(50) NOT NULL COMMENT '账号',
  6. `email` varchar(100) NOT NULL COMMENT '邮箱',
  7. `pass` varchar(50) NOT NULL COMMENT '密码',
  8. `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1正常0锁定',
  9. `if_system` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1系统管理员0普通管理员',
  10. `popedom` text NOT NULL COMMENT '权限',
  11. `langid` varchar(255) NOT NULL COMMENT '可操作的语言权限,系统管理员不限',
  12. PRIMARY KEY (`id`)
  13. ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  14. INSERT INTO yehnet_admin VALUES('1','admin','admin@admin.com','c3284d0f94606de1fd2af172aba15bf3','1','1','','');