);
+#
+# Structure for table tt_work_currencies.
+# This table keeps currencies supported by remote work plugin.
+#
+CREATE TABLE `tt_work_currencies` (
+ `id` int(10) unsigned NOT NULL, # currency id
+ `name` varchar(10) NOT NULL, # currency name (USD, CAD, etc.)
+ PRIMARY KEY (`id`)
+);
+
+# Create an index that guarantees unique work currencies.
+create unique index currency_idx on tt_work_currencies(`name`);
+
+INSERT INTO `tt_work_currencies` (`id`, `name`) VALUES ('1', 'USD'), ('2', 'CAD'), ('3', 'AUD'), ('4', 'EUR'), ('5', 'NZD');
+
+
+#
+# Structure for table tt_work_categories. WORK IN PROGRESS!
+# This table keeps work categories supported by remote work plugin.
+#
+# CREATE TABLE `tt_work_categories` (
+# `id` int(10) unsigned NOT NULL, # category id
+# `parent_id` int(10) unsigned default NULL, # parent category id
+# `level` tinyint(4) default 0, # sub-category level
+#
+# Localized name fields below for all supported languages?
+# `name_en` varhar(64) NOT NULL, # English.
+# `name_de` varhar(64) default NULL, # German.
+# `name_fr` varhar(64) default NULL, # French.
+# `name_ru` varhar(64) default NULL, # Russian.
+#
+# PRIMARY KEY (`id`)
+# );
+
+
#
# Structure for table tt_site_config. This table stores configuration data
# for Time Tracker site as a whole.
PRIMARY KEY (`param_name`)
);
-INSERT INTO `tt_site_config` (`param_name`, `param_value`, `created`) VALUES ('version_db', '1.19.0', now()); # TODO: change when structure changes.
+INSERT INTO `tt_site_config` (`param_name`, `param_value`, `created`) VALUES ('version_db', '1.19.2', now()); # TODO: change when structure changes.