| 12345678910 |
- CREATE TABLE IF NOT EXISTS `__PREFIX__posters` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
- `title` varchar(50) NOT NULL COMMENT '名称',
- `config` text NOT NULL COMMENT '配置',
- `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
- `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='自定义海报配置';
- INSERT INTO `__PREFIX__posters`(`id`, `title`, `config`, `create_time`, `update_time`) VALUES (1, '自定义海报', '{\"bg\":{\"color\":\"rgb(255,255,255)\",\"width\":424,\"height\":745},\"materials\":[{\"type\":\"image\",\"generate\":true,\"zIndex\":1,\"config\":{\"image\":null,\"left\":0,\"top\":0,\"width\":424,\"height\":423,\"radius\":0,\"opacity\":100}},{\"type\":\"qr\",\"generate\":true,\"zIndex\":2,\"config\":{\"text\":\"https:\\/\\/baidu.com\\/s?wd={:id}\",\"left\":18,\"top\":518,\"width\":112,\"margin\":6,\"opacity\":100}},{\"type\":\"text\",\"generate\":true,\"zIndex\":3,\"config\":{\"text\":\"我是{:user},\\n我为{:name}代言\",\"left\":149,\"top\":525,\"width\":275,\"fontSize\":20,\"lineHeight\":50,\"overflow\":\"ellipsis\",\"overflow_text\":\"\",\"color\":\"rgba(0, 0, 0, 1)\"}}]}', 1630043327, 1631174885);
|
