postfixadmin

Commit Graph

Author	SHA1	Message	Date
David Goodwin	40417e9247	upgrade.php: reindent; fix postgresql fetchmail stuff git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@352 a1433add-5e2c-0410-b055-b7f2511e0802	18 years ago
Christian Boltz	31963707b2	upgrade.php: - create fetchmail table (upgrade_344_mysql) - TODO: create fetchmail table for pgsql (empty function already included ;-) fetchmail.php: - removed CREATE TABLE statement - it's now created by upgrade.php git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@344 a1433add-5e2c-0410-b055-b7f2511e0802	18 years ago
David Goodwin	56b39454cf	upgrade.php: fix issue of mysql tables not being created on initial install git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@340 a1433add-5e2c-0410-b055-b7f2511e0802	18 years ago
David Goodwin	36109783fa	upgrade.php: fix bug in mysql vacation notification table as reported by gabbs on irc (thanks!) git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@339 a1433add-5e2c-0410-b055-b7f2511e0802	18 years ago
David Goodwin	bb62951377	upgrade.php: support creating PG db if it does nto exist; this means DATABASE_PGSQL.TXT is now obsolete git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@324 a1433add-5e2c-0410-b055-b7f2511e0802	18 years ago
Christian Boltz	fedca43854	upgrade.php: - print query (debug mode) _before_ executing it - upgrade_318_mysql: include CONSTRAINT in CREATE TABLE - otherwise dropping it afterwards fails... git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@319 a1433add-5e2c-0410-b055-b7f2511e0802	18 years ago
Christian Boltz	8b1ab537fc	upgrade.php: - creation of vacation_notification table moved to upgrade_318_mysql because the query in upgrade_81_mysql was broken (key length vs. utf8 charset) - added upgrade_318_mysql which finally creates a working vacation_notification table NOTE: Users who used workarounds to create this table before might need to drop it manually before upgrade works. This should fix http://sourceforge.net/tracker/index.php?func=detail&aid=1828857&group_id=191583&atid=937964 and probably also http://sourceforge.net/tracker/index.php?func=detail&aid=1875897&group_id=191583&atid=937964 additional minor fixes: - "create table config" for pgsql now uses table_by_key() - some whitespace changes - set default charset (latin1) in upgrade_5_mysql (instead of using the system default) git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@318 a1433add-5e2c-0410-b055-b7f2511e0802	18 years ago
Christian Boltz	79048b0dfe	upgrade.php: - integrated table creation, based on SVN r1 DATABASE_MYSQL.txt - added some comments about possible errors that can be ignored (I'm dreaming of having an error "whitelist" and displaying all other errors - but not for 2.2 ;-) DATABASE_MYSQL.TXT - added up-to-date database setup instructions - disabled all SQL code (will be deleted later) git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@317 a1433add-5e2c-0410-b055-b7f2511e0802	18 years ago
David Goodwin	7279fb2ac5	upgrade.php: needless echo removed; tested on another PostgreSQL database - worked fine git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@286 a1433add-5e2c-0410-b055-b7f2511e0802	18 years ago
David Goodwin	6c758eb4db	upgrade.php: fix pgsql isms - i..e check that fields exist before trying to remove them, likewise for tables; minor syntax fixes in upgrade etc; tested and works for me git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@278 a1433add-5e2c-0410-b055-b7f2511e0802	18 years ago
David Goodwin	36657401c7	upgrade.php: should work for postgresql now git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@277 a1433add-5e2c-0410-b055-b7f2511e0802	18 years ago
David Goodwin	3c2bf37f4a	upgrade.php: implemented some of the postgresql functions; have not tested it yet though git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@271 a1433add-5e2c-0410-b055-b7f2511e0802	18 years ago
Christian Boltz	3bbc918ca4	upgrade.php: - change "edit_alias_state" to "edit_alias_active" in log table (was changed in r90) https://sourceforge.net/tracker/index.php?func=detail&aid=1830376&group_id=191583&atid=937964 git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@231 a1433add-5e2c-0410-b055-b7f2511e0802	19 years ago
Christian Boltz	b54e71f235	- rename placeholder {UTF_8} to the more obvious {UTF-8} This also fixes my last commit ;-) git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@202 a1433add-5e2c-0410-b055-b7f2511e0802	19 years ago
Christian Boltz	f35d0bee7e	- completed upgrade_81_mysql() (several changes in vacation table) git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@201 a1433add-5e2c-0410-b055-b7f2511e0802	19 years ago
Christian Boltz	096a5ffbe6	- upgrade_90(): replace spaces with underscore in log.action (change was caused by translatable logging) git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@182 a1433add-5e2c-0410-b055-b7f2511e0802	19 years ago
Christian Boltz	29e2d63422	- fixed some SQL syntax errors - debug output now includes the query git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@175 a1433add-5e2c-0410-b055-b7f2511e0802	19 years ago
Christian Boltz	16178cab58	- next try to expand $Revision$ in upgrade.php :-/ git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@174 a1433add-5e2c-0410-b055-b7f2511e0802	19 years ago
Christian Boltz	ce2689dd4f	upgrade.php: - create config table at startup (not nice, but works) - changed _do_upgrade to use "for ($i = $current_version +1; $i <= $target_version; $i++)" loop and function_exists() - added support for upgrade_<number>>_mysql() and upgrade_<number>_pgsql() functions for database-specific changes - added function db_query_parsed(), idea taken from serendipity's include/db/*.php serendipity_db_schema_import() - added function _drop_index() - MySQL and PgSQL syntax differs too much on this - added pre-2.1 database updates (DOCUMENTS/TABLE_BACKUP_MX.TXT and DOCUMENTS/TABLE_CHANGES.TXT) - added all database changes between 2.1 and current SVN. Everything since the move to sourceforge has the revision number in the function name. (still several TODOs left) git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@172 a1433add-5e2c-0410-b055-b7f2511e0802	19 years ago
David Goodwin	aa919e242d	upgrade.php: test edition of a db upgrade script, based loosely around what Drupal uses git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@170 a1433add-5e2c-0410-b055-b7f2511e0802	19 years ago

20 Commits (postfixadmin-2.2.0)