123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687 |
- -- ----------------------------
- -- Table structure for __PREFIX__customcharts_total_number
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__customcharts_total_number` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
- `name` varchar(50) NOT NULL DEFAULT '' COMMENT '表名称',
- `title` varchar(50) NOT NULL DEFAULT '' COMMENT '标题',
- `field_total` varchar(50) NOT NULL DEFAULT '' COMMENT '统计字段',
- `type_total` enum('sum','count') NOT NULL DEFAULT 'count' COMMENT '统计类型',
- `field_time` varchar(50) NOT NULL DEFAULT '' COMMENT '时间字段',
- `field_time_type` varchar(20) NOT NULL DEFAULT '' COMMENT '时间字段类型',
- `type_time` enum('today','week','month','all') NOT NULL DEFAULT 'all' COMMENT '时间类型',
- `where` varchar(255) NOT NULL COMMENT '自定义where',
- `icon` varchar(50) NOT NULL DEFAULT '' COMMENT '图标',
- `icon_color` char(7) NOT NULL COMMENT '图标颜色',
- `weigh` tinyint(4) NOT NULL DEFAULT '0' COMMENT '排序',
- `is_money` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否金额格式',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='总数统计表';
- -- ----------------------------
- -- Table structure for __PREFIX__customcharts_ranking
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__customcharts_ranking` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
- `name` varchar(50) NOT NULL DEFAULT '' COMMENT '表名',
- `field_total` varchar(50) NOT NULL COMMENT '统计字段',
- `type_total` enum('count','sum') NOT NULL DEFAULT 'sum' COMMENT '统计类型',
- `group_field` varchar(50) NOT NULL DEFAULT '' COMMENT '分组字段',
- `field_time` varchar(50) NOT NULL DEFAULT '' COMMENT '时间字段',
- `field_time_type` varchar(20) NOT NULL DEFAULT '' COMMENT '时间字段类型',
- `type_time` enum('today','week','month') NOT NULL DEFAULT 'today' COMMENT '时间类型',
- `unit` varchar(10) NOT NULL COMMENT '单位标题',
- `title` varchar(100) NOT NULL DEFAULT '' COMMENT '标题',
- `where` varchar(255) NOT NULL DEFAULT '' COMMENT '自定义Where',
- `weigh` tinyint(4) NOT NULL DEFAULT '0' COMMENT '排序',
- `show_num` tinyint(3) unsigned NOT NULL DEFAULT '10' COMMENT '排行榜显示数量',
- `join_table` varchar(50) NOT NULL DEFAULT '' COMMENT '关联表',
- `foreign_key` varchar(50) NOT NULL DEFAULT '' COMMENT '关联外键',
- `local_key` varchar(50) NOT NULL DEFAULT '' COMMENT '关联主键',
- `field_show` varchar(50) NOT NULL DEFAULT '' COMMENT '显示的字段',
- `dictionary` text COMMENT '分组字典',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COMMENT='排行统计表';
- -- ----------------------------
- -- Table structure for __PREFIX__customcharts_chart
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__customcharts_chart` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
- `name` varchar(50) NOT NULL DEFAULT '' COMMENT '表名',
- `field_total` varchar(50) NOT NULL DEFAULT '' COMMENT '统计字段',
- `type_total` enum('sum','count') NOT NULL DEFAULT 'count' COMMENT '统计类型',
- `group_field` varchar(50) NOT NULL DEFAULT '' COMMENT '分组字段',
- `field_time` varchar(50) NOT NULL DEFAULT '' COMMENT '时间字段',
- `field_time_type` varchar(20) NOT NULL DEFAULT '' COMMENT '时间字段类型',
- `chart_type` enum('pie','graph','histogram') NOT NULL DEFAULT 'pie' COMMENT '图表类型',
- `legend_title` varchar(50) NOT NULL COMMENT '图例标题',
- `unit` varchar(10) NOT NULL COMMENT '单位',
- `title` varchar(100) NOT NULL DEFAULT '' COMMENT '标题',
- `subtext` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
- `where` varchar(255) NOT NULL DEFAULT '' COMMENT '自定义Where',
- `weigh` tinyint(4) NOT NULL DEFAULT '0' COMMENT '排序',
- `join_table` varchar(50) NOT NULL DEFAULT '' COMMENT '关联表',
- `foreign_key` varchar(50) NOT NULL DEFAULT '' COMMENT '关联外键',
- `local_key` varchar(50) NOT NULL DEFAULT '' COMMENT '关联主键',
- `field_show` varchar(50) NOT NULL DEFAULT '' COMMENT '显示的字段',
- `dictionary` text COMMENT '分组字典',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='图表统计表';
- -- ----------------------------
- -- 1.0.8
- -- ----------------------------
- BEGIN;
- ALTER TABLE __PREFIX__customcharts_chart ADD field_time_type varchar(20) NOT NULL DEFAULT "";
- ALTER TABLE __PREFIX__customcharts_ranking ADD field_time_type varchar(20) NOT NULL DEFAULT "";
- COMMIT;
- -- ----------------------------
- -- 1.0.9
- -- ----------------------------
- BEGIN;
- ALTER TABLE `__PREFIX__customcharts_ranking` ADD `dictionary` TEXT COMMENT '分组字典' AFTER `field_show`;
- ALTER TABLE `__PREFIX__customcharts_chart` ADD `dictionary` TEXT COMMENT '分组字典' AFTER `field_show`;
- COMMIT;
|