[Help] Pet Database Error Ep7v1

[EMOLISTA]

DB:SELECT PetName, PetChaNum, PetType, PetMID, PetSID, PetCardMID, PetCardSID, PetStyle, PetColor, PetFull, PetSkinMID, PetSkinSID, PetSkinScale, PetSkinTime, PetSkinStartDate FROM PetInfo WHERE PetNum=33598 And PetChaNum=62436
DB:42S22, NativeError:207, [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'PetSkinMID'.


How to fix this? Thanks in advance....

[MentaL]

[shakol]

SS ..?

[xXx`Jhopz`xXx]

DB:SELECT PetName, PetChaNum, PetType, PetMID, PetSID, PetCardMID, PetCardSID, PetStyle, PetColor, PetFull, PetSkinMID, PetSkinSID, PetSkinScale, PetSkinTime, PetSkinStartDate FROM PetInfo WHERE PetNum=33598 And PetChaNum=62436
DB:42S22, NativeError:207, [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'PetSkinMID'.


How to fix this? Thanks in advance....

hmmmm freelance dev why you not fixed your problem lols

[starstrokers]

hmmmm freelance dev why you not fixed your problem lols

even if your a freelance dev or whatever your rank here in rz, it does not means your a perfect developer. that`s the reason why rz is built. but anyway, i suggest to search or try other database.

[IamDJDRB]

Too many non-sense posts :)) Nyahahah .

hmmmm freelance dev why you not fixed your problem lols

If u want to help him :) Post a SENSE MESSAGES not giving a Feedback to the Thread Starter Tssssssss
"Tagalog - Para mas maintindihan mo :) Kung gusto mo makatulong, Tumulong ka nlang ayon sa nalalaman mo ! Walang taong Perfect sa mundo bkt ikaw ? Perfect ka ba ?
Kaya nga nag POST sa Help Section para tulungan natin ! Hindi para Batukusin !
Di porket natuto ka lang gumawa ng Server manlalait ka na ng ibang Tao"
Ive agreed of what starstrokers said - That's why RaGEZONE Built !

DB:SELECT PetName, PetChaNum, PetType, PetMID, PetSID, PetCardMID, PetCardSID, PetStyle, PetColor, PetFull, PetSkinMID, PetSkinSID, PetSkinScale, PetSkinTime, PetSkinStartDate FROM PetInfo WHERE PetNum=33598 And PetChaNum=62436
DB:42S22, NativeError:207, [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'PetSkinMID'.


How to fix this? Thanks in advance....

BTW Here :)) I think this can solved your Problem !

Spoiler:

USE [RanGame1]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetNum]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetNum]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetName]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetName]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetChaNum]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetChaNum]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetType]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetType]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetMID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetMID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetStyle]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetStyle]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetColor]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetColor]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetFull]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetFull]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetDeleted]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetDeleted]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetCreateDate]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetCreateDate]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetDeletedDate]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetDeletedDate]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetPutOnItems]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetPutOnItems]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetCardMID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetCardMID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetCardSID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetCardSID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinStartDate]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinStartDate]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinTime]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinTime]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinScale]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinScale]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinSID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinSID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinMID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinMID]
END

GO

USE [RanGame1]
GO

/****** Object: Table [dbo].[PetInfo] Script Date: 08/08/2011 11:50:21 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PetInfo]') AND type in (N'U'))
DROP TABLE [dbo].[PetInfo]
GO

USE [RanGame1]
GO

/****** Object: Table [dbo].[PetInfo] Script Date: 08/08/2011 11:50:21 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[PetInfo](
[PetNum] [int] NOT NULL,
[PetName] [varchar](20) NOT NULL,
[PetChaNum] [int] NOT NULL,
[PetType] [int] NOT NULL,
[PetMID] [int] NOT NULL,
[PetSID] [int] NOT NULL,
[PetStyle] [int] NOT NULL,
[PetColor] [int] NOT NULL,
[PetFull] [int] NOT NULL,
[PetDeleted] [int] NOT NULL,
[PetCreateDate] [datetime] NOT NULL,
[PetDeletedDate] [datetime] NOT NULL,
[PetPutOnItems] [image] NOT NULL,
[PetCardMID] [int] NOT NULL,
[PetCardSID] [int] NOT NULL,
[PetUniqueNum] [int] IDENTITY(1,1) NOT NULL,
[PetSkinStartDate] [datetime] NULL,
[PetSkinTime] [datetime] NULL,
[PetSkinScale] [int] NULL,
[PetSkinSID] [int] NULL,
[PetSkinMID] [int] NULL,
CONSTRAINT [PK_PetInfo] PRIMARY KEY CLUSTERED 
(
[PetUniqueNum] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [SECONDARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetNum] DEFAULT ((0)) FOR [PetNum]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetName] DEFAULT ('') FOR [PetName]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetChaNum] DEFAULT ((0)) FOR [PetChaNum]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetType] DEFAULT ((0)) FOR [PetType]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetMID] DEFAULT ((0)) FOR [PetMID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSID] DEFAULT ((0)) FOR [PetSID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetStyle] DEFAULT ((0)) FOR [PetStyle]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetColor] DEFAULT ((0)) FOR [PetColor]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetFull] DEFAULT ((1000)) FOR [PetFull]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetDeleted] DEFAULT ((0)) FOR [PetDeleted]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetCreateDate] DEFAULT (getdate()) FOR [PetCreateDate]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetDeletedDate] DEFAULT (getdate()) FOR [PetDeletedDate]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetPutOnItems] DEFAULT ('') FOR [PetPutOnItems]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetCardMID] DEFAULT ((0)) FOR [PetCardMID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetCardSID] DEFAULT ((0)) FOR [PetCardSID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinStartDate] DEFAULT (getdate()) FOR [PetSkinStartDate]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinTime] DEFAULT (getdate()) FOR [PetSkinTime]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinScale] DEFAULT ((0)) FOR [PetSkinScale]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinSID] DEFAULT ((0)) FOR [PetSkinSID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinMID] DEFAULT ((0)) FOR [PetSkinMID]
GO 

[EMOLISTA]

Thanks a lot essaeypride (buti ka pa may naitulong hindi tulad ng iba dyan puro comment lang....hayzzzz). Like it!

[xXx`Jhopz`xXx]

his telling me a perfect one on my FB or my YM -_-

Tagalog(nanghinge kasi ako ng advice sa kanya about ep6s2 kaso iba itinuro nya kulelat na daw ako bakit di nalang daw ako mag ep7 wala na daw kc nag eep6s2 ngayun lahat daw ep7 tama ba ung sagot nya )

Too many non-sense posts :)) Nyahahah .



If u want to help him :) Post a SENSE MESSAGES not giving a Feedback to the Thread Starter Tssssssss
"Tagalog - Para mas maintindihan mo :) Kung gusto mo makatulong, Tumulong ka nlang ayon sa nalalaman mo ! Walang taong Perfect sa mundo bkt ikaw ? Perfect ka ba ?
Kaya nga nag POST sa Help Section para tulungan natin ! Hindi para Batukusin !
Di porket natuto ka lang gumawa ng Server manlalait ka na ng ibang Tao"
Ive agreed of what starstrokers said - That's why RaGEZONE Built !





BTW Here :)) I think this can solved your Problem !

Spoiler:

USE [RanGame1]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetNum]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetNum]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetName]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetName]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetChaNum]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetChaNum]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetType]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetType]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetMID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetMID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetStyle]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetStyle]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetColor]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetColor]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetFull]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetFull]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetDeleted]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetDeleted]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetCreateDate]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetCreateDate]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetDeletedDate]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetDeletedDate]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetPutOnItems]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetPutOnItems]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetCardMID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetCardMID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetCardSID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetCardSID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinStartDate]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinStartDate]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinTime]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinTime]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinScale]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinScale]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinSID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinSID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinMID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinMID]
END

GO

USE [RanGame1]
GO

/****** Object: Table [dbo].[PetInfo] Script Date: 08/08/2011 11:50:21 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PetInfo]') AND type in (N'U'))
DROP TABLE [dbo].[PetInfo]
GO

USE [RanGame1]
GO

/****** Object: Table [dbo].[PetInfo] Script Date: 08/08/2011 11:50:21 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[PetInfo](
[PetNum] [int] NOT NULL,
[PetName] [varchar](20) NOT NULL,
[PetChaNum] [int] NOT NULL,
[PetType] [int] NOT NULL,
[PetMID] [int] NOT NULL,
[PetSID] [int] NOT NULL,
[PetStyle] [int] NOT NULL,
[PetColor] [int] NOT NULL,
[PetFull] [int] NOT NULL,
[PetDeleted] [int] NOT NULL,
[PetCreateDate] [datetime] NOT NULL,
[PetDeletedDate] [datetime] NOT NULL,
[PetPutOnItems] [image] NOT NULL,
[PetCardMID] [int] NOT NULL,
[PetCardSID] [int] NOT NULL,
[PetUniqueNum] [int] IDENTITY(1,1) NOT NULL,
[PetSkinStartDate] [datetime] NULL,
[PetSkinTime] [datetime] NULL,
[PetSkinScale] [int] NULL,
[PetSkinSID] [int] NULL,
[PetSkinMID] [int] NULL,
CONSTRAINT [PK_PetInfo] PRIMARY KEY CLUSTERED 
(
[PetUniqueNum] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [SECONDARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetNum] DEFAULT ((0)) FOR [PetNum]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetName] DEFAULT ('') FOR [PetName]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetChaNum] DEFAULT ((0)) FOR [PetChaNum]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetType] DEFAULT ((0)) FOR [PetType]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetMID] DEFAULT ((0)) FOR [PetMID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSID] DEFAULT ((0)) FOR [PetSID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetStyle] DEFAULT ((0)) FOR [PetStyle]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetColor] DEFAULT ((0)) FOR [PetColor]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetFull] DEFAULT ((1000)) FOR [PetFull]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetDeleted] DEFAULT ((0)) FOR [PetDeleted]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetCreateDate] DEFAULT (getdate()) FOR [PetCreateDate]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetDeletedDate] DEFAULT (getdate()) FOR [PetDeletedDate]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetPutOnItems] DEFAULT ('') FOR [PetPutOnItems]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetCardMID] DEFAULT ((0)) FOR [PetCardMID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetCardSID] DEFAULT ((0)) FOR [PetCardSID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinStartDate] DEFAULT (getdate()) FOR [PetSkinStartDate]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinTime] DEFAULT (getdate()) FOR [PetSkinTime]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinScale] DEFAULT ((0)) FOR [PetSkinScale]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinSID] DEFAULT ((0)) FOR [PetSkinSID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinMID] DEFAULT ((0)) FOR [PetSkinMID]
GO 

ok hehehe ..

tagalog( kung alam mo lang dahil mag kalugar kame nyan nanghinge ako sa knya ng advice pero di nya ako sinagot ng tama tsk tsk.. at di po ako nag mamagaling xsa ata un ...)