102
GO
ALTER DATABASE [РекламацииSQL] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [РекламацииSQL] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [РекламацииSQL] SET READ_WRITE
GO
ALTER DATABASE [РекламацииSQL] SET RECOVERY FULL
GO
ALTER DATABASE [РекламацииSQL] SET MULTI_USER
GO
ALTER DATABASE [РекламацииSQL] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [РекламацииSQL] SET DB_CHAINING OFF
GO
USE [РекламацииSQL]
GO
/****** Object: Table [dbo].[Группы] Script Date: 11/29/2011 03:22:02 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Группы]') AND type in
(N'U'))
DROP TABLE [dbo].[Группы]
GO
USE [РекламацииSQL]
GO
/****** Object: Table [dbo].[Группы] Script Date: 11/29/2011 03:22:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Группы](
[ГруппаID] [int] IDENTITY(1,1) NOT NULL,
[Название] [nvarchar](255) NULL,
CONSTRAINT [aaaaaГруппы_PK] PRIMARY KEY NONCLUSTERED
(
[ГруппаID] 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
USE [РекламацииSQL]
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[Заказ_FK00]')
AND parent_object_id = OBJECT_ID(N'[dbo].[Заказ]'))
ALTER TABLE [dbo].[Заказ] DROP CONSTRAINT [Заказ_FK00]
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[Заказ_FK01]')
AND parent_object_id = OBJECT_ID(N'[dbo].[Заказ]'))
ALTER TABLE [dbo].[Заказ] DROP CONSTRAINT [Заказ_FK01]
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[Заказ_FK02]')
AND parent_object_id = OBJECT_ID(N'[dbo].[Заказ]'))
ALTER TABLE [dbo].[Заказ] DROP CONSTRAINT [Заказ_FK02]
GO
USE [РекламацииSQL]
GO
/****** Object: Table [dbo].[Заказ] Script Date: 11/29/2011 03:26:56 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Заказ]') AND type in
(N'U'))
DROP TABLE [dbo].[Заказ]
103
GO
USE [РекламацииSQL]
GO
/****** Object: Table [dbo].[Заказ] Script Date: 11/29/2011 03:26:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Заказ](
[ЗаказID] [int] IDENTITY(1,1) NOT NULL,
[ПокупательКод] [int] NULL,
[ТоварКод] [int] NULL,
[Чек] [nvarchar](255) NULL,
[Договор] [nvarchar](255) NULL,
[ДатаЗаказа] [nvarchar](255) NULL,
[СпОплаты] [int] NULL,
CONSTRAINT [aaaaaЗаказ_PK] PRIMARY KEY NONCLUSTERED
(
[ЗаказID] 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].[Заказ] WITH CHECK ADD CONSTRAINT [Заказ_FK00] FOREIGN
KEY([ПокупательКод])
REFERENCES [dbo].[Покупатель] ([ПокупательID])
GO
ALTER TABLE [dbo].[Заказ] CHECK CONSTRAINT [Заказ_FK00]
GO
ALTER TABLE [dbo].[Заказ] WITH CHECK ADD CONSTRAINT [Заказ_FK01] FOREIGN
KEY([СпОплаты])
REFERENCES [dbo].[СпособыОплаты] ([СпОплатыID])
GO
ALTER TABLE [dbo].[Заказ] CHECK CONSTRAINT [Заказ_FK01]
GO
ALTER TABLE [dbo].[Заказ] WITH CHECK ADD CONSTRAINT [Заказ_FK02] FOREIGN
KEY([ТоварКод])
REFERENCES [dbo].[Товар] ([ТоварID])
GO
ALTER TABLE [dbo].[Заказ] CHECK CONSTRAINT [Заказ_FK02]
GO
USE [РекламацииSQL]
GO
USE [РекламацииSQL]
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id =
OBJECT_ID(N'[dbo].[Покупатель_FK00]') AND parent_object_id = OBJECT_ID(N'[dbo].[Покупатель]'))
ALTER TABLE [dbo].[Покупатель] DROP CONSTRAINT [Покупатель_FK00]
GO
USE [РекламацииSQL]
GO
/****** Object: Table [dbo].[Покупатель] Script Date: 11/29/2011 03:31:04 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Покупатель]') AND
type in (N'U'))
DROP TABLE [dbo].[Покупатель]
GO
USE [РекламацииSQL]
GO
/****** Object: Table [dbo].[Покупатель] Script Date: 11/29/2011 03:31:04 ******/
104
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Покупатель](
[ПокупательID] [int] IDENTITY(1,1) NOT NULL,
[ФИО] [nvarchar](255) NULL,
[Адрес] [nvarchar](255) NULL,
[Телефон] [nvarchar](255) NULL,
[РекламацияКод] [int] NULL,
CONSTRAINT [aaaaaПокупатель_PK] PRIMARY KEY NONCLUSTERED
(
[ПокупательID] 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
USE [РекламацииSQL]
GO
/****** Object: Table [dbo].[Поставщик] Script Date: 11/29/2011 03:31:45 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Поставщик]') AND
type in (N'U'))
DROP TABLE [dbo].[Поставщик]
GO
USE [РекламацииSQL]
GO
/****** Object: Table [dbo].[Поставщик] Script Date: 11/29/2011 03:31:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Поставщик](
[ПоставщикаID] [int] IDENTITY(1,1) NOT NULL,
[ИНН] [nvarchar](255) NULL,
[КПП] [nvarchar](255) NULL,
[Адрес] [nvarchar](255) NULL,
[Телефон] [nvarchar](255) NULL,
[Контакт] [nvarchar](255) NULL,
[Должность] [nvarchar](255) NULL,
CONSTRAINT [aaaaaПоставщик_PK] PRIMARY KEY NONCLUSTERED
(
[ПоставщикаID] 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
USE [РекламацииSQL]
GO
/****** Object: Table [dbo].[Размеры] Script Date: 11/29/2011 03:33:34 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Размеры]') AND type
in (N'U'))
DROP TABLE [dbo].[Размеры]
GO
USE [РекламацииSQL]
GO
/****** Object: Table [dbo].[Размеры] Script Date: 11/29/2011 03:33:34 ******/
SET ANSI_NULLS ON
105
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Размеры](
[РазмерID] [int] IDENTITY(1,1) NOT NULL,
[Название] [nvarchar](255) NULL,
CONSTRAINT [aaaaaРазмеры_PK] PRIMARY KEY NONCLUSTERED
(
[РазмерID] 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
USE [РекламацииSQL]
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id =
OBJECT_ID(N'[dbo].[FK_Регламент_Заказ]') AND parent_object_id = OBJECT_ID(N'[dbo].[Регламент]'))
ALTER TABLE [dbo].[Регламент] DROP CONSTRAINT [FK_Регламент_Заказ]
GO
USE [РекламацииSQL]
GO
/****** Object: Table [dbo].[Регламент] Script Date: 11/29/2011 03:34:10 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Регламент]') AND type
in (N'U'))
DROP TABLE [dbo].[Регламент]
GO
USE [РекламацииSQL]
GO
/****** Object: Table [dbo].[Регламент] Script Date: 11/29/2011 03:34:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Регламент](
[РегламентID] [int] IDENTITY(1,1) NOT NULL,
[Название] [nvarchar](255) NULL,
[Описание] [nvarchar](255) NULL,
CONSTRAINT [aaaaaРегламент_PK] PRIMARY KEY NONCLUSTERED
(
[РегламентID] 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
USE [РекламацииSQL]
GO
/****** Object: Table [dbo].[Рекламация] Script Date: 11/29/2011 03:34:54 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Рекламация]') AND
type in (N'U'))
DROP TABLE [dbo].[Рекламация]
GO
USE [РекламацииSQL]
GO
/****** Object: Table [dbo].[Рекламация] Script Date: 11/29/2011 03:34:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
106
CREATE TABLE [dbo].[Рекламация](
[РекламацияID] [int] IDENTITY(1,1) NOT NULL,
[Описание] [nvarchar](255) NULL,
[ДатаРекламации] [nvarchar](255) NULL,
[Пожелание] [nvarchar](255) NULL,
CONSTRAINT [aaaaaРекламация_PK] PRIMARY KEY NONCLUSTERED
(
[РекламацияID] 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
USE [РекламацииSQL]
GO
/****** Object: Table [dbo].[СпособыОплаты] Script Date: 11/29/2011 03:35:37 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[СпособыОплаты]')
AND type in (N'U'))
DROP TABLE [dbo].[СпособыОплаты]
GO
USE [РекламацииSQL]
GO
/****** Object: Table [dbo].[СпособыОплаты] Script Date: 11/29/2011 03:35:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[СпособыОплаты](
[СпОплатыID] [int] IDENTITY(1,1) NOT NULL,
[Название] [nvarchar](255) NULL,
CONSTRAINT [aaaaaСпособыОплаты_PK] PRIMARY KEY NONCLUSTERED
(
[СпОплатыID] 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
USE [РекламацииSQL]
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[Товар_FK00]')
AND parent_object_id = OBJECT_ID(N'[dbo].[Товар]'))
ALTER TABLE [dbo].[Товар] DROP CONSTRAINT [Товар_FK00]
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[Товар_FK01]')
AND parent_object_id = OBJECT_ID(N'[dbo].[Товар]'))
ALTER TABLE [dbo].[Товар] DROP CONSTRAINT [Товар_FK01]
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[Товар_FK02]')
AND parent_object_id = OBJECT_ID(N'[dbo].[Товар]'))
ALTER TABLE [dbo].[Товар] DROP CONSTRAINT [Товар_FK02]
GO
USE [РекламацииSQL]
GO
/****** Object: Table [dbo].[Товар] Script Date: 11/29/2011 03:36:06 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Товар]') AND type in
(N'U'))
107
DROP TABLE [dbo].[Товар]
GO
USE [РекламацииSQL]
GO
/****** Object: Table [dbo].[Товар] Script Date: 11/29/2011 03:36:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Товар](
[ТоварID] [int] IDENTITY(1,1) NOT NULL,
[Название] [nvarchar](255) NULL,
[РазмерКод] [int] NULL,
[ПоставшикКод] [int] NULL,
[ГруппаКод] [int] NULL,
[Цена] [nvarchar](255) NULL,
CONSTRAINT [aaaaaТовар_PK] PRIMARY KEY NONCLUSTERED
(
[ТоварID] 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
