USE [moc]
GO

/****** Object:  Table [dbo].[cdr]    Script Date: 02/01/2010 00:29:17 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[cdr](
	[acctid] [bigint] IDENTITY(1,1) NOT NULL,
	[calldate] [datetime] NOT NULL,
	[clid] [varchar](80) NOT NULL,
	[src] [varchar](80) NOT NULL,
	[dst] [varchar](80) NOT NULL,
	[dcontext] [varchar](80) NOT NULL,
	[channel] [varchar](80) NOT NULL,
	[dstchannel] [varchar](80) NOT NULL,
	[lastapp] [varchar](80) NOT NULL,
	[lastdata] [varchar](80) NOT NULL,
	[duration] [int] NOT NULL,
	[billsec] [int] NOT NULL,
	[disposition] [varchar](45) NOT NULL,
	[amaflags] [int] NOT NULL,
	[accountcode] [varchar](20) NOT NULL,
	[uniqueid] [varchar](32) NOT NULL,
	[userfield] [varchar](255) NOT NULL,
	[srcip] [varchar](18) NULL,
	[dstip] [varchar](18) NULL,
	[partition_string] [varchar](14) NOT NULL,
	[carrier_cost] [numeric](18, 0) NULL,
	[customer_cost] [numeric](18, 0) NULL,
	[prefix] [varchar](1) NULL,
	[carrier_rate] [numeric](18, 0) NULL,
	[customer_rate] [numeric](18, 0) NULL,
 CONSTRAINT [PK_acctid] PRIMARY KEY CLUSTERED 
(
	[acctid] ASC, [partition_string]
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON cdr_monthly(partition_string)
) ON cdr_monthly(partition_string)

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[cdr] ADD  DEFAULT (getdate()) FOR [calldate]
GO

ALTER TABLE [dbo].[cdr] ADD  DEFAULT ('') FOR [clid]
GO

ALTER TABLE [dbo].[cdr] ADD  DEFAULT ('') FOR [src]
GO

ALTER TABLE [dbo].[cdr] ADD  DEFAULT ('') FOR [dst]
GO

ALTER TABLE [dbo].[cdr] ADD  DEFAULT ('') FOR [dcontext]
GO

ALTER TABLE [dbo].[cdr] ADD  DEFAULT ('') FOR [channel]
GO

ALTER TABLE [dbo].[cdr] ADD  DEFAULT ('') FOR [dstchannel]
GO

ALTER TABLE [dbo].[cdr] ADD  DEFAULT ('') FOR [lastapp]
GO

ALTER TABLE [dbo].[cdr] ADD  DEFAULT ('') FOR [lastdata]
GO

ALTER TABLE [dbo].[cdr] ADD  DEFAULT ((0)) FOR [duration]
GO

ALTER TABLE [dbo].[cdr] ADD  DEFAULT ((0)) FOR [billsec]
GO

ALTER TABLE [dbo].[cdr] ADD  DEFAULT ('') FOR [disposition]
GO

ALTER TABLE [dbo].[cdr] ADD  DEFAULT ((0)) FOR [amaflags]
GO

ALTER TABLE [dbo].[cdr] ADD  DEFAULT ('') FOR [accountcode]
GO

ALTER TABLE [dbo].[cdr] ADD  DEFAULT ('') FOR [uniqueid]
GO

ALTER TABLE [dbo].[cdr] ADD  DEFAULT ('') FOR [userfield]
GO

ALTER TABLE [dbo].[cdr] ADD  DEFAULT ([dbo].[get_partition_string](DEFAULT)) FOR [partition_string]
GO