Skip to content

Instantly share code, notes, and snippets.

@cosminpopescu14

cosminpopescu14/corona-virus-app-case-table.sql

Created March 6, 2020 20:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cosminpopescu14/62c81cbf5d62a291341f9c56b1f4b269 to your computer and use it in GitHub Desktop.
Save cosminpopescu14/62c81cbf5d62a291341f9c56b1f4b269 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
corona-virus-app-case-table.sql
CREATE TABLE `cases` (
`id` bigint(20) NOT NULL,
`cases` bigint(20) DEFAULT NULL,
`date` date DEFAULT NULL,
PRIMARY KEY (`id`),
CONSTRAINT date_cases UNIQUE (cases , date)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment