Versions and SVN revisions

From The Smartest Wiki
Jump to: navigation, search

Releases & Major Revisions

  • Version 0.3.5 stable = SVN revision 169
  • Version 0.3.6 stable = SVN revision 184
  • Version 0.3.7 RC1 = SVN revision 237
  • Version 0.3.7 stable = SVN revision 256
    • Moved user tokens to text file = SVN revision 285
    • Moved asset types to YAML file = SVN revision 288
    • Added template importer = SVN revision 303
    • Added site-specific models and upgraded Spyc = revision 323
  • Version 0.4 = SVN revision 473
  • Version 0.5 is projected for around revision 620

Database schemas by SVN revision

Schema 2

(Revision 66)

  • Added table ManyToManyLookups
  • Added fields textfragment_webid and textfragment_file

Schema 3

(Revision 90)

  • Added field page_is_section to Pages table to support section pages

Schema 4

(Revision 92)

  • Added field asset_user_id to table Assets
  • Added field asset_is_held to table Assets
  • Added field asset_held_by to table Assets
  • Added field asset_created to table Assets
  • Added field asset_modified to table Assets
  • Removed field asset_assettype_id from table Assets
  • Removed field asset_href from table Assets
  • Added field todoitem_ignore to table TodoItems
  • Added field todoitem_is_complete to table TodoItems

Schema 5

(Revision 93)

Schema 6

(Revision 94)

Schema 7

(Revision 100)

Schema 8

(Revision 144)

Schema 9

(Revision 154)

Schema 10

(Revision 194)

Schema 11

(Revision 214)

Schema 12

(Revision 224)

  • ALTER TABLE `Assets` CHANGE `asset_stringid` `asset_stringid` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
  • ALTER TABLE `Sets` ADD `set_filter_type` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
  • ALTER TABLE `Sets` ADD `set_filter_value` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
  • ALTER TABLE `AssetClasses` ADD `assetclass_filter_type` VARCHAR( 64 ) CHARACTER SET ASCII COLLATE ascii_general_ci NOT NULL DEFAULT 'SM_ASSETCLASS_FILTERTYPE_NONE' ;
  • ALTER TABLE `AssetClasses` ADD `assetclass_filter_value` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
  • ALTER TABLE `ItemProperties` DROP `itemproperty_model_id` ;
  • ALTER TABLE `ItemProperties` ADD `itemproperty_option_set_type` VARCHAR( 64 ) CHARACTER SET ASCII COLLATE ascii_general_ci NOT NULL DEFAULT 'SM_PROPERTY_FILTERTYPE_NONE' AFTER `itemproperty_defaultvalue` ;

Schema 13

(Revision 314)

  • ALTER TABLE `ItemClasses` DROP INDEX `itemclass_name`;
  • ALTER TABLE `ItemClasses` ADD `itemclass_shared` TINYINT( 1 ) NOT NULL AFTER `itemclass_site_id`;
  • ALTER TABLE `Settings` CHANGE `site_id` `setting_site_id` INT( 11 ) NOT NULL DEFAULT '0';
  • ALTER TABLE `Settings` ADD `setting_user_id` INT( 9 ) NOT NULL AFTER `setting_site_id`;
  • ALTER TABLE `PageUrls` ADD `pageurl_item_id` INT( 11 ) NOT NULL AFTER `pageurl_page_id`;
  • ALTER TABLE `Sites` DROP `site_error_title`;
  • ALTER TABLE `Sites` DROP `site_error_tpl` ;
  • ALTER TABLE `TagsObjectsLookup` ADD `taglookup_order_index` INT( 9 ) NOT NULL;
  • ALTER TABLE `Assets` ADD `asset_search_field` TEXT NOT NULL;

Schema 14

(Revision 334)

  • Added field setting_application_id to table Table/Settings
  • Added field setting_type to table Table/Settings
  • Added field setting_parent_id to table Table/Settings
  • Changed field setting_user_id to be INT(11) NOT NULL DEFAULT '0';
  • Added field site_internal_label to table Table/Sites
  • Inserted values for system metas database_minimum_revision and database_version

Schema 15

(Revision 344)

  • Dropped unused tables: `DataExports`, `PairingDetails`, `Pairings`, `SchemaDefinitions`, `Schemas`, `Vocabulary`
  • Added field asset_label to table Table/Assets
  • Added field asset_group_id to table Table/Assets
  • Added field asset_model_id to table Table/Assets
  • Added field page_last_built to table Table/Pages

Schema 16

(Revision 384)

  • Added field itemclass_primary_property_id to table ItemClasses
  • Added field dropdown_datatype to table DropDowns
  • Added field dropdown_is_system to table DropDowns
  • Added field itemproperty_order_index to table Table/ItemProperties
  • Added field itemclass_class_file_checksum to table ItemClasses
  • Added field mtmlookup_status_flag to table ManyToManyLookups
  • Added field assetclass_is_system to table AssetClasses
  • Added field asset_is_system to table Assets
  • Added field tag_language to table Assets
  • Changed field itemproperty_required to be VARCHAR( 16 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'FALSE'

Schema 17

(Revision 454)

  • Added field user_profile_pic_asset_id to table Users
  • Added field set_is_system to table Sets
  • Added field itemproperty_storage_migrated to table ItemProperties
  • Added field asset_is_subbed to table Assets
  • Added field user_is_smartest_account to table Users
  • Added field itemproperty_defaultformat to table ItemProperties
  • Added field list_item_id to table Lists
  • Added field textfragment_is_approved to table TextFragments
  • Added field textfragment_type to table TextFragments
  • Changed and renamed field asset_group_id to `asset_parent_id` INT( 11 ) NOT NULL

Schema 18

(Revision 464)

  • Changed field set_filter_type to VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT
  • Changed field set_filter_value to VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ;
  • Changed field set_name to VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT
  • Changed field site_name to VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT
  • Changed field mtmlookup_id to INT( 20 ) NOT NULL AUTO_INCREMENT
  • Changed field itempropertyvalue_id to INT( 20 ) NOT NULL AUTO_INCREMENT
  • Changed field item_name to VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT
  • Changed field item_slug to VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT
  • Added field itemclass_settings to table ItemClasses
  • Dropped field itempropertyvalue_binary from table ItemPropertyValues

Schema 19

(Revision 474)

  • ALTER TABLE `ItemProperties` DROP `itemproperty_setting`;
  • ALTER TABLE `ItemProperties` DROP `itemproperty_setting_value`;
  • ALTER TABLE `ItemClasses` ADD `itemclass_default_sort_property_id` INT( 11 ) NOT NULL AFTER `itemclass_default_description_property_id`;
  • ALTER TABLE `ItemProperties` ADD `itemproperty_info` TEXT NOT NULL AFTER `itemproperty_defaultformat`;
  • ALTER TABLE `ItemClasses` ADD `itemclass_default_thumbnail_property_id` INT( 11 ) NOT NULL AFTER `itemclass_default_sort_property_id`;
  • ALTER TABLE `Assets` ADD `asset_variant_id` INT( 9 ) UNSIGNED NOT NULL AFTER `asset_parent_id`;
  • ALTER TABLE `PagePropertyValues` ADD `pagepropertyvalue_item_id` MEDIUMINT( 9 ) UNSIGNED NOT NULL AFTER `pagepropertyvalue_page_id`;
  • ALTER TABLE `TextFragments` CHANGE `textfragment_type` `textfragment_type` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'SM_TEXTFRAGMENTTYPE_CURRENT_VERSION';
  • ALTER TABLE `AssetClasses` DROP `assetclass_assettype_id` ;
  • ALTER TABLE `ItemProperties` ADD `itemproperty_share_values_autocomplete` TINYINT( 1 ) NOT NULL AFTER `itemproperty_info`;
  • ALTER TABLE `Pages` DROP `page_url`;
  • ALTER TABLE `Items` ADD `item_alt_title_tag` VARCHAR( 255 ) NOT NULL AFTER `item_slug`;
  • ALTER TABLE `Items` ADD `item_use_alt_title_tag` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `item_alt_title_tag`;
  • ALTER TABLE `PageUrls` ADD `pageurl_redirect_type` VARCHAR( 32 ) NOT NULL AFTER `pageurl_type`;
  • ALTER TABLE `Users` ADD `user_twitter_handle` VARCHAR( 32 ) NOT NULL AFTER `user_website`;
  • ALTER TABLE `Users` ADD `user_bio_asset_id` INT( 9 ) UNSIGNED NOT NULL AFTER `user_bio`;
  • ALTER TABLE `Sites` ADD `site_logo_image_asset_id` INT( 11 ) UNSIGNED NOT NULL AFTER `site_logo_image_file`;
  • ALTER TABLE `Sites` DROP `site_automatic_urls`;
  • ALTER TABLE `Sites` ADD `site_unique_id` VARCHAR( 23 ) NOT NULL AFTER `site_id`;
  • ALTER TABLE `Users` ADD `user_password_salt` VARCHAR( 40 ) NOT NULL AFTER `password`;
  • ALTER TABLE `Users` ADD `user_invert_name_order` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `user_lastname`;
  • ALTER TABLE `Users` ADD `user_password_last_changed` INT( 11 ) UNSIGNED NOT NULL AFTER `user_password_salt`;
  • ALTER TABLE `Sets` CHANGE `set_is_system` `set_is_system` TINYINT( 1 ) NOT NULL DEFAULT '0';
  • ALTER TABLE `Users` ADD `user_password_change_required` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `user_password_last_changed`;
  • ALTER TABLE `Sets` ADD `set_is_hidden` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `set_is_system`;
  • ALTER TABLE `Assets` ADD `asset_is_hidden` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `asset_is_system`;
  • ALTER TABLE `UsersTokensLookup` ADD `utlookup_order_index` INT( 9 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `utlookup_is_global`;
  • ALTER TABLE `AssetClasses` ADD `assetclass_parent_id` INT( 11 ) UNSIGNED NOT NULL AFTER `assetclass_info`;
  • ALTER TABLE `ItemPropertyValues` ADD `itempropertyvalue_name` VARCHAR( 64 ) NOT NULL AFTER `itempropertyvalue_property_id`;
  • ALTER TABLE `ItemClasses` ADD `itemclass_is_system` TINYINT( 1 ) NOT NULL DEFAULT '0';
  • ALTER TABLE `ItemClasses` ADD `itemclass_is_hidden` TINYINT( 1 ) NOT NULL DEFAULT '0';
  • ALTER TABLE `ItemClasses` ADD `itemclass_created_from_buildkit` VARCHAR( 64 ) NOT NULL;
  • ALTER TABLE `ItemProperties` ADD `itemproperty_last_regularized` INT( 11 ) NOT NULL AFTER `itemproperty_storage_migrated`;
  • ALTER TABLE `ItemClasses` ADD `itemclass_uses_draft_properties` TINYINT( 1 ) NOT NULL DEFAULT '1' AFTER `itemclass_settings`;
  • ALTER TABLE `ItemClasses` ADD `itemclass_item_webid_format` VARCHAR( 32 ) NOT NULL AFTER `itemclass_varname`;
  • ALTER TABLE `Lists` CHANGE `list_global` `list_global` TINYINT( 1 ) NOT NULL DEFAULT '1';
  • ALTER TABLE `PageProperties` CHANGE `pageproperty_type` `pageproperty_type` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ;
  • DROP TABLE `UserTokens`;

Schema 20

(Revision 494)

  • ALTER TABLE `Pages` ADD `page_icon_image_id` INT( 11 ) NOT NULL AFTER `page_icon_image`;
  • ALTER TABLE `Assets` ADD `asset_info` TEXT NOT NULL AFTER `asset_parameter_defaults`;
  • ALTER TABLE `PageUrls` ADD `pageurl_site_id` INT( 11 ) NOT NULL AFTER `pageurl_item_id`;
  • ALTER TABLE `PageUrls` ADD `pageurl_num_hits` INT( 11 ) UNSIGNED NOT NULL;

Schema 21

(Revision 584)

Changes:

  • removed index on AssetClasses.assetclass_name
  • added AssetClasses.assetclass_is_sitewide (tinyint 1 or default 0) for FS#521
  • added PageProperties.pageproperty_is_sitewide (tinyint 1 or default 0) for FS#522
  • added PagePropertyValues.pagepropertyvalue_language
  • added PageUrls.pageurl_language
  • added PageUrls.pageurl_asset_id for one-time asset download urls
  • added PageUrls.pageurl_expires for tracking if urls have expired
  • added PageUrls.pageurl_name for specifying specific urls in links
  • added Pages.page_pdf_version_asset_id
  • added PageLayoutPresetDefinitions.plpd_template_id for simple list definitions
  • added UsersTokensLookup.utlookup_granted_by_user_id
  • added Assets.asset_thumbnail_id for FS#497
  • added Assets.asset_submitted_from_public - for accepting asset submissions (but not trusting them)
  • added Assets.asset_public_status_trusted - for storing whether publicly submitted assets have been trusted or not
  • did not add Assets.asset_orig_created_for - for keeping track of where and why an asset was originally created - an id of a page or item. Will use asset_info instead.
  • did not add Assets.asset_orig_created_for_type - for knowing whether the asset was originally created for an item or a page. Will use asset_info instead.
  • did not add Assets.asset_num_public_downloads - for keeping track of how many times the public download link of an asset has been used successfully. Will use asset_info instead.
  • added Items.item_submitted_from_public - for accepting item submissions (but not trusting them)
  • added Items.item_public_status_trusted - for storing whether publicly submitted items have been trusted or not
  • added Items.item_type - in case other types of items need to be created.
  • added Tags.tag_site_id so that site specific tags can be implemented. 0 (default) is all-sites.
  • added Tags.tag_type so that different forms of taxonomy (such as "sections" or "categories") might be implemented.
  • changed Users.user_activated to tinyint(1) as it is a boolean.
  • added Users.user_info for storing serialised data on users
  • added Users.user_oath_consumer_token
  • added Users.user_oath_consumer_secret
  • added Users.user_oath_access_token
  • added Users.user_oath_access_token_secret
  • added Users.user_oath_service_id
  • added Users.user_type (SM_USERTYPE_SYSTEM_USER, SM_USERTYPE_EXTERNAL_USER, SM_USERTYPE_OAUTH_CLIENT_INTERNAL - for Smartest as a consumer, and SM_USERTYPE_OAUTH_CLIENT_EXTERNAL - for Smartest as a service provider)
  • added Sets.set_webid
  • added Sets.set_feed_sort_field
  • added Sets.set_feed_sort_direction - both of these for making static sets into feeds.
  • added Sets.set_feed_nonce - so that the feed can only be downloaded if the nonce is given
  • added Sets.set_cover_asset_id - so that if the feed is syndicated it can display a logo (FS#526) and so asset groups can have a cover image (FS#525).
  • added ItemClasses.itemclass_blog_mode
  • added ItemPropertyValues.itempropertyvalue_parent_value_id to allow for compound property values (See FS#476)
  • did not add ItemClasses.itemclass_blog_mode_text_property_id because itemclass_primary_property_id will be used
  • add Sites.site_url_prefix - so that different sites can share a domain, but precede their URLs with different paths
  • dropped unused Sites.site_logo_image_file
  • dropped unused Sites.site_root
  • lengthen all webid fields to a maximum of 36 to allow Universally Unique Identifiers (UUID) as per ISO/IEC 9834-8:2012
  • make primary keys of ItemPropertyValues ManyToManyLookups SetsItemsLookup unsigned