CREATE TABLE `comment` (
`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
`type` INTEGER NULL,
`poster_id` INTEGER NULL,
`original_author` TEXT NULL,
`original_author_id` INTEGER NULL,
`issue_id` INTEGER NULL,
`label_id` INTEGER NULL,
`old_project_id` INTEGER NULL,
`project_id` INTEGER NULL,
`old_milestone_id` INTEGER NULL,
`milestone_id` INTEGER NULL,
`time_id` INTEGER NULL,
`assignee_id` INTEGER NULL,
`removed_assignee` INTEGER NULL,
`assignee_team_id` INTEGER DEFAULT 0 NOT NULL,
`resolve_doer_id` INTEGER NULL,
`old_title` TEXT NULL,
`new_title` TEXT NULL,
`old_ref` TEXT NULL,
`new_ref` TEXT NULL,
`dependent_issue_id` INTEGER NULL,
`commit_id` INTEGER NULL,
`line` INTEGER NULL,
`tree_path` TEXT NULL,
`content` TEXT NULL,
`patch` TEXT NULL,
`created_unix` INTEGER NULL,
`updated_unix` INTEGER NULL,
`commit_sha` TEXT NULL,
`review_id` INTEGER NULL,
`invalidated` INTEGER NULL,
`ref_repo_id` INTEGER NULL,
`ref_issue_id` INTEGER NULL,
`ref_comment_id` INTEGER NULL,
`ref_action` INTEGER NULL,
`ref_is_pull` INTEGER NULL,
`content_version` INTEGER DEFAULT 0 NOT NULL,
`comment_meta_data` TEXT NULL
)