55 lines
1.7 KiB
Transact-SQL
55 lines
1.7 KiB
Transact-SQL
USE [LosaGame]
|
|
GO
|
|
|
|
/****** Object: Table [dbo].[userPracticeDB] Script Date: 2017-11-13 ¿ÀÀü 10:16:55 ******/
|
|
DROP TABLE [dbo].[userPracticeDB]
|
|
GO
|
|
|
|
/****** Object: Table [dbo].[userPracticeDB] Script Date: 2017-11-13 ¿ÀÀü 10:16:55 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
CREATE TABLE [dbo].[userPracticeDB](
|
|
[AccountIDX] [int] NOT NULL,
|
|
[PracticeIDX] [int] NOT NULL,
|
|
[PracticeCount] [int] NOT NULL,
|
|
[PracticeGrade] [int] NOT NULL,
|
|
[PracticeTime] [int] NOT NULL,
|
|
[PracticeRank] [int] NOT NULL,
|
|
[UpdateDate][datetime] NOT NULL,
|
|
[regDate] [datetime] NOT NULL,
|
|
CONSTRAINT [PK_userPracticeDB] PRIMARY KEY CLUSTERED
|
|
(
|
|
[AccountIDX] ASC,
|
|
[PracticeIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[userPracticeDB] ADD CONSTRAINT [DF__userPract__Pract__4AE30379] DEFAULT ((0)) FOR [PracticeIDX]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[userPracticeDB] ADD CONSTRAINT [DF__userPract__Grade__4BD727B2] DEFAULT ((0)) FOR [PracticeGrade]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[userPracticeDB] ADD CONSTRAINT [DF__userPract__Count__4BD727B2] DEFAULT ((0)) FOR [PracticeCount]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[userPracticeDB] ADD CONSTRAINT [DF__userPract__time__4BD727B2] DEFAULT ((999999999)) FOR [PracticeTime]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[userPracticeDB] ADD CONSTRAINT [DF__userPract__Rank__4BD727B2] DEFAULT ((99999999)) FOR [PracticeRank]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[userPracticeDB] ADD CONSTRAINT [DF__userPract__UpdateDate__4DBF7024] DEFAULT (getdate()) FOR [UpdateDate]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[userPracticeDB] ADD CONSTRAINT [DF__userPract__regDa__4DBF7024] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
|
|
|