issues: 455496504

This data as json

id node_id number title user state locked assignee milestone comments created_at updated_at closed_at author_association pull_request body repo type active_lock_reason performed_via_github_app reactions draft state_reason
455496504 MDU6SXNzdWU0NTU0OTY1MDQ= 27 sqlite-utils create-table command 9599 closed 0     8 2019-06-13T01:43:30Z 2020-05-03T15:26:15Z 2020-05-03T15:26:15Z OWNER  

Spun off from #24 - it would be useful if CLI users could create new tables (with explicit column types, not null rules and defaults) without having to insert an example record.

  • [x] Get it working
  • [x] Support --pk
  • [x] Support --not-null
  • [x] Support --default
  • [x] Support --fk colname othertable othercol
  • [x] Support --replace and --ignore
  • [x] Documentation
 140912432 issue     
{
    "url": "https://api.github.com/repos/simonw/sqlite-utils/issues/27/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   completed

Links from other tables