Skip to content

Instantly share code, notes, and snippets.

@JimiC

JimiC/EVEStaticData_Schema_Script

Created July 19, 2015 17:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save JimiC/648318fd105ca73a5423 to your computer and use it in GitHub Desktop.
Save JimiC/648318fd105ca73a5423 to your computer and use it in GitHub Desktop.
Download ZIP
EVE Static Data Schema (Re-imported)
Raw
EVEStaticData_Schema_Script
USE [master]
GO
/****** Object: Database [EveStaticData] Script Date: 15/07/2015 15:10:59 ******/
CREATE DATABASE [EveStaticData]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'ebs_DATADUMP', FILENAME = N'E:\SQL Server 2012\Data\ebs_DATADUMP.mdf' , SIZE = 349184KB , MAXSIZE = UNLIMITED, FILEGROWTH = 51200KB )
LOG ON
( NAME = N'ebs_DATADUMP_log', FILENAME = N'E:\SQL Server 2012\Data\ebs_DATADUMP_log.ldf' , SIZE = 208896KB , MAXSIZE = 2048GB , FILEGROWTH = 51200KB )
GO
ALTER DATABASE [EveStaticData] SET COMPATIBILITY_LEVEL = 110
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [EveStaticData].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [EveStaticData] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [EveStaticData] SET ANSI_NULLS OFF
GO
ALTER DATABASE [EveStaticData] SET ANSI_PADDING OFF
GO
ALTER DATABASE [EveStaticData] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [EveStaticData] SET ARITHABORT OFF
GO
ALTER DATABASE [EveStaticData] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [EveStaticData] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [EveStaticData] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [EveStaticData] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [EveStaticData] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [EveStaticData] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [EveStaticData] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [EveStaticData] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [EveStaticData] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [EveStaticData] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [EveStaticData] SET DISABLE_BROKER
GO
ALTER DATABASE [EveStaticData] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [EveStaticData] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [EveStaticData] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [EveStaticData] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [EveStaticData] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [EveStaticData] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [EveStaticData] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [EveStaticData] SET RECOVERY SIMPLE
GO
ALTER DATABASE [EveStaticData] SET MULTI_USER
GO
ALTER DATABASE [EveStaticData] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [EveStaticData] SET DB_CHAINING OFF
GO
ALTER DATABASE [EveStaticData] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
GO
ALTER DATABASE [EveStaticData] SET TARGET_RECOVERY_TIME = 0 SECONDS
GO
EXEC sys.sp_db_vardecimal_storage_format N'EveStaticData', N'ON'
GO
USE [EveStaticData]
GO
/****** Object: Table [dbo].[agtAgentTypes] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[agtAgentTypes](
[agentTypeID] [int] NOT NULL,
[agentType] [varchar](50) NULL,
CONSTRAINT [agtAgentTypes_PK] PRIMARY KEY CLUSTERED
(
[agentTypeID] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[agtAgents] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[agtAgents](
[agentID] [int] NOT NULL,
[divisionID] [tinyint] NULL,
[corporationID] [int] NULL,
[locationID] [int] NULL,
[level] [tinyint] NULL,
[quality] [smallint] NULL,
[agentTypeID] [int] NULL,
[isLocator] [bit] NULL,
CONSTRAINT [agtAgents_PK] PRIMARY KEY CLUSTERED
(
[agentID] 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
/****** Object: Table [dbo].[agtResearchAgents] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[agtResearchAgents](
[agentID] [int] NOT NULL,
[typeID] [int] NOT NULL,
CONSTRAINT [agtResearchAgents_PK] PRIMARY KEY CLUSTERED
(
[agentID] ASC,
[typeID] 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
/****** Object: Table [dbo].[chrAncestries] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[chrAncestries](
[ancestryID] [tinyint] NOT NULL,
[ancestryName] [nvarchar](100) NULL,
[bloodlineID] [tinyint] NULL,
[description] [nvarchar](1000) NULL,
[perception] [tinyint] NULL,
[willpower] [tinyint] NULL,
[charisma] [tinyint] NULL,
[memory] [tinyint] NULL,
[intelligence] [tinyint] NULL,
[iconID] [int] NULL,
[shortDescription] [nvarchar](500) NULL,
CONSTRAINT [chrAncestries_PK] PRIMARY KEY CLUSTERED
(
[ancestryID] 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
/****** Object: Table [dbo].[chrAttributes] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[chrAttributes](
[attributeID] [tinyint] NOT NULL,
[attributeName] [varchar](100) NULL,
[description] [varchar](1000) NULL,
[iconID] [int] NULL,
[shortDescription] [nvarchar](500) NULL,
[notes] [nvarchar](500) NULL,
CONSTRAINT [chrAttributes_PK] PRIMARY KEY CLUSTERED
(
[attributeID] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[chrBloodlines] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[chrBloodlines](
[bloodlineID] [tinyint] NOT NULL,
[bloodlineName] [nvarchar](100) NULL,
[raceID] [tinyint] NULL,
[description] [nvarchar](1000) NULL,
[maleDescription] [nvarchar](1000) NULL,
[femaleDescription] [nvarchar](1000) NULL,
[shipTypeID] [int] NULL,
[corporationID] [int] NULL,
[perception] [tinyint] NULL,
[willpower] [tinyint] NULL,
[charisma] [tinyint] NULL,
[memory] [tinyint] NULL,
[intelligence] [tinyint] NULL,
[iconID] [int] NULL,
[shortDescription] [nvarchar](500) NULL,
[shortMaleDescription] [nvarchar](500) NULL,
[shortFemaleDescription] [nvarchar](500) NULL,
CONSTRAINT [chrBloodlines_PK] PRIMARY KEY CLUSTERED
(
[bloodlineID] 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
/****** Object: Table [dbo].[chrFactions] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[chrFactions](
[factionID] [int] NOT NULL,
[factionName] [varchar](100) NULL,
[description] [varchar](1000) NULL,
[raceIDs] [int] NULL,
[solarSystemID] [int] NULL,
[corporationID] [int] NULL,
[sizeFactor] [float] NULL,
[stationCount] [smallint] NULL,
[stationSystemCount] [smallint] NULL,
[militiaCorporationID] [int] NULL,
[iconID] [int] NULL,
CONSTRAINT [chrFactions_PK] PRIMARY KEY CLUSTERED
(
[factionID] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[chrRaces] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[chrRaces](
[raceID] [tinyint] NOT NULL,
[raceName] [varchar](100) NULL,
[description] [varchar](1000) NULL,
[iconID] [int] NULL,
[shortDescription] [varchar](500) NULL,
CONSTRAINT [chrRaces_PK] PRIMARY KEY CLUSTERED
(
[raceID] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[crpActivities] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[crpActivities](
[activityID] [tinyint] NOT NULL,
[activityName] [nvarchar](100) NULL,
[description] [nvarchar](1000) NULL,
CONSTRAINT [crpActivities_PK] PRIMARY KEY CLUSTERED
(
[activityID] 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
/****** Object: Table [dbo].[crpNPCCorporationDivisions] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[crpNPCCorporationDivisions](
[corporationID] [int] NOT NULL,
[divisionID] [tinyint] NOT NULL,
[size] [tinyint] NULL,
CONSTRAINT [crpNPCCorporationDivisions_PK] PRIMARY KEY CLUSTERED
(
[corporationID] ASC,
[divisionID] 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
/****** Object: Table [dbo].[crpNPCCorporationResearchFields] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[crpNPCCorporationResearchFields](
[skillID] [int] NOT NULL,
[corporationID] [int] NOT NULL,
CONSTRAINT [crpNPCCorporationResearchFields_PK] PRIMARY KEY CLUSTERED
(
[skillID] ASC,
[corporationID] 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
/****** Object: Table [dbo].[crpNPCCorporationTrades] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[crpNPCCorporationTrades](
[corporationID] [int] NOT NULL,
[typeID] [int] NOT NULL,
CONSTRAINT [crpNPCCorporationTrades_PK] PRIMARY KEY CLUSTERED
(
[corporationID] ASC,
[typeID] 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
/****** Object: Table [dbo].[crpNPCCorporations] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[crpNPCCorporations](
[corporationID] [int] NOT NULL,
[size] [char](1) NULL,
[extent] [char](1) NULL,
[solarSystemID] [int] NULL,
[investorID1] [int] NULL,
[investorShares1] [tinyint] NULL,
[investorID2] [int] NULL,
[investorShares2] [tinyint] NULL,
[investorID3] [int] NULL,
[investorShares3] [tinyint] NULL,
[investorID4] [int] NULL,
[investorShares4] [tinyint] NULL,
[friendID] [int] NULL,
[enemyID] [int] NULL,
[publicShares] [bigint] NULL,
[initialPrice] [int] NULL,
[minSecurity] [float] NULL,
[scattered] [bit] NULL,
[fringe] [tinyint] NULL,
[corridor] [tinyint] NULL,
[hub] [tinyint] NULL,
[border] [tinyint] NULL,
[factionID] [int] NULL,
[sizeFactor] [float] NULL,
[stationCount] [smallint] NULL,
[stationSystemCount] [smallint] NULL,
[description] [nvarchar](4000) NULL,
[iconID] [int] NULL,
CONSTRAINT [crpNPCCorporations_PK] PRIMARY KEY CLUSTERED
(
[corporationID] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[crpNPCDivisions] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[crpNPCDivisions](
[divisionID] [tinyint] NOT NULL,
[divisionName] [nvarchar](100) NULL,
[description] [nvarchar](1000) NULL,
[leaderType] [nvarchar](100) NULL,
CONSTRAINT [crpNPCDivisions_PK] PRIMARY KEY CLUSTERED
(
[divisionID] 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
/****** Object: Table [dbo].[crtCertificates] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[crtCertificates](
[certificateID] [int] NOT NULL,
[groupID] [smallint] NULL,
[classID] [int] NULL,
[grade] [tinyint] NULL,
[corpID] [int] NULL,
[iconID] [int] NULL,
[description] [nvarchar](500) NULL,
CONSTRAINT [crtCertificates_PK] PRIMARY KEY CLUSTERED
(
[certificateID] 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
/****** Object: Table [dbo].[crtClasses] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[crtClasses](
[classID] [int] NOT NULL,
[description] [nvarchar](500) NULL,
[className] [nvarchar](256) NULL,
CONSTRAINT [crtClasses_PK] PRIMARY KEY CLUSTERED
(
[classID] 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
/****** Object: Table [dbo].[crtRecommendations] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[crtRecommendations](
[recommendationID] [int] IDENTITY(1,1) NOT NULL,
[shipTypeID] [int] NULL,
[certificateID] [int] NULL,
[recommendationLevel] [tinyint] NOT NULL DEFAULT ((0)),
CONSTRAINT [crtRecommendations_PK] PRIMARY KEY CLUSTERED
(
[recommendationID] 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
/****** Object: Table [dbo].[crtRelationships] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[crtRelationships](
[relationshipID] [int] IDENTITY(1,1) NOT NULL,
[parentID] [int] NULL,
[parentTypeID] [int] NULL,
[parentLevel] [tinyint] NULL,
[childID] [int] NULL,
[grade] [tinyint] NULL,
CONSTRAINT [crtRelationships_relationship] PRIMARY KEY CLUSTERED
(
[relationshipID] 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
/****** Object: Table [dbo].[dgmAttributeCategories] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dgmAttributeCategories](
[categoryID] [tinyint] NOT NULL,
[categoryName] [nvarchar](50) NULL,
[categoryDescription] [nvarchar](200) NULL,
CONSTRAINT [dgmAttributeCategories_PK] PRIMARY KEY CLUSTERED
(
[categoryID] 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
/****** Object: Table [dbo].[dgmAttributeTypes] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dgmAttributeTypes](
[attributeID] [smallint] NOT NULL,
[attributeName] [varchar](100) NULL,
[description] [varchar](1000) NULL,
[iconID] [int] NULL,
[defaultValue] [float] NULL,
[published] [bit] NULL,
[displayName] [varchar](100) NULL,
[unitID] [tinyint] NULL,
[stackable] [bit] NULL,
[highIsGood] [bit] NULL,
[categoryID] [tinyint] NULL,
CONSTRAINT [dgmAttributeTypes_PK] PRIMARY KEY CLUSTERED
(
[attributeID] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[dgmEffects] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dgmEffects](
[effectID] [smallint] NOT NULL,
[effectName] [varchar](400) NULL,
[effectCategory] [smallint] NULL,
[preExpression] [int] NULL,
[postExpression] [int] NULL,
[description] [varchar](1000) NULL,
[guid] [varchar](60) NULL,
[iconID] [int] NULL,
[isOffensive] [bit] NULL,
[isAssistance] [bit] NULL,
[durationAttributeID] [smallint] NULL,
[trackingSpeedAttributeID] [smallint] NULL,
[dischargeAttributeID] [smallint] NULL,
[rangeAttributeID] [smallint] NULL,
[falloffAttributeID] [smallint] NULL,
[disallowAutoRepeat] [bit] NULL,
[published] [bit] NULL,
[displayName] [varchar](100) NULL,
[isWarpSafe] [bit] NULL,
[rangeChance] [bit] NULL,
[electronicChance] [bit] NULL,
[propulsionChance] [bit] NULL,
[distribution] [tinyint] NULL,
[sfxName] [varchar](20) NULL,
[npcUsageChanceAttributeID] [smallint] NULL,
[npcActivationChanceAttributeID] [smallint] NULL,
[fittingUsageChanceAttributeID] [smallint] NULL,
[modifierInfo] [varchar](max) NULL,
CONSTRAINT [dgmEffects_PK] PRIMARY KEY CLUSTERED
(
[effectID] 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 [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[dgmExpressions] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dgmExpressions](
[expressionID] [int] NOT NULL,
[operandID] [int] NULL,
[arg1] [int] NULL,
[arg2] [int] NULL,
[expressionValue] [varchar](100) NULL,
[description] [varchar](1000) NULL,
[expressionName] [varchar](500) NULL,
[expressionTypeID] [int] NULL,
[expressionGroupID] [smallint] NULL,
[expressionAttributeID] [smallint] NULL,
CONSTRAINT [dgmExpressions_PK] PRIMARY KEY CLUSTERED
(
[expressionID] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[dgmMasteries] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dgmMasteries](
[masteryID] [int] NOT NULL,
[certificateID] [int] NOT NULL,
[grade] [tinyint] NOT NULL,
CONSTRAINT [dgmMasteries_PK] PRIMARY KEY CLUSTERED
(
[masteryID] 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
/****** Object: Table [dbo].[dgmTraits] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dgmTraits](
[traitID] [int] NOT NULL,
[bonusText] [nvarchar](500) NOT NULL,
[unitID] [tinyint] NULL,
CONSTRAINT [dgmTraits_PK] PRIMARY KEY CLUSTERED
(
[traitID] 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
/****** Object: Table [dbo].[dgmTypeAttributes] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dgmTypeAttributes](
[typeID] [int] NOT NULL,
[attributeID] [smallint] NOT NULL,
[valueInt] [int] NULL,
[valueFloat] [float] NULL,
CONSTRAINT [dgmTypeAttributes_PK] PRIMARY KEY CLUSTERED
(
[typeID] ASC,
[attributeID] 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
/****** Object: Table [dbo].[dgmTypeEffects] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dgmTypeEffects](
[typeID] [int] NOT NULL,
[effectID] [smallint] NOT NULL,
[isDefault] [bit] NULL,
CONSTRAINT [dgmTypeEffects_PK] PRIMARY KEY CLUSTERED
(
[typeID] ASC,
[effectID] 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
/****** Object: Table [dbo].[dgmTypeMasteries] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dgmTypeMasteries](
[typeID] [int] NOT NULL,
[masteryID] [smallint] NOT NULL,
CONSTRAINT [dgmTypeMasteries_PK] PRIMARY KEY CLUSTERED
(
[typeID] ASC,
[masteryID] 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
/****** Object: Table [dbo].[dgmTypeTraits] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dgmTypeTraits](
[typeID] [int] NOT NULL,
[parentTypeID] [int] NOT NULL,
[traitID] [int] NOT NULL,
[bonus] [float] NULL,
CONSTRAINT [dgmTypeTraits_PK] PRIMARY KEY CLUSTERED
(
[typeID] ASC,
[parentTypeID] ASC,
[traitID] 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
/****** Object: Table [dbo].[eveGraphics] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[eveGraphics](
[graphicID] [int] NOT NULL,
[graphicFile] [varchar](500) NOT NULL DEFAULT (''),
[description] [nvarchar](max) NOT NULL DEFAULT (''),
[obsolete] [bit] NOT NULL DEFAULT ((0)),
[graphicType] [varchar](100) NULL,
[collidable] [bit] NULL,
[directoryID] [int] NULL,
[graphicName] [nvarchar](64) NOT NULL DEFAULT (''),
[gfxRaceID] [varchar](255) NULL,
[colorScheme] [varchar](255) NULL,
[sofHullName] [varchar](64) NULL,
CONSTRAINT [eveGraphics_PK] PRIMARY KEY CLUSTERED
(
[graphicID] 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 [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[eveIcons] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[eveIcons](
[iconID] [int] NOT NULL,
[iconFile] [varchar](500) NOT NULL DEFAULT (''),
[description] [nvarchar](max) NOT NULL DEFAULT (''),
CONSTRAINT [eveIcons_PK] PRIMARY KEY CLUSTERED
(
[iconID] 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 [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[eveUnits] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[eveUnits](
[unitID] [tinyint] NOT NULL,
[unitName] [varchar](100) NULL,
[displayName] [varchar](50) NULL,
[description] [varchar](1000) NULL,
CONSTRAINT [eveUnits_PK] PRIMARY KEY CLUSTERED
(
[unitID] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[invBlueprintTypes] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[invBlueprintTypes](
[blueprintTypeID] [int] NOT NULL,
[parentBlueprintTypeID] [int] NULL,
[productTypeID] [int] NULL,
[productionTime] [int] NULL,
[techLevel] [smallint] NULL,
[researchProductivityTime] [int] NULL,
[researchMaterialTime] [int] NULL,
[researchCopyTime] [int] NULL,
[researchTechTime] [int] NULL,
[duplicatingTime] [int] NULL,
[reverseEngineeringTime] [int] NULL,
[inventionTime] [int] NULL,
[productivityModifier] [int] NULL,
[materialModifier] [smallint] NULL,
[wasteFactor] [smallint] NULL,
[maxProductionLimit] [int] NULL,
CONSTRAINT [invBlueprintTypes_PK] PRIMARY KEY CLUSTERED
(
[blueprintTypeID] 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
/****** Object: Table [dbo].[invCategories] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[invCategories](
[categoryID] [int] NOT NULL,
[categoryName] [nvarchar](100) NULL,
[description] [nvarchar](3000) NULL,
[iconID] [int] NULL,
[published] [bit] NULL,
CONSTRAINT [invCategories_PK] PRIMARY KEY CLUSTERED
(
[categoryID] 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
/****** Object: Table [dbo].[invContrabandTypes] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[invContrabandTypes](
[factionID] [int] NOT NULL,
[typeID] [int] NOT NULL,
[standingLoss] [float] NULL,
[confiscateMinSec] [float] NULL,
[fineByValue] [float] NULL,
[attackMinSec] [float] NULL,
CONSTRAINT [invContrabandTypes_PK] PRIMARY KEY CLUSTERED
(
[factionID] ASC,
[typeID] 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
/****** Object: Table [dbo].[invControlTowerResourcePurposes] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[invControlTowerResourcePurposes](
[purpose] [tinyint] NOT NULL,
[purposeText] [varchar](100) NULL,
CONSTRAINT [invControlTowerResourcePurposes_PK] PRIMARY KEY CLUSTERED
(
[purpose] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[invControlTowerResources] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[invControlTowerResources](
[controlTowerTypeID] [int] NOT NULL,
[resourceTypeID] [int] NOT NULL,
[purpose] [tinyint] NULL,
[quantity] [int] NULL,
[minSecurityLevel] [float] NULL,
[factionID] [int] NULL,
CONSTRAINT [invControlTowerResources_PK] PRIMARY KEY CLUSTERED
(
[controlTowerTypeID] ASC,
[resourceTypeID] 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
/****** Object: Table [dbo].[invFlags] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[invFlags](
[flagID] [smallint] NOT NULL,
[flagName] [varchar](200) NULL,
[flagText] [varchar](100) NULL,
[orderID] [int] NULL,
CONSTRAINT [invFlags_PK] PRIMARY KEY CLUSTERED
(
[flagID] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[invGroups] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[invGroups](
[groupID] [int] NOT NULL,
[categoryID] [int] NULL,
[groupName] [nvarchar](100) NULL,
[description] [nvarchar](3000) NULL,
[iconID] [int] NULL,
[useBasePrice] [bit] NULL,
[allowManufacture] [bit] NULL,
[allowRecycler] [bit] NULL,
[anchored] [bit] NULL,
[anchorable] [bit] NULL,
[fittableNonSingleton] [bit] NULL,
[published] [bit] NULL,
CONSTRAINT [invGroups_PK] PRIMARY KEY CLUSTERED
(
[groupID] 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
/****** Object: Table [dbo].[invItems] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[invItems](
[itemID] [bigint] NOT NULL,
[typeID] [int] NOT NULL,
[ownerID] [int] NOT NULL,
[locationID] [bigint] NOT NULL,
[flagID] [smallint] NOT NULL,
[quantity] [int] NOT NULL,
CONSTRAINT [invItems_PK] PRIMARY KEY CLUSTERED
(
[itemID] 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
/****** Object: Table [dbo].[invMarketGroups] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[invMarketGroups](
[marketGroupID] [int] NOT NULL,
[parentGroupID] [int] NULL,
[marketGroupName] [nvarchar](100) NULL,
[description] [nvarchar](3000) NULL,
[iconID] [int] NULL,
[hasTypes] [bit] NULL,
CONSTRAINT [invMarketGroups_PK] PRIMARY KEY CLUSTERED
(
[marketGroupID] 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
/****** Object: Table [dbo].[invMetaGroups] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[invMetaGroups](
[metaGroupID] [smallint] NOT NULL,
[metaGroupName] [nvarchar](100) NULL,
[description] [nvarchar](1000) NULL,
[iconID] [int] NULL,
CONSTRAINT [invMetaGroups_PK] PRIMARY KEY CLUSTERED
(
[metaGroupID] 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
/****** Object: Table [dbo].[invMetaTypes] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[invMetaTypes](
[typeID] [int] NOT NULL,
[parentTypeID] [int] NULL,
[metaGroupID] [smallint] NULL,
CONSTRAINT [invMetaTypes_PK] PRIMARY KEY CLUSTERED
(
[typeID] 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
/****** Object: Table [dbo].[invNames] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[invNames](
[itemID] [bigint] NOT NULL,
[itemName] [nvarchar](200) NOT NULL,
CONSTRAINT [invNames_PK] PRIMARY KEY CLUSTERED
(
[itemID] 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
/****** Object: Table [dbo].[invPositions] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[invPositions](
[itemID] [bigint] NOT NULL,
[x] [float] NOT NULL DEFAULT ((0.0)),
[y] [float] NOT NULL DEFAULT ((0.0)),
[z] [float] NOT NULL DEFAULT ((0.0)),
[yaw] [real] NULL,
[pitch] [real] NULL,
[roll] [real] NULL,
CONSTRAINT [invPositions_PK] PRIMARY KEY CLUSTERED
(
[itemID] 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
/****** Object: Table [dbo].[invTypeMaterials] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[invTypeMaterials](
[typeID] [int] NOT NULL,
[materialTypeID] [int] NOT NULL,
[quantity] [int] NOT NULL DEFAULT ((0)),
CONSTRAINT [invTypeMaterials_PK] PRIMARY KEY CLUSTERED
(
[typeID] ASC,
[materialTypeID] 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
/****** Object: Table [dbo].[invTypeReactions] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[invTypeReactions](
[reactionTypeID] [int] NOT NULL,
[input] [bit] NOT NULL,
[typeID] [int] NOT NULL,
[quantity] [smallint] NULL,
CONSTRAINT [pk_invTypeReactions] PRIMARY KEY CLUSTERED
(
[reactionTypeID] ASC,
[input] ASC,
[typeID] 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
/****** Object: Table [dbo].[invTypes] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[invTypes](
[typeID] [int] NOT NULL,
[groupID] [int] NULL,
[typeName] [nvarchar](100) NULL,
[description] [nvarchar](3000) NULL,
[mass] [float] NULL,
[volume] [float] NULL,
[capacity] [float] NULL,
[portionSize] [int] NULL,
[raceID] [tinyint] NULL,
[basePrice] [money] NULL,
[published] [bit] NULL,
[marketGroupID] [int] NULL,
[chanceOfDuplicating] [float] NULL,
[factionID] [int] NULL,
[graphicID] [int] NULL,
[iconID] [int] NULL,
[radius] [float] NULL,
[soundID] [int] NULL,
CONSTRAINT [invTypes_PK] PRIMARY KEY CLUSTERED
(
[typeID] 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
/****** Object: Table [dbo].[invUniqueNames] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[invUniqueNames](
[itemID] [int] NOT NULL,
[itemName] [nvarchar](200) NOT NULL,
[groupID] [int] NULL,
CONSTRAINT [invUniqueNames_PK] PRIMARY KEY CLUSTERED
(
[itemID] 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
/****** Object: Table [dbo].[mapCelestialStatistics] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[mapCelestialStatistics](
[celestialID] [int] NOT NULL,
[temperature] [float] NULL,
[spectralClass] [varchar](10) NULL,
[luminosity] [float] NULL,
[age] [float] NULL,
[life] [float] NULL,
[orbitRadius] [float] NULL,
[eccentricity] [float] NULL,
[massDust] [float] NULL,
[massGas] [float] NULL,
[fragmented] [bit] NULL,
[density] [float] NULL,
[surfaceGravity] [float] NULL,
[escapeVelocity] [float] NULL,
[orbitPeriod] [float] NULL,
[rotationRate] [float] NULL,
[locked] [bit] NULL,
[pressure] [float] NULL,
[radius] [float] NULL,
[mass] [float] NULL,
CONSTRAINT [mapCelestialStatistics_PK] PRIMARY KEY CLUSTERED
(
[celestialID] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[mapConstellationJumps] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mapConstellationJumps](
[fromRegionID] [int] NULL,
[fromConstellationID] [int] NOT NULL,
[toConstellationID] [int] NOT NULL,
[toRegionID] [int] NULL,
CONSTRAINT [mapConstellationJumps_PK] PRIMARY KEY CLUSTERED
(
[fromConstellationID] ASC,
[toConstellationID] 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
/****** Object: Table [dbo].[mapConstellations] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mapConstellations](
[regionID] [int] NULL,
[constellationID] [int] NOT NULL,
[constellationName] [nvarchar](100) NULL,
[x] [float] NULL,
[y] [float] NULL,
[z] [float] NULL,
[xMin] [float] NULL,
[xMax] [float] NULL,
[yMin] [float] NULL,
[yMax] [float] NULL,
[zMin] [float] NULL,
[zMax] [float] NULL,
[factionID] [int] NULL,
[radius] [float] NULL,
CONSTRAINT [mapConstellations_PK] PRIMARY KEY CLUSTERED
(
[constellationID] 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
/****** Object: Table [dbo].[mapDenormalize] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mapDenormalize](
[itemID] [int] NOT NULL,
[typeID] [int] NULL,
[groupID] [int] NULL,
[solarSystemID] [int] NULL,
[constellationID] [int] NULL,
[regionID] [int] NULL,
[orbitID] [int] NULL,
[x] [float] NULL,
[y] [float] NULL,
[z] [float] NULL,
[radius] [float] NULL,
[itemName] [nvarchar](100) NULL,
[security] [float] NULL,
[celestialIndex] [tinyint] NULL,
[orbitIndex] [tinyint] NULL,
CONSTRAINT [mapDenormalize_PK] PRIMARY KEY CLUSTERED
(
[itemID] 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
/****** Object: Table [dbo].[mapJumps] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mapJumps](
[stargateID] [int] NOT NULL,
[celestialID] [int] NULL,
CONSTRAINT [mapJumps_PK] PRIMARY KEY CLUSTERED
(
[stargateID] 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
/****** Object: Table [dbo].[mapLandmarks] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[mapLandmarks](
[landmarkID] [smallint] NOT NULL,
[landmarkName] [varchar](100) NULL,
[description] [varchar](7000) NULL,
[locationID] [int] NULL,
[x] [float] NULL,
[y] [float] NULL,
[z] [float] NULL,
[radius] [float] NULL,
[iconID] [int] NULL,
[importance] [tinyint] NULL,
CONSTRAINT [mapLandmarks_PK] PRIMARY KEY CLUSTERED
(
[landmarkID] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[mapLocationScenes] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mapLocationScenes](
[locationID] [int] NOT NULL,
[graphicID] [int] NULL,
CONSTRAINT [mapLocationScenes_PK_] PRIMARY KEY CLUSTERED
(
[locationID] 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
/****** Object: Table [dbo].[mapLocationWormholeClasses] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mapLocationWormholeClasses](
[locationID] [int] NOT NULL,
[wormholeClassID] [tinyint] NULL,
CONSTRAINT [mapLocationWormholeClasses_PK] PRIMARY KEY CLUSTERED
(
[locationID] 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
/****** Object: Table [dbo].[mapRegionJumps] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mapRegionJumps](
[fromRegionID] [int] NOT NULL,
[toRegionID] [int] NOT NULL,
CONSTRAINT [mapRegionJumps_PK] PRIMARY KEY CLUSTERED
(
[fromRegionID] ASC,
[toRegionID] 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
/****** Object: Table [dbo].[mapRegions] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mapRegions](
[regionID] [int] NOT NULL,
[regionName] [nvarchar](100) NULL,
[x] [float] NULL,
[y] [float] NULL,
[z] [float] NULL,
[xMin] [float] NULL,
[xMax] [float] NULL,
[yMin] [float] NULL,
[yMax] [float] NULL,
[zMin] [float] NULL,
[zMax] [float] NULL,
[factionID] [int] NULL,
[radius] [float] NULL,
CONSTRAINT [mapRegions_PK] PRIMARY KEY CLUSTERED
(
[regionID] 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
/****** Object: Table [dbo].[mapSolarSystemJumps] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mapSolarSystemJumps](
[fromRegionID] [int] NULL,
[fromConstellationID] [int] NULL,
[fromSolarSystemID] [int] NOT NULL,
[toSolarSystemID] [int] NOT NULL,
[toConstellationID] [int] NULL,
[toRegionID] [int] NULL,
CONSTRAINT [mapSolarSystemJumps_PK] PRIMARY KEY CLUSTERED
(
[fromSolarSystemID] ASC,
[toSolarSystemID] 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
/****** Object: Table [dbo].[mapSolarSystems] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[mapSolarSystems](
[regionID] [int] NULL,
[constellationID] [int] NULL,
[solarSystemID] [int] NOT NULL,
[solarSystemName] [nvarchar](100) NULL,
[x] [float] NULL,
[y] [float] NULL,
[z] [float] NULL,
[xMin] [float] NULL,
[xMax] [float] NULL,
[yMin] [float] NULL,
[yMax] [float] NULL,
[zMin] [float] NULL,
[zMax] [float] NULL,
[luminosity] [float] NULL,
[border] [bit] NULL,
[fringe] [bit] NULL,
[corridor] [bit] NULL,
[hub] [bit] NULL,
[international] [bit] NULL,
[regional] [bit] NULL,
[constellation] [bit] NULL,
[security] [float] NULL,
[factionID] [int] NULL,
[radius] [float] NULL,
[sunTypeID] [int] NULL,
[securityClass] [varchar](2) NULL,
CONSTRAINT [mapSolarSystems_PK] PRIMARY KEY CLUSTERED
(
[solarSystemID] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[mapUniverse] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[mapUniverse](
[universeID] [int] NOT NULL,
[universeName] [varchar](100) NULL,
[x] [float] NULL,
[y] [float] NULL,
[z] [float] NULL,
[xMin] [float] NULL,
[xMax] [float] NULL,
[yMin] [float] NULL,
[yMax] [float] NULL,
[zMin] [float] NULL,
[zMax] [float] NULL,
[radius] [float] NULL,
CONSTRAINT [mapUniverse_PK] PRIMARY KEY CLUSTERED
(
[universeID] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[planetSchematics] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[planetSchematics](
[schematicID] [smallint] NOT NULL,
[schematicName] [nvarchar](255) NULL,
[cycleTime] [int] NULL,
CONSTRAINT [planetSchematics_PK] PRIMARY KEY CLUSTERED
(
[schematicID] 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
/****** Object: Table [dbo].[planetSchematicsPinMap] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[planetSchematicsPinMap](
[schematicID] [smallint] NOT NULL,
[pinTypeID] [int] NOT NULL,
CONSTRAINT [planetSchematicsPinMap_PK] PRIMARY KEY CLUSTERED
(
[schematicID] ASC,
[pinTypeID] 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
/****** Object: Table [dbo].[planetSchematicsTypeMap] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[planetSchematicsTypeMap](
[schematicID] [smallint] NOT NULL,
[typeID] [int] NOT NULL,
[quantity] [smallint] NULL,
[isInput] [bit] NULL,
CONSTRAINT [planetSchematicsTypeMap_PK] PRIMARY KEY CLUSTERED
(
[schematicID] ASC,
[typeID] 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
/****** Object: Table [dbo].[ramActivities] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ramActivities](
[activityID] [tinyint] NOT NULL,
[activityName] [nvarchar](100) NULL,
[iconNo] [varchar](5) NULL,
[description] [nvarchar](1000) NULL,
[published] [bit] NULL,
CONSTRAINT [ramActivities_PK] PRIMARY KEY CLUSTERED
(
[activityID] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[ramAssemblyLineStations] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ramAssemblyLineStations](
[stationID] [int] NOT NULL,
[assemblyLineTypeID] [tinyint] NOT NULL,
[quantity] [tinyint] NULL,
[stationTypeID] [int] NULL,
[ownerID] [int] NULL,
[solarSystemID] [int] NULL,
[regionID] [int] NULL,
CONSTRAINT [ramAssemblyLineStations_PK] PRIMARY KEY CLUSTERED
(
[stationID] ASC,
[assemblyLineTypeID] 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
/****** Object: Table [dbo].[ramAssemblyLineTypeDetailPerCategory] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ramAssemblyLineTypeDetailPerCategory](
[assemblyLineTypeID] [tinyint] NOT NULL,
[categoryID] [int] NOT NULL,
[timeMultiplier] [float] NULL,
[materialMultiplier] [float] NULL,
[costMultiplier] [float] NULL,
CONSTRAINT [ramAssemblyLineTypeDetailPerCategory_PK] PRIMARY KEY CLUSTERED
(
[assemblyLineTypeID] ASC,
[categoryID] 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
/****** Object: Table [dbo].[ramAssemblyLineTypeDetailPerGroup] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ramAssemblyLineTypeDetailPerGroup](
[assemblyLineTypeID] [tinyint] NOT NULL,
[groupID] [int] NOT NULL,
[timeMultiplier] [float] NULL,
[materialMultiplier] [float] NULL,
[costMultiplier] [float] NULL,
CONSTRAINT [ramAssemblyLineTypeDetailPerGroup_PK] PRIMARY KEY CLUSTERED
(
[assemblyLineTypeID] ASC,
[groupID] 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
/****** Object: Table [dbo].[ramAssemblyLineTypes] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ramAssemblyLineTypes](
[assemblyLineTypeID] [tinyint] NOT NULL,
[assemblyLineTypeName] [nvarchar](100) NULL,
[description] [nvarchar](1000) NULL,
[baseTimeMultiplier] [float] NULL,
[baseMaterialMultiplier] [float] NULL,
[baseCostMultiplier] [float] NULL,
[volume] [float] NULL,
[activityID] [tinyint] NULL,
[minCostPerHour] [float] NULL,
CONSTRAINT [ramAssemblyLineTypes_PK] PRIMARY KEY CLUSTERED
(
[assemblyLineTypeID] 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
/****** Object: Table [dbo].[ramInstallationTypeContents] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ramInstallationTypeContents](
[installationTypeID] [int] NOT NULL,
[assemblyLineTypeID] [tinyint] NOT NULL,
[quantity] [tinyint] NULL,
CONSTRAINT [ramInstallationTypeContents_PK] PRIMARY KEY CLUSTERED
(
[installationTypeID] ASC,
[assemblyLineTypeID] 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
/****** Object: Table [dbo].[ramTypeRequirements] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ramTypeRequirements](
[typeID] [int] NOT NULL,
[activityID] [tinyint] NOT NULL,
[requiredTypeID] [int] NOT NULL,
[quantity] [int] NULL,
[level] [int] NULL,
[damagePerJob] [float] NULL,
[recycle] [bit] NULL,
[raceID] [int] NULL,
[probability] [float] NULL,
[consume] [bit] NULL,
CONSTRAINT [ramTypeRequirements_PK] PRIMARY KEY CLUSTERED
(
[typeID] ASC,
[activityID] ASC,
[requiredTypeID] 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
/****** Object: Table [dbo].[sknLicenses] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sknLicenses](
[licenseTypeID] [int] NOT NULL,
[skinID] [int] NULL,
[duration] [int] NOT NULL DEFAULT ((-1)),
CONSTRAINT [sknLicenses_PK] PRIMARY KEY CLUSTERED
(
[licenseTypeID] 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
/****** Object: Table [dbo].[sknMaterials] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sknMaterials](
[skinMaterialID] [int] NOT NULL,
[material] [nvarchar](255) NOT NULL DEFAULT (''),
[displayNameID] [int] NULL,
[colorHull] [nvarchar](6) NULL,
[colorWindow] [nvarchar](6) NULL,
[colorPrimary] [nvarchar](6) NULL,
[colorSecondary] [nvarchar](6) NULL,
CONSTRAINT [sknMaterials_PK] PRIMARY KEY CLUSTERED
(
[skinMaterialID] 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
/****** Object: Table [dbo].[sknSkins] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sknSkins](
[skinID] [int] NOT NULL,
[internalName] [nvarchar](100) NOT NULL DEFAULT (''),
[skinMaterialID] [int] NULL,
[typeID] [int] NULL,
[allowCCPDevs] [bit] NOT NULL DEFAULT ((0)),
[visibleSerenity] [bit] NOT NULL DEFAULT ((0)),
[visibleTranquility] [bit] NOT NULL DEFAULT ((0)),
CONSTRAINT [sknSkins_PK] PRIMARY KEY CLUSTERED
(
[skinID] 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
/****** Object: Table [dbo].[staOperationServices] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[staOperationServices](
[operationID] [tinyint] NOT NULL,
[serviceID] [int] NOT NULL,
CONSTRAINT [staOperationServices_PK] PRIMARY KEY CLUSTERED
(
[operationID] ASC,
[serviceID] 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
/****** Object: Table [dbo].[staOperations] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[staOperations](
[activityID] [tinyint] NULL,
[operationID] [tinyint] NOT NULL,
[operationName] [nvarchar](100) NULL,
[description] [nvarchar](1000) NULL,
[fringe] [tinyint] NULL,
[corridor] [tinyint] NULL,
[hub] [tinyint] NULL,
[border] [tinyint] NULL,
[ratio] [tinyint] NULL,
[caldariStationTypeID] [int] NULL,
[minmatarStationTypeID] [int] NULL,
[amarrStationTypeID] [int] NULL,
[gallenteStationTypeID] [int] NULL,
[joveStationTypeID] [int] NULL,
CONSTRAINT [staOperations_PK] PRIMARY KEY CLUSTERED
(
[operationID] 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
/****** Object: Table [dbo].[staServices] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[staServices](
[serviceID] [int] NOT NULL,
[serviceName] [nvarchar](100) NULL,
[description] [nvarchar](1000) NULL,
CONSTRAINT [staServices_PK] PRIMARY KEY CLUSTERED
(
[serviceID] 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
/****** Object: Table [dbo].[staStationTypes] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[staStationTypes](
[stationTypeID] [int] NOT NULL,
[dockEntryX] [float] NULL,
[dockEntryY] [float] NULL,
[dockEntryZ] [float] NULL,
[dockOrientationX] [float] NULL,
[dockOrientationY] [float] NULL,
[dockOrientationZ] [float] NULL,
[operationID] [tinyint] NULL,
[officeSlots] [tinyint] NULL,
[reprocessingEfficiency] [float] NULL,
[conquerable] [bit] NULL,
CONSTRAINT [stationTypes_PK] PRIMARY KEY CLUSTERED
(
[stationTypeID] 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
/****** Object: Table [dbo].[staStations] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[staStations](
[stationID] [int] NOT NULL,
[security] [smallint] NULL,
[dockingCostPerVolume] [float] NULL,
[maxShipVolumeDockable] [float] NULL,
[officeRentalCost] [int] NULL,
[operationID] [tinyint] NULL,
[stationTypeID] [int] NULL,
[corporationID] [int] NULL,
[solarSystemID] [int] NULL,
[constellationID] [int] NULL,
[regionID] [int] NULL,
[stationName] [nvarchar](100) NULL,
[x] [float] NULL,
[y] [float] NULL,
[z] [float] NULL,
[reprocessingEfficiency] [float] NULL,
[reprocessingStationsTake] [float] NULL,
[reprocessingHangarFlag] [tinyint] NULL,
CONSTRAINT [staStations_PK] PRIMARY KEY CLUSTERED
(
[stationID] 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
/****** Object: Table [dbo].[translationTables] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[translationTables](
[sourceTable] [nvarchar](200) NOT NULL,
[destinationTable] [nvarchar](200) NULL,
[translatedKey] [nvarchar](200) NOT NULL,
[tcGroupID] [int] NULL,
[tcID] [int] NULL,
CONSTRAINT [translationTables_PK] PRIMARY KEY CLUSTERED
(
[sourceTable] ASC,
[translatedKey] 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
/****** Object: Table [dbo].[trnTranslationColumns] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[trnTranslationColumns](
[tcGroupID] [smallint] NULL,
[tcID] [smallint] NOT NULL,
[tableName] [nvarchar](256) NOT NULL,
[columnName] [nvarchar](128) NOT NULL,
[masterID] [nvarchar](128) NULL,
CONSTRAINT [translationColumns_PK] PRIMARY KEY CLUSTERED
(
[tcID] 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
/****** Object: Table [dbo].[trnTranslationLanguages] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[trnTranslationLanguages](
[numericLanguageID] [int] NOT NULL,
[languageID] [varchar](50) NULL,
[languageName] [nvarchar](200) NULL,
CONSTRAINT [trnTranslationLanguages_PK] PRIMARY KEY CLUSTERED
(
[numericLanguageID] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[trnTranslations] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[trnTranslations](
[tcID] [smallint] NOT NULL,
[keyID] [int] NOT NULL,
[languageID] [varchar](50) NOT NULL,
[text] [nvarchar](max) NOT NULL,
CONSTRAINT [trnTranslations_PK] PRIMARY KEY CLUSTERED
(
[tcID] ASC,
[keyID] ASC,
[languageID] 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 [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[warCombatZoneSystems] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[warCombatZoneSystems](
[solarSystemID] [int] NOT NULL,
[combatZoneID] [int] NULL,
CONSTRAINT [combatZoneSystems_PK] PRIMARY KEY CLUSTERED
(
[solarSystemID] 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
/****** Object: Table [dbo].[warCombatZones] Script Date: 15/07/2015 15:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[warCombatZones](
[combatZoneID] [int] NOT NULL DEFAULT ((-1)),
[combatZoneName] [nvarchar](100) NULL,
[factionID] [int] NULL,
[centerSystemID] [int] NULL,
[description] [nvarchar](500) NULL,
CONSTRAINT [combatZones_PK] PRIMARY KEY CLUSTERED
(
[combatZoneID] 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
/****** Object: Index [agtAgents_IX_corporation] Script Date: 15/07/2015 15:10:59 ******/
CREATE NONCLUSTERED INDEX [agtAgents_IX_corporation] ON [dbo].[agtAgents]
(
[corporationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object: Index [agtAgents_IX_station] Script Date: 15/07/2015 15:10:59 ******/
CREATE NONCLUSTERED INDEX [agtAgents_IX_station] ON [dbo].[agtAgents]
(
[locationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object: Index [agtResearchAgents_IX_type] Script Date: 15/07/2015 15:10:59 ******/
CREATE NONCLUSTERED INDEX [agtResearchAgents_IX_type] ON [dbo].[agtResearchAgents]
(
[typeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object: Index [invContrabandTypes_IX_type] Script Date: 15/07/2015 15:10:59 ******/
CREATE NONCLUSTERED INDEX [invContrabandTypes_IX_type] ON [dbo].[invContrabandTypes]
(
[typeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object: Index [items_IX_Location] Script Date: 15/07/2015 15:10:59 ******/
CREATE NONCLUSTERED INDEX [items_IX_Location] ON [dbo].[invItems]
(
[locationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object: Index [items_IX_OwnerLocation] Script Date: 15/07/2015 15:10:59 ******/
CREATE NONCLUSTERED INDEX [items_IX_OwnerLocation] ON [dbo].[invItems]
(
[ownerID] ASC,
[locationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [invUniqueNames_IX_GroupName] Script Date: 15/07/2015 15:10:59 ******/
CREATE NONCLUSTERED INDEX [invUniqueNames_IX_GroupName] ON [dbo].[invUniqueNames]
(
[groupID] ASC,
[itemName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [invUniqueNames_UQ] Script Date: 15/07/2015 15:10:59 ******/
CREATE UNIQUE NONCLUSTERED INDEX [invUniqueNames_UQ] ON [dbo].[invUniqueNames]
(
[itemName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object: Index [ramAssemblyLineStations_IX_owner] Script Date: 15/07/2015 15:10:59 ******/
CREATE NONCLUSTERED INDEX [ramAssemblyLineStations_IX_owner] ON [dbo].[ramAssemblyLineStations]
(
[ownerID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object: Index [ramAssemblyLineStations_IX_region] Script Date: 15/07/2015 15:10:59 ******/
CREATE NONCLUSTERED INDEX [ramAssemblyLineStations_IX_region] ON [dbo].[ramAssemblyLineStations]
(
[regionID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object: Index [staStations_IX_constellation] Script Date: 15/07/2015 15:10:59 ******/
CREATE NONCLUSTERED INDEX [staStations_IX_constellation] ON [dbo].[staStations]
(
[constellationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object: Index [staStations_IX_corporation] Script Date: 15/07/2015 15:10:59 ******/
CREATE NONCLUSTERED INDEX [staStations_IX_corporation] ON [dbo].[staStations]
(
[corporationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object: Index [staStations_IX_operation] Script Date: 15/07/2015 15:10:59 ******/
CREATE NONCLUSTERED INDEX [staStations_IX_operation] ON [dbo].[staStations]
(
[operationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object: Index [staStations_IX_region] Script Date: 15/07/2015 15:10:59 ******/
CREATE NONCLUSTERED INDEX [staStations_IX_region] ON [dbo].[staStations]
(
[regionID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object: Index [staStations_IX_system] Script Date: 15/07/2015 15:10:59 ******/
CREATE NONCLUSTERED INDEX [staStations_IX_system] ON [dbo].[staStations]
(
[solarSystemID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object: Index [staStations_IX_type] Script Date: 15/07/2015 15:10:59 ******/
CREATE NONCLUSTERED INDEX [staStations_IX_type] ON [dbo].[staStations]
(
[stationTypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
USE [master]
GO
ALTER DATABASE [EveStaticData] SET READ_WRITE
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment