USE [Malii]
GO
/****** Object:  User [##MS_PolicyEventProcessingLogin##]    Script Date: 06/29/2013 02:52:36 ******/
CREATE USER [##MS_PolicyEventProcessingLogin##] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object:  User [##MS_PolicyTsqlExecutionLogin##]    Script Date: 06/29/2013 02:52:36 ******/
CREATE USER [##MS_PolicyTsqlExecutionLogin##] FOR LOGIN [##MS_PolicyTsqlExecutionLogin##] WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object:  Table [dbo].[MChartOfAccounts]    Script Date: 06/29/2013 02:52:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MChartOfAccounts](
	[IDentityy] [int] IDENTITY(1,1) NOT NULL,
	[IDD] [int] NOT NULL,
	[ID1] [int] NULL,
	[Namee] [nvarchar](100) NULL,
 CONSTRAINT [PK_MChartOfAccounts] PRIMARY KEY CLUSTERED 
(
	[IDD] 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
/****** Object:  Table [dbo].[MChartOfAccountsD]    Script Date: 06/29/2013 02:52:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MChartOfAccountsD](
	[IDentityy] [int] IDENTITY(1,1) NOT NULL,
	[IDD] [int] NOT NULL,
	[IDDTxt] [nvarchar](100) NULL,
	[Namee] [nvarchar](100) NULL,
	[IDDChartM] [int] NULL,
 CONSTRAINT [PK_MChartOfAccountsD] PRIMARY KEY CLUSTERED 
(
	[IDD] 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
/****** Object:  Table [dbo].[MInvDetail]    Script Date: 06/29/2013 02:52:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MInvDetail](
	[IDentityy] [int] IDENTITY(1,1) NOT NULL,
	[IDD] [int] NOT NULL,
	[Sequence] [int] NULL,
	[StartYear] [date] NULL,
	[Numberr] [int] NULL,
	[Datee] [date] NULL,
	[PayType] [int] NULL,
	[Val] [money] NULL,
	[ValDesc] [nvarchar](50) NULL,
	[ConSeq] [int] NULL,
	[ConFlag] [int] NULL,
	[ConType] [int] NULL,
	[AvVal] [money] NULL,
	[IDDChartD] [int] NULL,
	[IDDInvM] [int] NULL,
 CONSTRAINT [PK_MInvDetail] PRIMARY KEY CLUSTERED 
(
	[IDD] 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
/****** Object:  Table [dbo].[MInvData]    Script Date: 06/29/2013 02:52:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MInvData](
	[IDentityy] [int] IDENTITY(1,1) NOT NULL,
	[IDD] [int] NOT NULL,
	[StartYear] [date] NULL,
	[Numberr] [int] NULL,
	[Datee] [date] NULL,
	[Amount] [money] NULL,
	[AmountTo] [nvarchar](50) NULL,
	[Causee] [nvarchar](30) NULL,
	[CountNum] [int] NULL,
	[CountDate] [date] NULL,
	[DocType] [nvarchar](30) NULL,
	[OldAmount] [money] NULL,
	[PostFlag] [int] NULL,
	[EntryNumber] [int] NULL,
	[IDDChartD] [int] NULL,
 CONSTRAINT [PK_MInvData] PRIMARY KEY CLUSTERED 
(
	[IDD] 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
/****** Object:  ForeignKey [FK_MChartOfAccountsD_MChartOfAccounts]    Script Date: 06/29/2013 02:52:36 ******/
ALTER TABLE [dbo].[MChartOfAccountsD]  WITH CHECK ADD  CONSTRAINT [FK_MChartOfAccountsD_MChartOfAccounts] FOREIGN KEY([IDDChartM])
REFERENCES [dbo].[MChartOfAccounts] ([IDD])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[MChartOfAccountsD] CHECK CONSTRAINT [FK_MChartOfAccountsD_MChartOfAccounts]
GO
/****** Object:  ForeignKey [FK_MInvData_MChartOfAccountsD]    Script Date: 06/29/2013 02:52:36 ******/
ALTER TABLE [dbo].[MInvData]  WITH CHECK ADD  CONSTRAINT [FK_MInvData_MChartOfAccountsD] FOREIGN KEY([IDDChartD])
REFERENCES [dbo].[MChartOfAccountsD] ([IDD])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[MInvData] CHECK CONSTRAINT [FK_MInvData_MChartOfAccountsD]
GO
/****** Object:  ForeignKey [FK_MInvDetail_MChartOfAccountsD]    Script Date: 06/29/2013 02:52:36 ******/
ALTER TABLE [dbo].[MInvDetail]  WITH CHECK ADD  CONSTRAINT [FK_MInvDetail_MChartOfAccountsD] FOREIGN KEY([IDDChartD])
REFERENCES [dbo].[MChartOfAccountsD] ([IDD])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[MInvDetail] CHECK CONSTRAINT [FK_MInvDetail_MChartOfAccountsD]
GO