数据库建表语句 (11)

基于JAVA的学习网站的设计与实现建表语句1管理员表USEDXSGO/对象TABLEDBOADMIN脚本日期06/13/2014230607/SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLEDBOADMINIDINTIDENTITY1,1NOTNULL,USERNAMENVARCHAR50COLLATECHINESE_PRC_CI_ASNOTNULL,PASSWORDNVARCHAR200COLLATECHINESE_PRC_CI_ASNOTNULL,CREATTIMEDATETIMENOTNULL,FLAGINTNOTNULL,ISUSEINTNOTNULL,LOGINTIMESINTNOTNULL,QUANXIANNVARCHAR1000COLLATECHINESE_PRC_CI_ASNOTNULLONPRIMARY2管理员登陆表USEDXSGO/对象TABLEDBOADMINLOG脚本日期06/13/2014231746/SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLEDBOADMINLOGIDINTIDENTITY1,1NOTNULL,USERNAMENVARCHAR100COLLATECHINESE_PRC_CI_ASNOTNULL,PASSWORDNVARCHAR200COLLATECHINESE_PRC_CI_ASNOTNULL,LOGINTIMEDATETIMENOTNULL,LOGINIPNVARCHAR300COLLATECHINESE_PRC_CI_ASNOTNULL,USEROSNVARCHAR100COLLATECHINESE_PRC_CI_ASNOTNULL,OKNVARCHAR50COLLATECHINESE_PRC_CI_ASNOTNULLONPRIMARY3公告管理表USEDXSGO/对象TABLEDBOAFFICHE脚本日期06/13/2014232310/SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLEDBOAFFICHEIDINTIDENTITY1,1NOTNULL,TITLENVARCHAR100COLLATECHINESE_PRC_CI_ASNOTNULL,CONTENTNVARCHAR200COLLATECHINESE_PRC_CI_ASNOTNULL,ADDTIMENVARCHAR50COLLATECHINESE_PRC_CI_ASNOTNULL,ADDERNVARCHAR50COLLATECHINESE_PRC_CI_ASNOTNULL,IFHIDEINTNOTNULLONPRIMARY4留言板信息表USEDXSGO/对象TABLEDBOGUESTBOOK脚本日期06/13/2014232550/SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLEDBOGUESTBOOKIDINTIDENTITY1,1NOTNULL,NICKNAMENVARCHAR100COLLATECHINESE_PRC_CI_ASNOTNULL,PICNVARCHAR100COLLATECHINESE_PRC_CI_ASNOTNULL,EMAILNVARCHAR50COLLATECHINESE_PRC_CI_ASNULL,QQNVARCHAR50COLLATECHINESE_PRC_CI_ASNULL,WEBURLNVARCHAR100COLLATECHINESE_PRC_CI_ASNULL,BLOGURLNVARCHAR100COLLATECHINESE_PRC_CI_ASNULL,EXPRESSIONSNVARCHAR100COLLATECHINESE_PRC_CI_ASNOTNULL,CONTENTNVARCHAR200COLLATECHINESE_PRC_CI_ASNOTNULL,ADDTIMEDATETIMENOTNULL,IPNVARCHAR50COLLATECHINESE_PRC_CI_ASNOTNULL,REPLAYINTNOTNULL,IFHIDEINTNULLONPRIMARY5在线阅读表USEDXSGO/对象TABLEDBOJBJXWJ脚本日期06/13/2014233436/SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLEDBOJBJXWJIDINTIDENTITY1,1NOTNULL,TITLENVARCHAR50COLLATECHINESE_PRC_CI_ASNULL,INTRONVARCHAR150COLLATECHINESE_PRC_CI_ASNULL,URLNVARCHAR50COLLATECHINESE_PRC_CI_ASNULL,JIHUATEXTCOLLATECHINESE_PRC_CI_ASNULL,ADDTIMENVARCHAR50COLLATECHINESE_PRC_CI_ASNULLONPRIMARYTEXTIMAGE_ONPRIMARY6用户登陆表USEDXSGO/对象TABLEDBOMEMBER脚本日期06/13/2014233708/SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLEDBOMEMBERIDINTIDENTITY1,1NOTNULL,USERNAMENVARCHAR50COLLATECHINESE_PRC_CI_ASNOTNULL,PASSWORDNVARCHAR100COLLATECHINESE_PRC_CI_ASNOTNULL,TYPENVARCHAR50COLLATECHINESE_PRC_CI_ASNOTNULL,REGTIMEDATETIMENOTNULL,IFUSEINTNOTNULL,LOGINTIMESINTNOTNULL,LASTTIMEDATETIMENOTNULL,LASTIPNVARCHAR50COLLATECHINESE_PRC_CI_ASNOTNULLONPRIMARY7用户注册表USEDXSGO/对象TABLEDBOPMEMBER脚本日期06/13/2014234134/SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLEDBOPMEMBERIDINTIDENTITY1,1NOTNULL,MIDINTNOTNULL,REALNAMENVARCHAR100COLLATECHINESE_PRC_CI_ASNOTNULL,SEXNVARCHAR50COLLATECHINESE_PRC_CI_ASNOTNULL,BIRNVARCHAR50COLLATECHINESE_PRC_CI_ASNULL,SHENGNVARCHAR50COLLATECHINESE_PRC_CI_ASNULL,CITYNVARCHAR50COLLATECHINESE_PRC_CI_ASNULL,TELPHONENVARCHAR50COLLATECHINESE_PRC_CI_ASNOTNULL,EMAILNVARCHAR50COLLATECHINESE_PRC_CI_ASNOTNULL,QUESTIONNVARCHAR100COLLATECHINESE_PRC_CI_ASNOTNULL,ANSWERNVARCHAR100COLLATECHINESE_PRC_CI_ASNOTNULLONPRIMARY8系统设置表USEDXSGO/对象TABLEDBOSYSTEM脚本日期06/13/2014234422/SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLEDBOSYSTEMIDINTNOTNULL,SITENAMENVARCHAR100COLLATECHINESE_PRC_CI_ASNOTNULL,URLNVARCHAR100COLLATECHINESE_PRC_CI_ASNOTNULL,KEYWORDNVARCHAR500COLLATECHINESE_PRC_CI_ASNOTNULL,DESCRIPTIONNVARCHAR500COLLATECHINESE_PRC_CI_ASNOTNULL,EMAILNVARCHAR100COLLATECHINESE_PRC_CI_ASNOTNULL,STATENVARCHAR50COLLATECHINESE_PRC_CI_ASNOTNULL,REASONSNVARCHAR100COLLATECHINESE_PRC_CI_ASNOTNULL,DIRNVARCHAR100COLLATECHINESE_PRC_CI_ASNOTNULL,RECORDNVARCHAR50COLLATECHINESE_PRC_CI_ASNOTNULL,COPYRIGHTTEXTCOLLATECHINESE_PRC_CI_ASNOTNULLONPRIMARYTEXTIMAGE_ONPRIMARY9在线视频表USEDXSGO/对象TABLEDBOXS脚本日期06/13/2014234800/SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOSETANSI_PADDINGONGOCREATETABLEDBOXSIDINTIDENTITY1,1NOTNULL,TITLENVARCHAR50COLLATECHINESE_PRC_CI_ASN