Ethan Lane
8b3fb062f0
All checks were successful
continuous-integration/drone/push Build is passing
#3 Reviewed-on: https://gitea.vylpes.xyz/External/card-drop/pulls/18 Co-authored-by: Ethan Lane <ethan@vylpes.com> Co-committed-by: Ethan Lane <ethan@vylpes.com>
10 lines
349 B
SQL
10 lines
349 B
SQL
CREATE TABLE `inventory` (
|
|
`Id` varchar(255) NOT NULL,
|
|
`WhenCreated` datetime NOT NULL,
|
|
`WhenUpdated` datetime NOT NULL,
|
|
`UserId` varchar(255) NOT NULL,
|
|
`CardNumber` varchar(255) NOT NULL,
|
|
`Quantity` int NOT NULL,
|
|
`ClaimId` varchar(255) NOT NULL,
|
|
PRIMARY KEY (`Id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; |