[Request Users_Masters design

[andya78]

hey guys ive been a nub and dropped my users masters table thinking id made a backup but hadnt saved it properly so now i dont have it lol
i had originally posted this up myself for others who have made the same mistake but unfortunatly its been removed due to no more downloads of it and now made the same mistake myself LOL
if anyone can post an image on here or somewhere id be greatful
i would just reconect a new PS_User blah blah but i have other tables in there that i dont want to lose by messing up so would rather just redesign the users master table cheers

[Clonaid]

 Spoiler

USE PS_UserData
GO

DROP TABLE dbo.Users_Master
GO

CREATE TABLE dbo.Users_Master(
UserUID INT NOT NULL,
UserID VARCHAR(18) NOT NULL,
Pw VARCHAR(12) NOT NULL,
JoinDate SMALLDATETIME NOT NULL CONSTRAINT DF_Users_Master_JoinDate DEFAULT (getdate()),
Admin BIT NOT NULL,
AdminLevel TINYINT NOT NULL,
UseQueue BIT NOT NULL,
Status SMALLINT NOT NULL,
Leave TINYINT NOT NULL,
LeaveDate SMALLDATETIME NULL,
UserType CHAR(1) NOT NULL,
UserIp VARCHAR(15) NULL,
ModiIp VARCHAR(15) NULL,
ModiDate DATETIME NULL,
Point INT NOT NULL CONSTRAINT DF_Users_Master_Point DEFAULT (0),
Enpassword CHAR(32) NULL,
Birth VARCHAR(8) NULL,
Email VARCHAR(50) NULL
) ON [PRIMARY]
GO

Hope this works for you