mysql> use emoncms;
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> show tables
-> ;
+-------------------+
| Tables_in_emoncms |
+-------------------+
| app_config |
| dashboard |
| event |
| event_settings |
| feeds |
| graph |
| input |
| multigraph |
| rememberme |
| schedule |
| sync |
| tasks |
| users |
+-------------------+
13 rows in set (0.00 sec)
mysql> describe tasks;
+-------------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| userid | int(11) | NO | | NULL | |
| name | text | YES | | NULL | |
| description | text | YES | | NULL | |
| tag | text | YES | | NULL | |
| run_on | int(10) | YES | | 0 | |
| frequency | text | YES | | NULL | |
| processList | text | YES | | NULL | |
| time | int(10) | YES | | NULL | |
| enabled | tinyint(4) | YES | | NULL | |
+-------------+------------+------+-----+---------+----------------+
10 rows in set (0.02 sec)
mysql> ALTER TABLE `tasks` MODIFY `description` text DEFAULT '';
ERROR 1101 (42000): BLOB, TEXT, GEOMETRY or JSON column 'description' can't have a default value
mysql>
Comments