Not sure if this is what Brett had in mind, but in SQL Server Management Studio Express, I selected the table, right-clicked and selected "Script Table as > CREATE to > New Query Editor Window", and then copied and pasted the results below:
USE [maineinns_staging]
GO
/****** Object: Table [dbo].[MaineInnMembers] Script Date: 08/25/2010 14:31:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MaineInnMembers](
[ID] [int] NOT NULL,
[PropertyName] [nvarchar](255) NULL,
[Designation] [nvarchar](255) NULL,
[Innkeeper] [nvarchar](255) NULL,
[Address] [nvarchar](255) NULL,
[City] [nvarchar](255) NULL,
[State] [nvarchar](255) NULL,
[Zip] [nvarchar](255) NULL,
[Phone1] [nvarchar](255) NULL,
[Phone2] [nvarchar](255) NULL,
[Fax] [nvarchar](255) NULL,
[Email] [nvarchar](255) NULL,
[Web] [nvarchar](255) NULL,
[Region] [nvarchar](255) NULL,
[Rooms] [int] NULL,
[Suites] [int] NULL,
[Cottages] [int] NULL,
[SingleRoom] [nvarchar](255) NULL,
[DoubleRoom] [nvarchar](255) NULL,
[Suite] [nvarchar](255) NULL,
[Cottage] [nvarchar](255) NULL,
[Alt_Locale1] [nvarchar](50) NULL,
[Alt_Locale2] [nvarchar](50) NULL,
[Description] [nvarchar](max) NULL,
[Enhanced_Description] [nvarchar](max) NULL,
[MeetingFacilities] [int] NULL,
[CreditCards] [nvarchar](255) NULL,
[Pets] [bit] NOT NULL,
[Restaurant] [bit] NOT NULL,
[WheelchairUnit] [bit] NOT NULL,
[TDD] [bit] NOT NULL,
[VisualSystem] [bit] NOT NULL,
[Openperiod] [nvarchar](255) NULL,
[IndoorPool] [bit] NOT NULL,
[OutdoorPool] [bit] NOT NULL,
[Childcare] [bit] NOT NULL,
[AirConditioning] [bit] NOT NULL,
[FitnessCenter] [bit] NOT NULL,
[Movies] [bit] NOT NULL,
[CableTV] [bit] NOT NULL,
[Lounge] [bit] NOT NULL,
[Dataports] [bit] NOT NULL,
[Transportation] [bit] NOT NULL,
[Whirlpool] [bit] NOT NULL,
[HotTub] [bit] NOT NULL,
[Kitchenettes] [bit] NOT NULL,
[AgencyCommission] [bit] NOT NULL,
[Fireplaces] [bit] NOT NULL,
[Laundry] [bit] NOT NULL,
[RoomService] [bit] NOT NULL,
[agriculturalfairs] [bit] NOT NULL,
[amusementparks] [bit] NOT NULL,
[antiquing] [bit] NOT NULL,
[bicycling] [bit] NOT NULL,
[birding] [bit] NOT NULL,
[boatcruises] [bit] NOT NULL,
[canoeing] [bit] NOT NULL,
[xcskiing] [bit] NOT NULL,
[fishing] [bit] NOT NULL,
[golfing] [bit] NOT NULL,
[hiking] [bit] NOT NULL,
[hunting] [bit] NOT NULL,
[islands] [bit] NOT NULL,
[kayaking] [bit] NOT NULL,
[lighthouses] [bit] NOT NULL,
[musmshistsites] [bit] NOT NULL,
[music] [bit] NOT NULL,
[scenicbyways] [bit] NOT NULL,
[shopping] [bit] NOT NULL,
[snowmobiling] [bit] NOT NULL,
[statenatlpark] [bit] NOT NULL,
[summeryouthcamp] [bit] NOT NULL,
[whalewatching] [bit] NOT NULL,
[whtwtrrafting] [bit] NOT NULL,
[windjammer] [bit] NOT NULL,
[airport] [bit] NOT NULL,
[highspeed] [bit] NOT NULL,
[wifi] [bit] NOT NULL,
[spaonsite] [bit] NOT NULL,
[spanearby] [bit] NOT NULL,
[WorldResID] [nvarchar](50) NULL,
[EnhancedListing] [bit] NOT NULL,
[Image1] [nvarchar](50) NULL,
[Image2] [nvarchar](50) NULL,
[InnLinkID] [nvarchar](50) NULL,
[InnLinkURL] [nvarchar](50) NULL,
[beachnearby] [bit] NOT NULL,
[lakenearby] [bit] NOT NULL,
[marinanearby] [bit] NOT NULL,
[oceannearby] [bit] NOT NULL,
[tenniscourtsnearby] [bit] NOT NULL,
[beachclose] [bit] NOT NULL,
[lakeclose] [bit] NOT NULL,
[marinaclose] [bit] NOT NULL,
[oceanclose] [bit] NOT NULL,
[tenniscourtsclose] [bit] NOT NULL
) ON [PRIMARY]
As you can see, this really doesn't seem like the most sensible way to handle the data. Any advice appreciated.
schema question
Posted - 08/02/2010 : 14:57:57
