not working with default value

[happyman]

for this chema, I want to let sqlite3 add default value. how to do with sql30?

       'name': 'mylog',
                'fields': {
                    'ts': 'timestamp DEFAULT CURRENT_TIMESTAMP',
                    'type': 'text',
                    'data': 'float DEFAULT 0.0'
                    },

I can do with this sql, the timestamp and data will insert default values,
insert into mylog (type, data) values ("abc",1.0)
insert into mylog (type) values("def")
but I can't do it with write()