Difference between revisions of "Core Data Script.sql"

From Dragon Age Toolset Wiki
Jump to: navigation, search
(this script was slightly out of date. Updating.)
m (category)
Line 433: Line 433:
 
INSERT INTO t_KeyGenStringID ([LastUsedID]) VALUES (0)
 
INSERT INTO t_KeyGenStringID ([LastUsedID]) VALUES (0)
 
</pre>
 
</pre>
 +
[[Category:Database]]

Revision as of 22:22, 27 October 2009

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

 

/*
*****************************************************
    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')
INSERT INTO [t_ModuleType]([Name], [Directory]) VALUES('Module', 'modules')
INSERT INTO [t_ModuleType]([Name], [Directory]) VALUES('Addin', 'addins')
INSERT INTO [t_ModuleType]([Name], [Directory]) VALUES('Offer', 'offers')


/*
*****************************************************
    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)
Retrieved from "http://www.datoolset.net/mw/index.php?title=Core_Data_Script.sql&oldid=7240"