Release Notes

Audit Log: New audit log level: 4. Read access to revisions will be logged.

Game UI: 'Changesets' view is now available. The new view just allow to show changesets and filter them. No more actions implemented yet.

GTK & Mac GUI's: The 'Delete' context menu option is now available on the 'Pending changes' view.

Server: SQL Server database creation command can now be customized with user-defined settings.

A new key in 'db.conf' file, named 'DatabaseCreationCommands' is available for this purpouse.

The command must be written in a single line. The following 'db.conf' file example is written in several lines for better readability:

<?xml version="1.0"?>
<DbConfig>
<ProviderName>sqlserver</ProviderName>
<ConnectionString>SERVER=localhostSQLEXPRESS;User Id=username;Pwd=password;DATABASE={0};</ConnectionString>
<DatabaseCreationCommands>
CREATE DATABASE @PlasticDatabase ON PRIMARY
(NAME=@PlasticDatabase_custom, FILENAME='@PlasticDefaultDatabaseFile', SIZE=10, FILEGROWTH=100) 
LOG ON (NAME=@PlasticDatabase_log, FILENAME='@PlasticDefaultLogFile', SIZE=10, FILEGROWTH=100) 
COLLATE @PlasticDefaultCollation
</DatabaseCreationCommands>
<DatabasePath></DatabasePath>
</DbConfig>

The following 'default values' identifiers are available in order to build custom database creation commands:

* @PlasticDatabase -> The default database name. It's mandatory to use this identifier in the 'CREATE DATABASE' command. Otherwise the Plastic SCM server won't work properly.

* @PlasticDefaultDatabaseFile -> Default database file. (A path that includes @PlasticDatabase as a part of the database file name can be used instead).

* @PlasticDefaultLogFile -> Default log file path. (A path that includes @PlasticDatabase as a part as a part of the file name can be used instead. Also, appending a suffix to the @PlasticDefaultDatabaseFile identifier can be used. Example: @PlasticDefaultDatabaseFile.log).

* @PlasticDefaultCollation -> Its value is the collation defined in the 'db.conf' file with the 'DatabaseCollation' tag. If 'DatabaseCollation' tag is not present, in will take the default collation used by Plastic SCM server, which is: 'Latin1_General_CI_AI'. The collation in the custom command will take precedence over the value of 'DatabaseCollation' tag.

Important remark: A valid collation in the custom creation command must be specified if the SQL Server's default collation is not Case Insensitive or Accent Insensitive. Valid collations are: 'Case Insenstive' and 'Accent Insensitive' ('CI_AI' or 'KI_KS' collation suffixes). Otherwise, the Plastic SCM server won't work properly.

The default command that Plastic SCM server uses to create databases is the following:

CREATE DATABASE @PlasticDatabase ON PRIMARY
(NAME=@PlasticDatabase, FILENAME='@PlasticDefaultDatabaseFile', SIZE=10, FILEGROWTH=100)
LOG ON (NAME=@PlasticDatabase_log, FILENAME='@PlasticDefaultLogFile', SIZE=10, FILEGROWTH=100)
COLLATE @PlasticDefaultCollation

Examples (Remember to write them in a single line. The examples below are written in several lines for better readability):

* Multiple commands. Must be separated with ";" and specified in a single line. The "GO" clause can't be used.

CREATE DATABASE @PlasticDatabase ON PRIMARY
(NAME=@PlasticDatabase, FILENAME='@PlasticDefaultDatabaseFile', SIZE=10, FILEGROWTH=100)
LOG ON (NAME=@PlasticDatabase_log, FILENAME='@PlasticDefaultLogFile', SIZE=10, FILEGROWTH=100)
COLLATE @PlasticDefaultCollation;ALTER DATABASE @PlasticDatabase SET PAGE_VERIFY CHECKSUM;ALTER DATABASE @PlasticDatabase SET ANSI_WARNINGS OFF

* Change database file location and log names and paths:

CREATE DATABASE @PlasticDatabase ON PRIMARY
(NAME=@PlasticDatabase, FILENAME='C:/databases/dbs/@PlasticDatabase.db', SIZE=10, FILEGROWTH=100)
LOG ON (NAME=PlasticLog_@PlasticDatabase, FILENAME='C:/databases/logs/@PlasticDatabase.log', SIZE=10, FILEGROWTH=100)
COLLATE @PlasticDefaultCollation

* Change size parameters or collation:

CREATE DATABASE @PlasticDatabase ON PRIMARY
(NAME=@PlasticDatabase, FILENAME='@PlasticDefaultDatabaseFile', SIZE=100, FILEGROWTH=50)
LOG ON (NAME=@PlasticDatabase_log, FILENAME='@PlasticDefaultLogFile', SIZE=100, FILEGROWTH=50)
COLLATE SQL_Latin1_General_CP1_CS_AS