1. phpLiteAdmin Avatar phpLiteAdmin
  2. phpLiteAdmin
  3. public
  4. Issues

Add View & Trigger Support

Issue #311 invalid
Former user created an issue

SQLite is capable of stored views and Triggers.

Can these be added to the phpLiteAdmin to make a more complete tool.

Comments (3)

  1. phpLiteAdmin repo owner

    We have support for both!? Or do I get you wrong?

    Views: Open the "structure" tab of a database and scroll down. "Create new view on database" allows you to create a view, Views will be listed in the list of tables just that it says View instead of table in the type column.

    Triggers: Open the "structure" tab of a table and scroll down. Click the "create a new trigger" button. Triggers will be listed on the "structure" tab of the table and can be managed from there.

    So what feature is missing?

  2. phpLiteAdmin repo owner

    Note that there was a bug in 1.9.6 (issue #273) that broke the trigger functionality, but it should be fixed in 1.9.7.1 Edit: Ah sorry, this bug was regarding indexes, not triggers. Triggers were not broken.

  3. phpLiteAdmin repo owner

    Closed as invalid. Support for views and triggers is there. The original poster did not explain in detail what he is missing.

  4. Log in to comment
Assignee
–
Type
enhancement
Priority
minor
Status
invalid
Component
–
Milestone
–
Version
–
Votes
0
Watchers
None
Jira Software: the preferred issue tracker for Bitbucket. Join the team!