14 lines
456 B
SQL
14 lines
456 B
SQL
CREATE TABLE `wa_card` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`type` int DEFAULT NULL,
|
|
`title` varchar(64) NOT NULL,
|
|
`total` int NOT NULL DEFAULT '0',
|
|
`used` int DEFAULT '0',
|
|
`expires` int NOT NULL,
|
|
`days` int NOT NULL DEFAULT '0',
|
|
`status` tinyint(1) NOT NULL DEFAULT '1',
|
|
`created_at` int NOT NULL,
|
|
`updated_at` int DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|