Если нет структуры для сохранения товаров в базе данных, то мы можем создать её на SQLEXPRESS или MSQL Server в базе данных.
Создание таблиц в MSSQL для YML:
USE [magazin]
GO
/****** Object: Table [dbo].[yml_category] Script Date: 08/28/2009 15:57:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[yml_category](
[ID] [bigint] NULL,
[parentId] [bigint] NULL,
[name] [nvarchar](1000) NULL,
[dateCreated] [datetime] NULL
) ON [PRIMARY]
USE [magazin]
GO
/****** Object: Table [dbo].[yml_category_offer] Script Date: 08/28/2009 15:57:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[yml_category_offer](
[itemId] [bigint] NULL,
[categoryId] [bigint] NULL,
[dateCreated] [datetime] NULL
) ON [PRIMARY]
USE [magazin]
GO
/****** Object: Table [dbo].[yml_offer] Script Date: 08/28/2009 15:57:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[yml_offer](
[ID] [bigint] NULL,
[available] [bit] NULL,
[url] [nvarchar](250) NULL,
[price] [decimal](18, 4) NULL,
[currencyId] [varchar](50) NULL,
[picture] [nvarchar](250) NULL,
[delivery] [bit] NULL,
[orderingTime] [nvarchar](250) NULL,
[name] [nvarchar](1000) NULL,
[description] [ntext] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
alexeiv
