summaryrefslogtreecommitdiffstats
path: root/includes/admin/register_db_tables.php
Commit message (Collapse)AuthorAgeFilesLines
* Clean up, fix and rename db tables.Harald Eilertsen2021-09-161-49/+19
| | | | | | | | | | | | | | | | | This patch got a bit more involved than what was originally planned, but since we're messing with the tables I decided to do it all right away. - Moves the constraint definition to the CREATE TABLE statement for the concerts table. This replaces the existing KEY definition that it had. - Make sure the venues table is created before the concerts table so that the above mentioned constraint definition works. - Rename the tables. Use the wpdb-prefix and make the name a bit prettier. This caused some changes in the Concert and Venue classes, and for slightly silly reasons some test classes. The code actually turned out better (for the most part), but some refactoring can still be done. The column names remains unchanged for now.
* Reinsert created and updated columns for venues.Harald Eilertsen2021-09-161-0/+2
| | | | Was accidentally dropped during rewrite of base schema.
* Facelift of database table creation to use create tables instead of ↵AndreaChirulescu2021-09-131-323/+17
| | | | versioning. First attempt
* Don't error if obsolete indexes or keys are already deleted.Harald Eilertsen2021-09-051-2/+2
|
* Drop obsolete database tables.Harald Eilertsen2021-09-041-97/+6
| | | | | These tables are no longer being used, so let's remove them and the code to add them.
* Add timestamp columns to concerts and venues.Harald Eilertsen2021-09-041-2/+17
| | | | To keep track of creation and modification times for each record.
* Begin move roles and status field to concerts table.Harald Eilertsen2021-06-141-2/+16
| | | | There's no need to have a separate table (concertlogs) for these fields.
* Auto fixup missing return types by PsalmHarald Eilertsen2021-05-081-1/+4
|
* Activate db version 5Harald Eilertsen2021-04-221-1/+1
|
* Fix typo in register_db_table.Harald Eilertsen2021-04-221-11/+11
| | | | | Also moved dropping of band foreign key from concerts table into the db version 5 changeset.
* Added column for concert title in databaseAndreaChirulescu2021-04-211-1/+19
| | | | Modified so that band is no longer in use
* Added NN country for defaulting bands to an unknown countryAndreaChirulescu2021-04-181-1/+6
|
* Add license comment _after_ the php opening tag.Harald Eilertsen2021-04-141-1/+1
|
* Switch to Reuse for license handling.Harald Eilertsen2021-04-141-0/+5
| | | | Run `reuse lint` to verify that all material is licensed.
* Move concert logs creation date to db version 3Harald Eilertsen2021-04-071-3/+10
| | | | Just to make updating easier without having to nuke the db every time.
* Added created_date column to wpgAndreaChirulescu2021-04-061-0/+1
|
* Populate the pressstatus table on activation.Harald Eilertsen2021-04-011-33/+50
| | | | | | | | | Was missing in the first import. This looks like pure static data, though, and will probably be moved to constants in the code instead. While this doesn't really change the db schema, the db version was incremented to version 2, to make sure the new data is added, even if the db is already initialized.
* Fix embarrasing misnaming of module.Harald Eilertsen2021-01-171-8/+8
|
* Skip setting up db if db version is ok.Harald Eilertsen2021-01-171-0/+7
| | | | | | Introduces a database schema version which we store in the wordpress options table. We could just use a flag, but if the schema ever will change, it will be good to have it versioned.
* Register database tables on activation.Harald Eilertsen2021-01-161-0/+391
Tables, constraints and country data taken from database dump of prototype dataset by Andrea.
generated by cgit v1.2.3 (git 2.25.1) at 2024-06-02 23:35:13 +0000