CREATE TABLE [dbo].[Sklad] (
	[ID_sklad] [int] IDENTITY ( 1 ,  1 ) NOT NULL ,
	[Naim_sklad] [nvarchar] ( 100 ) COLLATE Cyrillic_General_CI_AS NOT NULL ,
	[Deleted] [bit] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[MOL] (
	[ID_MOL] [int] IDENTITY ( 1 ,  1 ) NOT NULL ,
	[Tab_nomer] [int] NOT NULL ,
	[FIO_mol] [nvarchar] ( 200 ) COLLATE Cyrillic_General_CI_AS NOT NULL ,
	[Sklad_otn] [int] NOT NULL ,
	[Deleted] [bit] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Tmc] (
	[ID_tmc] [int] IDENTITY ( 1 ,  1 ) NOT NULL ,
	[KOD_tmc] [bigint] NOT NULL ,
	[Naim_tmc] [nvarchar] ( 100 ) COLLATE Cyrillic_General_CI_AS NULL ,
	[Polnoe_naim] [ntext] COLLATE Cyrillic_General_CI_AS NULL ,
	[Ed_izmer] [int] NULL ,
	[Tmc_count] [int] NULL ,
	[Deleted] [bit] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Counts] (
	[ID_count] [int] IDENTITY ( 1 ,  1 ) NOT NULL ,
	[KOD_count] [bigint] NOT NULL ,
	[Naim_count] [nvarchar] ( 100 ) COLLATE Cyrillic_General_CI_AS NOT NULL ,
	[Deleted] [bit] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Ed_izm] (
	[ID_izm] [int] IDENTITY ( 1 ,  1 ) NOT NULL ,
	[Naim_izm] [nvarchar] ( 50 ) COLLATE Cyrillic_General_CI_AS NOT NULL ,
	[Polnoe_naim_izm] [nvarchar] ( 1000 ) COLLATE Cyrillic_General_CI_AS NULL ,
	[Deleted] [bit] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Kontragents] (
	[ID_KONT] [int] IDENTITY ( 1 ,  1 ) NOT NULL ,
	[ID_1C] [int] NOT NULL ,
	[Naim] [char] ( 30 ) COLLATE Cyrillic_General_CI_AS NOT NULL ,
	[EGRPOU] [char] ( 15 ) COLLATE Cyrillic_General_CI_AS NULL ,
	[INN] [char] ( 20 ) COLLATE Cyrillic_General_CI_AS NULL ,
	[Telefon] [char] ( 20 ) COLLATE Cyrillic_General_CI_AS NULL ,
	[Deleted] [bit] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Prihod_shapka] (
	[ID_Shapka] [int] IDENTITY ( 1 ,  1 ) NOT NULL ,
	[Deleted] [bit] NULL ,
	[Checked] [bit] NULL ,
	[Date_p] [datetime] NOT NULL ,
	[Kontrag_kod] [int] NOT NULL ,
	[Sklad_kod] [int] NOT NULL ,
	[Mol_kod] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Prihod_stroki] (
	[ID_prihod_str] [int] IDENTITY ( 1 ,  1 ) NOT NULL ,
	[TMC_kod] [int] NOT NULL ,
	[Ed_izm_id] [int] NOT NULL ,
	[Count_id] [int] NOT NULL ,
	[Kol] [float] NULL ,
	[Price] [float] NULL ,
	[ID_prihod_shap] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Rashod_shapka] (
	[ID_Shapka] [int] IDENTITY ( 1 ,  1 ) NOT NULL ,
	[Deleted] [bit] NULL ,
	[Checked] [bit] NULL ,
	[Date_r] [datetime] NOT NULL ,
	[Kontrag_kod] [int] NOT NULL ,
	[Sklad_kod] [int] NOT NULL ,
	[Mol_kod] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Rashod_stroki] (
	[ID_rashod_str] [int] IDENTITY ( 1 ,  1 ) NOT NULL ,
	[TMC_kod] [int] NOT NULL ,
	[Ed_izm_id] [int] NOT NULL ,
	[Count_id] [int] NOT NULL ,
	[Kol] [float] NULL ,
	[Price] [float] NULL ,
	[ID_rashod_shap] [int] NOT NULL 
) ON [PRIMARY]
GO