summaryrefslogtreecommitdiff
path: root/lib/schema.php
AgeCommit message (Collapse)Author
2010-03-12Fixes for updating indices, charset/collation and engine type on ↵Brion Vibber
plugin-created tables. Under MySQL, new tables will be created as InnoDB with UTF-8 (utf8/utf8_bin) same as core tables. Existing plugin tables will have table engine and default charset/collation updated, and string columns will have charset updated, at checkschema time. Switched from 'DESCRIBE' to INFORMATION_SCHEMA for pulling column information in order to get charset. A second hit to INFORMATION_SCHEMA is also needed to get table properties. Indices were only being created at table creation time, which ain't so hot. Now also adding/dropping indices when they change. Fixed up some schema defs in OStatus plugin that were a bit flaky, causing extra alter tables to be run. TODO: Generalize this infrastructure a bit more up to base schema & pg schema classes.
2010-01-31move schema.type.php to typeschema.php like other filesEvan Prodromou
2010-01-30removed describeTable from base class, and fixed it up in pgsqlBrenda Wallace
2010-01-30getTableDef() mostly working in postgresBrenda Wallace
2010-01-30move the schema DDL sql off into seperate files for each db we supportBrenda Wallace
2010-01-05Support an 'extra' clause when definining a column (e.g.: 'on updateZach Copley
CURRENT_TIMESTAMP').
2010-01-04Fix for auto_increment parameter in auto-created tables via checkschema.Brion Vibber
Update FeedSub plugin for non-Plugin_DataObject setup and working checkschema updates.
2009-12-03Code style cleanup: dropped some unnecessary =& reference assignments where ↵Brion Vibber
they're used only out of habit for PHP 4-style object semantics
2009-11-25Revert "Allow plugin DB_DataObject classes to not have to use the .ini file ↵Zach Copley
by overriding keys(), table(), and sequenceKey() for them" This reverts commit a373d07ae00b878f47970f2e4a7d86c6ec3a65cf. Conflicts: classes/statusnet.ini lib/schema.php plugins/Authentication/AuthenticationPlugin.php plugins/OpenID/OpenIDPlugin.php plugins/UserFlag/UserFlagPlugin.php
2009-11-24Break TableDef, ColumnDef classes to separate files so autoloader can find them.Brion Vibber
With $config['db']['schemacheck'] set to 'script' in live deployment, Schema class wasn't being preloaded for us; the uses of TableDef by plugins for DataObject configuration would then fail because the class wasn't loaded. Broken to separate files, the autoloader can find all classes in either case. PHP Fatal error: Class 'TableDef' not found in /var/www/statusnet/plugins/OpenID/User_openid.php on line 43, referer: http://identi.ca/brionv/all
2009-11-16Allow plugin DB_DataObject classes to not have to use the .ini file by ↵Craig Andrews
overriding keys(), table(), and sequenceKey() for them
2009-10-02make lib/schema.php phpcs-cleanEvan Prodromou
2009-10-01Some bug fixesEvan Prodromou
The $tomod variable wasn't set, and the ColumnDef constructor didn't work without any args. These are fixed.
2009-10-01add some more methods to SchemaEvan Prodromou
2009-09-23use schema tool to create a tableEvan Prodromou
2009-09-23statusize schema-related modulesEvan Prodromou
2009-09-23make table def method of schema code workEvan Prodromou
2009-09-23start a module for schema managementEvan Prodromou