summaryrefslogtreecommitdiff
path: root/lib/schema.php
AgeCommit message (Collapse)Author
2010-11-01Include fulltext indexes in MySQL table createBrion Vibber
2010-10-29some sorta vaguely working bitsBrion Vibber
2010-10-29fix noticeBrion Vibber
2010-10-19Convert SamplePlugin to new-style table defs, tweak some stuff to test basic ↵Brion Vibber
checkschema
2010-10-19Starting to encapsulate some of the schema_version checksum / updater logicBrion Vibber
2010-10-19Initial foreign key setup supportBrion Vibber
2010-10-18Fix misnamed unique constraintBrion Vibber
2010-10-18tweak unique constraint setupBrion Vibber
2010-10-18MySQL schema: fix dropping unique indexes, add support for changing table ↵Brion Vibber
properties back from old code.
2010-10-18Drop reverseTypeMap from schemas; we're now doing the forward-mapping on the ↵Brion Vibber
canonical def before comparing
2010-10-15some more tweaking to do the mappings during filterDef; not totally sure I ↵Brion Vibber
like it
2010-10-15Cleanup on making the schema work for installer (not quite there yet)Brion Vibber
2010-10-15fix typo on params on Schema->createTable()Brion Vibber
2010-10-13logic fix in diffing :DBrion Vibber
2010-10-13suppress notices for non-present sectionsBrion Vibber
2010-10-13Filter table definitions to scrub out unsupported features before trying to ↵Brion Vibber
alter a table. This lets us skip those where we end up trying to change unsupported features.
2010-10-12some of the ensureTable stuff partially workingBrion Vibber
2010-10-11fix for column prefixes in table/index buildingBrion Vibber
2010-10-11fix for index genBrion Vibber
2010-10-11tweak for stringsBrion Vibber
2010-10-11Start reworking things to build create table stuff (can view via ↵Brion Vibber
dumpschema.php --build)
2010-10-08Merge branch 'schema-x' of /Users/brion/pages/mublog into schema-xBrion Vibber
2010-10-08Starting on adapting postgresql schema class to look stuff up in the new ↵Brion Vibber
drupalish format... Fetching basic column data and unique indexes. Still needs detail work, multi-value indexes, foreign keys, and distinguishing the primary key. Since we don't get comments and such, for cleaner comparisons we should probably do a filtering on supported features.
2010-10-07Some more poking at schema stuff, on the road towards a more portable ↵Brion Vibber
table-modification with the new schema bits
2010-10-07Some cleanup on detecting typesBrion Vibber
2010-08-16More schema work in progress... removing duped code from schema child ↵Brion Vibber
classes, rebuilding things a bit more (incomplete; non-working state)
2010-08-16first pass at columndef->drupal-style array converter (need to handle some ↵Brion Vibber
more things probably; untested)
2010-07-29allow schema to work on more than one connection (namely, the Status_network DB)James Walker
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
generated by cgit v1.2.3-54-g00ecf (git 2.45.2) at 2025-01-01 05:00:26 +0000