-- OPRET NY TABEL [KL_monitorering]: USE [LOISStatistik2] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[KL_monitorering]( [KL_ID] [int] IDENTITY(1,1) NOT NULL, [KL_dimTid] [int] NULL, [KL_analyse] [nvarchar](50) NULL, [KL_analyseNavn] [nvarchar](50) NULL, [KL_Niveau] [nvarchar](50) NULL, [KL_NiveauNavn] [nvarchar](50) NULL, [ID] [nvarchar](50) NULL, [KL_gruppe] [nvarchar](50) NULL, [antal] [int] NULL, [ikkeVestlige] [int] NULL, [pct] [decimal](10, 2) NULL, [pct_ikkeVestlige] [decimal](10, 2) NULL, [indexOmr] [decimal](10, 2) NULL, [indexKomm] [decimal](10, 2) NULL, [ghetto_niveau] [decimal](10, 2) NULL, [lat] [decimal](10, 6) NULL, [long] [decimal](10, 6) NULL, [size] [int] NULL, [image_URL] [nchar](250) NULL, [text] [nchar](250) NULL, [Map_ID] [nvarchar](60) NULL, CONSTRAINT [PK_KL_monitorering] PRIMARY KEY CLUSTERED ( [KL_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO