They were added to the new table in the new database after it was scripted. That's where I said I re-built the database manually two times, no scripting, but actually...

I used the auto generated one from SSMS

USE [DB_CW01_SiHu]

GO

/****** Object: Table [dbo].[shops] Script Date: 01/12/2012 13:00:19 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[shops](

[bizID] [int] IDENTITY(1,1) NOT...