guestbook.sql

来自「jsp留言板 对刚学的希望有帮助,程序很简单的」· SQL 代码 · 共 49 行

IF EXISTS (SELECT Name FROM master.dbo.sysdatabases WHERE name = N'GuestBook')
	DROP DATABASE GuestBook
GO

CREATE DATABASE GuestBook
go

use GuestBook
go
/*==============================================================*/
/*1 Table: Users                                        */
/*==============================================================*/ 
 CREATE TABLE Users (
        ID                   bigint IDENTITY(1000,1) not null,
        Name                 varchar(20) NOT NULL,
        Pwd                  varchar(20) NOT NULL,
        Popedom              int NOT NULL,
 )
go
 
 
 ALTER TABLE Users
        ADD PRIMARY KEY (ID ASC)
go
 
/*==============================================================*/
/*2 Table: Messages                                         */
/*==============================================================*/ 
 CREATE TABLE Messages (
        Id                   bigint IDENTITY(1,1) not null,        
        L_Id                 bigint NOT NULL  references Users(id),
        Re_Id                bigint     NULL  references Users(id),
        Contents             varchar(500) NOT NULL,
        Title                varchar(50)  NOT NULL,
        Re_Contents          varchar(500) NULL,
        L_time               datetime NOT NULL  default getdate(),
        Re_time              datetime NULL,
        
 )
go
 
 
 ALTER TABLE Messages
        ADD PRIMARY KEY (Id ASC)
go

insert  Users  values ("admin","admin","1")
insert  Users  values ("Member","123","0")
go