History

Commits on master to Source/Libraries/GSF.TimeSeries/Data/SQL Server/GSFSchema.sql33

Added Recommended Action to AlarmStateChristoph Lackner committed 5 years agoc32da58
GSF.TimeSeries: Fixed typo in SQL Server schemaJ. Ritchie Carroll committed 5 years ago06607d1
GSF.TimeSeries: Updated SQL Server schema to mark Device UniqueID with a unique constraintJ. Ritchie Carroll committed 5 years ago96aa61e
GSF.TimeSeries: Updated all schemas to version 13 to extend OutputStreamDeviceAnalog Label length to 200.J. Ritchie Carroll committed 5 years ago1282fcd
Updated DeviceAlarm View to include Device IDChristoph Lackner committed 6 years agoa72de8d
Moved Alarm Panel Tables to GSF SchemaChristoph Lackner committed 6 years agoaa06835
GSF.TimeSeries: Added Phasor.BaseKV to MeasurementDetail view.J. Ritchie Carroll committed 7 years ago8d45478
GSF.TimeSeries: Updated GSF schema and GEP data synchronization to include BaseKV in phasor table.J. Ritchie Carroll committed 7 years ago0189c1a
GSF.TimeSeries: Updated the schema version of the databases to reflect the change to the device update trigger.StephenCWills committed 8 years agoc60166a
GSF.TimeSeries: Fixed NULL comparisons in SQL trigger for tracking changes to Device records.StephenCWills committed 8 years ago2fdb5db
GSF.TimeSeries: Added unique constraint to the Phasor table to catch user input errors that caused crashes in the WPF Manager.StephenCWills committed 8 years ago606f059
GSF.TimeSeries: Added filter adapters to modify measurement properties before routing.StephenCWills committed 8 years ago4ff56a0
GSF.TimeSeries: Modified Measurement, ImportedMeasurement, and OutputStreamMeasurement to use a 64-bit integer for the point ID in GSFSchema.sql.StephenCWills committed 9 years agobe6500f
GSF.TimeSeries: Modified the MapAcronym field of the Company table in the SQL Server schema to match the other database types.StephenCWills committed 10 years ago0546d10
GSF.TimeSeries.Data: Fixed cascade deletes related to measurement table.Ritchie Carroll committed 10 years ago4ddbb6a
Fixed and normalized the foreign key constraint names in the time-series schema implementations for the PowerCalculations table.J. Ritchie Carroll committed 10 years agofe5ced4
GSF.TimeSeries: 1) Fixed adder/multiplier on throttled subscriptions. 2) Added PowerCalculations table to SQL scripts.StephenCWills committed 10 years ago76ae436
Converted TFS repository to Git.StephenCWills committed 11 years agodd143d7
GSF: Migrated all file license references from Eclipse to MIT.ritchiecarroll committed 11 years ago6d94f5f
GSF.Historian: Improved operation of MetadataFile (e.g., nnn_dbase.dat) to use a new variable length file format to support non-fixed length strings and structures and dictionary style lookups - new file name is nnn_dbase.dat2. Supports three modes of legacy operation (1) Enabled - use legacy format only, (2) Compatible - use new format but keep an old legacy file in-sync for compatibility, and (3) Disabled - use new format only. For implementations with large ID gaps or very large meta-data sets, it is recommended to switch to new format to conserve memory.ritchiecarroll committed 12 years ago9fdf1ce
GSF.Core: 1) Improved AdoDataConnection to handle null parameters by converting them to DBNull.Value automatically. 2) Added MixedSynchronizedOperation to GSF.Threading.StephenCWills committed 12 years agoaafd44b
(1) GSF.Core.Parsing: Added TemplatedExpressionParser class: a template based token substitution parser that supports binary expressions. (2) PhasorProtocolAdapters / GSF.PhasorProtocols.UI.*: Added support for custom tag naming expressions so that end user can control format of tag names. (3) PIAdapters: Updated meta-data synchronization to take into account last update time so that meta-data will only be refreshed if needed. (4) GSF.TimeSeries.Data: Updated database schema to version 3 to include last update times in various measurement views and add a LongAcronym field to the SignalType table for better flexibility in custom tag naming. (5) GSF.TimeSeries.Adapters::IaonSession: Updated temporal configuration extraction to cache current temporal configuration so long as primary real-time configuration hasn't changed as an optimization. (6) GSF.TimeSeries.Transport: (a) modified to publisher to include updated times in default meta-data, (b) modified subscriber to track last update time and check publisher meta-data update times to only update local database records if meta-data was changed, (c) modified subscriber with SQL Server configuration to default to not using transactions to help avoid dead-lock victims (7) Various consistency and spelling corrections.ritchiecarroll committed 12 years agoe328c95
GSF.TimeSeries.Data: Updated SQL Server schema to include WITH (NOLOCK) in views to help reduce deadlock victim errors.ritchiecarroll committed 12 years ago5f56d65
GSF.TimeSeries: 1) Fixed an issue in DatabaseConfigurationLoader where an empty TrackedChange table would cause the configuration data set version to revert to 0. 2) Fixed an issue in DatabaseConfigurationLoader where records that already existed in the configuration data set would be added anyway when augmenting configuration. 3) Fixed various issues in the Oracle database script.StephenCWills committed 12 years ago3dd3d74
GSF.TimeSeries: Changed version numbers for configuration augmentation to unsigned long.StephenCWills committed 12 years ago58fe059
GSF.TimeSeries: Implemented configuration augmentation and conditional data operations for database configurations to speed up ReloadConfig for large databases.StephenCWills committed 12 years ago429ebdf
GSF.TimeSeries: Fixed the unique index on the ApplicationRole table in the SQL Server database script.StephenCWills committed 12 years agoe2812e0
GSF.TimeSeries: Added unique index to ApplicationRole in SQL scripts.StephenCWills committed 12 years agodf2dfa2
GSF.TimeSeries: Added unique index to the Name field of the SecurityGroup table.StephenCWills committed 12 years ago3e89de9
GSF.TimeSeries: Rolled-up schema changes to support remote ADO database setups and applied consistency changes to scripts to support roll-down to all time-series implementations.ritchiecarroll committed 13 years ago2dc3ce9
GSF.TimeSeries: Updated header for SQL Server schema script.ritchiecarroll committed 13 years ago65445f8
GSF.TimeSeries: Updated database schema scripts to consistently use ANSI encoding.ritchiecarroll committed 13 years agob510581
GSF.TimeSeries: Added time-series database schemas (as GSFSchema.*) to Grid Solutions Framework such that same schema can be rolled down to specific time-series implementations.ritchiecarroll committed 13 years ago8868f24