Hi,
I would like to see the option to right-click (or similar) on a table/field in AG and click there on something that will create the SQL code needed to generate the table/field I clicked on and put that code into the clipboard.
This would make adjustments in the database much easier.
I created a little mockup to visualize my request:
Olaf
Copy&Past code for table creation
Copy&Past code for table creation
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
Re: Copy&Past code for table creation
Hi Olaf,
I think that CREATE code is (more or less) in admin\updateDB.php. It's a little klunky but I'm not sure how much such a feature would be used. I don't have a lot experience with phymyadmin but that is where I'd expect to see such a feature and I don't see it.
Just my $.02.
~Paul
I think that CREATE code is (more or less) in admin\updateDB.php. It's a little klunky but I'm not sure how much such a feature would be used. I don't have a lot experience with phymyadmin but that is where I'd expect to see such a feature and I don't see it.
Just my $.02.
~Paul
Re: Copy&Past code for table creation
Hi Paul,
well, I know we can use phpadmin to create/alter tables/fields. My suggestion is, that AG gives the option to quickly get the code so we can more easily try things out. With a complex app, I do not want to create the app, make all adjustments just to have change X in my database.
I am asking for this feature, as I prepare my database quite often: already creating fields and indexes, constraints foreign key etc ... as AG simply does not do this.
Olaf
well, I know we can use phpadmin to create/alter tables/fields. My suggestion is, that AG gives the option to quickly get the code so we can more easily try things out. With a complex app, I do not want to create the app, make all adjustments just to have change X in my database.
I am asking for this feature, as I prepare my database quite often: already creating fields and indexes, constraints foreign key etc ... as AG simply does not do this.
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view