drop table if exists 'article';
create table Article
(
ArtID int(20) not null auto_increment,
ArtCaption varchar(100) not null,
ArtContent varchar(5000) not null,
ArtPublishTime date default null,
ArtLimit char(1) not null,--权限,0为hide,1为public
ArtUser int(5) not null,
ArtClass int(10) not null,
primary key('ArtID')
)default charset=GBK;drop table if exists 'UserData';
create table UserData
(
UserID int(5) not null auto_increment,
UserAccount varchar(10) not null,
UserPassword varchar(16) not null,
UserNickName varchar(10) not null,
UserRealName varchar(10),
UserSex char(1),--0为女,1为男
UserAge varchar(3),
UserBirthday date default null,
UserConstellation varchar(4) default null,
UserInterest varchar(100) default null,
UserProfession varchar(10) default null,
UserAddress varchar(100) default null,
UserBlogTitle varchar(100) not null,
UserPageTitle varchar(50) default null,
primary key('UserID')
)default charset=GBK;drop table if exists 'ArticleClass';
create table ArticleClass
(
ArtClassID int(10) not null auto_increment,
ArtClassName varchar(100) not null,
primary key('UserID')
)default charset=GBK;drop table if exists 'Re';
create table Re
(
RmkID int(20) not null auto_increment,
RmkUsername varchar(10) not null,
RmkContent varchar(500) not null,
RmkTime date default null,
ArtID int(20) not null,
primary key('RmkID')
)default charset=GBK;drop table if exists 'FriendLink';
create table FriendLink
(
FLID int(8) not null auto_increment,
FriendName varchar(10) not null,
FriendURL varchar(100) not null,
primary key('FLID')
)default charset=GBK;drop table if exists 'MsgBoard';
create table MsgBoard
(
MsgID int(20) not null auto_increment,
MsgUsername varchar(10) not null,
MsgUserMail varchar(50) default null,
MsgUserQQ varchar(12) default null,
MsgUserWebSite varchar(100) default null,
MsgContent varchar(500) not null,
MsgTime date default null,
primary key('MsgID')
)default charset=GBK;
alter table Article add constraint 'Art1' foreign key('ArtUser') references UserData('UserID');
alter table Article add constraint 'Art2' foreign key('ArtClass') references ArticleClass('ArtClassID');
alter table Re add constraint 'Rmk1' foreign key('ArtID') references Article('ArtID');
=====================================================================
mysql query browser 老是报错!!!! 郁闷啊.
create table Article
(
ArtID int(20) not null auto_increment,
ArtCaption varchar(100) not null,
ArtContent varchar(5000) not null,
ArtPublishTime date default null,
ArtLimit char(1) not null,--权限,0为hide,1为public
ArtUser int(5) not null,
ArtClass int(10) not null,
primary key('ArtID')
)default charset=GBK;drop table if exists 'UserData';
create table UserData
(
UserID int(5) not null auto_increment,
UserAccount varchar(10) not null,
UserPassword varchar(16) not null,
UserNickName varchar(10) not null,
UserRealName varchar(10),
UserSex char(1),--0为女,1为男
UserAge varchar(3),
UserBirthday date default null,
UserConstellation varchar(4) default null,
UserInterest varchar(100) default null,
UserProfession varchar(10) default null,
UserAddress varchar(100) default null,
UserBlogTitle varchar(100) not null,
UserPageTitle varchar(50) default null,
primary key('UserID')
)default charset=GBK;drop table if exists 'ArticleClass';
create table ArticleClass
(
ArtClassID int(10) not null auto_increment,
ArtClassName varchar(100) not null,
primary key('UserID')
)default charset=GBK;drop table if exists 'Re';
create table Re
(
RmkID int(20) not null auto_increment,
RmkUsername varchar(10) not null,
RmkContent varchar(500) not null,
RmkTime date default null,
ArtID int(20) not null,
primary key('RmkID')
)default charset=GBK;drop table if exists 'FriendLink';
create table FriendLink
(
FLID int(8) not null auto_increment,
FriendName varchar(10) not null,
FriendURL varchar(100) not null,
primary key('FLID')
)default charset=GBK;drop table if exists 'MsgBoard';
create table MsgBoard
(
MsgID int(20) not null auto_increment,
MsgUsername varchar(10) not null,
MsgUserMail varchar(50) default null,
MsgUserQQ varchar(12) default null,
MsgUserWebSite varchar(100) default null,
MsgContent varchar(500) not null,
MsgTime date default null,
primary key('MsgID')
)default charset=GBK;
alter table Article add constraint 'Art1' foreign key('ArtUser') references UserData('UserID');
alter table Article add constraint 'Art2' foreign key('ArtClass') references ArticleClass('ArtClassID');
alter table Re add constraint 'Rmk1' foreign key('ArtID') references Article('ArtID');
=====================================================================
mysql query browser 老是报错!!!! 郁闷啊.
我已经解决了。 符号问题。
[align=center]==== 思想重于技巧 ====
[/align]
.
贴子分数<20:对自已的问题不予重视。
贴子大量未结:对别人的回答不予尊重。
.