member.sql 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. -- phpMyAdmin SQL Dump
  2. -- version phpStudy 2014
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- 主机: localhost
  6. -- 生�日期: 2017 �11 �30 �17:33
  7. -- �务器版本: 5.5.53
  8. -- PHP 版本: 5.6.27
  9. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  10. SET time_zone = "+00:00";
  11. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  12. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  13. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  14. /*!40101 SET NAMES utf8 */;
  15. --
  16. -- 数�库: `silence`
  17. --
  18. -- --------------------------------------------------------
  19. --
  20. -- 表的结构 `member`
  21. --
  22. CREATE TABLE IF NOT EXISTS `member` (
  23. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  24. `name` varchar(50) NOT NULL COMMENT '�称',
  25. `image` varchar(255) NOT NULL,
  26. PRIMARY KEY (`id`),
  27. KEY `admin_id` (`id`)
  28. ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='管�员表' AUTO_INCREMENT=22 ;
  29. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  30. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  31. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;