db.htm

一个用jsp和access做的bbs

      <td width="44%" align="center">　</td>
    </tr>
    <tr>
      <td width="8%" align="center"><font size="2">8</font></td>
      <td width="21%" align="center"><font size="2">boardtopics</font></td>
      <td width="30%" align="center"><font size="2">长整型</font></td>
      <td width="22%" align="center"><font size="2">主题数</font></td>
      <td width="44%" align="center"><font size="2">（不包括跟贴）</font></td>
    </tr>
    <tr>
      <td width="8%" align="center">　</td>
      <td width="21%" align="center">　</td>
      <td width="30%" align="center">　</td>
      <td width="22%" align="center">　</td>
      <td width="44%" align="center">　</td>
    </tr>
    <tr>
      <td width="8%" align="center">　</td>
      <td width="21%" align="center"><font color="#FF0000" size="2">admin</font></td>
      <td width="30%" align="center"><font size="2">管理员表</font></td>
      <td width="22%" align="center">　</td>
      <td width="44%" align="center">　</td>
    </tr>
    <tr>
      <td width="8%" align="center">　</td>
      <td width="21%" align="center"><font color="#000080" size="2">字段名</font></td>
      <td width="30%" align="center"><font color="#000080" size="2">规格参数</font></td>
      <td width="22%" align="center"><font color="#000080" size="2">说明</font></td>
      <td width="44%" align="center"><font color="#000080" size="2">备注</font></td>
    </tr>
    <tr>
      <td width="8%" align="center"><font size="2">1</font></td>
      <td width="21%" align="center"><font size="2">id</font></td>
      <td width="30%" align="center"><font size="2">自动编号</font></td>
      <td width="22%" align="center">　</td>
      <td width="44%" align="center">　</td>
    </tr>
    <tr>
      <td width="8%" align="center"><font size="2">2</font></td>
      <td width="21%" align="center"><font size="2">adminname</font></td>
      <td width="30%" align="center"><font size="2">c50</font></td>
      <td width="22%" align="center"><font size="2">管理员名</font></td>
      <td width="44%" align="center">　</td>
    </tr>
    <tr>
      <td width="8%" align="center"><font size="2">3</font></td>
      <td width="21%" align="center"><font size="2">adminpwd</font></td>
      <td width="30%" align="center"><font size="2">c20</font></td>
      <td width="22%" align="center"><font size="2">管理员密码</font></td>
      <td width="44%" align="center">　</td>
    </tr>
    <tr>
      <td width="8%" align="center">　</td>
      <td width="21%" align="center">　</td>
      <td width="30%" align="center">　</td>
      <td width="22%" align="center">　</td>
      <td width="44%" align="center">　</td>
    </tr>
    <tr>
      <td width="8%" align="center">　</td>
      <td width="21%" align="center"><font color="#FF0000" size="2">bbs</font></td>
      <td width="30%" align="center"><font size="2">贴表</font></td>
      <td width="22%" align="center">　</td>
      <td width="44%" align="center">　</td>
    </tr>
    <tr>
      <td width="8%" align="center">　</td>
      <td width="21%" align="center"><font color="#000080" size="2">字段名</font></td>
      <td width="30%" align="center"><font color="#000080" size="2">规格参数</font></td>
      <td width="22%" align="center"><font color="#000080" size="2">说明</font></td>
      <td width="44%" align="center"><font color="#000080" size="2">备注</font></td>
    </tr>
    <tr>
      <td width="8%" align="center"><font size="2">1</font></td>
      <td width="21%" align="center"><font size="2">bbsid</font></td>
      <td width="30%" align="center"><font size="2">自动编号</font></td>
      <td width="22%" align="center"><font size="2">贴号</font></td>
      <td width="44%" align="center"><font size="2">唯一</font></td>
    </tr>
    <tr>
      <td width="8%" align="center"><font size="2">2</font></td>
      <td width="21%" align="center"><font size="2">parentid</font></td>
      <td width="30%" align="center"><font size="2">长整型</font></td>
      <td width="22%" align="center"><font size="2">父贴编号</font></td>
      <td width="44%" align="center"><font size="2">0：主贴</font></td>
    </tr>
    <tr>
      <td width="8%" align="center"><font size="2">3</font></td>
      <td width="21%" align="center"><font size="2">boardid</font></td>
      <td width="30%" align="center"><font size="2">长整型</font></td>
      <td width="22%" align="center"><font size="2">所属版块</font></td>
      <td width="44%" align="center">　</td>
    </tr>
    <tr>
      <td width="8%" align="center"><font size="2">4</font></td>
      <td width="21%" align="center"><font size="2">child</font></td>
      <td width="30%" align="center"><font size="2">长整型</font></td>
      <td width="22%" align="center"><font size="2">跟贴数</font></td>
      <td width="44%" align="center">　</td>
    </tr>
    <tr>
      <td width="8%" align="center"><font size="2">5</font></td>
      <td width="21%" align="center"><font size="2">username</font></td>
      <td width="30%" align="center"><font size="2">c50</font></td>
      <td width="22%" align="center"><font size="2">发表人名</font></td>
      <td width="44%" align="center">　</td>
    </tr>
    <tr>
      <td width="8%" align="center"><font size="2">6</font></td>
      <td width="21%" align="center"><font size="2">useremail</font></td>
      <td width="30%" align="center"><font size="2">c50</font></td>
      <td width="22%" align="center"><font size="2">发表人MAIL</font></td>
      <td width="44%" align="center">　</td>
    </tr>
    <tr>
      <td width="8%" align="center"><font size="2">7</font></td>
      <td width="21%" align="center"><font size="2">userip</font></td>
      <td width="30%" align="center"><font size="2">c20</font></td>
      <td width="22%" align="center"><font size="2">发表人IP</font></td>
      <td width="44%" align="center">　</td>
    </tr>
    <tr>
      <td width="8%" align="center"><font size="2">8</font></td>
      <td width="21%" align="center"><font size="2">expression</font></td>
      <td width="30%" align="center"><font size="2">c20</font></td>
      <td width="22%" align="center"><font size="2">发表人表情</font></td>
      <td width="44%" align="center"><font size="2">图片名：54.gif&nbsp;  
        tr.jpg</font></td> 
    </tr> 
    <tr> 
      <td width="8%" align="center"><font size="2">9</font></td> 
      <td width="21%" align="center"><font size="2">usersign</font></td> 
      <td width="30%" align="center"><font size="2">c255</font></td> 
      <td width="22%" align="center"><font size="2">发表人签名</font></td> 
      <td width="44%" align="center">　</td> 
    </tr> 
    <tr> 
      <td width="8%" align="center"><font size="2">10</font></td> 
      <td width="21%" align="center"><font size="2">bbstopic</font></td> 
      <td width="30%" align="center"><font size="2">c255</font></td> 
      <td width="22%" align="center"><font size="2">主题</font></td> 
      <td width="44%" align="center">　</td> 
    </tr> 
    <tr> 
      <td width="8%" align="center"><font size="2">11</font></td> 
      <td width="21%" align="center"><font size="2">bbscontent</font></td> 
      <td width="30%" align="center"><font size="2">备注</font></td> 
      <td width="22%" align="center"><font size="2">内容</font></td> 
      <td width="44%" align="center">　</td> 
    </tr> 
    <tr> 
      <td width="8%" align="center"><font size="2">12</font></td> 
      <td width="21%" align="center"><font size="2">dateandtime</font></td> 
      <td width="30%" align="center"><font size="2">d/t</font></td> 
      <td width="22%" align="center"><font size="2">发表时间</font></td> 
      <td width="44%" align="center">　</td> 
    </tr> 
    <tr> 
      <td width="8%" align="center"><font size="2">13</font></td> 
      <td width="21%" align="center"><font size="2">bbshits</font></td> 
      <td width="30%" align="center"><font size="2">长整型</font></td> 
      <td width="22%" align="center"><font size="2">点击数</font></td> 
      <td width="44%" align="center">　</td> 
    </tr> 
    <tr> 
      <td width="8%" align="center"><font size="2">14</font></td> 
      <td width="21%" align="center"><font size="2">length</font></td> 
      <td width="30%" align="center"><font size="2">长整型</font></td> 
      <td width="22%" align="center"><font size="2">内容长度</font></td> 
      <td width="44%" align="center">　</td> 
    </tr> 
  </table> 
  </center> 
</div> 
<p>　</p> 
<p><a name="积分制:"><font size="2">积分制:</font></a></p> 
<p><font size="2">1.加贴:2分/贴. 跟贴:1分/帖;贴被收入到精华部分:3分/贴;贴被删:-3分/贴.</font></p> 
<p><font size="2">所以有负分存在的可能性.</font></p> 
 
</body> 
 
</html>