create database jspdev

drop table user_info 

CREATE TABLE user_info (	
        userid nvarchar (40)  NOT NULL ,
	name nvarchar (40)  NOT NULL ,	        	
	phone nvarchar (40)  NOT NULL ,
        street nvarchar (40)  NOT NULL ,
        state nvarchar (40)  NOT NULL ,
        city nvarchar (40)  NOT NULL ,       
        zipCode nvarchar (40)  NOT NULL ,
        email nvarchar (40)  NULL ,	
        cardNumber nvarchar (40)  NOT NULL ,
	cardType int NOT NULL ,
	userLogCount int NOT NULL ,
	userLastLogTime smalldatetime NULL ,	
	userType int NOT NULL ,
        banneropt int NOT NULL,
        fanvcategory nvarchar (40)  NOT NULL ,
        password nvarchar (40)  NOT NULL ,
	constraint pk_userinfo primary key(userId)
) 
GO