SQLite Forum

alter table "table" add column "name" varchar not null throws Cannot add a NOT NULL column with default value NULL
Login
Chronological Hierarchical 
Good day

- Compile or install latest SQLite.
- Create a single table with field id int
- Alter the table and add a column to it which is not null

Here is SQL:

```sql
create table permissions
(
    id               bigint unsigned auto_increment
        primary key,
    name             varchar(191)         not null,
    guard_name       varchar(191)         not null,
    for_organization tinyint(1) default 0 not null,
    created_at       timestamp            null,
    updated_at       timestamp            null
)
    collate = utf8mb4_unicode_ci;


alter table "permissions" add column "title" varchar not null;
```