Показать сообщение отдельно
Старый 22.12.2012, 15:50  
Salomey
Читер
Аватар для Salomey
OFFLINE
Регистрация: 31.03.2011
Сообщений: 192
Благодарностей:
9,117 всего
Мнения: + 3918
Репутация: 22975
Отправить сообщение для Salomey с помощью Skype™

Как ты мог ее удалить? Неужели просто запрос этот нельзя было тупо выполнить?
___________________________
ПО ТЕМЕ:
Цитата:
USE [RF_User]
GO

/****** Object: Table [dbo].[tbl_UserAccount] Script Date: 12/22/2012 15:51:05 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tbl_UserAccount](
[serial] [int] IDENTITY(1,1) NOT NULL,
[id] [binary](16) NOT NULL,
[createtime] [datetime] NOT NULL,
[createip] [char](16) NOT NULL,
[lastlogintime] [datetime] NOT NULL,
[lastlogofftime] [datetime] NOT NULL,
[totallogmin] [int] NOT NULL,
[lastconnectip] [char](16) NOT NULL,
[pushclosetime] [datetime] NOT NULL,
[pusherip] [char](16) NOT NULL,
[JoinCode] [int] NOT NULL,
[LoginFailureCnt] [tinyint] NOT NULL,
[fire_on] [smalldatetime] NOT NULL,
[fire_warning] [smalldatetime] NOT NULL,
[uilock] [tinyint] NOT NULL,
[uilock_pw] [binary](13) NOT NULL,
[uilock_failcnt] [tinyint] NOT NULL,
[uilock_update] [smalldatetime] NOT NULL,
[uilock_hintindex] [tinyint] NOT NULL,
[uilock_hintanswer] [binary](17) NOT NULL,
[uilock_find_pass_failcnt] [tinyint] NOT NULL,
[gpoint] [int] NOT NULL,
CONSTRAINT [PK_tbl_rfuser] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [IX_tbl_rfuser] UNIQUE NONCLUSTERED
(
[serial] 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

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_rfuser_CreateTime] DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_rfuser_createip] DEFAULT ((0)) FOR [createip]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_rfuser_LastLogTime] DEFAULT (getdate()) FOR [lastlogintime]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_rfuser_lastlogintime1] DEFAULT (getdate()) FOR [lastlogofftime]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_rfuser_TotalLogMin] DEFAULT ((0)) FOR [totallogmin]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_rfuser_lastconnectip] DEFAULT ((0)) FOR [lastconnectip]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_rfuser_pushclosetime] DEFAULT (getdate()) FOR [pushclosetime]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_rfuser_pusherip] DEFAULT ((0)) FOR [pusherip]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_rfuser_JoinCode] DEFAULT ((0)) FOR [JoinCode]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_loginfailurecnt] DEFAULT ((0)) FOR [LoginFailureCnt]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_fire_on] DEFAULT (getdate()) FOR [fire_on]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_fire_warning] DEFAULT (getdate()) FOR [fire_warning]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_uilock] DEFAULT ((0)) FOR [uilock]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_uilock_pw] DEFAULT ((0)) FOR [uilock_pw]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_uilock_failcnt] DEFAULT ((0)) FOR [uilock_failcnt]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_uilock_update] DEFAULT ((0)) FOR [uilock_update]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_uilock_hintindex] DEFAULT ((0)) FOR [uilock_hintindex]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_uilock_hintanswer] DEFAULT ((0)) FOR [uilock_hintanswer]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_uilock_find_pass_failcnt] DEFAULT ((0)) FOR [uilock_find_pass_failcnt]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_UserAccount_gpoint] DEFAULT ((0)) FOR [gpoint]
GO


Последний раз редактировалось Salomey; 22.12.2012 в 15:53. Причина: Добавлено сообщение

Под лежачий камень вода не течёт.
 
Сказали спасибо:
RotooW (22.12.2012)