Plings Input API - MS SQL

From Plings Info

Jump to: navigation, search

MS SQL Server create table instructions

Many people need to create a local data store for Plings data before they can send it to the Plings Input API. Rather than have lots of people recreating work for themselves we hope this is helpful.

Thanks to Mark Perry from Knowsley MBC for supplying this.

If you need MySQL create table code - see Plings Input API - MySQL

If you can improve on this then please contact us and let us know 

USE [PLINGS]
GO
/****** Object:  Table [dbo].[activity]    Script Date: 09/08/2009 15:32:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[activity](
        [ActivitySourceID] [int] IDENTITY(1,1) NOT NULL,
        [plingsactivityid] [int] NULL,
        [Name] [varchar](150) COLLATE Latin1_General_CI_AS NOT NULL,
        [Description] [text] COLLATE Latin1_General_CI_AS NULL,
        [Starts] [datetime] NOT NULL,
        [Ends] [datetime] NOT NULL,
        [ContactName] [varchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
        [ContactNumber] [varchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
        [ContactEmail] [varchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
        [ContactAddress] [varchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
        [MinAge] [tinyint] NULL,
        [MaxAge] [tinyint] NULL,
        [Cost] [decimal](10, 0) NULL,
        [Categories] [varchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
        [Keywords] [varchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
        [ECMCodes] [tinyint] NULL,
        [ActivityTypeCodes] [tinyint] NULL,
        [LinkWithActivity] [int] NULL,
        [LinkWithActivitySourceID] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
        [first_submitted] [datetime] NOT NULL,
        [updated_on] [datetime] NOT NULL,
        [venue_id] [int] NULL,
        [organisation_id] [int] NOT NULL,
        [user_id] [tinyint] NOT NULL,
 CONSTRAINT [PK_activity] PRIMARY KEY CLUSTERED ([ActivitySourceID] ASC) WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 
GO
SET ANSI_PADDING OFF
 
USE [PLINGS]
GO
/****** Object:  Table [dbo].[organisations]    Script Date: 09/08/2009 15:33:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[organisations](
        [DBProviderID] [int] IDENTITY(1,1) NOT NULL,
        [Name] [varchar](50) COLLATE Latin1_General_CI_AS NULL,
        [ProjectDepartment] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
        [BuildingNameNo] [varchar](70) COLLATE Latin1_General_CI_AS NULL,
        [Street] [varchar](70) COLLATE Latin1_General_CI_AS NULL,
        [Town] [varchar](70) COLLATE Latin1_General_CI_AS NULL,
        [PostTown] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
        [County] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
        [PostCode] [varchar](50) COLLATE Latin1_General_CI_AS NULL,
        [ContactForename] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
        [ContactSurname] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
        [ContactEmail] [varchar](150) COLLATE Latin1_General_CI_AS NULL,
        [ContactPhone] [varchar](20) COLLATE Latin1_General_CI_AS NULL,
        [ContactFax] [varchar](20) COLLATE Latin1_General_CI_AS NULL,
        [Description] [varchar](500) COLLATE Latin1_General_CI_AS NULL,
        [MinAge] [tinyint] NULL,
        [MaxAge] [tinyint] NULL,
        [Website] [varchar](250) COLLATE Latin1_General_CI_AS NULL,
        [created_at] [datetime] NOT NULL,
        [updated_on] [datetime] NOT NULL,
        [user_id] [int] NULL,
 CONSTRAINT [PK_organisations] PRIMARY KEY CLUSTERED ([DBProviderID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]
 
GO
SET ANSI_PADDING OFF
 
USE [PLINGS]
GO
/****** Object:  Table [dbo].[venues]    Script Date: 09/08/2009 15:33:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[venues](
        [ProviderVenueID] [int] IDENTITY(1,1) NOT NULL,
        [plingsplace_id] [int] NULL,
        [Name] [varchar](50) COLLATE Latin1_General_CI_AS NULL,
        [BuildingNameNo] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
        [Postcode] [varchar](50) COLLATE Latin1_General_CI_AS NULL,
        [ContactForename] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
        [ContactSurname] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
        [ContactNumber] [varchar](25) COLLATE Latin1_General_CI_AS NULL,
        [ContactEmail] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
        [ContactFax] [varchar](30) COLLATE Latin1_General_CI_AS NULL,
        [GeoCoordSystem] [varchar](50) COLLATE Latin1_General_CI_AS NULL,
        [GeoCoordX] [decimal](13, 10) NULL,
        [GeoCoordY] [decimal](13, 10) NULL,
        [Description] [varchar](500) COLLATE Latin1_General_CI_AS NULL,
        [Website] [varchar](250) COLLATE Latin1_General_CI_AS NULL,
        [ParkingSpaces] [int] NULL,
        [CyclePark] [varchar](50) COLLATE Latin1_General_CI_AS NULL,
        [DisabledFacilitiesNotes] [varchar](500) COLLATE Latin1_General_CI_AS NULL,
        [created_at] [datetime] NOT NULL,
        [updated_on] [datetime] NOT NULL,
        [user_id] [int] NULL,
 CONSTRAINT [PK_venues] PRIMARY KEY CLUSTERED ([ProviderVenueID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]
 
GO
SET ANSI_PADDING OFF
Retrieved from "http://plings.info/wiki/index.php/Plings_Input_API_-_MS_SQL"
Personal tools