资源描述：
《微博开发设计文档》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、微博开发设计文档数据库MySQLDataTninsferSourceHost:localhostSourceDatabase:testdb2011TargetHost:localhostTargetDatabase:testdb2011Date:2011-5-2417:05:09SETFOREIGN_KEY_CHECKS=0;一TablestructureforarticleCREATETABLE'article、(vatcidvint(20)NOTNULLAUTO.INCREMENT,'username'varchar(20)COLLATEu
2、tf8_unicode_ciNOTNULL,'content'varchar(600)COLLATEutf8_unicode_ciNOTNULL,'pubdate、datetimeNOTNULLDEFAULTf0000-00-0000:00:00；'replycounfint(20)NOTNULLDEFAULTO,CHARSET=utfBCHARSET=utf8PRIMARYKEYfatcid'))ENGINE=MyISAMAUTO_INCREMENT=27DEFAULTCOLLATE=utf8_unicode_ci;-Tablestructu
3、reformyfriendCREATETABLE'myfriend、(、id'int(20)NOTNULLAUTOJNCREMENT,'myname'varchar(20)COLLATEutf8_unicode_ciNOTNULL,sfname'varchar(20)COLLATEutf8_unicode_ciNOTNULL,'fimage'varchar(50)COLLATEutf8_unicode_ciNOTNULL,PRIMARYKEY('id'))ENGINE=MyISAMAUTO_INCREMENT=54DEFAULTCOLLATE=
4、utf8_unicode_ci;一TablestructureforreplyCREATETABLEsreplyv('repid'int(20)NOTNULLAUTO_INCREMENT,vartidsint(20)NOTNULL,'repuser'varchar(20)COLLATEutf8_unicode_ciNOTNULL,'repcontent'varchar(600)COLLATEutf8_unicode_ciNOTNULL,vrepdate'datetimeNOTNULLDEFAULT'0000-00-0000:00:00',PRI
5、MARYKEYfrepid'))ENGINE=MyISAMAUTO_INCREMENT=2DEFAULTCHARSET=utf8COLLATE=utf8_unicode_ci;TablestructureforuserCREATETABLE'user'('uid、int(20)NOTNULLAUTO.INCREMENT,'name'varchar(20)COLLATEutf8_unicode_ciNOTNULL,'password'varchar(20)COLLATEutfB_unicode_ciNOTNULL,'emaiPvarchar(50
6、)COLLATEutf8_unicode_ciNOTNULL,legdate'datetimeNOTNULLDEFAULT'0000-00-0000:00:00；'image'varchar(50)COLLATEutf8_unicode_ciNOTNULLDEFAULT'uploadphoto.gif,Attention'int(20)NOTNULLDEFAULT‘0；PRIMARYKEY('uid'))ENGINE=MyISAMAUTO」NCREMENT=9DEFAULTCHARSET=utf8COLLATE=utf8_unicode_ci;
7、—RecordsINSERTINTO'article、VALUES（T,阿奎字你好,这是我第一次做微波的网站,做的不好,请多多指教!*2011-05-2100:00:00；O）;INSERTINTO'article、VALUES（2,‘admin；'呵呵，你好呀,谢谢你的帮助！‘，2011-05-23（）0:00:00；O）;INSERTINTO'article'VALUES（3'admin1,'恩，不错的,今天好不开心!!!*,2011-05-2300:00:00；O）;INSERTINTO'article'VALUES（4,'admin
8、；'昨天下了好大的雨呀，真是郁闷!!*,*2011-05-2300:00:00；O）;INSERTINTO'article'VALUES（‘5；‘ad
