9 lines
310 B
MySQL
9 lines
310 B
MySQL
|
CREATE TABLE IF NOT EXISTS `crypto` (
|
||
|
|
`crypto` varchar(50) NOT NULL DEFAULT 'qbit',
|
||
|
|
`worth` int(11) NOT NULL DEFAULT 0,
|
||
|
|
`history` text DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`crypto`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
||
|
|
|
||
|
|
INSERT INTO `crypto` VALUES ('qbit', 1000, '[{"NewWorth":1000,"PreviousWorth":1000}]');
|