Since im get used to IDR (indonesian rupiah) currency im forgot to set the price field to become a FLOAT type.. some users like Rocco (italy) and Razza (spain) asked me about that .. so here’s a quick
from terminal :
$mysql -u easyhotspot -p
[password] = easyhotspot
use easyhotspot;
ALTER TABLE billingplan CHANGE price price FLOAT( 11 ) NOT NULL;
ALTER TABLE postplan CHANGE price price FLOAT( 11 ) NOT NULL;
describe billingplan;
describe postplan;
exit;
pheew .. theres anoter bugs solved, thx to you all guys ..
like this :
mysql> use easyhotspot;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> ALTER TABLE billingplan CHANGE price price FLOAT( 11 ) NOT NULL;
Query OK, 2 rows affected (0.06 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> ALTER TABLE postplan CHANGE price price FLOAT( 11 ) NOT NULL;
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql>
mysql> describe billingplan;
+--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(255) | NO | UNI | NULL | |
| type | varchar(255) | NO | | NULL | |
| amount | int(255) | NO | | NULL | |
| price | float | NO | | NULL | |
| IdleTimeout | int(255) | NO | | NULL | |
| simultaneous | int(10) | NO | | NULL | |
| redirect_url | varchar(255) | NO | | NULL | |
| bw_upload | int(255) | NO | | NULL | |
| bw_download | int(255) | NO | | NULL | |
| created_by | varchar(255) | NO | | NULL | |
+--------------+--------------+------+-----+---------+----------------+
11 rows in set (0.00 sec)
mysql>
mysql> describe postplan;
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| id | int(255) | NO | PRI | NULL | |
| name | varchar(255) | NO | | NULL | |
| price | float | NO | | NULL | |
+-------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql>
