webamp/packages/skin-database/types.ts

export type TweetStatus =
  | "APPROVED"
  | "REJECTED"
  | "TWEETED"
  | "UNREVIEWED"
  | "NSFW";

/**
 * The judgement made about a skin by a moderator
 * @gqlEnum
 */
export type Rating = "APPROVED" | "REJECTED" | "NSFW";

export type SkinType = "MODERN" | "CLASSIC";

export type SkinRow = {
  id: number;
  md5: string;
  skin_type: number;
  emails: string;
  // readme_text: string;
  average_color: string;
};

export type TweetRow = {
  skin_md5: string;
  url: string;
  tweet_id: string;
  likes: number;
  retweets: number;
};

export type InstagramPostRow = {
  skin_md5: string;
  url: string;
  post_id: string;
};

export type ReviewRow = {
  skin_md5: string;
  review: Rating;
  reviewer: string;
};

export type FileRow = {
  skin_md5: string;
  file_path: string;
};

export type ArchiveFileRow = {
  skin_md5: string;
  file_name: string;
  file_md5: string;
  file_date: string;
  uncompressed_size: number;
  text_content: string | null;
  is_directory: number; // SQLite uses integers for booleans
};

export type FileInfoRow = {
  file_md5: string;
  text_content: string | null;
  size_in_bytes: number;
};

export type IaItemRow = {
  skin_md5: string;
  identifier: string;
  metadata: string; // JSON from the internet archive
  metadata_timestamp: string;
};

export type UploadStatus =
  | "UPLOAD_REPORTED"
  | "URL_REQUESTED"
  | "ERRORED"
  | "ARCHIVED";

export type UploadRow = {
  skin_md5: string;
  id: string;
  status: UploadStatus;
};