summaryrefslogtreecommitdiffstats
path: root/application/migrations
AgeCommit message (Collapse)AuthorFilesLines
2017-10-28mysql: Enable full UTF8 supportFlorian Pritz1-0/+27
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2017-09-26Fix incorrect table name in migration 20 for postgresFlorian Pritz1-1/+1
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2017-09-26Migration 20: Fix id column sizeFlorian Pritz1-1/+4
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2017-09-16Update ci_session table for CI3Florian Pritz1-0/+42
Signed-off-by: Florian Pritz <bluewind@xinu.at>
2017-07-10Fix chunk update for filesizeshashworks1-1/+2
This includes the where limitation of the update query in the total limit of the chunk for loop.
2017-07-10Update filesizes after changing filesize db typehashworks1-0/+23
This updates all wrong filesizes after db migration 19 (`filesize` type change to `bigint`). It will only update files with a filesize of 2147483647 byte since the database set the max integer value as the filesize if the file was > 2147483647 byte.
2017-07-10Use bigint for filesize in databasehashworks1-0/+27
The current type, integer, only stores numerics up to 2147483647. Since filebin stores the size in byte MySQL will only write up to 2GB in there, PostgreSQL failes by default for files >2GB. The new type bigint allows file sizes up to ~9223 petabyte.
2016-08-20Migration 18: Allow user info to be nulledFlorian Pritz1-0/+31
This allows us to safely delete users without breaking referrer information. Signed-off-by: Florian Pritz <bluewind@xinu.at>
2016-03-29Increase size of password field in DBFlorian Pritz1-0/+27
The php documentation for password_hash recommends 255. Signed-off-by: Florian Pritz <bluewind@xinu.at>
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>