History of SchemaChangelog
Version 12
Schema changes
This is an ongoing list of *any* changes to *any* DataDict array in a schema_inc in *any* package.
Date | Table | Reason | who |
2-DEC-2004 | tiki_categorized_objects | standardized naming and type to match user_objectpermissions | spiderr |
Update SQL: | ALTER TABLE tiki_categorized_objects RENAME type TO object_type; ALTER TABLE tiki_categorized_objects ADD COLUMN object_id INTEGER; UPDATE tiki_categorized_objects SET object_id=(SELECT content_id FROM tiki_blog_posts WHERE post_id=tiki_categorized_objects.obj_id); UPDATE tiki_categorized_objects SET object_type='tikiblogpost' WHERE object_type='blogpost'; UPDATE tiki_categorized_objects SET object_id=(SELECT content_id FROM tiki_content WHERE title=tiki_categorized_objects.obj_id AND content_type_guid='tikipage'); UPDATE tiki_categorized_objects SET object_type='tikipage' WHERE object_type='wiki page'; ALTER TABLE tiki_categorized_objects ALTER object_id SET NOT NULL; ALTER TABLE tiki_categorized_objects DROP obj_id; | ||
1-DEC-2004 | users_objectpermissions | Changed object_id to be of type I4. Added object_type to be part of the primary key | drewslater |
29-NOV-2004 | tiki_history | added format_guid so that format can change between versions | spiderr |
29-NOV-2004 | tiki_blobs | added user_id column after much pondering with drewslater | spiderr |
29-NOV-2004 | tiki_files | added user_id column after much pondering with drewslater | spiderr |
tiki_semaphores | was accidentally removed. added back, and some columns renamed for minimal name collision | spiderr | |
18-NOV-2004 | tiki_copyrights | overlooked user_name converted to user_id | spiderr |
tiki_semaphores | was accidentally removed. added back, and some columns renamed for minimal name collision | spiderr | |
tiki_tags | data column changed from BLOB to standard TEXT | spiderr | |
tiki_content_types | now has complete columns to reverse engineer an content_id | spiderr | |
tiki_plugins | has maintainer_url added | spider | |
tiki_structures | was moved to Liberty from wiki and generalized with content_id's | spider |