NittyGritty icon

Emoncms-MySQL-Issue

NittyGritty | PRO | 11/15/19 08:20:21 AM UTC | 0 ⭐ | 549 👁️ | Never ⏰ | []
text |

1.79 KB

|

None

|

0 👍

/

0 👎

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