BryanDerksen: Created page with 'This is the SQL script for populating the database with core data needed by the toolset to run. See Database for more details.

 /* *************************************...'

2009-10-15T19:42:27Z

Created page with 'This is the SQL script for populating the database with core data needed by the toolset to run. See Database for more details. <pre> /* *************************************...'

New page

This is the SQL script for populating the database with core data needed by the toolset to run. See [[Database]] for more details.

<pre>
/*
*****************************************************
Populate the core data
*****************************************************
*/

INSERT INTO t_ResourceTables([Name]) VALUES ('t_Area')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_AreaObject')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_AreaObjectGeometry')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_AreaSound')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_AssociatedResource')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_Conversation')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_ConversationLine')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_ConversationTransition')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_Creature')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_CreatureAbility')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_Cutscene')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_CutsceneAction')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_CutsceneActionTransition')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_CutsceneObject')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_CutsceneTrack')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_Inventory')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_Item')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_ItemProperty')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_Merchant')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_MerchantRestrictedItem')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_Placeable')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_Plot')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_PlotStatus')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_Script')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_String')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_Trigger')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_Variable')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_AreaWaypoint')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_Role')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_Character')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_Character2')
DELETE FROM t_ResourceTables WHERE NAME = 't_Character2'
INSERT INTO t_ResourceTables([Name]) VALUES ('t_AreaList')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_Stage')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_StageObject')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_StageObjectReference')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_ConversationTagMap')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_ConversationCinematics')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_Map')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_MapPin')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_PlotAssist')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_ConversationAnimations')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_AreaReverbVolume')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_AreaReverbVolumeGeometry')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_AreaAudioVolume')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_AreaAudioVolumeGeometry')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_AreaAudioVolumeSound')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_AreaMusicVolume')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_AreaMusicVolumeGeometry')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_CutsceneActionFBEParameter')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_AreaObjectVariable')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_StageFBEParameter')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_AreaInstanceAssociations')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_MapTrail')
INSERT INTO t_ResourceTables([Name]) VALUES ('t_MapTrailPoint')

INSERT INTO t_ResourceDefinition([ResType], [BaseResourceTableID]) VALUES ('are', 1)
INSERT INTO t_ResourceDefinition([ResType], [BaseResourceTableID]) VALUES ('dlg', 6)
INSERT INTO t_ResourceDefinition([ResType], [BaseResourceTableID]) VALUES ('utc', 9)
INSERT INTO t_ResourceDefinition([ResType], [BaseResourceTableID]) VALUES ('cut', 11)
INSERT INTO t_ResourceDefinition([ResType], [BaseResourceTableID]) VALUES ('uti', 17)
INSERT INTO t_ResourceDefinition([ResType], [BaseResourceTableID]) VALUES ('utm', 19)
INSERT INTO t_ResourceDefinition([ResType], [BaseResourceTableID]) VALUES ('utp', 21)
INSERT INTO t_ResourceDefinition([ResType], [BaseResourceTableID]) VALUES ('plo', 22)
INSERT INTO t_ResourceDefinition([ResType], [BaseResourceTableID]) VALUES ('nss', 24)
INSERT INTO t_ResourceDefinition([ResType], [BaseResourceTableID]) VALUES ('nsc', 24)
INSERT INTO t_ResourceDefinition([ResType], [BaseResourceTableID]) VALUES ('str', 25)
INSERT INTO t_ResourceDefinition([ResType], [BaseResourceTableID]) VALUES ('utt', 26)
INSERT INTO t_ResourceDefinition([ResType], [BaseResourceTableID]) VALUES ('rol', 29)
INSERT INTO t_ResourceDefinition([ResType], [BaseResourceTableID]) VALUES ('chr', 30)
INSERT INTO t_ResourceDefinition([ResType], [BaseResourceTableID]) VALUES ('lst', 32)
INSERT INTO t_ResourceDefinition([ResType], [BaseResourceTableID]) VALUES ('stg', 33)
INSERT INTO t_ResourceDefinition([ResType], [BaseResourceTableID]) VALUES ('map', 38)

INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (1, 1, '1.', 1)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (1, 2, '1.2.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (1, 4, '1.4.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (1, 5, '1.5.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (1, 27, '1.27.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (1, 28, '1.28.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (1, 42, '1.42.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (1, 44, '1.44.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (1, 47, '1.47.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (1, 52, '1.52.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (2, 3, '1.2.3.', 3)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (2, 50, '1.2.50.', 3)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (6, 6, '6.', 1)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (6, 7, '6.7.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (6, 8, '6.8.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (6, 36, '6.36.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (6, 37, '6.37.', 3)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (7, 41, '6.7.41.', 3)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (9, 9, '9.', 1)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (9, 10, '9.10.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (9, 16, '9.16.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (9, 27, '9.27.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (11, 11, '11.', 1)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (11, 14, '11.14.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (12, 13, '11.14.15.12.13.', 5)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (12, 49, '11.14.15.12.49.', 5)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (14, 15, '11.14.15.', 3)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (15, 12, '11.14.15.12.', 4)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (17, 17, '17.', 1)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (17, 18, '17.18.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (17, 27, '17.27.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (19, 16, '19.16.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (19, 19, '19.', 1)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (19, 20, '19.20.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (19, 27, '19.27.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (21, 16, '21.16.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (21, 21, '21.', 1)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (21, 27, '21.27.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (22, 22, '22.', 1)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (22, 23, '22.23.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (23, 40, '22.23.40.', 3)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (24, 24, '24.', 1)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (26, 26, '26.', 1)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (26, 27, '26.27.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (29, 29, '29.', 1)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (30, 30, '30.', 1)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (32, 32, '32.', 1)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (33, 33, '33.', 1)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (33, 34, '33.34.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (34, 35, '33.34.35.', 3)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (34, 51, '33.34.51.', 3)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (38, 38, '38.', 1)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (38, 39, '38.39.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (38, 53, '38.53.', 2)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (53, 54, '38.53.54.', 3)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (42, 43, '1.42.43.', 3)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (44, 45, '1.44.45.', 3)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (44, 46, '1.44.46.', 3)
INSERT INTO t_ResourceTableRelationship([ParentResourceTableID], [ChildResourceTableID], [FullPath], [Level]) VALUES (47, 48, '1.47.48.', 3)

INSERT INTO [t_ModuleType]([Name], [Directory]) VALUES('Core', 'packages')
INSERT INTO [t_ModuleType]([Name], [Directory]) VALUES('Package', 'packages\core\data')
INSERT INTO [t_ModuleType]([Name], [Directory]) VALUES('Module', 'modules')
INSERT INTO [t_ModuleType]([Name], [Directory]) VALUES('PRC', 'add-ins')

/*
*****************************************************
Create the Core and first Module
*****************************************************
*/

DECLARE @a_iModuleID int
exec bsp_AddNewModule 'Core Game Resources', 'core', -1, 1, 'core', NULL, NULL, '', NULL, '', NULL, 1, 1, -1,-1,-1, NULL, NULL, NULL, NULL, NULL, -1, -1, -1, -1, NULL, NULL, NULL, -1, 1, 1, -1, -1, @a_iModuleID OUTPUT
exec bsp_AddNewModule 'Single Player', 'Single Player', 1, 0, 'Single Player', NULL, NULL, '', NULL, '', NULL, 1, 3,-1,-1,-1, NULL, NULL, NULL, NULL, NULL, -1, -1, -1, -1, NULL, NULL, NULL, -1, 1, 1, -1, -1, @a_iModuleID OUTPUT

/*
*****************************************************
Create the String Data
*****************************************************
*/

INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Base Item Type Names', 'Strings associated with the base items.', NULL, 0)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Conversation, Extra', 'Conversation strings not managed by the designer toolset.', NULL, 0)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Exported Area Text', 'Strings managed by the designer toolset.', NULL, 1)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Exported Conversation Text', 'Strings managed by the designer toolset.', NULL, 1)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Exported Creature Text', 'Strings managed by the designer toolset.', NULL, 1)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Exported Door Text', 'Strings managed by the designer toolset.', NULL, 1)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Exported Item Text', 'Strings managed by the designer toolset.', NULL, 1)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Exported Journal Text', 'Strings managed by the designer toolset.', NULL, 1)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Exported Placeable Text', 'Strings managed by the designer toolset.', NULL, 1)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Exported Sound Text', 'Strings managed by the designer toolset.', NULL, 1)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Exported Store Text', 'Strings managed by the designer toolset.', NULL, 1)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Exported Trap Text', 'Strings managed by the designer toolset.', NULL, 1)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Exported Trigger Text', 'Strings managed by the designer toolset.', NULL, 1)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Exported GUI Text', 'Strings managed by the designer toolset.', NULL, 1)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Item Properties', NULL, NULL, 0)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Skills', NULL, NULL, 0)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Spells', NULL, NULL, 0)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Talents', NULL, NULL, 0)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Rules', NULL, NULL, 0)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Exported Merchant Text', 'Strings managed by the designer toolset.', NULL, 1)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Exported Cutscene Text', 'Strings managed by the designer toolset.', NULL, 1)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Exported Plot Text', 'Strings managed by the designer toolset', NULL, 1)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Not Used', NULL, NULL, 1)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('GUI', NULL, NULL, 0)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Not Used', NULL, NULL, 1)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Exported Map Text', 'Strings managed by the designer toolset.', NULL, 1)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Module Localized Text', 'Strings associated with Module Display Names and Descriptions.', NULL, 0)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('PRC GUI', NULL, NULL, 0)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('GUI Console', 'Console-only GUI strings', NULL, 0)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('GUI Xbox360', 'Xbox360-only GUI strings', NULL, 0)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('GUI PS3', 'PS3-only GUI strings', NULL, 0)
INSERT INTO t_StringType ([Name], [Description], [IncludeFile], [Exported]) values ('Imported from Console', 'Imported from Console strings', NULL, 1)

INSERT INTO [t_StringLanguage]([Name], [Description]) VALUES('English', 'English')

/*
*****************************************************
Define the Male and Female Genders
These are fixed at 1 and 2 respectively
*****************************************************
*/
SET IDENTITY_INSERT t_StringVariant ON

IF NOT EXISTS
(
SELECT 1
FROM t_StringVariant
WHERE [ID] = 1
)
BEGIN
INSERT t_StringVariant ([ID], [Name])
VALUES (1, 'Male/Neutral')
END
ELSE
BEGIN
UPDATE t_StringVariant
SET [Name] = 'Male/Neutral'
WHERE [ID] = 1
END

IF NOT EXISTS
(
SELECT 1
FROM t_StringVariant
WHERE [ID] = 2
)
BEGIN
INSERT t_StringVariant ([ID], [Name])
VALUES (2, 'Female')
END
ELSE
BEGIN
UPDATE t_StringVariant
SET [Name] = 'Female'
WHERE [ID] = 2
END

SET IDENTITY_INSERT t_StringVariant OFF

INSERT INTO [t_StringLanguageVariant]([StringLanguageID], [StringVariantID]) VALUES(1, 1)

/*
*****************************************************
Define the English Language tag as 'en-us', and
hook it up as the default tag.
*****************************************************
*/
IF NOT EXISTS
(
SELECT [ID]
FROM t_StringLanguageTag
WHERE [Tag] = 'en-us'
AND [StringLanguageID] = 1
)
BEGIN
INSERT t_StringLanguageTag ([StringLanguageID], [Tag])
VALUES (1, 'en-us')
END

IF EXISTS
(
SELECT 1
FROM t_StringLanguage
WHERE [ID] = 1
AND [DefaultStringLanguageTagID] IS NULL
)
BEGIN
DECLARE @iTagID int
SELECT @iTagID = [ID]
FROM t_StringLanguageTag
WHERE [Tag] = 'en-us'
AND [StringLanguageID] = 1

UPDATE t_StringLanguage
SET [DefaultStringLanguageTagID] = @iTagID
WHERE [ID] = 1
END

/*
*****************************************************
Define the Foreign Languages to be used on
this project.
*****************************************************
*/

-- Define the foreign languages we want to add to this project
DECLARE @tForeignLanguages TABLE
(
[Name] varchar(128),
[Tag] varchar(64)
)

INSERT @tForeignLanguages VALUES ('French-France', 'fr-fr')
INSERT @tForeignLanguages VALUES ('Italian-Italy', 'it-it')
INSERT @tForeignLanguages VALUES ('German-Germany', 'de-de')
INSERT @tForeignLanguages VALUES ('Spanish-Spain', 'es-es')

INSERT @tForeignLanguages VALUES ('Polish-Poland', 'pl-pl')
INSERT @tForeignLanguages VALUES ('Russian-Russia', 'ru-ru')

INSERT @tForeignLanguages VALUES ('PseudoLoc', 'pseudo')

INSERT @tForeignLanguages VALUES ('Czech - Czech Republic', 'cs-cz')
INSERT @tForeignLanguages VALUES ('Hungarian - Hungary', 'hu-hu')

-- Add these foreign languages iteratively
-- ONLY add the languages if they are not found in the database already
DECLARE @currentName varchar(128)
DECLARE @currentTag varchar(64)

DECLARE language_cursor CURSOR FOR
SELECT [Name], [Tag]
FROM @tForeignLanguages
WHERE [Name] NOT IN
(SELECT [Name] FROM t_StringLanguage)

OPEN language_cursor

FETCH NEXT FROM language_cursor
INTO @currentName, @currentTag

WHILE @@FETCH_STATUS = 0
BEGIN
print 'Defining new Foreign Language: ' + @currentName + ' - ' + @currentTag
DECLARE @iLanguageID int
DECLARE @iLanguageTagID int

-- Insert the language
INSERT t_StringLanguage ([Name], [Description])
VALUES (@currentName, @currentName)

SELECT @iLanguageID = SCOPE_IDENTITY()

-- Insert the StringLanguageTag
INSERT t_StringLanguageTag ([StringLanguageID], [Tag])
VALUES (@iLanguageID, @currentTag)

SELECT @iLanguageTagID = SCOPE_IDENTITY()

-- Mark the LanguageTag as Default for this language
UPDATE sl
SET sl.[DefaultStringLanguageTagID] = @iLanguageTagID
FROM t_StringLanguage sl
WHERE sl.[ID] = @iLanguageID

-- Define the LanguageVariant combinations (male and female)
INSERT t_StringLanguageVariant ([StringLanguageID], [StringVariantID])
VALUES (@iLanguageID, 1)

INSERT t_StringLanguageVariant ([StringLanguageID], [StringVariantID])
VALUES (@iLanguageID, 2)

print '- Done adding language ' + @currentName

-- Get the next language
FETCH NEXT FROM language_cursor
INTO @currentName, @currentTag
END

CLOSE language_cursor
DEALLOCATE language_cursor

GO

/*
*****************************************************
Create the Core Scripts
*****************************************************
*/

declare @iRRID int
declare @iVerID int
declare @sName varchar(32)
declare @sScriptFolderName varchar(32)

set @sScriptFolderName = 'Core Scripts'
set @sName = 'area_core'
EXEC [bsp_AddResRef] 1, 1, @sName, @sScriptFolderName, 'nss', 0, @iRRID OUTPUT, @iVerID OUTPUT
INSERT INTO t_Script(ModuleResRefVersionID, [Text]) VALUES (@iVerID, 'void main () { } ')
set @sName = 'creature_core'
EXEC [bsp_AddResRef] 1, 1, @sName, @sScriptFolderName, 'nss', 0, @iRRID OUTPUT, @iVerID OUTPUT
INSERT INTO t_Script(ModuleResRefVersionID, [Text]) VALUES (@iVerID, 'void main () { } ')
set @sName = 'merchant_core'
EXEC [bsp_AddResRef] 1, 1, @sName, @sScriptFolderName, 'nss', 0, @iRRID OUTPUT, @iVerID OUTPUT
INSERT INTO t_Script(ModuleResRefVersionID, [Text]) VALUES (@iVerID, 'void main () { } ')
set @sName = 'placeable_core'
EXEC [bsp_AddResRef] 1, 1, @sName, @sScriptFolderName, 'nss', 0, @iRRID OUTPUT, @iVerID OUTPUT
INSERT INTO t_Script(ModuleResRefVersionID, [Text]) VALUES (@iVerID, 'void main () { } ')
set @sName = 'trigger_core'
EXEC [bsp_AddResRef] 1, 1, @sName, @sScriptFolderName, 'nss', 0, @iRRID OUTPUT, @iVerID OUTPUT
INSERT INTO t_Script(ModuleResRefVersionID, [Text]) VALUES (@iVerID, 'void main () { } ')
set @sName = 'module_core'
EXEC [bsp_AddResRef] 1, 1, @sName, @sScriptFolderName, 'nss', 0, @iRRID OUTPUT, @iVerID OUTPUT
INSERT INTO t_Script(ModuleResRefVersionID, [Text]) VALUES (@iVerID, 'void main () { } ')
set @sName = 'plot_core'
EXEC [bsp_AddResRef] 1, 1, @sName, @sScriptFolderName, 'nss', 0, @iRRID OUTPUT, @iVerID OUTPUT
INSERT INTO t_Script(ModuleResRefVersionID, [Text]) VALUES (@iVerID, 'void main () { } ')

/*
*****************************************************
Create the Global Parameters
*****************************************************
*/

INSERT INTO t_GlobalParameters ([Name], [Value]) VALUES ('DatabaseVersion', '1.0.0.194')
INSERT INTO t_GlobalParameters ([Name], [Value]) VALUES ('StringIDEndRange', '4999999')
INSERT INTO t_GlobalParameters ([Name], [Value]) VALUES ('StringIDStartRange', '1')

INSERT INTO t_KeyGenStringID ([LastUsedID]) VALUES (0)
</pre>

@@ Line 427: / Line 427: @@
 INSERT INTO t_GlobalParameters ([Name], [Value]) VALUES ('DatabaseVersion', '1.0.0.194')
-INSERT INTO t_GlobalParameters ([Name], [Value]) VALUES ('StringIDEndRange', '4999999')
+INSERT INTO t_GlobalParameters ([Name], [Value]) VALUES ('StringIDEndRange', '2147483647')
-INSERT INTO t_GlobalParameters ([Name], [Value]) VALUES ('StringIDStartRange', '1')
+INSERT INTO t_GlobalParameters ([Name], [Value]) VALUES ('StringIDStartRange', '610000000')
-INSERT INTO t_KeyGenStringID ([LastUsedID]) VALUES (0)
+INSERT INTO t_KeyGenStringID ([LastUsedID]) VALUES (609999999)
 </pre>
 [[Category:Database]]

← Older revision		Revision as of 22:22, 27 October 2009
Line 433:		Line 433:
	INSERT INTO t_KeyGenStringID ([LastUsedID]) VALUES (0)		INSERT INTO t_KeyGenStringID ([LastUsedID]) VALUES (0)
	</pre>		</pre>
		+	[[Category:Database]]

Core Data Script.sql - Revision history

BryanDerksen: another update

BryanDerksen: category

BryanDerksen: this script was slightly out of date. Updating.

BryanDerksen: Created page with 'This is the SQL script for populating the database with core data needed by the toolset to run. See Database for more details.
/* *************************************...'

@@ Line 2: / Line 2: @@
 <pre>
 /*
 *****************************************************
@@ Line 149: / Line 151: @@
 INSERT INTO [t_ModuleType]([Name], [Directory]) VALUES('Core', 'packages')
-INSERT INTO [t_ModuleType]([Name], [Directory]) VALUES('Package', 'packages\core\data')
+INSERT INTO [t_ModuleType]([Name], [Directory]) VALUES('Package', 'packages')
 INSERT INTO [t_ModuleType]([Name], [Directory]) VALUES('Module', 'modules')
-INSERT INTO [t_ModuleType]([Name], [Directory]) VALUES('PRC', 'add-ins')
+INSERT INTO [t_ModuleType]([Name], [Directory]) VALUES('Addin', 'addins')