search

linwiz / Raspberry-Pi-Web-GPIO

PHP script to control Raspberry PI GPIO pins from the web
GNU General Public License v3.0
4 stars 1 forks source link

gpio.sql and script #31

Closed Paku- closed 9 years ago

Paku- commented 9 years ago

Little updates; 1.non-unique index added 2.sleep 0.2 removed

Sorry for direct push but it's just fast update.

Do not know why indexes and autoinc fields are added at the bottom of the sql file, but result is the same.

Paku- commented 9 years ago

Result on v3 (HUGE) will add some more filters at the top gpiov3

linwiz commented 9 years ago

I'm not really a sure why so many changes were made in f0205f573f1e935adf441b4015006a2ce25bb201 but I like the other commits in this merge.

The picture you posted made me think of something I have overlooked. There are non-GPIO pins in the database but I don't really see the reason for this. They can't be enabled or disabled, and their status cannot be changed. I am not sure they need to be listed on the page with the pins

Paku- commented 9 years ago

I used newer phpMyAdmin version to get it (have a look at file header), index and autoincrements are at the bottom but the final dbase is the same.Do not worry (I took this snapshot from your dbase, after minimal changes)

Yes the X X pins should be invisible here (want to introduce filter at top of the page). But in my opinion they should be in the database because they are PINs on Pi. You never know what the future will bring to u. (could be we will analyse their state in later versionsor the GPIO lib gives nice functionality for them).