SQL
CREATE TABLE users (
id TEXT PRIMARY KEY,
phone TEXT UNIQUE,
role TEXT NOT NULL DEFAULT 'user'
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
id |
TEXT |
✓ | ✓ | Rename | Drop |
phone |
TEXT |
✓ | Rename | Drop | |
role |
TEXT |
Rename | Drop |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_users_1 |
id
|
✓ | SQL | Drop |
| sqlite_autoindex_users_2 |
phone
|
✓ | SQL | Drop |