CREATE TABLE `repository` (
`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
`owner_id` INTEGER NULL,
`owner_name` TEXT NULL,
`lower_name` TEXT NOT NULL,
`name` TEXT NOT NULL,
`description` TEXT NULL,
`website` TEXT NULL,
`original_service_type` INTEGER NULL,
`original_url` TEXT NULL,
`default_branch` TEXT NULL,
`default_wiki_branch` TEXT NULL,
`num_watches` INTEGER NULL,
`num_stars` INTEGER NULL,
`num_forks` INTEGER NULL,
`num_issues` INTEGER NULL,
`num_closed_issues` INTEGER NULL,
`num_pulls` INTEGER NULL,
`num_closed_pulls` INTEGER NULL,
`num_milestones` INTEGER DEFAULT 0 NOT NULL,
`num_closed_milestones` INTEGER DEFAULT 0 NOT NULL,
`num_projects` INTEGER DEFAULT 0 NOT NULL,
`num_closed_projects` INTEGER DEFAULT 0 NOT NULL,
`num_action_runs` INTEGER DEFAULT 0 NOT NULL,
`num_closed_action_runs` INTEGER DEFAULT 0 NOT NULL,
`is_private` INTEGER NULL,
`is_empty` INTEGER NULL,
`is_archived` INTEGER NULL,
`is_mirror` INTEGER NULL,
`status` INTEGER DEFAULT 0 NOT NULL,
`is_fork` INTEGER DEFAULT 0 NOT NULL,
`fork_id` INTEGER NULL,
`is_template` INTEGER DEFAULT 0 NOT NULL,
`template_id` INTEGER NULL,
`size` INTEGER DEFAULT 0 NOT NULL,
`git_size` INTEGER DEFAULT 0 NOT NULL,
`lfs_size` INTEGER DEFAULT 0 NOT NULL,
`is_fsck_enabled` INTEGER DEFAULT 1 NOT NULL,
`close_issues_via_commit_in_any_branch` INTEGER DEFAULT 0 NOT NULL,
`topics` TEXT NULL,
`object_format_name` TEXT DEFAULT 'sha1' NOT NULL,
`trust_model` INTEGER NULL,
`avatar` TEXT NULL,
`created_unix` INTEGER NULL,
`updated_unix` INTEGER NULL,
`archived_unix` INTEGER DEFAULT 0 NULL,
push_ips TEXT,
`auto_sync_deploy` INTEGER DEFAULT 0 NOT NULL
)