This test requires admin access.

Setup

1. Login as admin.
2. Go to Site administration > Advanced features and Enable portfolios.
3. Go to Site administration > Plugins > Portfolios > Manage portfolios and select "Enabled and visible" for the "File download" portfolio.
4. Create a topics format course with at least a student and a teacher
5. Add enough activities to the course to have scroll in the course index drawer.
6. Add enough blocks to the course to have scroll in the blocks drawer
7. Create a database activity "Testing Database improvements" in the course. 

Zero state pages

1. Login as teacher and go to "Testing Database improvements" Database activity
2. Confirm the page looks similar to attached teacher_view_zero_state.png image
3. Navigate to Fields tab and confirm the page looks similar to attached teacher_fields_zero_state.png image
4. Navigate to Templates tab and confirm the page looks similar to attached teacher_templates_zero_state.png image
5. Log in as student and go to "Testing Database improvements" Database activity
6. Confirm the page looks similar to attached student_view_zero_state.png image
7. Login as teacher and go to "Testing Database improvements"  Database activity
8. Navigate to Presets, select "Image gallery" and click the "Use preset" button
9. Navigate to Database tab and confirm the page looks similar to attached teacher_no_entries.png image
10. Log in as student and go to "Zero state page" Database activity
11. Confirm the page looks similar to attached student_no_entries.png image.
12. Add some entries to the database (at least 2).  

Sticky footer

1. Log in as teacher and go to"Testing Database improvements" Database activity
2. Navigate through Database, Fieds, Templates and Presets tabs on Database secondary navigation and check:
   1. Wait until the sticky footer appears.
   2. Open the course index drawer and check that the last activity of the course is visible when you scroll down to the bottom of the course index drawer.
   3. Open the blocks drawer and check the last block is fully visible when you scroll down to the bottom of the blocks drawer.
   4. Open the messaging drawer and check the messaging drawer appears on top of the sticky footer.
3. Navigate to Presets and click on the "Use a preset" button and check the page has a sticky footer with the "Use a preset" button dimmed.
4. Select the radio button from "Journal" and check the "Use a preset" button is enabled now
5. Click on the "Use a preset" button and check the "Fields mapping" form has the "Cancel" and "Continue" buttons in the sticky footer.
6. Click on the "Cancel" button and check you are again on the presets page
7. Click the "Image gallery" preset name and check the preset preview has the "Use a preset" button in the sticky footer
8. Click on the "Use a preset" button and accept the default mappings
9. Go to the "Database" tab and go to add entry and Check you have the cancel, save and "Save and add another" buttons in the sticky footer.
10. Add some image to the image field and click on the "Save and add another" and check you go again to the New entry form
11. Add at least 3 more entries.
12. Upload another image in the New entry form and click on "Save" this time
13. Check you are now on "Single view" and the pagination and the "Add entry" button is in the sticky footer
14. Go to Templates tab and navigate to "List template"
15. Check you have "Reset" and "Save" option in the sticky footer.
16. Add ##delcheck## tag just before the [[title]] at the Repeated entry editor and "Save" template.
17. Go to "List view" and check you have at least the Select all, delete and add entry button in the sticky footer
18. Change the "Entries per page" to 2 and click on Save settings
    1. Check that now you have also the pagination in the sticky footer
19. Go to the Fields tab and check you have a "View templates" link in the sticky footer
20. Click on the 3-dots icon, select Edit icon from the title field and check the Save and cancel buttons are in the sticky footer
21. Change the field name to title2 and click the save button
    1. Check you are now in the fields list page again and the title field is now title2
22. Click on the sticky footer's "View templates" link
    1. Check you are now in the templates tab and that you have the "reset template", "save template" and the "enable editor" in the sticky footer

Navigation

1. Navigate to "Templates" tab
2. Check the secondary navigation displays Presets before Fields and Templates.
3. Check the List view and the Actions menu is displayed in the tertiary navigation.
4. Click the "Advanced search" checkbox.
5. Check the "Save settings" secondary button is hidden (and only the "Save settings" primary button is displayed).
6. Go to the "Presets" page and check the "Actions" menu is displayed in the tertiary navigation.
7. Check there is no "Actions" column in the table (near the Description).
8. Click "Image gallery" name to preview this preset and check the List/single template action menu is aligned to the right.
9. Also check the preset description is not displayed and "Use this preset" is displayed as the primary button.
10. Go to the "Fields" page.
11. Check the Create a new field is displayed in the tertiary navigation, aligned to the right.
12. Check the Save as preset and Export preset buttons are not displayed anymore.
13. Check there is no "Manage fields" actions menu. Besides, the "Manage fields" should be displayed as a heading in the tertiary navigation.
14. Check there is no "Actions" column in the table (near the Field description).
15. Check the actions for each field (Edit and Delete) are displayed in a kebab menu.
16. Go to the "Templates" page.
17. Check the "Add entry template" menu in the tertiary navigation is selected by default and confirm this selector has the following elements (in the same order):
    1. Add entry template
    2. Single view template
    3. List view template
    4. Advanced search template
    5. CSS template
    6. Javascript template
    7. RSS template
18. Check the Actions menu is displayed in the tertiary navigation, aligned to the right.