Editable Gridview

Response.Write("");

<asp:GridView ID="gridsub" runat="server" AutoGenerateColumns="False" ShowFooter="True" OnRowEditing="gridsub_RowEditing" OnRowCancelingEdit="gridsub_RowCancelingEdit" OnRowDataBound="gridsub_RowDataBound"  OnRowUpdating="gridsub_RowUpdating" OnRowCommand="gridsub_RowCommand">
<RowStyle CssClass="RowStyle" />
<PagerStyle CssClass="PagerStyle" />
<SelectedRowStyle CssClass="SelectedRowStyle" />
<HeaderStyle CssClass="HeaderStyle" />
<EditRowStyle CssClass="EditRowStyle" />
<AlternatingRowStyle CssClass="AltRowStyle" />
<Columns>
<asp:TemplateField HeaderText="ID" HeaderStyle-HorizontalAlign="Left" Visible="false">
<EditItemTemplate>
<asp:Label ID="lblId" runat="server" Text='<%# Bind("ID") %>'></asp:Label> </EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblId" runat="server" Text='<%# Bind("ID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Member" HeaderStyle-HorizontalAlign="Left">
<EditItemTemplate>
<asp:DropDownList ID="ddlmem" runat="server"></asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblmem" runat="server" Text='<%# Bind("member") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Project" HeaderStyle-HorizontalAlign="Left">
<EditItemTemplate>
<asp:DropDownList ID="ddlproject" runat="server"></asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lbltitle" runat="server" Text='<%# Bind("title") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Task" HeaderStyle-HorizontalAlign="Left">
<EditItemTemplate>
<asp:DropDownList ID="ddltask" runat="server"></asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblTask_title" runat="server" Text='<%# Bind("Task_title") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Frequency" HeaderStyle-HorizontalAlign="Left">
<EditItemTemplate>
<asp:TextBox ID="txtfrequency" runat="server" Text='<%# Bind("frequency") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblfrequency" runat="server" Text='<%# Bind("frequency") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Edit" ShowHeader="False" HeaderStyle-HorizontalAlign="Left">
<EditItemTemplate>
<asp:LinkButton ID="lbkUpdate" runat="server" CausesValidation="True" CommandName="Update" CommandArgument='<%#DataBinder.Eval(Container.DataItem,"ID" )%>' Text="Update"></asp:LinkButton>
<asp:LinkButton ID="lnkCancel" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"></asp:LinkButton>
</EditItemTemplate>
<ItemTemplate>
<asp:LinkButton ID="lnkEdit" runat="server" CausesValidation="False" CommandName="Edit"
Text="Edit"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField HeaderText="Delete" ShowDeleteButton="false" ShowHeader="True" Visible="false"/>
</Columns>
</asp:GridView>

Code on .Cs Page

int variable;
public static int fre, oldfre;
public static string member, project, projecttxt, tasktxt,task, oldmember, oldproject, oldtask;
DateTime Creatdt;
int querystring;
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["linkbuilding"].ToString().Trim());
protected void Page_Load(object sender, EventArgs e)
{
if (Session["role"] == "1")
{
if (!IsPostBack)
{
update_task();
fillgrid();
}
}
else
{
Session.Abandon();
Session.Clear();
Page.ClientScript.RegisterStartupScript(typeof(Page), "key", "");
}
}
public void fillgrid()
{
if (Page.Request.QueryString["ID"] != null)
{
int i = Int32.Parse(Request.QueryString["ID"].ToString().Trim());
querystring = i;
string query = "SELECT subtask.ID, subtask.detail, subtask.frequency, subtask.status, subtask.created_at, subtask.Updated_at, subtask.completion_date, subtask.mem_id,subtask.TL_task_id, subtask.member, TL_task.Project_id, TL_task.task_type_id, project.title, Commontask.Title AS Task_title FROM Commontask INNER JOIN TL_task ON Commontask.ID = TL_task.task_type_id LEFT OUTER JOIN project ON TL_task.Project_id = project.id RIGHT OUTER JOIN subtask ON TL_task.ID = subtask.TL_task_id where TL_task_id="+i+"";
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["linkbuilding"].ToString().Trim());
SqlDataAdapter cmd = new SqlDataAdapter(query, con);
DataSet ds = new DataSet();
cmd.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
gridsub.DataSource = ds;
gridsub.DataBind();
}
else
{
Response.Write("Record does not exist in database..");
}
}
}
protected void gridsub_RowEditing(object sender, GridViewEditEventArgs e)
{
gridsub.EditIndex = e.NewEditIndex;
GridViewRow editingRow = gridsub.Rows[e.NewEditIndex];
Label lblmb = (editingRow.FindControl("lblmem") as Label);
Label lblpt = (editingRow.FindControl("lbltitle") as Label);
Label ddlt = (editingRow.FindControl("lblTask_title") as Label);
Label ddlf = (editingRow.FindControl("lblfrequency") as Label);
oldmember = lblmb.Text.ToString().Trim();
oldproject = lblpt.Text.ToString().Trim();
oldtask = ddlt.Text.ToString().Trim();
oldfre = Convert.ToInt32(ddlf.Text.ToString().Trim());
gridsub.EditIndex = e.NewEditIndex;
fillgrid();
}
protected void gridsub_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
gridsub.EditIndex = -1;
fillgrid();
}
protected void gridsub_RowDataBound(object sender, GridViewRowEventArgs e)
{

if (e.Row.RowType == DataControlRowType.DataRow)
{
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["linkbuilding"].ToString().Trim());
string query = "select * from user_details where role_id=4";
DropDownList cmbType = (DropDownList)e.Row.FindControl("ddlmem");
SqlDataAdapter cmd = new SqlDataAdapter(query, con);
DataSet ds = new DataSet();
cmd.Fill(ds);
if (cmbType != null)
{
cmbType.DataSource = ds;
cmbType.DataTextField = "name";
cmbType.DataValueField = "id";
cmbType.DataBind();
cmbType.Items.Insert(0, new ListItem("-Select-"));
}
string queryprj = "select * from project";
SqlDataAdapter daprj = new SqlDataAdapter(queryprj, con);
DataSet dt = new DataSet();
daprj.Fill(dt);
DropDownList ddlprj = (DropDownList)e.Row.FindControl("ddlproject");
if (ddlprj != null)
{
ddlprj.DataSource = dt;
ddlprj.DataTextField = "title";
ddlprj.DataValueField = "id";
ddlprj.DataBind();
ddlprj.Items.Insert(0, new ListItem("-Select-"));
}
string querytyp = "select * from commontask";
SqlDataAdapter daprjt = new SqlDataAdapter(querytyp, con);
DataSet dttask = new DataSet();
daprjt.Fill(dttask);
DropDownList ddltask = (DropDownList)e.Row.FindControl("ddltask");
if (ddltask != null)
{
ddltask.DataSource = dttask;
ddltask.DataTextField = "Title";
ddltask.DataValueField = "id";
ddltask.DataBind();
ddltask.Items.Insert(0, new ListItem("-Select-"));
}

}

}
protected void gridsub_RowUpdating(object sender, GridViewUpdateEventArgs e)
{

TextBox txtfr = (TextBox)gridsub.Rows[e.RowIndex].FindControl("txtfrequency");
DropDownList ddlmem = (DropDownList)gridsub.Rows[e.RowIndex].FindControl("ddlmem");
DropDownList ddlprj = (DropDownList)gridsub.Rows[e.RowIndex].FindControl("ddlproject");
DropDownList ddltask = (DropDownList)gridsub.Rows[e.RowIndex].FindControl("ddltask");
fre = Convert.ToInt32(txtfr.Text.ToString().Trim());
member = ddlmem.SelectedItem.Text.ToString().Trim();
project = ddlprj.SelectedItem.Value;
projecttxt = ddlprj.SelectedItem.Text.ToString().Trim();
task = ddltask.SelectedItem.Value;
tasktxt = ddltask.SelectedItem.Text.ToString().Trim();
if (member == "-Select-" || projecttxt == "-Select-" || tasktxt == "-Select-")
{
Response.Write("Please Select Member, Project, Task");
}
else
{
update_task();
if (Page.Request.QueryString["ID"] != null)
{
int i = Int32.Parse(Request.QueryString["ID"].ToString().Trim());
querystring = i;
}

if (member != oldmember)
{
SqlCommand cmdfr = new SqlCommand("update subtask set member='" + member + "' where ID=" + variable + "", con);
con.Open();
cmdfr.ExecuteNonQuery();
con.Close();
}
if (project != oldproject)
{
SqlCommand cmdpr = new SqlCommand("update TL_task set Project_id=" + project + " where ID=" + querystring + "", con);
con.Open();
cmdpr.ExecuteNonQuery();
con.Close();
}
if (fre != oldfre)
{
SqlCommand cmdfr = new SqlCommand("update subtask set frequency=" + fre + " where ID=" + variable + "", con);
con.Open();
cmdfr.ExecuteNonQuery();
con.Close();
}
if (task != oldtask)
{
SqlCommand cmdtk = new SqlCommand("update TL_task set task_type_id=" + task + " where ID=" + querystring + "", con);
con.Open();
cmdtk.ExecuteNonQuery();
con.Close();
}

Page.ClientScript.RegisterStartupScript(typeof(Page), "key", "");
}
}
protected void gridsub_RowCommand(object sender, GridViewCommandEventArgs e)
{

if (e.CommandName.Equals("Update"))
{
int i = Int32.Parse(e.CommandArgument.ToString().Trim());
variable = i;

}
}
public void update_task()
{
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["linkbuilding"].ToString().Trim());
SqlCommand cmd1 = new SqlCommand("SELECT subtask.ID, subtask.detail, subtask.frequency, subtask.status, subtask.created_at, subtask.Updated_at, subtask.completion_date, subtask.mem_id,subtask.TL_task_id, subtask.member, TL_task.Project_id, TL_task.task_type_id, project.title, Commontask.Title AS Task_title FROM Commontask INNER JOIN TL_task ON Commontask.ID = TL_task.task_type_id LEFT OUTER JOIN project ON TL_task.Project_id = project.id RIGHT OUTER JOIN subtask ON TL_task.ID = subtask.TL_task_id where Subtask.ID=" + variable + "", con);
SqlDataAdapter cmd = new SqlDataAdapter(cmd1);
DataSet ds = new DataSet();
cmd.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{

}
string oldstr = oldmember + "---------" + oldproject + "---------" + oldtask + "---------" + oldfre + "----------" + Creatdt;
string newstr = member + "---------" + projecttxt + "---------" + tasktxt + "---------" + fre + "---------" + DateTime.Now;
DateTime up_date = DateTime.Now;
string tl_name = "";
if (oldmember != member)
{
tl_name = tl_name + "user_details" + ",";
}
if (oldproject != project)
{
tl_name = tl_name + "Commontask" + ",";
}
if (oldtask != task)
{
tl_name = tl_name + "TM_task" + ",";
}
if (oldfre != fre)
{
tl_name = tl_name + "TM_task" + ",";
}
if (Creatdt != DateTime.Now)
{
tl_name = tl_name + "TM_task" + ",";
}
SqlCommand upd = new SqlCommand("insert into auditsub(Old_value,New_value,created_at,Updated_at,table_name,row_id) values('" + oldstr + "','" + newstr + "','" + up_date + "','" + up_date + "','" + tl_name + "'," + variable + ")", con);
con.Open();
upd.ExecuteNonQuery();
con.Close();
}

}

Database structure

Copy the below code and create new database then above code will run perfectly




 
/****** Object:  View [dbo].[View_3]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[View_3]'))
DROP VIEW [dbo].[View_3]
GO
/****** Object:  View [dbo].[View_2]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[View_2]'))
DROP VIEW [dbo].[View_2]
GO
/****** Object:  StoredProcedure [dbo].[user_imf]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[user_imf]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[user_imf]
GO
/****** Object:  StoredProcedure [dbo].[client_project]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[client_project]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[client_project]
GO
/****** Object:  StoredProcedure [dbo].[link]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[link]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[link]
GO
/****** Object:  StoredProcedure [dbo].[assignment]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[assignment]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[assignment]
GO
/****** Object:  StoredProcedure [dbo].[createtask]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[createtask]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[createtask]
GO
/****** Object:  StoredProcedure [dbo].[insertTLtask]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[insertTLtask]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[insertTLtask]
GO
/****** Object:  View [dbo].[View_1]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[View_1]'))
DROP VIEW [dbo].[View_1]
GO
/****** Object:  View [dbo].[View_4]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[View_4]'))
DROP VIEW [dbo].[View_4]
GO
/****** Object:  Table [dbo].[swap]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[swap]') AND type in (N'U'))
DROP TABLE [dbo].[swap]
GO
/****** Object:  Table [dbo].[tblContactDetails]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblContactDetails]') AND type in (N'U'))
DROP TABLE [dbo].[tblContactDetails]
GO
/****** Object:  Table [dbo].[user_detail]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[user_detail]') AND type in (N'U'))
DROP TABLE [dbo].[user_detail]
GO
/****** Object:  Table [dbo].[project]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[project]') AND type in (N'U'))
DROP TABLE [dbo].[project]
GO
/****** Object:  Table [dbo].[client]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[client]') AND type in (N'U'))
DROP TABLE [dbo].[client]
GO
/****** Object:  Table [dbo].[assign_role]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[assign_role]') AND type in (N'U'))
DROP TABLE [dbo].[assign_role]
GO
/****** Object:  StoredProcedure [dbo].[suser]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[suser]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[suser]
GO
/****** Object:  Table [dbo].[role1]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[role1]') AND type in (N'U'))
DROP TABLE [dbo].[role1]
GO
/****** Object:  Table [dbo].[auditsub]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[auditsub]') AND type in (N'U'))
DROP TABLE [dbo].[auditsub]
GO
/****** Object:  Table [dbo].[audit]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[audit]') AND type in (N'U'))
DROP TABLE [dbo].[audit]
GO
/****** Object:  Table [dbo].[TM_task]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TM_task]') AND type in (N'U'))
DROP TABLE [dbo].[TM_task]
GO
/****** Object:  Table [dbo].[Commontask]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Commontask]') AND type in (N'U'))
DROP TABLE [dbo].[Commontask]
GO
/****** Object:  Table [dbo].[TL_task]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TL_task]') AND type in (N'U'))
DROP TABLE [dbo].[TL_task]
GO
/****** Object:  Table [dbo].[subtask]    Script Date: 06/19/2013 17:20:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[subtask]') AND type in (N'U'))
DROP TABLE [dbo].[subtask]
GO
/****** Object:  Table [dbo].[subtask]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[subtask]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[subtask](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [detail] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [frequency] [smallint] NULL,
    [status] [tinyint] NULL,
    [created_at] [datetime] NULL,
    [Updated_at] [datetime] NULL,
    [completion_date] [datetime] NULL,
    [mem_id] [int] NULL,
    [TL_task_id] [int] NULL,
    [member] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
END
GO
SET IDENTITY_INSERT [dbo].[subtask] ON
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (1, N'sasdadsdsas', 1000, NULL, NULL, NULL, NULL, 3, 21, NULL)
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (2, N'sasdadsdsas', 1000, NULL, NULL, NULL, NULL, 3, 21, NULL)
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (3, N'sasdadsdsas', 1000, NULL, NULL, NULL, NULL, 3, 21, NULL)
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (4, N'sasdadsdsas', 500, NULL, NULL, NULL, NULL, 3, 21, NULL)
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (5, N'sasdadsdsas', 500, NULL, NULL, NULL, NULL, 3, 22, NULL)
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (6, N'sasdadsdsas', 11, NULL, NULL, NULL, NULL, 2, 23, NULL)
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (7, N'sasdadsdsas', 10, NULL, NULL, NULL, NULL, 2, 23, NULL)
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (8, N'sasdadsdsas', 500, NULL, NULL, NULL, NULL, 2, 23, NULL)
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (9, N'sasdadsdsas', 500, NULL, NULL, NULL, NULL, 2, 23, NULL)
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (10, N'', 1000, NULL, NULL, NULL, NULL, 4, 20, NULL)
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (11, N'', 500, NULL, NULL, NULL, NULL, 4, 20, NULL)
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (12, N'fine', 1000, NULL, NULL, NULL, NULL, 4, 20, NULL)
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (13, N'fine', 500, NULL, NULL, NULL, NULL, 4, 20, NULL)
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (14, N'fine', 1000, NULL, NULL, NULL, NULL, 4, 20, N'Sandeep')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (15, N'fine', 500, NULL, NULL, NULL, NULL, 4, 20, N'sam')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (16, N'fine', 250, NULL, NULL, NULL, NULL, 4, 20, N'sanjay singhania')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (17, N'fine', 1000, NULL, NULL, NULL, NULL, 4, 20, N'sanjay singhania')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (18, N'fine', 500, NULL, NULL, NULL, NULL, 4, 20, N'MR Aggrawal')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (19, N'sasdadsdsas', 1000, NULL, NULL, NULL, NULL, 2, 28, N'Sandeep')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (20, N'sasdadsdsas', 500, NULL, NULL, NULL, NULL, 2, 28, N'sam')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (21, N'sasdadsdsas', 250, NULL, NULL, NULL, NULL, 2, 28, N'sanjay singhania')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (22, N'sasdadsdsas', 250, NULL, NULL, NULL, NULL, 2, 28, N'MR Aggrawal')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (23, N'', 1000, NULL, NULL, NULL, NULL, 2, 28, N'Sandeep')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (24, N'', 500, NULL, NULL, NULL, NULL, 2, 28, N'sam')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (25, N'', 250, NULL, NULL, NULL, NULL, 2, 28, N'sanjay singhania')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (26, N'500 each person within 2 days.', 500, NULL, NULL, NULL, NULL, 3, 29, N'Sandeep')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (27, N'500 each person within 2 days.', 500, NULL, NULL, NULL, NULL, 3, 29, N'sam')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (28, N'sasdadsdsas', 500, NULL, NULL, NULL, NULL, 3, 29, N'sam')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (29, N'sasdadsdsas', 500, NULL, NULL, NULL, NULL, 3, 29, N'sanjay singhania')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (30, N'within week', 250, NULL, NULL, NULL, NULL, 2, 31, N'Sandeep')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (31, N'within week', 250, NULL, NULL, NULL, NULL, 2, 31, N'sam')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (32, N'within week', 250, NULL, NULL, NULL, NULL, 2, 31, N'sanjay singhania')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (33, N'within week', 250, NULL, NULL, NULL, NULL, 2, 31, N'MR Aggrawal')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (34, N'', 500, NULL, NULL, NULL, NULL, 2, 34, N'Sandeep')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (35, N'', 500, NULL, NULL, NULL, NULL, 2, 34, N'sam')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (36, N'', 500, NULL, NULL, NULL, NULL, 2, 34, N'sanjay singhania')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (37, N'', 500, NULL, NULL, NULL, NULL, 2, 34, N'MR Aggrawal')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (38, N'this is test', 1000, NULL, NULL, NULL, NULL, 4, 41, N'Sandeep')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (39, N'this is test', 500, NULL, NULL, NULL, NULL, 4, 41, N'sam')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (40, N'', 500, NULL, NULL, NULL, NULL, 4, 41, N'Sandeep')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (41, N'', 500, NULL, NULL, NULL, NULL, 4, 41, N'sanjay singhania')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (42, N'', 2500, NULL, NULL, NULL, NULL, 4, 41, N'Sandeep')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (43, N'', 2500, NULL, NULL, NULL, NULL, 4, 41, N'sam')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (44, N'', 327, NULL, NULL, NULL, NULL, 3, 35, N'sam')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (45, N'', 67, NULL, NULL, NULL, NULL, 3, 35, N'sanjay singhania')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (46, N'', 2000, NULL, NULL, NULL, NULL, 4, 42, N'Sandeep')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (47, N'', 3000, NULL, NULL, NULL, NULL, 4, 42, N'Sandeep')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (48, N'', 1000, NULL, NULL, NULL, NULL, 4, 42, N'sam')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (49, N'', 500, NULL, NULL, NULL, NULL, 4, 45, N'Rahul')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (50, N'', 500, NULL, NULL, NULL, NULL, 4, 45, N'hariom')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (51, N'', 500, NULL, NULL, NULL, NULL, 4, 45, N'Rahul')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (52, N'', 500, NULL, NULL, NULL, NULL, 4, 45, N'hariom')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (53, N'', 1000, NULL, NULL, NULL, NULL, 4, 45, N'sandeep')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (54, N'', 1000, NULL, NULL, NULL, NULL, 4, 45, N'sanjeev')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (55, N'', 1000, NULL, NULL, NULL, NULL, 4, 45, N'sanjeev')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (56, N'', 5000, NULL, NULL, NULL, NULL, 9, 50, N'sandeep')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (57, N'', 5000, NULL, NULL, NULL, NULL, 9, 50, N'Renu bala')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (58, N'', 5000, NULL, NULL, NULL, NULL, 9, 50, N'Renu bala')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (59, N'', 5000, NULL, NULL, NULL, NULL, 9, 50, N'Renu bala')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (60, N'', 1500, NULL, NULL, NULL, NULL, 11, 51, N'sandeep')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (61, N'', 1500, NULL, NULL, NULL, NULL, 11, 51, N'Renu bala')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (62, N'', 500, NULL, NULL, NULL, NULL, 9, 53, N'sandeep')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (63, N'', 500, NULL, NULL, NULL, NULL, 9, 53, N'kajol')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (64, N'', 100, NULL, NULL, NULL, NULL, 11, 55, N'sandeep')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (65, N'', 100, NULL, NULL, NULL, NULL, 11, 55, N'Renu bala')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (66, N'', 100, NULL, NULL, NULL, NULL, 11, 55, N'sandeep')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (67, N'', 100, NULL, NULL, NULL, NULL, 11, 55, N'Renu bala')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (68, N'', 100, NULL, NULL, NULL, NULL, 11, 55, N'Renu bala')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (69, N'', 100, NULL, NULL, NULL, NULL, 11, 55, N'kajol')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (70, N'', 600, NULL, NULL, NULL, NULL, 9, 56, N'Renu bala')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (71, N'', 600, NULL, NULL, NULL, NULL, 9, 56, N'kajol')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (72, N'', 1200, NULL, NULL, NULL, NULL, 9, 56, N'sandeep')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (73, N'', 12500, NULL, NULL, NULL, NULL, 2, 57, N'sandeep')
INSERT [dbo].[subtask] ([ID], [detail], [frequency], [status], [created_at], [Updated_at], [completion_date], [mem_id], [TL_task_id], [member]) VALUES (74, N'', 12500, NULL, NULL, NULL, NULL, 2, 57, N'Renu bala')
SET IDENTITY_INSERT [dbo].[subtask] OFF
/****** Object:  Table [dbo].[TL_task]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TL_task]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[TL_task](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [user_id] [int] NULL,
    [Project_id] [int] NULL,
    [task_type_id] [int] NULL,
    [frequency] [smallint] NULL,
    [created_at] [datetime] NULL,
    [Updated_at] [datetime] NULL,
    [status] [tinyint] NULL,
    [completion_date] [datetime] NULL
)
END
GO
SET IDENTITY_INSERT [dbo].[TL_task] ON
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (1, 1, 1, 1, 50, CAST(0x00009F9800000000 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (2, 1, 1, 1, 50, CAST(0x00009F9800000000 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (3, 1, 2, 1, 50, CAST(0x00009F9800000000 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (4, 1, 1, 1, 50, CAST(0x00009F9800000000 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (6, 1, 1, 1, 50, CAST(0x00009F9800000000 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (7, 3, 1, 1, 100, CAST(0x00009F5E00000000 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (8, 3, 2, 3, 2000, CAST(0x00009E5E00000000 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (9, 2, 1, 1, 400, CAST(0x00009F560114AE78 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (10, 2, 1, 1, 400, CAST(0x00009F560114F4C8 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (11, 2, 1, 1, 1000, CAST(0x00009F56011BA160 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (12, 3, 2, 2, 1000, CAST(0x00009F5700CAE630 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (13, 3, 2, 2, 2000, CAST(0x00009F5700CBA408 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (14, 3, 2, 2, 2000, CAST(0x00009F5700CC89B8 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (15, 3, 2, 2, 2000, CAST(0x00009F5700CC9444 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (17, 3, 2, 2, 2000, CAST(0x00009F5700CCC900 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (18, 2, 2, 2, 500, CAST(0x00009F5700CCF588 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (19, 2, 2, 2, 100, CAST(0x00009F5700CD0848 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (20, 4, 2, 1, 100, CAST(0x00009F5700CDDB38 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (22, 3, 2, 2, 600, CAST(0x00009F5700CECA48 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (23, 2, 1, 1, 2100, CAST(0x00009F5700CF2DE4 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (24, 2, 1, 1, 46, CAST(0x00009F5700CF399C AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (25, 2, 1, 1, 45, CAST(0x00009F5700CF4EB4 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (27, 4, 2, 2, 10, CAST(0x00009F5700D1E020 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (29, 3, 2, 1, 200, CAST(0x00009F5900D4475C AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (30, 2, 2, 1, 10, CAST(0x00009F5C010BC3A8 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (31, 2, 1, 2, 1000, CAST(0x00009F5D00C50DB4 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (33, 4, 1, 1, 1000, CAST(0x00009F5D00D6707C AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (34, 2, 1, 1, 2000, CAST(0x00009F5D00D9A274 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (36, 3, 1, 1, 45, CAST(0x00009F5D00FA7E2C AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (37, 3, 1, 1, 4355, CAST(0x00009F5D010B777C AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (38, 2, 1, 12, 55, CAST(0x00009F5F0111DEF0 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (39, 4, 1, 1, 21, CAST(0x00009F6100F0A8FC AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (40, 4, 2, 1, 1000, CAST(0x00009F6300CA3668 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (41, 4, 1, 1, 1000, CAST(0x00009F63010A84E8 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (42, 4, 1, 2, 6000, CAST(0x00009F6400B2C8C0 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (43, 2, 1, 3, 0, CAST(0x00009F6500AFE2F4 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (44, 3, 1, 2, 1000, CAST(0x00009F6500B97D8C AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (45, 4, 12, 15, 1000, CAST(0x00009F6500BD4584 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (46, 2, 1, 2, 222, CAST(0x00009F6500F76728 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (47, 2, 10, 2, 2000, CAST(0x00009F6E0105E1CC AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (48, 9, 10, 15, 2000, CAST(0x00009F6E0106B264 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (49, 5, 10, 15, 4000, CAST(0x00009F6E01075EA8 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (50, 9, 14, 16, 5000, CAST(0x00009F6E011D1158 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (52, 2, 10, 2, 3000, CAST(0x00009F6F00C9F84C AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (53, 9, 11, 3, 1000, CAST(0x00009F6F00CB27D0 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (54, 9, 11, 3, 100, CAST(0x00009F6F00D21F68 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (55, 11, 14, 15, 200, CAST(0x00009F6F00D27D28 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (56, 9, 10, 15, 1200, CAST(0x00009F6F00EB6FE0 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (57, 2, 10, 15, 25000, CAST(0x00009F6F00EF4F48 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (5, 1, 1, 1, 50, CAST(0x00009F9800000000 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (16, 3, 2, 2, 2000, CAST(0x00009F5700CCAA88 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (21, 3, 2, 2, 600, CAST(0x00009F5700CE88A8 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (32, 2, 2, 1, 123, CAST(0x00009F5D00D2C378 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (26, 2, 2, 1, 500, CAST(0x00009F5700D007DC AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (28, 2, 2, 2, 1000, CAST(0x00009F5700D49F40 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (35, 3, 1, 2, 32767, CAST(0x00009F5D00F8AA98 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[TL_task] ([ID], [user_id], [Project_id], [task_type_id], [frequency], [created_at], [Updated_at], [status], [completion_date]) VALUES (51, 11, 11, 14, 3000, CAST(0x00009F6E013017A8 AS DateTime), NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[TL_task] OFF
/****** Object:  Table [dbo].[Commontask]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Commontask]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Commontask](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [Title] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [created_at] [datetime] NULL,
    [Updated_at] [datetime] NULL,
    [status] [tinyint] NULL,
    [abbre] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
END
GO
SET IDENTITY_INSERT [dbo].[Commontask] ON
INSERT [dbo].[Commontask] ([ID], [Title], [created_at], [Updated_at], [status], [abbre]) VALUES (15, N'fortune', CAST(0x00009F6E010647FA AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[Commontask] ([ID], [Title], [created_at], [Updated_at], [status], [abbre]) VALUES (2, N'Directory_Submission', NULL, NULL, NULL, N'DS')
INSERT [dbo].[Commontask] ([ID], [Title], [created_at], [Updated_at], [status], [abbre]) VALUES (3, N'Article_submission', NULL, NULL, NULL, N'AS')
INSERT [dbo].[Commontask] ([ID], [Title], [created_at], [Updated_at], [status], [abbre]) VALUES (14, N'welcome', CAST(0x00009F6500AF08D9 AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[Commontask] ([ID], [Title], [created_at], [Updated_at], [status], [abbre]) VALUES (16, N'Clubitc', CAST(0x00009F6E0107E127 AS DateTime), NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[Commontask] OFF
/****** Object:  Table [dbo].[TM_task]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TM_task]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[TM_task](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [member] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Project_id] [int] NULL,
    [task_id] [int] NULL,
    [frequency] [int] NULL,
    [created_at] [datetime] NULL,
    [Updated_at] [datetime] NULL,
    [status] [tinyint] NULL,
    [completion] [datetime] NULL,
    [user_detail_id] [int] NULL,
    [TL_task_id] [int] NULL
)
END
GO
SET IDENTITY_INSERT [dbo].[TM_task] ON
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (1, N'0', 0, 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (2, N'0', 0, 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (3, N'sam', 0, 0, 50, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (4, N'sam', 0, 0, 50, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (5, N'Sandeep', 0, 0, 50, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (6, N'sam', 0, 0, 50, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (7, N'sam', 0, 0, 50, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (8, N'Sandeep', 1, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (9, N'sam', 1, 1, 20, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (10, N'sam', 1, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (11, N'sam', 1, 1, 20, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (12, N'2', 1, 1, 50, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (13, N'2', 1, 1, 50, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (14, N'2', 1, 1, 50, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (15, N'2', 1, 1, 50, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (16, N'2', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (17, N'2', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (18, N'2', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (19, N'Sandeep', 1, 1, 25, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (20, N'sam', 1, 1, 25, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (21, N'1', 1, 1, 50, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (22, N'sam', 1, 1, 50, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (23, N'sam', 1, 1, 50, NULL, NULL, NULL, NULL, 1, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (24, N'Sandeep', 1, 1, 30, NULL, NULL, NULL, NULL, 1, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (25, N'sam', 1, 1, 20, NULL, NULL, NULL, NULL, 1, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (26, N'sam', 1, 1, 50, NULL, NULL, NULL, NULL, 1, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (27, N'sam', 1, 1, 100, NULL, NULL, NULL, NULL, 3, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (28, N'sam', 1, 1, 50, NULL, NULL, NULL, NULL, 1, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (29, N'sam', 1, 1, 50, NULL, NULL, NULL, NULL, 1, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (30, N'Sandeep', 2, 3, 2000, NULL, NULL, NULL, NULL, 3, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (31, N'sam', 2, 3, 2000, NULL, NULL, NULL, NULL, 3, NULL)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (32, N'sam', 1, 1, 50, NULL, NULL, NULL, NULL, 1, 1)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (33, N'sam', 2, 3, 2000, NULL, NULL, NULL, NULL, 3, 8)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (34, N'Sandeep', 1, 1, 50, NULL, NULL, NULL, NULL, 3, 7)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (35, N'sam', 1, 1, 50, NULL, NULL, NULL, NULL, 3, 7)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (36, N'Sandeep', 1, 1, 50, NULL, NULL, NULL, NULL, 1, 1)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (37, N'Sandeep', 2, 3, 10, NULL, NULL, NULL, NULL, 4, 27)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (38, N'sanjay singhania', 2, 2, 500, NULL, NULL, NULL, NULL, 2, 18)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (39, N'Sandeep', 2, 2, 500, NULL, NULL, NULL, NULL, 2, 18)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (41, N'sam', 1, 1, 500, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (42, N'sanjay singhania', 1, 1, 500, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (43, N'sam', 1, 1, 500, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (44, N'sanjay singhania', 1, 1, 500, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (45, N'Sandeep', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (46, N'sam', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (47, N'sanjay singhania', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (48, N'sam', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (49, N'sanjay singhania', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (50, N'Sandeep', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (51, N'sam', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (52, N'', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (53, N'sam', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (54, N'', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (55, N'Sandeep', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (56, N'sam', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (57, N'', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (58, N'Sandeep', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (59, N'sam', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (60, N'sanjay singhania', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (61, N'MR Aggrawal', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (62, N'', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (63, N'sanjay singhania', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (64, N'MR Aggrawal', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (65, N'', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (66, N'Sandeep', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (67, N'sam', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (68, N'', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (69, N'Sandeep', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (70, N'sam', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (71, N'sanjay singhania', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (72, N'Sandeep', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (73, N'sam', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (74, N'sanjay singhania', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (75, N'Sandeep', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (76, N'sam', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (79, N'Sandeep', 1, 1, 1000, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (80, N'Sandeep', 1, 1, 1000, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (81, N'sam', 1, 1, 500, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (82, N'sanjay singhania', 1, 1, 250, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (83, N'MR Aggrawal', 1, 1, 250, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (84, N'Sandeep', 1, 1, 1000, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (85, N'sam', 1, 1, 900, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (86, N'sanjay singhania', 1, 1, 800, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (87, N'MR Aggrawal', 1, 1, 700, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (88, N'Sandeep', 1, 1, 2, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (89, N'sam', 1, 1, 3, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (90, N'sanjay singhania', 1, 1, 4, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (91, N'Sandeep', 1, 1, 1000, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (92, N'sam', 1, 1, 500, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (93, N'sanjay singhania', 1, 1, 250, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (94, N'MR Aggrawal', 1, 1, 250, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (95, N'Sandeep', 1, 1, 1, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (96, N'sam', 1, 1, 2, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (97, N'sanjay singhania', 1, 1, 3, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (98, N'MR Aggrawal', 1, 1, 4, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (99, N'Sandeep', 1, 1, 5, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (100, N'sam', 1, 1, 6, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (101, N'sanjay singhania', 1, 1, 7, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (102, N'MR Aggrawal', 1, 2, 8, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (103, N'Sandeep', 1, 1, 10, NULL, NULL, NULL, NULL, 2, 28)
GO
print 'Processed 100 total records'
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (104, N'sam', 1, 1, 11, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (105, N'Sandeep', 1, 1, 1000, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (106, N'sam', 1, 1, 500, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (107, N'sanjay singhania', 1, 1, 250, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (108, N'MR Aggrawal', 1, 1, 250, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (117, N'Sandeep', 1, 1, 10000, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (118, N'sam', 1, 1, 9000, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (119, N'Sandeep', 1, 1, 1000, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (120, N'Sandeep', 1, 1, 1000, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (121, N'Sandeep', 1, 1, 1000, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (122, N'Sandeep', 1, 1, 1000, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (123, N'sam', 1, 1, 800, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (124, N'Sandeep', 1, 1, 1000, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (125, N'sam', 1, 1, 500, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (126, N'sanjay singhania', 1, 1, 250, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (127, N'MR Aggrawal', 1, 1, 250, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (40, N'MR Aggrawal', 2, 2, 500, NULL, NULL, NULL, NULL, 2, 18)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (77, N'Sandeep', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (78, N'sam', 1, 1, NULL, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (109, N'Sandeep', 1, 1, 97, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (110, N'sam', 1, 1, 99, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (111, N'sanjay singhania', 1, 1, 7, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (112, N'MR Aggrawal', 1, 1, 420, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (113, N'Sandeep', 1, 1, 1, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (114, N'sam', 1, 1, 2, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (115, N'sanjay singhania', 1, 1, 3, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (116, N'MR Aggrawal', 1, 1, 4, NULL, NULL, NULL, NULL, 2, 28)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (128, N'Sandeep', 2, 2, 1000, NULL, NULL, NULL, NULL, 3, 21)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (129, N'sam', 2, 2, 500, NULL, NULL, NULL, NULL, 3, 21)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (130, N'Sandeep', 2, 2, 1000, NULL, NULL, NULL, NULL, 3, 21)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (131, N'sam', 2, 2, 500, NULL, NULL, NULL, NULL, 3, 21)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (132, N'Sandeep', 2, 2, 500, NULL, NULL, NULL, NULL, 3, 21)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (133, N'sam', 1, 2, 1000, NULL, NULL, NULL, NULL, 3, 21)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (134, N'sanjay singhania', 2, 1, 250, NULL, NULL, NULL, NULL, 3, 21)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (135, N'Sandeep', 1, 2, 1000, NULL, NULL, NULL, NULL, 3, 21)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (136, N'sam', 1, 3, 5000, NULL, NULL, NULL, NULL, 3, 21)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (137, N'sanjay singhania', 2, 2, 250, NULL, NULL, NULL, NULL, 3, 21)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (138, N'MR Aggrawal', 1, 1, 250, NULL, NULL, NULL, NULL, 3, 21)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (139, N'MR Aggrawal', 2, 3, 1000, NULL, NULL, NULL, NULL, 3, 29)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (140, N'sanjay singhania', 2, 1, 2000, NULL, NULL, NULL, NULL, 3, 29)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (141, N'sanjay singhania', 1, 1, 6000, NULL, NULL, NULL, NULL, 3, 22)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (142, N'sanjay singhania', 2, 2, 20, NULL, NULL, NULL, NULL, 2, 34)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (143, N'Sandeep', 1, 14, 1000, NULL, NULL, NULL, NULL, 4, 41)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (144, N'hariom', 1, 2, 1000, NULL, NULL, NULL, NULL, 4, 45)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (145, N'Rahul', 1, 2, 1000, NULL, NULL, NULL, NULL, 4, 45)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (146, N'Rahul', 10, 2, 1000, NULL, NULL, NULL, NULL, 4, 45)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (147, N'Rahul', 14, 2, 1000, NULL, NULL, NULL, NULL, 4, 45)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (148, N'sandeep', 10, 16, 5000, NULL, NULL, NULL, NULL, 9, 50)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (149, N'sandeep', 10, 2, 4000, NULL, NULL, NULL, NULL, 5, 49)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (150, N'kajol', 14, 15, 200, NULL, NULL, NULL, NULL, 11, 55)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (151, N'Renu bala', 14, 15, 200, NULL, NULL, NULL, NULL, 11, 55)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (152, N'Renu bala', 14, 15, 200, NULL, NULL, NULL, NULL, 11, 55)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (153, N'kajol', 14, 15, 200, NULL, NULL, NULL, NULL, 11, 55)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (154, N'sandeep', 14, 15, 200, NULL, NULL, NULL, NULL, 11, 55)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (155, N'kajol', 14, 15, 200, NULL, NULL, NULL, NULL, 11, 55)
INSERT [dbo].[TM_task] ([ID], [member], [Project_id], [task_id], [frequency], [created_at], [Updated_at], [status], [completion], [user_detail_id], [TL_task_id]) VALUES (156, N'sandeep', 14, 15, 200, NULL, NULL, NULL, NULL, 11, 55)
SET IDENTITY_INSERT [dbo].[TM_task] OFF
/****** Object:  Table [dbo].[audit]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[audit]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[audit](
    [Old_value] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [New_value] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [UserId] [int] NULL,
    [created_at] [datetime] NULL,
    [Updated_at] [datetime] NULL,
    [table_name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [row_id] [int] NULL,
    [ID] [int] IDENTITY(1,1) NOT NULL
)
END
GO
SET IDENTITY_INSERT [dbo].[audit] ON
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Directory_Submission---------500---------9/7/2011 12:31:58 PM', N'sam---------Clubitc---------Directory_Submission---------500---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00B5FBE4 AS DateTime), N'', 136, 1)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Directory_Submission---------900---------9/7/2011 12:31:58 PM', N'sam---------Clubitc---------Directory_Submission---------900---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00B9BA7C AS DateTime), N'', 133, 2)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Article_submission---------1000---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Clubitc---------Article_submission---------1000---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5C00BF0C34 AS DateTime), N'', 140, 3)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'MR Aggrawal---------Clubitc---------Directory_Submission---------250---------9/7/2011 12:31:58 PM', N'MR Aggrawal---------Clubitc---------Directory_Submission---------500---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00CCDBC0 AS DateTime), N'TM_task,', 138, 4)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Fortune---------Linkbuilding---------500---------9/7/2011 12:31:58 PM', N'sam---------Fortune---------1---------500---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00D49130 AS DateTime), N'TM_task,', 136, 13)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Linkbuilding---------500---------9/7/2011 12:31:58 PM', N'sam---------Clubitc---------Linkbuilding---------500---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00D4A51C AS DateTime), N'', 136, 14)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Linkbuilding---------5000---------9/7/2011 12:31:58 PM', N'sam---------Clubitc---------Linkbuilding---------5000---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00D4B6B0 AS DateTime), N'', 136, 15)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Article_submission---------5000---------9/7/2011 12:31:58 PM', N'sam---------Clubitc---------3---------5000---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00D51218 AS DateTime), N'TM_task,', 136, 16)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Fortune---------Directory_Submission---------250---------9/7/2011 12:31:58 PM', N'sanjay singhania---------Fortune---------Directory_Submission---------250---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00D545A8 AS DateTime), N'', 134, 17)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Directory_Submission---------250---------9/7/2011 12:31:58 PM', N'sanjay singhania---------Clubitc---------Directory_Submission---------250---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00D55160 AS DateTime), N'', 134, 18)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Article_submission---------2000---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Clubitc---------Article_submission---------2000---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5C00D64520 AS DateTime), N'', 140, 19)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Directory_Submission---------2000---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Clubitc---------2---------2000---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5D00A87884 AS DateTime), N'TM_task,', 140, 30)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Directory_Submission---------600---------9/7/2011 12:32:54 PM', N'sanjay singhania---------Clubitc---------Directory_Submission---------600---------9/7/2011 12:32:54 PM', NULL, CAST(0x00009F5700CECA48 AS DateTime), CAST(0x00009F5D00AB273C AS DateTime), N'', 141, 31)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Fortune---------Directory_Submission---------600---------9/7/2011 12:32:54 PM', N'sanjay singhania---------Fortune---------2---------600---------9/7/2011 12:32:54 PM', NULL, CAST(0x00009F5700CECA48 AS DateTime), CAST(0x00009F5D00B81244 AS DateTime), N'TM_task,', 141, 32)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Fortune---------Directory_Submission---------600---------9/7/2011 12:32:54 PM', N'sanjay singhania---------Fortune---------Directory_Submission---------600---------9/7/2011 12:32:54 PM', NULL, CAST(0x00009F5700CECA48 AS DateTime), CAST(0x00009F5D00B82504 AS DateTime), N'', 141, 33)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Fortune---------Linkbuilding---------2000---------9/13/2011 1:12:23 PM', N'sanjay singhania---------Fortune---------Linkbuilding---------2000---------9/13/2011 1:12:23 PM', NULL, CAST(0x00009F5D00D9A274 AS DateTime), CAST(0x00009F5D010D892C AS DateTime), N'', 142, 46)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Fortune---------Linkbuilding---------2000---------9/13/2011 1:12:23 PM', N'sanjay singhania---------Fortune---------Directory_Submission---------2000---------9/13/2011 1:12:23 PM', NULL, CAST(0x00009F5D00D9A274 AS DateTime), CAST(0x00009F5D010DA09C AS DateTime), N'TM_task,', 142, 47)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Fortune---------Directory_Submission---------2000---------9/13/2011 1:12:23 PM', N'sanjay singhania---------Clubitc---------Directory_Submission---------20---------9/13/2011 1:12:23 PM', NULL, CAST(0x00009F5D00D9A274 AS DateTime), CAST(0x00009F5D0111FE94 AS DateTime), N'Commontask,TM_task,', 142, 48)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Fortune---------Directory_Submission---------1000---------9/19/2011 4:10:22 PM', N'Sandeep---------Fortune---------Directory_Submission---------2000---------9/19/2011 4:10:22 PM', NULL, CAST(0x00009F63010A84E8 AS DateTime), CAST(0x00009F6400AC1778 AS DateTime), N'TM_task,', 143, 49)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Fortune---------Directory_Submission---------2000---------9/19/2011 4:10:22 PM', N'Sandeep---------Fortune---------Directory_Submission---------2000---------9/19/2011 4:10:22 PM', NULL, CAST(0x00009F63010A84E8 AS DateTime), CAST(0x00009F640144CC0C AS DateTime), N'', 143, 50)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Fortune---------Directory_Submission---------2000---------9/19/2011 4:10:22 PM', N'Rahul---------Fortune---------welcome---------1000---------9/19/2011 4:10:22 PM', NULL, CAST(0x00009F63010A84E8 AS DateTime), CAST(0x00009F6500BD0060 AS DateTime), N'user_details,TM_task,TM_task,', 143, 51)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjeev---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', N'Rahul---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', NULL, CAST(0x00009F6500BD4584 AS DateTime), CAST(0x00009F6500D450BC AS DateTime), N'user_details,', 147, 52)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjeev---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', N'Rahul---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', NULL, CAST(0x00009F6500BD4584 AS DateTime), CAST(0x00009F6500D4C970 AS DateTime), N'user_details,', 147, 53)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjeev---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', N'Rahul---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', NULL, CAST(0x00009F6500BD4584 AS DateTime), CAST(0x00009F6500D53798 AS DateTime), N'user_details,', 147, 55)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjeev---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', N'Rahul---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', NULL, CAST(0x00009F6500BD4584 AS DateTime), CAST(0x00009F6500D540F8 AS DateTime), N'user_details,', 147, 56)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjeev---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', N'Rahul---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', NULL, CAST(0x00009F6500BD4584 AS DateTime), CAST(0x00009F6500D5D4A0 AS DateTime), N'user_details,', 147, 58)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjeev---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', N'Rahul---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', NULL, CAST(0x00009F6500BD4584 AS DateTime), CAST(0x00009F6500D650D8 AS DateTime), N'user_details,', 147, 59)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjeev---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', N'hariom---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', NULL, CAST(0x00009F6500BD4584 AS DateTime), CAST(0x00009F6500D67D60 AS DateTime), N'user_details,', 146, 60)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Rahul------------------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', N'Rahul---------zindgi---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', NULL, CAST(0x00009F6500BD4584 AS DateTime), CAST(0x00009F6E0126C360 AS DateTime), N'Commontask,', 147, 63)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Rahul------------------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', N'Rahul---------indiamart---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', NULL, CAST(0x00009F6500BD4584 AS DateTime), CAST(0x00009F6E0126E55C AS DateTime), N'Commontask,', 146, 64)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Rahul---------indiamart---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', N'Rahul---------indiamart---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', NULL, CAST(0x00009F6500BD4584 AS DateTime), CAST(0x00009F6E0127FE9C AS DateTime), N'', 146, 65)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Rahul---------zindgi---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', N'Rahul---------zindgi---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', NULL, CAST(0x00009F6500BD4584 AS DateTime), CAST(0x00009F6E01294C98 AS DateTime), N'', 147, 66)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sandeep---------zindgi---------Clubitc---------5000---------9/30/2011 5:17:54 PM', N'sandeep---------indiamart---------Clubitc---------5000---------9/30/2011 5:17:54 PM', NULL, CAST(0x00009F6E011D1158 AS DateTime), CAST(0x00009F6F009F6708 AS DateTime), N'Commontask,', 148, 67)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sandeep---------indiamart---------fortune---------4000---------9/30/2011 3:58:54 PM', N'sandeep---------indiamart---------Directory_Submission---------4000---------9/30/2011 3:58:54 PM', NULL, CAST(0x00009F6E01075EA8 AS DateTime), CAST(0x00009F6F009FC018 AS DateTime), N'TM_task,', 149, 68)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'MR Aggrawal---------Clubitc---------Directory_Submission---------250---------9/7/2011 12:31:58 PM', N'MR Aggrawal---------Clubitc---------Directory_Submission---------250---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00CD26C0 AS DateTime), N'', 138, 5)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'MR Aggrawal---------Clubitc---------Directory_Submission---------250---------9/7/2011 12:31:58 PM', N'MR Aggrawal---------Clubitc---------Directory_Submission---------500---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00CDBA68 AS DateTime), N'TM_task,', 138, 6)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Fortune---------Directory_Submission---------500---------9/7/2011 12:31:58 PM', N'Sandeep---------Fortune---------3---------500---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00CF4428 AS DateTime), N'TM_task,', 132, 7)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Fortune---------Directory_Submission---------500---------9/7/2011 12:31:58 PM', N'Sandeep---------Fortune---------3---------500---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00CF975C AS DateTime), N'TM_task,', 132, 8)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Clubitc---------Directory_Submission---------500---------9/7/2011 12:31:58 PM', N'Sandeep---------Clubitc---------Directory_Submission---------500---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00D8165C AS DateTime), N'', 132, 20)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Clubitc---------Directory_Submission---------500---------9/7/2011 12:31:58 PM', N'Sandeep---------Clubitc---------Directory_Submission---------500---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00D84794 AS DateTime), N'', 132, 21)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Fortune---------Article_submission---------5000---------9/7/2011 12:31:58 PM', N'sam---------Fortune---------Article_submission---------5000---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00D8E6F4 AS DateTime), N'', 136, 22)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'MR Aggrawal---------Clubitc---------Article_submission---------250---------9/7/2011 12:31:58 PM', N'MR Aggrawal---------Clubitc---------3---------250---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00D9137C AS DateTime), N'TM_task,', 138, 23)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'MR Aggrawal---------Fortune---------Directory_Submission---------8---------9/7/2011 12:54:08 PM', N'MR Aggrawal---------Fortune---------2---------8---------9/7/2011 12:54:08 PM', NULL, CAST(0x00009F5700D49F40 AS DateTime), CAST(0x00009F5C00D9ABD4 AS DateTime), N'TM_task,', 102, 24)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Directory_Submission---------1000---------9/7/2011 12:31:58 PM', N'sam---------Clubitc---------Directory_Submission---------1000---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00DA0160 AS DateTime), N'', 133, 25)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Fortune---------Directory_Submission---------1000---------9/7/2011 12:31:58 PM', N'sam---------Fortune---------2---------1000---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00DA1B28 AS DateTime), N'TM_task,', 133, 26)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Clubitc---------Directory_Submission---------500---------9/7/2011 12:31:58 PM', N'Sandeep---------Clubitc---------Directory_Submission---------500---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00DD8B3C AS DateTime), N'', 132, 27)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Directory_Submission---------250---------9/7/2011 12:31:58 PM', N'sanjay singhania---------Clubitc---------Directory_Submission---------250---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00E07A68 AS DateTime), N'', 137, 28)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Directory_Submission---------250---------9/7/2011 12:31:58 PM', N'sanjay singhania---------Clubitc---------Directory_Submission---------250---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00F0CD50 AS DateTime), N'', 137, 29)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Directory_Submission---------500---------9/7/2011 12:31:58 PM', N'sam---------Clubitc---------Directory_Submission---------500---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00D206CC AS DateTime), N'', 136, 9)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Fortune---------Directory_Submission---------500---------9/7/2011 12:31:58 PM', N'sam---------Fortune---------Directory_Submission---------500---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00D21F68 AS DateTime), N'', 136, 10)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Fortune---------Directory_Submission---------1000---------9/7/2011 12:31:58 PM', N'Sandeep---------Fortune---------Directory_Submission---------1000---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00D236D8 AS DateTime), N'', 135, 11)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Directory_Submission---------1000---------9/7/2011 12:31:58 PM', N'sam---------Clubitc---------Directory_Submission---------1000---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C00D26F18 AS DateTime), N'', 133, 12)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Linkbuilding---------2000---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Clubitc---------1---------2000---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5D00B83314 AS DateTime), N'TM_task,', 140, 34)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Directory_Submission---------600---------9/7/2011 12:32:54 PM', N'sanjay singhania---------Clubitc---------Directory_Submission---------600---------9/7/2011 12:32:54 PM', NULL, CAST(0x00009F5700CECA48 AS DateTime), CAST(0x00009F5D00B83FF8 AS DateTime), N'', 141, 35)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'MR Aggrawal---------Fortune---------Article_submission---------250---------9/7/2011 12:31:58 PM', N'MR Aggrawal---------Fortune---------Article_submission---------250---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5D00B8F59C AS DateTime), N'', 138, 36)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'MR Aggrawal---------Fortune---------Article_submission---------250---------9/7/2011 12:31:58 PM', N'MR Aggrawal---------Fortune---------1---------250---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5D00B9D69C AS DateTime), N'TM_task,', 138, 37)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'MR Aggrawal---------Clubitc---------Article_submission---------1000---------9/9/2011 12:52:53 PM', N'MR Aggrawal---------Clubitc---------2---------1000---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5D00BA138C AS DateTime), N'TM_task,', 139, 38)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Directory_Submission---------600---------9/7/2011 12:32:54 PM', N'sanjay singhania---------Clubitc---------3---------600---------9/7/2011 12:32:54 PM', NULL, CAST(0x00009F5700CECA48 AS DateTime), CAST(0x00009F5D00BA714C AS DateTime), N'TM_task,', 141, 39)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Fortune---------Article_submission---------5000---------9/7/2011 12:31:58 PM', N'sam---------Clubitc---------Article_submission---------5000---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5D00BAF810 AS DateTime), N'Commontask,', 136, 40)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Fortune---------Article_submission---------5000---------9/7/2011 12:31:58 PM', N'sam---------Fortune---------2---------5000---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5D00BB8F3C AS DateTime), N'TM_task,', 136, 41)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Directory_Submission---------250---------9/7/2011 12:31:58 PM', N'sanjay singhania---------Clubitc---------1---------250---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5D00BDB3AC AS DateTime), N'TM_task,', 134, 42)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Directory_Submission---------600---------9/7/2011 12:32:54 PM', N'sanjay singhania---------Clubitc---------Linkbuilding---------600---------9/7/2011 12:32:54 PM', NULL, CAST(0x00009F5700CECA48 AS DateTime), CAST(0x00009F5D00BDF9FC AS DateTime), N'TM_task,', 141, 43)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Linkbuilding---------600---------9/7/2011 12:32:54 PM', N'sanjay singhania---------Fortune---------Linkbuilding---------600---------9/7/2011 12:32:54 PM', NULL, CAST(0x00009F5700CECA48 AS DateTime), CAST(0x00009F5D00BE1748 AS DateTime), N'Commontask,', 141, 44)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Fortune---------Linkbuilding---------600---------9/7/2011 12:32:54 PM', N'sanjay singhania---------Fortune---------Linkbuilding---------6000---------9/7/2011 12:32:54 PM', NULL, CAST(0x00009F5700CECA48 AS DateTime), CAST(0x00009F5D00BE2C60 AS DateTime), N'TM_task,', 141, 45)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjeev---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', N'Rahul---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', NULL, CAST(0x00009F6500BD4584 AS DateTime), CAST(0x00009F6500D56B28 AS DateTime), N'user_details,', 147, 57)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'hariom---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', N'Rahul---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', NULL, CAST(0x00009F6500BD4584 AS DateTime), CAST(0x00009F6500D6AE98 AS DateTime), N'user_details,', 146, 61)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjeev---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', N'Rahul---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', NULL, CAST(0x00009F6500BD4584 AS DateTime), CAST(0x00009F6500D4FD00 AS DateTime), N'user_details,', 147, 54)
INSERT [dbo].[audit] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Rahul---------Fortune---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', N'Rahul---------Clubitc---------Directory_Submission---------1000---------9/21/2011 11:29:07 AM', NULL, CAST(0x00009F6500BD4584 AS DateTime), CAST(0x00009F65013536FC AS DateTime), N'Commontask,', 147, 62)
SET IDENTITY_INSERT [dbo].[audit] OFF
/****** Object:  Table [dbo].[auditsub]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[auditsub]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[auditsub](
    [Old_value] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [New_value] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [UserId] [int] NULL,
    [created_at] [datetime] NULL,
    [Updated_at] [datetime] NULL,
    [table_name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [row_id] [int] NULL,
    [ID] [int] IDENTITY(1,1) NOT NULL
)
END
GO
SET IDENTITY_INSERT [dbo].[auditsub] ON
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Fortune---------Article_submission---------1000---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Fortune---------Article_submission---------1000---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5C0101C8F8 AS DateTime), N'', 29, 1)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Fortune---------Linkbuilding---------1000---------9/7/2011 12:54:08 PM', N'sam---------Fortune---------Linkbuilding---------1000---------9/7/2011 12:54:08 PM', NULL, CAST(0x00009F5700D49F40 AS DateTime), CAST(0x00009F5C010463C4 AS DateTime), N'', 28, 2)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'MR Aggrawal---------Clubitc---------Article_submission---------10---------9/7/2011 12:44:08 PM', N'MR Aggrawal---------Clubitc---------Article_submission---------10---------9/7/2011 12:44:08 PM', NULL, CAST(0x00009F5700D1E020 AS DateTime), CAST(0x00009F5C0104ECE0 AS DateTime), N'', 27, 3)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Fortune---------Article_submission---------1000---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Fortune---------Article_submission---------1000---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5C01054CF8 AS DateTime), N'', 29, 4)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'MR Aggrawal---------Clubitc---------Article_submission---------10---------9/7/2011 12:44:08 PM', N'MR Aggrawal---------Clubitc---------Article_submission---------10---------9/7/2011 12:44:08 PM', NULL, CAST(0x00009F5700D1E020 AS DateTime), CAST(0x00009F5C0106524C AS DateTime), N'', 27, 5)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Directory_Submission---------600---------9/7/2011 12:31:58 PM', N'sanjay singhania---------Clubitc---------Directory_Submission---------600---------9/7/2011 12:31:58 PM', NULL, CAST(0x00009F5700CE88A8 AS DateTime), CAST(0x00009F5C0106DB68 AS DateTime), N'', 21, 6)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Fortune---------Linkbuilding---------21---------9/7/2011 12:34:19 PM', N'sam---------Fortune---------Linkbuilding---------21---------9/7/2011 12:34:19 PM', NULL, CAST(0x00009F5700CF2DE4 AS DateTime), CAST(0x00009F5C01071BDC AS DateTime), N'', 23, 7)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Fortune---------Linkbuilding---------2100---------9/7/2011 12:34:19 PM', N'sam---------Fortune---------Linkbuilding---------2100---------9/7/2011 12:34:19 PM', NULL, CAST(0x00009F5700CF2DE4 AS DateTime), CAST(0x00009F5C01078B30 AS DateTime), N'', 23, 8)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Linkbuilding---------500---------9/7/2011 12:37:25 PM', N'sam---------Clubitc---------Linkbuilding---------500---------9/7/2011 12:37:25 PM', NULL, CAST(0x00009F5700D007DC AS DateTime), CAST(0x00009F5C0107CF28 AS DateTime), N'', 26, 9)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Article_submission---------1000---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Clubitc---------Article_submission---------1000---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5C0107F700 AS DateTime), N'', 29, 10)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Directory_Submission---------1000---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Clubitc---------2---------1000---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5C01081ED8 AS DateTime), N'TM_task,', 29, 11)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Directory_Submission---------10000---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Clubitc---------Directory_Submission---------10000---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5C0108351C AS DateTime), N'', 29, 12)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Directory_Submission---------100---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Clubitc---------Directory_Submission---------100---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5C01087C98 AS DateTime), N'', 29, 13)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Directory_Submission---------2000---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Clubitc---------Directory_Submission---------2000---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5C010905B4 AS DateTime), N'', 29, 14)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Linkbuilding---------2000---------9/12/2011 4:14:54 PM', N'sam---------Clubitc---------Linkbuilding---------2000---------9/12/2011 4:14:54 PM', NULL, CAST(0x00009F5C010BC3A8 AS DateTime), CAST(0x00009F5D00A606BC AS DateTime), N'', 30, 15)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Article_submission---------200---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Clubitc---------3---------200---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5D00A7C40C AS DateTime), N'TM_task,', 29, 16)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Linkbuilding---------1000---------9/7/2011 12:54:08 PM', N'sam---------Clubitc---------Linkbuilding---------1000---------9/7/2011 12:54:08 PM', NULL, CAST(0x00009F5700D49F40 AS DateTime), CAST(0x00009F5D00A80B88 AS DateTime), N'', 28, 17)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Directory_Submission---------200---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Clubitc---------2---------200---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5D00B121B4 AS DateTime), N'TM_task,', 29, 21)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Fortune---------Directory_Submission---------200---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Fortune---------2---------200---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5D00B1ED9C AS DateTime), N'TM_task,', 29, 22)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Article_submission---------200---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Clubitc---------3---------200---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5D00B2ACA0 AS DateTime), N'TM_task,', 29, 23)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Fortune---------Article_submission---------200---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Fortune---------Article_submission---------200---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5D00B33940 AS DateTime), N'', 29, 24)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Fortune---------Directory_Submission---------200---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Fortune---------2---------200---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5D00B3B6A4 AS DateTime), N'TM_task,', 29, 25)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Fortune---------Directory_Submission---------200---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Clubitc---------Directory_Submission---------200---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5D00B402D0 AS DateTime), N'Commontask,', 29, 26)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Directory_Submission---------200---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Clubitc---------1---------200---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5D00B440EC AS DateTime), N'TM_task,', 29, 27)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Linkbuilding---------200---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Clubitc---------3---------200---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5D00B4D944 AS DateTime), N'TM_task,', 29, 28)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Linkbuilding---------1000---------9/7/2011 12:54:08 PM', N'sam---------Clubitc---------2---------1000---------9/7/2011 12:54:08 PM', NULL, CAST(0x00009F5700D49F40 AS DateTime), CAST(0x00009F5D00B67498 AS DateTime), N'TM_task,', 28, 29)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Directory_Submission---------1000---------9/7/2011 12:54:08 PM', N'sam---------Clubitc---------2---------1000---------9/7/2011 12:54:08 PM', NULL, CAST(0x00009F5700D49F40 AS DateTime), CAST(0x00009F5D00B68758 AS DateTime), N'TM_task,', 28, 30)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Directory_Submission---------1000---------9/7/2011 12:54:08 PM', N'sam---------Clubitc---------2---------1000---------9/7/2011 12:54:08 PM', NULL, CAST(0x00009F5700D49F40 AS DateTime), CAST(0x00009F5D00B69C70 AS DateTime), N'TM_task,', 28, 31)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'MR Aggrawal---------Clubitc---------Article_submission---------10---------9/7/2011 12:44:08 PM', N'MR Aggrawal---------Clubitc---------1---------10---------9/7/2011 12:44:08 PM', NULL, CAST(0x00009F5700D1E020 AS DateTime), CAST(0x00009F5D00B6E518 AS DateTime), N'TM_task,', 27, 32)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'MR Aggrawal---------Clubitc---------Linkbuilding---------10---------9/7/2011 12:44:08 PM', N'MR Aggrawal---------Clubitc---------2---------10---------9/7/2011 12:44:08 PM', NULL, CAST(0x00009F5700D1E020 AS DateTime), CAST(0x00009F5D00B74080 AS DateTime), N'TM_task,', 27, 33)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Linkbuilding---------2000---------9/12/2011 4:14:54 PM', N'sam---------Clubitc---------2---------2000---------9/12/2011 4:14:54 PM', NULL, CAST(0x00009F5C010BC3A8 AS DateTime), CAST(0x00009F5D00BEB324 AS DateTime), N'TM_task,', 30, 34)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Article_submission---------200---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Fortune---------Directory_Submission---------200---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5D00BEF398 AS DateTime), N'Commontask,TM_task,', 29, 35)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Fortune---------Directory_Submission---------200---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Fortune---------Linkbuilding---------200---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5D00BF6FD0 AS DateTime), N'TM_task,', 29, 36)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Fortune---------Linkbuilding---------200---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Clubitc---------Linkbuilding---------200---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5D00C02574 AS DateTime), N'Commontask,TM_task,', 29, 37)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Directory_Submission---------2000---------9/12/2011 4:14:54 PM', N'sam---------Clubitc---------Directory_Submission---------1000---------9/12/2011 4:14:54 PM', NULL, CAST(0x00009F5C010BC3A8 AS DateTime), CAST(0x00009F5D00C080DC AS DateTime), N'TM_task,', 30, 38)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Directory_Submission---------1000---------9/12/2011 4:14:54 PM', N'sam---------Clubitc---------Linkbuilding---------1000---------9/12/2011 4:14:54 PM', NULL, CAST(0x00009F5C010BC3A8 AS DateTime), CAST(0x00009F5D00C13C5C AS DateTime), N'TM_task,', 30, 39)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Linkbuilding---------1000---------9/12/2011 4:14:54 PM', N'sam---------Clubitc---------Directory_Submission---------10000---------9/12/2011 4:14:54 PM', NULL, CAST(0x00009F5C010BC3A8 AS DateTime), CAST(0x00009F5D00C18F90 AS DateTime), N'TM_task,TM_task,', 30, 40)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Directory_Submission---------10000---------9/12/2011 4:14:54 PM', N'sam---------Clubitc---------Linkbuilding---------10000---------9/12/2011 4:14:54 PM', NULL, CAST(0x00009F5C010BC3A8 AS DateTime), CAST(0x00009F5D00C1C1F4 AS DateTime), N'TM_task,', 30, 41)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Linkbuilding---------10000---------9/12/2011 4:14:54 PM', N'sam---------Clubitc---------Directory_Submission---------10000---------9/12/2011 4:14:54 PM', NULL, CAST(0x00009F5C010BC3A8 AS DateTime), CAST(0x00009F5D00C22B6C AS DateTime), N'TM_task,', 30, 42)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Directory_Submission---------10000---------9/12/2011 4:14:54 PM', N'sam---------Clubitc---------Linkbuilding---------10000---------9/12/2011 4:14:54 PM', NULL, CAST(0x00009F5C010BC3A8 AS DateTime), CAST(0x00009F5D00C2BCBC AS DateTime), N'TM_task,', 30, 43)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Linkbuilding---------10000---------9/12/2011 4:14:54 PM', N'sam---------Clubitc---------Linkbuilding---------10---------9/12/2011 4:14:54 PM', NULL, CAST(0x00009F5C010BC3A8 AS DateTime), CAST(0x00009F5D00C38AFC AS DateTime), N'TM_task,', 30, 44)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'MR Aggrawal---------Fortune---------Linkbuilding---------1000---------9/13/2011 1:00:45 PM', N'MR Aggrawal---------Fortune---------Linkbuilding---------1000---------9/13/2011 1:00:45 PM', NULL, CAST(0x00009F5D00D6707C AS DateTime), CAST(0x00009F6400ABF57C AS DateTime), N'', 33, 45)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Directory_Submission---------123---------9/13/2011 12:47:22 PM', N'Sandeep---------Clubitc---------Directory_Submission---------123---------9/13/2011 12:47:22 PM', NULL, CAST(0x00009F5D00D2C378 AS DateTime), CAST(0x00009F6400B071EC AS DateTime), N'user_details,TM_task,', 32, 46)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Directory_Submission---------123---------9/13/2011 12:47:22 PM', N'sam---------Clubitc---------Linkbuilding---------123---------9/13/2011 12:47:22 PM', NULL, CAST(0x00009F5D00D2C378 AS DateTime), CAST(0x00009F6400B093E8 AS DateTime), N'TM_task,', 32, 47)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'MR Aggrawal---------Fortune---------Linkbuilding---------6000---------9/20/2011 10:50:56 AM', N'Sandeep---------Fortune---------Article_submission---------6000---------9/20/2011 10:50:56 AM', NULL, CAST(0x00009F6400B2C8C0 AS DateTime), CAST(0x00009F6400C3BC34 AS DateTime), N'user_details,TM_task,', 42, 48)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'MR Aggrawal---------Fortune---------Article_submission---------6000---------9/20/2011 10:50:56 AM', N'MR Aggrawal---------Clubitc---------Linkbuilding---------6000---------9/20/2011 10:50:56 AM', NULL, CAST(0x00009F6400B2C8C0 AS DateTime), CAST(0x00009F6400C4D448 AS DateTime), N'Commontask,TM_task,', 42, 49)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'MR Aggrawal---------Fortune---------Article_submission---------6000---------9/20/2011 10:50:56 AM', N'MR Aggrawal---------Fortune---------Directory_Submission---------6000---------9/20/2011 10:50:56 AM', NULL, CAST(0x00009F6400B2C8C0 AS DateTime), CAST(0x00009F6400C4E384 AS DateTime), N'TM_task,', 42, 50)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/20/2011 5:27:57 PM', NULL, CAST(0x00009F64011FD3FC AS DateTime), CAST(0x00009F64011FD3FC AS DateTime), N'TM_task,', 0, 53)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/20/2011 5:32:58 PM', NULL, CAST(0x00009F64012134B8 AS DateTime), CAST(0x00009F64012134B8 AS DateTime), N'TM_task,', 0, 54)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'MR Aggrawal---------Fortune---------Directory_Submission---------6000---------9/20/2011 10:50:56 AM', N'MR Aggrawal---------Fortune---------Directory_Submission---------6000---------9/20/2011 10:50:56 AM', NULL, CAST(0x00009F6400B2C8C0 AS DateTime), CAST(0x00009F6401216014 AS DateTime), N'', 42, 55)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/20/2011 5:38:23 PM', NULL, CAST(0x00009F640122B194 AS DateTime), CAST(0x00009F640122B194 AS DateTime), N'TM_task,', 46, 56)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/20/2011 5:38:34 PM', NULL, CAST(0x00009F640122BE78 AS DateTime), CAST(0x00009F640122BE78 AS DateTime), N'TM_task,', 46, 57)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/20/2011 5:38:52 PM', NULL, CAST(0x00009F640122D390 AS DateTime), CAST(0x00009F640122D390 AS DateTime), N'TM_task,', 0, 58)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/20/2011 5:39:45 PM', NULL, CAST(0x00009F64012311AC AS DateTime), CAST(0x00009F64012311AC AS DateTime), N'TM_task,', 0, 59)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/20/2011 5:40:10 PM', NULL, CAST(0x00009F6401232EF8 AS DateTime), CAST(0x00009F6401232EF8 AS DateTime), N'TM_task,', 46, 60)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/20/2011 5:42:03 PM', NULL, CAST(0x00009F640123B364 AS DateTime), CAST(0x00009F640123B364 AS DateTime), N'TM_task,', 47, 61)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/20/2011 5:46:14 PM', NULL, CAST(0x00009F640124D988 AS DateTime), CAST(0x00009F640124D988 AS DateTime), N'TM_task,', 48, 62)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/20/2011 5:46:58 PM', NULL, CAST(0x00009F6401250D18 AS DateTime), CAST(0x00009F6401250D18 AS DateTime), N'TM_task,', 48, 63)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/20/2011 5:47:28 PM', NULL, CAST(0x00009F6401253040 AS DateTime), CAST(0x00009F6401253040 AS DateTime), N'TM_task,', 48, 64)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/20/2011 5:48:34 PM', NULL, CAST(0x00009F6401257D98 AS DateTime), CAST(0x00009F6401257D98 AS DateTime), N'TM_task,', 48, 65)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/20/2011 5:50:50 PM', NULL, CAST(0x00009F6401261CF8 AS DateTime), CAST(0x00009F6401261CF8 AS DateTime), N'TM_task,', 47, 66)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/20/2011 6:09:23 PM', NULL, CAST(0x00009F64012B3544 AS DateTime), CAST(0x00009F64012B3544 AS DateTime), N'TM_task,', 0, 67)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'Sandeep---------1---------1---------1000---------9/20/2011 6:41:07 PM', NULL, CAST(0x00009F640133EC84 AS DateTime), CAST(0x00009F640133EC84 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 46, 81)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Fortune---------Linkbuilding---------3000----------1/1/0001 12:00:00 AM', N'Sandeep---------2---------1---------1000---------9/20/2011 6:41:52 PM', NULL, CAST(0x00009F6401342CF8 AS DateTime), CAST(0x00009F6401342CF8 AS DateTime), N'Commontask,TM_task,TM_task,TM_task,', 46, 82)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/21/2011 10:42:13 AM', NULL, CAST(0x00009F6500B063DC AS DateTime), CAST(0x00009F6500B063DC AS DateTime), N'TM_task,', 0, 90)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:42:24 AM', NULL, CAST(0x00009F6500B070C0 AS DateTime), CAST(0x00009F6500B070C0 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 46, 91)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:43:09 AM', NULL, CAST(0x00009F6500B0A57C AS DateTime), CAST(0x00009F6500B0A57C AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 92)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:43:37 AM', NULL, CAST(0x00009F6500B0C64C AS DateTime), CAST(0x00009F6500B0C64C AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 93)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:43:42 AM', NULL, CAST(0x00009F6500B0CC28 AS DateTime), CAST(0x00009F6500B0CC28 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 94)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:43:47 AM', NULL, CAST(0x00009F6500B0D204 AS DateTime), CAST(0x00009F6500B0D204 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 95)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:44:02 AM', NULL, CAST(0x00009F6500B0E398 AS DateTime), CAST(0x00009F6500B0E398 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 96)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:44:07 AM', NULL, CAST(0x00009F6500B0E974 AS DateTime), CAST(0x00009F6500B0E974 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 97)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:44:11 AM', NULL, CAST(0x00009F6500B0EE24 AS DateTime), CAST(0x00009F6500B0EE24 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 98)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:44:13 AM', NULL, CAST(0x00009F6500B0F07C AS DateTime), CAST(0x00009F6500B0F07C AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 99)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:44:16 AM', NULL, CAST(0x00009F6500B0F400 AS DateTime), CAST(0x00009F6500B0F400 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 100)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sanjay singhania---------Clubitc---------Linkbuilding---------200---------9/9/2011 12:52:53 PM', N'sanjay singhania---------Clubitc---------1---------200---------9/9/2011 12:52:53 PM', NULL, CAST(0x00009F5900D4475C AS DateTime), CAST(0x00009F5D00A88FF4 AS DateTime), N'TM_task,', 29, 18)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Linkbuilding---------1000---------9/7/2011 12:54:08 PM', N'sam---------Clubitc---------Linkbuilding---------1000---------9/7/2011 12:54:08 PM', NULL, CAST(0x00009F5700D49F40 AS DateTime), CAST(0x00009F5D00A9E3CC AS DateTime), N'', 28, 19)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Fortune---------Linkbuilding---------45---------9/7/2011 12:34:47 PM', N'sam---------Fortune---------Linkbuilding---------45---------9/7/2011 12:34:47 PM', NULL, CAST(0x00009F5700CF4EB4 AS DateTime), CAST(0x00009F5D00ACA670 AS DateTime), N'', 25, 20)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/20/2011 6:09:29 PM', NULL, CAST(0x00009F64012B3C4C AS DateTime), CAST(0x00009F64012B3C4C AS DateTime), N'TM_task,', 0, 68)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:44:19 AM', NULL, CAST(0x00009F6500B0F784 AS DateTime), CAST(0x00009F6500B0F784 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 101)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:44:23 AM', NULL, CAST(0x00009F6500B0FC34 AS DateTime), CAST(0x00009F6500B0FC34 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 102)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:44:27 AM', NULL, CAST(0x00009F6500B100E4 AS DateTime), CAST(0x00009F6500B100E4 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 103)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:44:32 AM', NULL, CAST(0x00009F6500B106C0 AS DateTime), CAST(0x00009F6500B106C0 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 104)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:46:46 AM', NULL, CAST(0x00009F6500B1A3C8 AS DateTime), CAST(0x00009F6500B1A3C8 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 105)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:46:49 AM', NULL, CAST(0x00009F6500B1A74C AS DateTime), CAST(0x00009F6500B1A74C AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 106)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:46:52 AM', NULL, CAST(0x00009F6500B1AAD0 AS DateTime), CAST(0x00009F6500B1AAD0 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 107)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:46:56 AM', NULL, CAST(0x00009F6500B1AF80 AS DateTime), CAST(0x00009F6500B1AF80 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 108)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:47:00 AM', NULL, CAST(0x00009F6500B1B430 AS DateTime), CAST(0x00009F6500B1B430 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 109)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:47:04 AM', NULL, CAST(0x00009F6500B1B8E0 AS DateTime), CAST(0x00009F6500B1B8E0 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 110)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:47:09 AM', NULL, CAST(0x00009F6500B1BEBC AS DateTime), CAST(0x00009F6500B1BEBC AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 111)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:47:14 AM', NULL, CAST(0x00009F6500B1C498 AS DateTime), CAST(0x00009F6500B1C498 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 112)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:49:15 AM', NULL, CAST(0x00009F6500B25264 AS DateTime), CAST(0x00009F6500B25264 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 113)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:49:46 AM', NULL, CAST(0x00009F6500B276B8 AS DateTime), CAST(0x00009F6500B276B8 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 114)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:49:57 AM', NULL, CAST(0x00009F6500B2839C AS DateTime), CAST(0x00009F6500B2839C AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 115)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:52:20 AM', NULL, CAST(0x00009F6500B32B30 AS DateTime), CAST(0x00009F6500B32B30 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 116)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:52:56 AM', NULL, CAST(0x00009F6500B35560 AS DateTime), CAST(0x00009F6500B35560 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 117)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:53:11 AM', NULL, CAST(0x00009F6500B366F4 AS DateTime), CAST(0x00009F6500B366F4 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 118)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------------------------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:53:39 AM', NULL, CAST(0x00009F6500B387C4 AS DateTime), CAST(0x00009F6500B387C4 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 119)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/21/2011 10:57:32 AM', NULL, CAST(0x00009F6500B498D0 AS DateTime), CAST(0x00009F6500B498D0 AS DateTime), N'TM_task,', 0, 120)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/21/2011 10:57:38 AM', NULL, CAST(0x00009F6500B49FD8 AS DateTime), CAST(0x00009F6500B49FD8 AS DateTime), N'TM_task,', 0, 121)
GO
print 'Processed 100 total records'
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Fortune---------Directory_Submission---------2000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------2000---------9/21/2011 10:58:29 AM', NULL, CAST(0x00009F6500B4DB9C AS DateTime), CAST(0x00009F6500B4DB9C AS DateTime), N'user_details,Commontask,TM_task,TM_task,', 46, 122)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Fortune---------Directory_Submission---------3000----------1/1/0001 12:00:00 AM', N'Rahul---------Fortune---------Directory_Submission---------3000---------9/21/2011 10:59:56 AM', NULL, CAST(0x00009F6500B54190 AS DateTime), CAST(0x00009F6500B54190 AS DateTime), N'user_details,Commontask,TM_task,TM_task,', 47, 123)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/21/2011 1:02:16 PM', NULL, CAST(0x00009F6500D6DB20 AS DateTime), CAST(0x00009F6500D6DB20 AS DateTime), N'TM_task,', 0, 124)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'hariom---------Fortune---------Directory_Submission---------500----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/21/2011 1:04:07 PM', NULL, CAST(0x00009F6500D75D34 AS DateTime), CAST(0x00009F6500D75D34 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 125)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Rahul---------Fortune---------Directory_Submission---------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Directory_Submission---------1000---------9/21/2011 1:08:31 PM', NULL, CAST(0x00009F6500D89294 AS DateTime), CAST(0x00009F6500D89294 AS DateTime), N'user_details,Commontask,TM_task,TM_task,', 54, 126)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/30/2011 5:52:27 PM', NULL, CAST(0x00009F6E01268EA4 AS DateTime), CAST(0x00009F6E01268EA4 AS DateTime), N'TM_task,', 0, 134)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/30/2011 5:52:32 PM', NULL, CAST(0x00009F6E01269480 AS DateTime), CAST(0x00009F6E01269480 AS DateTime), N'TM_task,', 0, 135)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/30/2011 5:52:36 PM', NULL, CAST(0x00009F6E01269930 AS DateTime), CAST(0x00009F6E01269930 AS DateTime), N'TM_task,', 0, 136)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/30/2011 5:52:39 PM', NULL, CAST(0x00009F6E01269CB4 AS DateTime), CAST(0x00009F6E01269CB4 AS DateTime), N'TM_task,', 0, 137)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/30/2011 5:55:06 PM', NULL, CAST(0x00009F6E012748F8 AS DateTime), CAST(0x00009F6E012748F8 AS DateTime), N'TM_task,', 0, 138)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/30/2011 6:00:26 PM', NULL, CAST(0x00009F6E0128BFF8 AS DateTime), CAST(0x00009F6E0128BFF8 AS DateTime), N'TM_task,', 0, 139)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'hariom------------------Directory_Submission---------1000----------1/1/0001 12:00:00 AM', N'sandeep---------indiamart---------fortune---------1000---------9/30/2011 6:00:36 PM', NULL, CAST(0x00009F6E0128CBB0 AS DateTime), CAST(0x00009F6E0128CBB0 AS DateTime), N'user_detail,Commontask,TM_task,TM_task,', 53, 140)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------10/1/2011 9:40:03 AM', NULL, CAST(0x00009F6F009F50C4 AS DateTime), CAST(0x00009F6F009F50C4 AS DateTime), N'TM_task,', 0, 141)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------10/1/2011 9:56:08 AM', NULL, CAST(0x00009F6F00A3BBA0 AS DateTime), CAST(0x00009F6F00A3BBA0 AS DateTime), N'TM_task,', 0, 142)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------10/1/2011 2:10:30 PM', NULL, CAST(0x00009F6F00E998C8 AS DateTime), CAST(0x00009F6F00E998C8 AS DateTime), N'TM_task,', 0, 143)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/20/2011 6:10:29 PM', NULL, CAST(0x00009F64012B9688 AS DateTime), CAST(0x00009F64012B9688 AS DateTime), N'TM_task,', 46, 69)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/20/2011 6:11:44 PM', NULL, CAST(0x00009F64012BDA80 AS DateTime), CAST(0x00009F64012BDA80 AS DateTime), N'TM_task,', 46, 70)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'Sandeep---------1---------1---------3000---------9/20/2011 6:14:48 PM', NULL, CAST(0x00009F64012CB34C AS DateTime), CAST(0x00009F64012CB34C AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 46, 71)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/20/2011 6:16:56 PM', NULL, CAST(0x00009F64012D4820 AS DateTime), CAST(0x00009F64012D4820 AS DateTime), N'TM_task,', 0, 72)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'Sandeep---------1---------1---------1000---------9/20/2011 6:20:44 PM', NULL, CAST(0x00009F64012E5350 AS DateTime), CAST(0x00009F64012E5350 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 48, 73)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Fortune---------Linkbuilding---------0----------1/1/0001 12:00:00 AM', N'Sandeep---------1---------1---------1000---------9/20/2011 6:22:31 PM', NULL, CAST(0x00009F64012ED0B4 AS DateTime), CAST(0x00009F64012ED0B4 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 48, 74)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Linkbuilding---------0----------1/1/0001 12:00:00 AM', N'Sandeep---------1---------1---------1000---------9/20/2011 6:23:12 PM', NULL, CAST(0x00009F64012F00C0 AS DateTime), CAST(0x00009F64012F00C0 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 48, 75)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'sam---------Clubitc---------Linkbuilding---------1000----------1/1/0001 12:00:00 AM', N'Sandeep---------1---------1---------1000---------9/20/2011 6:24:22 PM', NULL, CAST(0x00009F64012F5C28 AS DateTime), CAST(0x00009F64012F5C28 AS DateTime), N'user_details,Commontask,TM_task,TM_task,', 48, 76)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Fortune---------Linkbuilding---------3000----------1/1/0001 12:00:00 AM', N'Sandeep---------1---------1---------3000---------9/20/2011 6:38:07 PM', NULL, CAST(0x00009F6401331994 AS DateTime), CAST(0x00009F6401331994 AS DateTime), N'Commontask,TM_task,TM_task,', 47, 77)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Fortune---------Linkbuilding---------3000----------1/1/0001 12:00:00 AM', N'Sandeep---------1---------1---------3000---------9/20/2011 6:38:21 PM', NULL, CAST(0x00009F64013329FC AS DateTime), CAST(0x00009F64013329FC AS DateTime), N'Commontask,TM_task,TM_task,', 0, 78)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Fortune---------Linkbuilding---------3000----------1/1/0001 12:00:00 AM', N'Sandeep---------1---------1---------1000---------9/20/2011 6:38:41 PM', NULL, CAST(0x00009F64013358DC AS DateTime), CAST(0x00009F64013358DC AS DateTime), N'Commontask,TM_task,TM_task,TM_task,', 46, 79)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'Sandeep---------Fortune---------1---------1000---------9/20/2011 6:40:27 PM', NULL, CAST(0x00009F640133BDA4 AS DateTime), CAST(0x00009F640133BDA4 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 46, 80)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Fortune---------Linkbuilding---------3000----------1/1/0001 12:00:00 AM', N'Sandeep---------Fortune---------Article_submission---------1000---------9/20/2011 6:43:52 PM', NULL, CAST(0x00009F640134ADE0 AS DateTime), CAST(0x00009F640134ADE0 AS DateTime), N'Commontask,TM_task,TM_task,TM_task,', 46, 83)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Fortune---------Linkbuilding---------3000----------1/1/0001 12:00:00 AM', N'Sandeep---------Fortune---------Linkbuilding---------1000---------9/20/2011 6:44:34 PM', NULL, CAST(0x00009F6401350114 AS DateTime), CAST(0x00009F6401350114 AS DateTime), N'Commontask,TM_task,TM_task,TM_task,', 46, 84)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Fortune---------Linkbuilding---------3000----------1/1/0001 12:00:00 AM', N'Sandeep---------Fortune---------Linkbuilding---------1000---------9/20/2011 6:45:19 PM', NULL, CAST(0x00009F64013513D4 AS DateTime), CAST(0x00009F64013513D4 AS DateTime), N'Commontask,TM_task,TM_task,TM_task,', 0, 85)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Fortune---------Linkbuilding---------3000----------1/1/0001 12:00:00 AM', N'Sandeep---------Fortune---------Linkbuilding---------1000---------9/20/2011 6:45:27 PM', NULL, CAST(0x00009F6401351D34 AS DateTime), CAST(0x00009F6401351D34 AS DateTime), N'Commontask,TM_task,TM_task,TM_task,', 0, 86)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Fortune---------Directory_Submission---------500----------1/1/0001 12:00:00 AM', N'Sandeep---------Fortune---------Linkbuilding---------1000---------9/20/2011 6:45:53 PM', NULL, CAST(0x00009F6401353BAC AS DateTime), CAST(0x00009F6401353BAC AS DateTime), N'Commontask,TM_task,TM_task,TM_task,', 38, 87)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/20/2011 7:42:41 PM', NULL, CAST(0x00009F640144D56C AS DateTime), CAST(0x00009F640144D56C AS DateTime), N'TM_task,', 0, 88)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Sandeep---------Fortune---------Linkbuilding---------1000----------1/1/0001 12:00:00 AM', N'sanjeev---------Fortune---------Linkbuilding---------1000---------9/20/2011 7:42:44 PM', NULL, CAST(0x00009F640144D8F0 AS DateTime), CAST(0x00009F640144D8F0 AS DateTime), N'user_details,Commontask,TM_task,TM_task,', 46, 89)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/21/2011 1:45:16 PM', NULL, CAST(0x00009F6500E2AA90 AS DateTime), CAST(0x00009F6500E2AA90 AS DateTime), N'TM_task,', 0, 127)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Rahul---------Fortune---------Directory_Submission---------500----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/21/2011 1:45:49 PM', NULL, CAST(0x00009F6500E2D13C AS DateTime), CAST(0x00009F6500E2D13C AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 128)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Rahul---------Fortune---------Directory_Submission---------500----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/21/2011 1:49:42 PM', NULL, CAST(0x00009F6500E3E248 AS DateTime), CAST(0x00009F6500E3E248 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 129)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'Rahul---------Fortune---------Directory_Submission---------500----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/21/2011 1:50:07 PM', NULL, CAST(0x00009F6500E3FF94 AS DateTime), CAST(0x00009F6500E3FF94 AS DateTime), N'user_details,Commontask,TM_task,TM_task,TM_task,', 0, 130)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/21/2011 2:09:48 PM', NULL, CAST(0x00009F6500E96790 AS DateTime), CAST(0x00009F6500E96790 AS DateTime), N'TM_task,', 0, 131)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/21/2011 6:46:12 PM', NULL, CAST(0x00009F65013551F0 AS DateTime), CAST(0x00009F65013551F0 AS DateTime), N'TM_task,', 0, 132)
INSERT [dbo].[auditsub] ([Old_value], [New_value], [UserId], [created_at], [Updated_at], [table_name], [row_id], [ID]) VALUES (N'---------------------------0----------1/1/0001 12:00:00 AM', N'---------------------------0---------9/21/2011 6:46:18 PM', NULL, CAST(0x00009F65013558F8 AS DateTime), CAST(0x00009F65013558F8 AS DateTime), N'TM_task,', 0, 133)
SET IDENTITY_INSERT [dbo].[auditsub] OFF
/****** Object:  Table [dbo].[role1]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[role1]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[role1](
    [role_id] [int] IDENTITY(1,1) NOT NULL,
    [role_Type] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 CONSTRAINT [PK_role] PRIMARY KEY CLUSTERED
(
    [role_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
)
END
GO
SET IDENTITY_INSERT [dbo].[role1] ON
INSERT [dbo].[role1] ([role_id], [role_Type]) VALUES (1, N'Super Admin')
INSERT [dbo].[role1] ([role_id], [role_Type]) VALUES (2, N'Team Leader')
INSERT [dbo].[role1] ([role_id], [role_Type]) VALUES (3, N'Admin')
INSERT [dbo].[role1] ([role_id], [role_Type]) VALUES (4, N'Link Builder')
SET IDENTITY_INSERT [dbo].[role1] OFF
/****** Object:  StoredProcedure [dbo].[suser]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[suser]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'create proc [dbo].[suser]
(
@name varchar(100),
@password varchar(100),
@mobile int,
@email nvarchar(100),
@status tinyint,
@role_id int
)
as
begin
insert into suuser values(@name,@password,@mobile,@email,@role_id,@status)
end'
END
GO
/****** Object:  Table [dbo].[assign_role]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[assign_role]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[assign_role](
    [assign_id] [int] IDENTITY(1,1) NOT NULL,
    [project_id] [int] NULL,
    [client_id] [int] NULL,
    [role_id] [int] NULL,
    [create_at] [datetime] NULL,
    [updated_at] [datetime] NULL,
    [status] [tinyint] NULL,
 CONSTRAINT [PK_assign_role] PRIMARY KEY CLUSTERED
(
    [assign_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
)
END
GO
/****** Object:  Table [dbo].[client]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[client]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[client](
    [client_id] [int] IDENTITY(1,1) NOT NULL,
    [name] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [password] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [logo] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [email] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [description] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [crete_at] [datetime] NULL,
    [updated_at] [datetime] NULL,
    [status] [tinyint] NULL,
 CONSTRAINT [PK_client1] PRIMARY KEY CLUSTERED
(
    [client_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
)
END
GO
SET IDENTITY_INSERT [dbo].[client] ON
INSERT [dbo].[client] ([client_id], [name], [password], [logo], [email], [description], [crete_at], [updated_at], [status]) VALUES (5, N'vivek', N'123456', N'32173-avinash-in-chhoti-bahu-sindoor-bin-suhaagan.jpg', N'beena@envigo.co.uk', N'feg', CAST(0x00009F6500F7119C AS DateTime), CAST(0x00009F6A00092FF4 AS DateTime), 1)
INSERT [dbo].[client] ([client_id], [name], [password], [logo], [email], [description], [crete_at], [updated_at], [status]) VALUES (6, N'beena', N'benna123', N'37247-a-still-image-of-rubina-dilaik.jpg', N'bindu@envigo.co.uk', N'fgdfg', CAST(0x00009F650122CB5C AS DateTime), CAST(0x00009F6A0009EEF8 AS DateTime), 1)
INSERT [dbo].[client] ([client_id], [name], [password], [logo], [email], [description], [crete_at], [updated_at], [status]) VALUES (7, N'sabita', N'sabita123', N'BMW_Logo.jpg', N'nisha@envigo.co.uk', N'sad', CAST(0x00009F6600BA15E4 AS DateTime), CAST(0x00009F6A000C7704 AS DateTime), 1)
INSERT [dbo].[client] ([client_id], [name], [password], [logo], [email], [description], [crete_at], [updated_at], [status]) VALUES (8, N'sam', N'123456', N'37248-radhika-with-krishna.jpg', N'priyakmr679@gmail.com', N'ASAD', CAST(0x00009F6600BC541C AS DateTime), CAST(0x00009F6600C4C890 AS DateTime), 1)
INSERT [dbo].[client] ([client_id], [name], [password], [logo], [email], [description], [crete_at], [updated_at], [status]) VALUES (9, N'apul', N'apul123', N'250px-Teddy_bear_27.jpeg', N'apul@envigo.co.uk', N'asd', CAST(0x00009F6600C5C808 AS DateTime), NULL, 1)
INSERT [dbo].[client] ([client_id], [name], [password], [logo], [email], [description], [crete_at], [updated_at], [status]) VALUES (10, N'subhodh', N'12344321', N'icon-help.png', N'subodh@envigo.co.uk', N'rgf', CAST(0x00009F6600FDEE40 AS DateTime), NULL, 1)
INSERT [dbo].[client] ([client_id], [name], [password], [logo], [email], [description], [crete_at], [updated_at], [status]) VALUES (11, N'renu', N'123456', N'big-availability-icon.gif', N'renu@gmail.com', N'fsdf', CAST(0x00009F67000CA134 AS DateTime), CAST(0x00009F67000CC6B4 AS DateTime), 1)
INSERT [dbo].[client] ([client_id], [name], [password], [logo], [email], [description], [crete_at], [updated_at], [status]) VALUES (12, N'samina', N'111111', N'green_logo.jpg', N'arch.renu@yahoo.com', N'we are friend', CAST(0x00009F69018944F4 AS DateTime), CAST(0x00009F6901897F8C AS DateTime), 1)
SET IDENTITY_INSERT [dbo].[client] OFF
/****** Object:  Table [dbo].[project]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[project]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[project](
    [Project_id] [int] IDENTITY(1,1) NOT NULL,
    [client_id] [int] NULL,
    [title] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [create_at] [datetime] NULL,
    [update_at] [datetime] NULL,
    [description] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [active] [tinyint] NULL,
 CONSTRAINT [PK_project] PRIMARY KEY CLUSTERED
(
    [Project_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
)
END
GO
SET IDENTITY_INSERT [dbo].[project] ON
INSERT [dbo].[project] ([Project_id], [client_id], [title], [create_at], [update_at], [description], [active]) VALUES (10, 5, N'indiamart', CAST(0x00009F6500F75210 AS DateTime), CAST(0x00009F690189A50C AS DateTime), N'vdsvd', 1)
INSERT [dbo].[project] ([Project_id], [client_id], [title], [create_at], [update_at], [description], [active]) VALUES (11, 8, N'wecomeclub', CAST(0x00009F6600FE21D0 AS DateTime), CAST(0x00009F67000D4544 AS DateTime), N'tg', 1)
INSERT [dbo].[project] ([Project_id], [client_id], [title], [create_at], [update_at], [description], [active]) VALUES (12, 11, N'indiamart', CAST(0x00009F67000D2B7C AS DateTime), NULL, N'fdgfh', 1)
INSERT [dbo].[project] ([Project_id], [client_id], [title], [create_at], [update_at], [description], [active]) VALUES (14, 10, N'zindgi', CAST(0x00009F690189CCE4 AS DateTime), NULL, N'gfgh', 1)
SET IDENTITY_INSERT [dbo].[project] OFF
/****** Object:  Table [dbo].[user_detail]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[user_detail]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[user_detail](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [name] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [password] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [mobile] [bigint] NULL,
    [email] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [role_id] [int] NULL,
    [create_at] [datetime] NULL,
    [update_at] [datetime] NULL,
    [status] [tinyint] NULL,
 CONSTRAINT [PK_user] PRIMARY KEY CLUSTERED
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
)
END
GO
SET IDENTITY_INSERT [dbo].[user_detail] ON
INSERT [dbo].[user_detail] ([id], [name], [password], [mobile], [email], [role_id], [create_at], [update_at], [status]) VALUES (1, N'priya', N'1', 1234567898, N'priya@envigo.co.uk', 1, CAST(0x00009DEF00000000 AS DateTime), CAST(0x00009F650108B730 AS DateTime), 1)
INSERT [dbo].[user_detail] ([id], [name], [password], [mobile], [email], [role_id], [create_at], [update_at], [status]) VALUES (2, N'apul gupta', N'111111', 3243547568, N'qwert@envigo.co.uk', 3, CAST(0x00009F6500BD6078 AS DateTime), CAST(0x00009F6A0008433C AS DateTime), 1)
INSERT [dbo].[user_detail] ([id], [name], [password], [mobile], [email], [role_id], [create_at], [update_at], [status]) VALUES (3, N'sandeep', N'12344321', 2132432548, N'riya@envigo.co.uk', 4, CAST(0x00009F6500F1CF20 AS DateTime), CAST(0x00009F6701130FA0 AS DateTime), 1)
INSERT [dbo].[user_detail] ([id], [name], [password], [mobile], [email], [role_id], [create_at], [update_at], [status]) VALUES (4, N'saurabh', N'envigo123', 1232452354, N'saurabh@envigo.co.uk', 2, CAST(0x00009F6500FCE8EC AS DateTime), CAST(0x00009F670110F814 AS DateTime), 1)
INSERT [dbo].[user_detail] ([id], [name], [password], [mobile], [email], [role_id], [create_at], [update_at], [status]) VALUES (5, N'surjit', N'1234567', 1232434546, N'surjit@gamil.com', 3, CAST(0x00009F6600FEE6B0 AS DateTime), CAST(0x00009F6600FF0528 AS DateTime), 1)
INSERT [dbo].[user_detail] ([id], [name], [password], [mobile], [email], [role_id], [create_at], [update_at], [status]) VALUES (6, N'Renu bala', N'renu123', 4546576867, N'priya123@envigo.co.uk', 4, CAST(0x00009F67000C4950 AS DateTime), CAST(0x00009F670133542C AS DateTime), 0)
INSERT [dbo].[user_detail] ([id], [name], [password], [mobile], [email], [role_id], [create_at], [update_at], [status]) VALUES (7, N'kajol', N'kajol123', 1232534657, N'kajol@envigo.co.uk', 4, CAST(0x00009F67012DB648 AS DateTime), NULL, 1)
INSERT [dbo].[user_detail] ([id], [name], [password], [mobile], [email], [role_id], [create_at], [update_at], [status]) VALUES (8, N'manus', N'123456', 3434565876, N'manus@envigo.co.uk', 2, CAST(0x00009F67012E18B8 AS DateTime), NULL, 1)
INSERT [dbo].[user_detail] ([id], [name], [password], [mobile], [email], [role_id], [create_at], [update_at], [status]) VALUES (9, N'nitu', N'123456', 8678566756, N'neetu0907@gmail.com', 3, CAST(0x00009F690181F0C8 AS DateTime), CAST(0x00009F6901826724 AS DateTime), 1)
INSERT [dbo].[user_detail] ([id], [name], [password], [mobile], [email], [role_id], [create_at], [update_at], [status]) VALUES (10, N'renu', N'envigo123', 3124325436, N'arch.renu@yahoo.com', 1, CAST(0x00009F6901824654 AS DateTime), NULL, 1)
INSERT [dbo].[user_detail] ([id], [name], [password], [mobile], [email], [role_id], [create_at], [update_at], [status]) VALUES (11, N'sanjay', N'envigo', 1234567890, N'san@gmail.com', 3, CAST(0x00009F6901824654 AS DateTime), CAST(0x00009F6901824654 AS DateTime), 1)
SET IDENTITY_INSERT [dbo].[user_detail] OFF
/****** Object:  Table [dbo].[tblContactDetails]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblContactDetails]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tblContactDetails](
    [emailid] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
END
GO
INSERT [dbo].[tblContactDetails] ([emailid]) VALUES (N'perfect.chourasia@gmail.com')
INSERT [dbo].[tblContactDetails] ([emailid]) VALUES (N'sandeepchrs@yahoo.com')
INSERT [dbo].[tblContactDetails] ([emailid]) VALUES (N'vivekgupta0505@gmail.com')
/****** Object:  Table [dbo].[swap]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[swap]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[swap](
    [Id] [int] NULL,
    [newid] [int] NULL,
    [mane] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
END
GO
INSERT [dbo].[swap] ([Id], [newid], [mane]) VALUES (1, 2, N'sam')
INSERT [dbo].[swap] ([Id], [newid], [mane]) VALUES (3, 4, N'sam1')
INSERT [dbo].[swap] ([Id], [newid], [mane]) VALUES (5, 6, N'sam3')
INSERT [dbo].[swap] ([Id], [newid], [mane]) VALUES (7, 8, N'sam4')
INSERT [dbo].[swap] ([Id], [newid], [mane]) VALUES (1, 1, N'ONE')
INSERT [dbo].[swap] ([Id], [newid], [mane]) VALUES (1, 2, N'TWO')
INSERT [dbo].[swap] ([Id], [newid], [mane]) VALUES (1, 2, N'TWO')
INSERT [dbo].[swap] ([Id], [newid], [mane]) VALUES (1, 3, N'THREE')
INSERT [dbo].[swap] ([Id], [newid], [mane]) VALUES (1, 3, N'THREE')
INSERT [dbo].[swap] ([Id], [newid], [mane]) VALUES (1, 3, N'THREE')
/****** Object:  View [dbo].[View_4]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[View_4]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[View_4]
AS
SELECT     dbo.TM_task.ID, dbo.TM_task.member, dbo.TM_task.Project_id, dbo.TM_task.task_id, dbo.TM_task.frequency, dbo.TM_task.created_at, dbo.TM_task.Updated_at,
                      dbo.TM_task.status, dbo.TM_task.completion, dbo.TM_task.user_detail_id, dbo.TM_task.TL_task_id
FROM         dbo.TM_task LEFT OUTER JOIN
                      dbo.subtask ON dbo.TM_task.TL_task_id = dbo.subtask.TL_task_id
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'View_4', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "TM_task"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 114
               Right = 190
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "subtask"
            Begin Extent =
               Top = 6
               Left = 228
               Bottom = 114
               Right = 387
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_4'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'View_4', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_4'
GO
/****** Object:  View [dbo].[View_1]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[View_1]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[View_1]
AS
SELECT     SUM(frequency) AS frequency, Project_id, task_type_id
FROM         (SELECT     dbo.TL_task.frequency, dbo.project.Project_id, dbo.TL_task.task_type_id, dbo.project.title
                       FROM          dbo.project LEFT OUTER JOIN
                                              dbo.TL_task ON dbo.project.Project_id = dbo.TL_task.Project_id) AS m
GROUP BY Project_id, task_type_id
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'View_1', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[33] 4[14] 2[27] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "m"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 114
               Right = 205
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_1'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'View_1', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_1'
GO
/****** Object:  StoredProcedure [dbo].[insertTLtask]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[insertTLtask]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[insertTLtask]
(
@user_id int,
@project_id int,
@task_type_id int,
@frequency smallint,
@crdate datetime
)
AS
BEGIN
    insert into TL_task(user_id,Project_id,task_type_id,frequency,created_at)values(@user_id,@project_id,@task_type_id,@frequency,@crdate)
END
'
END
GO
/****** Object:  StoredProcedure [dbo].[createtask]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[createtask]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[createtask] 
(     
@Newtask varchar(50),
@crdate datetime     
)     
AS     
BEGIN     
     
IF EXISTS(SELECT * FROM commontask WHERE [Title] = @Newtask)     
BEGIN     
print 10     
END     
ELSE     
BEGIN     
INSERT into commontask([Title],created_at) VALUES(@Newtask,@crdate)     
END     
END '
END
GO
/****** Object:  StoredProcedure [dbo].[assignment]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[assignment]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'create proc [dbo].[assignment]
(
@project_id int,
@client_id int,
@role_id int,
@create_at datetime,
@updated_at datetime,
@status tinyint
)
as
begin
insert into assign_role values(@project_id,@client_id,@role_id,@create_at,@updated_at,@status)
end



'
END
GO
/****** Object:  StoredProcedure [dbo].[link]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[link]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE proc [dbo].[link]
(
@name varchar(100),
@password varchar(100),
@logo varchar(100),
@email nvarchar(100),
@description text,
@create_at datetime,
@update_at datetime,
@status tinyint
)
as
begin
if exists(select * from client where email=@email)
begin
print 1
end
else
insert into client values(@name,@password,@logo,@email,@description,@create_at,@update_at,@status)
end '
END
GO
/****** Object:  StoredProcedure [dbo].[client_project]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[client_project]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE proc [dbo].[client_project]
(
@client_id int,
@title varchar(100),
@create_at datetime,
@update_at datetime,
@description text,
@active tinyint
)
as
begin
insert into project values(@client_id,@title,@create_at,@update_at,@description,@active)
end'
END
GO
/****** Object:  StoredProcedure [dbo].[user_imf]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[user_imf]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE proc [dbo].[user_imf]
(
@name varchar(100),
@password varchar(100),
@mobile bigint,
@email nvarchar(100),
@role_id int,
@create_at datetime,
@update_at datetime,
@status tinyint
)
as
begin
if Exists(select * from user_detail where email=@email)
begin
print 1
end
else
insert into user_detail values(@name,@password,@mobile,@email,@role_id,@create_at,@update_at,@status)
end
'
END
GO
/****** Object:  View [dbo].[View_2]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[View_2]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[View_2]
AS
SELECT     dbo.View_1.frequency, dbo.project.title AS Projectname, dbo.View_1.Project_id AS Projectid, dbo.Commontask.Title AS task_type_title, dbo.View_1.task_type_id
FROM         dbo.View_1 INNER JOIN
                      dbo.project ON dbo.View_1.Project_id = dbo.project.Project_id INNER JOIN
                      dbo.Commontask ON dbo.View_1.task_type_id = dbo.Commontask.ID
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'View_2', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "View_1"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 99
               Right = 189
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "project"
            Begin Extent =
               Top = 6
               Left = 227
               Bottom = 114
               Right = 381
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Commontask"
            Begin Extent =
               Top = 6
               Left = 419
               Bottom = 114
               Right = 570
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_2'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'View_2', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_2'
GO
/****** Object:  View [dbo].[View_3]    Script Date: 06/19/2013 17:20:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[View_3]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[View_3]
AS
SELECT     dbo.View_1.frequency, dbo.project.title AS Projectname, dbo.View_1.Project_id AS Projectid, dbo.Commontask.Title AS task_type_title, dbo.View_1.task_type_id
FROM         dbo.View_1 INNER JOIN
                      dbo.project ON dbo.View_1.Project_id = dbo.project.Project_id INNER JOIN
                      dbo.Commontask ON dbo.View_1.task_type_id = dbo.Commontask.ID
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'View_3', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "View_1"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 99
               Right = 189
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "project"
            Begin Extent =
               Top = 6
               Left = 227
               Bottom = 114
               Right = 381
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Commontask"
            Begin Extent =
               Top = 6
               Left = 419
               Bottom = 114
               Right = 570
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_3'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'View_3', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_3'
GO