• php1


    
    tb_admin    管理员表

    CREATE TABLE `tb_admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `manager` varchar(20) CHARACTER SET gb2312 NOT NULL, `password` varchar(50) CHARACTER SET gb2312 NOT NULL, `lastIP` varchar(20) CHARACTER SET gb2312 NOT NULL, `lasttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `freeze` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=71 DEFAULT CHARSET=latin1
    tb_article   博客文章列表

    CREATE TABLE `tb_article` ( `id` int(11) NOT NULL AUTO_INCREMENT, `typename` varchar(20) CHARACTER SET gb2312 NOT NULL, `title` varchar(50) CHARACTER SET gb2312 NOT NULL, `content` mediumtext CHARACTER SET gb2312 NOT NULL, `author` varchar(50) CHARACTER SET gb2312 NOT NULL, `firsttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `artquote` varchar(300) CHARACTER SET gb2312 NOT NULL, `hitnum` int(4) NOT NULL, `renum` int(4) NOT NULL, `examine` int(1) NOT NULL, `isnominate` int(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1
    tb_frd     用户好友信息表

    CREATE TABLE `tb_frd` ( `id` int(11) NOT NULL AUTO_INCREMENT, `frdname` varchar(100) CHARACTER SET gb2312 NOT NULL, `frdmem` varchar(100) CHARACTER SET gb2312 NOT NULL, `frdlevel` int(11) NOT NULL, `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1
    tb_log   文章日志信息表

    tb_member    用户信息数据表

    CREATE TABLE `tb_member` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET gb2312 NOT NULL, `pwd` varchar(50) CHARACTER SET gb2312 NOT NULL, `question` varchar(50) CHARACTER SET gb2312 NOT NULL, `answer` varchar(50) CHARACTER SET gb2312 NOT NULL, `email` varchar(50) CHARACTER SET gb2312 NOT NULL, `realname` varchar(50) CHARACTER SET gb2312 NOT NULL, `sex` varchar(1) CHARACTER SET gb2312 NOT NULL, `birthday` date NOT NULL DEFAULT '2008-06-12', `tel` varchar(20) CHARACTER SET gb2312 NOT NULL, `address` varchar(200) CHARACTER SET gb2312 NOT NULL, `homepage` varchar(200) CHARACTER SET gb2312 NOT NULL, `qq` varchar(10) CHARACTER SET gb2312 NOT NULL, `unwrite` varchar(200) CHARACTER SET gb2312 NOT NULL, `headgif` varchar(200) CHARACTER SET gb2312 NOT NULL, `hitnum` int(4) NOT NULL, `upfile` int(4) NOT NULL, `uppics` int(4) NOT NULL, `lasttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `freeze` int(1) NOT NULL, `blogname` varchar(100) CHARACTER SET gb2312 NOT NULL, `blogurl` varchar(200) CHARACTER SET gb2312 NOT NULL, `arttype` varchar(300) CHARACTER SET gb2312 NOT NULL, `pictype` varchar(300) CHARACTER SET gb2312 NOT NULL, `isnew` int(1) NOT NULL DEFAULT '0', `isnominate` int(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1
     CREATE TABLE `tb_log` (
     `id` int(11) NOT NULL AUTO_INCREMENT,
     `content` varchar(200) CHARACTER SET gb2312 NOT NULL,
     `operator` varchar(50) CHARACTER SET gb2312 NOT NULL,
     `uptime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
     PRIMARY KEY (`id`)
    ) ENGINE=MyISAM AUTO_INCREMENT=348 DEFAULT CHARSET=latin1
    tb_mess   用户留言数据表
    CREATE TABLE `tb_mess` ( `id` int(11) NOT NULL AUTO_INCREMENT, `messer` varchar(100) CHARACTER SET gb2312 NOT NULL, `content` varchar(300) CHARACTER SET gb2312 NOT NULL, `messered` varchar(100) CHARACTER SET gb2312 NOT NULL, `messtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1
    tb_review    文章评论表

    CREATE TABLE `tb_review` ( `id` int(11) NOT NULL AUTO_INCREMENT, `artid` int(4) NOT NULL, `content` varchar(300) CHARACTER SET gb2312 NOT NULL, `man` varchar(100) CHARACTER SET gb2312 NOT NULL, `firsttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1
    tb_script    小纸条列表

    CREATE TABLE `tb_script` ( `id` int(11) NOT NULL AUTO_INCREMENT, `accept` varchar(100) CHARACTER SET gb2312 NOT NULL, `sender` varchar(100) CHARACTER SET gb2312 NOT NULL, `content` varchar(300) CHARACTER SET gb2312 NOT NULL, `isnew` int(1) NOT NULL, `sendtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1
    tb_uppics    上传图片信息表

    CREATE TABLE `tb_uppics` ( `id` int(11) NOT NULL AUTO_INCREMENT, `picname` varchar(50) CHARACTER SET gb2312 NOT NULL, `picpath` varchar(100) CHARACTER SET gb2312 NOT NULL, `upauthor` varchar(100) CHARACTER SET gb2312 NOT NULL, `pictype` varchar(50) CHARACTER SET gb2312 NOT NULL, `hitnum` int(4) NOT NULL, `examine` int(1) NOT NULL, `uptime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=latin1
  • 相关阅读:
    在Ajax中将数组转换成字符串(0517-am)
    Json,Ajax(0516)
    JQUERY的应用
    php 之 PDO数据访问抽象层(0513)
    php 之 房屋租赁练习(0509)
    MySQL 高级查询
    MySQL简单查询
    MySQL语句
    php 之 查询 投票练习(0508)
    linux查看java jdk jre安装路径和设置环境变量
  • 原文地址:https://www.cnblogs.com/mengluo/p/4790131.html
Copyright © 2020-2023  润新知