
Reference 153
© Copyright 2003-2015 C-R Media All Rights Reserved.
5.2 Database Reference
The XStudio Database is a collection of files called "tables" and is used to store components of
automation operations, including tasks, actions, resources used by tasks and scheduled events. There
are also tables for song title and artist information (music database) and broadcast log historical
information.
A second database, known as the XStudio Inventory Database, is also used. This database is a
collection of tables used to store current audio inventory information.
5.2.1 Database Files Location
As a default, XStudio database files are located in a folder immediately under the XStudio installation
folder. The folder is named "Data" and is automatically created when XStudio is launched for the very
first time.
A number of files are created in the Data folder when XStudio is first launched; these consist of the
tables and support files that comprise the database.
Database files, referred to as the XStudio Database, are owned exclusively by XStudio as a default;
when XStudio is running, no other application is allowed access to these files. Any attempts to open,
copy or delete these files will be denied by the operating system, as they are already opened
exclusively by XStudio.
You can make the data available to other applications by setting the Allow Remote Administration
option in XStudio preferences. When Remote Administration is enabled, applications like XStudio
Administration can be used to remotely update the database.
Files in the Data folder should never be deleted or otherwise modified, as loss
of XStudio functionality or corrupted data will result, causing XStudio to behave
unpredictably.
When XStudio is not running, the database files can be copied, if desired, for archiving, cloning or
backup purposes.
5.2.2 Database Tables
The XStudio database is a collection of tables, stored on-disk as one file per table. This section
documents tables that are a part of the database, including technical information on fields contained in
each table, their type and usage.
All tables are binary data files having a file extension of "NX1". Files are created and maintained using
NexusDB, created by Nexus Database Systems Pty Ltd. NexusDB is a fast, flexible, reliable database
engine embedded in XStudio and supplied royalty-free to the end-user. There's also the option to run
NexusDB as a stand-alone server, implementing true multi-user, client/server database operations.
5.2.2.1 Actions Table
The Actions table contains information about all defined Actions. Its on-disk name is: Actions.nx1
Actions Table Field Definitions
The fields contained in the Actions table, including field type and size (if applicable).
Kommentare zu diesen Handbüchern