summaryrefslogtreecommitdiffstats
path: root/application/migrations
AgeCommit message (Collapse)AuthorFilesLines
2016-02-26Fix MYSQL error in migration 14/15Florian Pritz2-24/+16
Error was: You can't specify target table 'testsuite_prefix_file_storage' for update in FROM clause The new code is ported from the existing postgres migration. Signed-off-by: Florian Pritz <bluewind@xinu.at>
2015-09-20Migration 16: Increase length of ci_session.ip_address for IPv6Florian Pritz1-0/+27
Reported-by: Michael Mueller <michael.mueller@selfnet.de> Signed-off-by: Florian Pritz <bluewind@xinu.at>
2015-09-20postgres: Add missing prefix to index creationFlorian Pritz7-11/+11
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2015-09-20Implement migration 14 for postgresFlorian Pritz2-47/+94
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2015-09-20Fix missing prefix in migration 7Florian Pritz1-1/+1
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2015-05-22Fix missing db prefix in migration0.9.0Florian Pritz2-12/+12
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2015-05-22Remove unneeded duplicates in file_storageFlorian Pritz2-0/+79
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2015-05-21migration 14: Fix error if file was already renamedFlorian Pritz1-1/+3
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2015-05-21Support multiple files with the same hashFlorian Pritz1-14/+35
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2015-02-03Support database table prefixesFlorian Pritz14-120/+212
This also cleans up some inconsistencies with quotes. Signed-off-by: Florian Pritz <bluewind@xinu.at>
2015-02-03Use exceptions instead of show_errorFlorian Pritz2-2/+2
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2014-10-19Clean up the postgres changesFlorian Pritz3-9/+4
Style cleanup and some regression fixes Signed-off-by: Florian Pritz <bluewind@xinu.at>
2014-09-19Optimizing multipaste tablesRafael Bodill1-17/+7
2014-09-19apikeys.created should be timestamp with default now()Rafael Bodill1-1/+1
2014-09-19No column based encoding. Reverting dbforge migrationRafael Bodill1-15/+31
2014-09-18Correcting bracket style for 'if'Rafael Bodill13-95/+56
2014-09-18Migrations support for PostgreSQLRafael Bodill13-168/+426
2014-08-29add multipaste supportFlorian Pritz1-0/+36
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2014-04-17migration 12: remove dependencies on users table againFlorian Pritz1-9/+0
When using external authentication databases (ldap, fluxbb, ..) the users table is empty so adding the constraints won't work. Signed-off-by: Florian Pritz <bluewind@xinu.at>
2014-04-15Use alter table to rename tablesFlorian Pritz1-2/+2
For some strange reason using "rename table" causes an exception in system/database/DB_driver.php:query() because it trys to call num_rows() on a boolean. Using "alter table" works. According to the php manpage mysqli::query() it should return a boolean too, but whatever... Signed-off-by: Florian Pritz <bluewind@xinu.at>
2014-04-15migration 12: Remove tablename, fix ordering problemFlorian Pritz1-6/+6
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2014-04-12Add foreign keys to databaseFlorian Pritz1-0/+29
Changing the referrer value for the root admin from 0 to NULL to make the foreign key check work. Signed-off-by: Florian Pritz <bluewind@xinu.at>
2014-02-21Implement multiple access levels for api keysFlorian Pritz1-0/+19
This allows to use an api key to write a completly standalone client. Signed-off-by: Florian Pritz <bluewind@xinu.at>
2013-09-22Use InnoDB for the files tablePierre Schmitz1-0/+16
The files table was MyISAM even though all other tables were InnoDB. We should avoid mixing types here (backups, transactions and performance). Signed-off-by: Pierre Schmitz <pierre@archlinux.de> Signed-off-by: Florian Pritz <bluewind@xinu.at>
2013-08-11Add API key supportFlorian Pritz1-0/+24
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2013-07-13Add profile page to allow changing the upload id limitsFlorian Pritz1-0/+31
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2013-01-24Repurpose invitations table to actionsFlorian Pritz1-0/+37
This can be used to track data for all kinds of one-time actions like invitations and password resets. Signed-off-by: Florian Pritz <bluewind@xinu.at>
2012-07-26fix typo in migration "add username index"Florian Pritz1-1/+1
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2012-07-12Add unique index for users.usernameFlorian Pritz1-0/+21
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2012-05-03remove password column from `files`Florian Pritz1-0/+21
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2012-04-11Add filesize to history viewFlorian Pritz1-0/+22
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2012-04-10Fix syntax error in migration 2Florian Pritz1-1/+1
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2012-04-09Implement simple referral systemFlorian Pritz1-0/+33
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2012-04-09start working on usersFlorian Pritz1-0/+46
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2011-12-17use migrations; automatically set up the databaseFlorian Pritz1-0/+27
Signed-off-by: Florian Pritz <bluewind@xinu.at>