电子相册系统 源代码

CREATE TABLE [Photos] ( [PhotoID] [int] IDENTITY (1, 1) NOT NULL , [PhotoTitle] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL , [PhotoDesc] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [PhotoFileName] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL , [CateID] [int] NULL , [UserID] [int] NULL , CONSTRAINT [PK_Photos] PRIMARY KEY CLUSTERED ( [PhotoID] ) ON [PRIMARY] ) ON [PRIMARY] go alter table Photos add constraint FK_PHOTOS_REFERENCE_CATEGORY foreign key (CateID) references Categorys (CateID) go alter table Photos add constraint FK_PHOTOS_REFERENCE_USERINFO foreign key (UserID) references UserInfo (UserID) go