Difference between revisions of "Core Data Script.sql"
From Dragon Age Toolset Wiki
BryanDerksen (Talk | contribs) m (category) |
BryanDerksen (Talk | contribs) m (another update) |
||
Line 427: | Line 427: | ||
INSERT INTO t_GlobalParameters ([Name], [Value]) VALUES ('DatabaseVersion', '1.0.0.194') | INSERT INTO t_GlobalParameters ([Name], [Value]) VALUES ('DatabaseVersion', '1.0.0.194') | ||
− | INSERT INTO t_GlobalParameters ([Name], [Value]) VALUES ('StringIDEndRange', ' | + | INSERT INTO t_GlobalParameters ([Name], [Value]) VALUES ('StringIDEndRange', '2147483647') |
− | INSERT INTO t_GlobalParameters ([Name], [Value]) VALUES ('StringIDStartRange', ' | + | INSERT INTO t_GlobalParameters ([Name], [Value]) VALUES ('StringIDStartRange', '610000000') |
− | INSERT INTO t_KeyGenStringID ([LastUsedID]) VALUES ( | + | INSERT INTO t_KeyGenStringID ([LastUsedID]) VALUES (609999999) |
</pre> | </pre> | ||
[[Category:Database]] | [[Category:Database]] |
Latest revision as of 17:31, 28 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', '2147483647') INSERT INTO t_GlobalParameters ([Name], [Value]) VALUES ('StringIDStartRange', '610000000') INSERT INTO t_KeyGenStringID ([LastUsedID]) VALUES (609999999)