crebas.sql

用asp做的一个小的聊天程序

/*==============================================================*/
/* DBMS name:      Microsoft SQL Server 2000                    */
/* Created on:     2005-12-5 19:13:16                           */
/*==============================================================*/
create database lijianhua
go
use lijianhua
go

if exists (select 1
            from  sysobjects
           where  id = object_id('leaguer')
            and   type = 'U')
   drop table leaguer
go

/*==============================================================*/
/* Table: leaguer                                               */
/*==============================================================*/
create table leaguer (
   em_name              varchar(10)          not null,
   em_password1         varchar(15)          null,
   em_password2         varchar(15)          null,
   cert_number          varchar(20)          null,
   pormpt_pro           varchar(50)          null,
   prompt_key           varchar(50)          null,
   real_name                 varchar(10)          null,
   sex                  bit                  null,
   province             varchar(20)          null,
   city                 varchar(20)          null,
   mobile               varchar(13)          null,
   email                varchar(50)          null,
   memery               varchar(20)          null,
   constraint PK_LEAGUER primary key  (em_name)
)
go

insert into leaguer values('xingmulee','53174390','53174390','','','','','','','','','','')