Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement