wechat-vote/dev.sql

-- phpMyAdmin SQL Dump
-- version 4.5.2
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: 2016-12-07 07:57:44
-- 服务器版本： 5.7.9
-- PHP Version: 5.6.16

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `dev`
--

-- --------------------------------------------------------

--
-- 表的结构 `activity_info`
--

DROP TABLE IF EXISTS `activity_info`;
CREATE TABLE IF NOT EXISTS `activity_info` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '投票信息id',
  `activity_title` varchar(120) COLLATE utf8_unicode_ci NOT NULL COMMENT '活动标题',
  `activity_desc` text COLLATE utf8_unicode_ci NOT NULL COMMENT '活动描述',
  `activity_introduce` text COLLATE utf8_unicode_ci NOT NULL COMMENT '活动介绍',
  `activity_rule` text COLLATE utf8_unicode_ci NOT NULL COMMENT '活动规则',
  `start_time` timestamp NULL DEFAULT NULL COMMENT '活动开始时间',
  `end_time` timestamp NULL DEFAULT NULL COMMENT '活动结束时间',
  `count_views` int(11) NOT NULL COMMENT '浏览次数',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 转存表中的数据 `activity_info`
--

INSERT INTO `activity_info` (`id`, `activity_title`, `activity_desc`, `activity_introduce`, `activity_rule`, `start_time`, `end_time`, `count_views`) VALUES
(3, 'bbbbbb', 'sdsadasdasd', 'dsadsa', 'dsadasdas', '2016-12-01 16:00:00', '2016-12-29 16:00:00', 1),
(4, 'cccccccc', 'fsadsadasdasda', 'sdasdasdas', 'vgxxx', '2016-12-02 16:00:00', '2016-12-30 16:00:00', 0);

-- --------------------------------------------------------

--
-- 表的结构 `groups`
--

DROP TABLE IF EXISTS `groups`;
CREATE TABLE IF NOT EXISTS `groups` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分组id',
  `group_name` varchar(120) COLLATE utf8_unicode_ci NOT NULL COMMENT '分组名称',
  `player_count` tinyint(3) UNSIGNED NOT NULL COMMENT '选手个数',
  `group_desc` varchar(120) COLLATE utf8_unicode_ci NOT NULL COMMENT '分组描述',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- 表的结构 `migrations`
--

DROP TABLE IF EXISTS `migrations`;
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 转存表中的数据 `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2016_10_31_032006_create_group_table', 1),
(4, '2016_10_31_032221_create_player_table', 1),
(5, '2016_10_31_032321_create_vote_table', 1),
(6, '2016_11_02_080926_add_column_groups_group_desc', 1),
(7, '2016_11_02_183650_add_votes_updated_at', 1),
(8, '2016_11_03_152819_create_activity_info', 1),
(9, '2016_11_27_210923_add_column_votes_group_id', 1),
(10, '2016_11_27_220959_add_column_votes_ip', 1),
(11, '2016_12_06_132834_create_new_players', 2);

-- --------------------------------------------------------

--
-- 表的结构 `new_players`
--

DROP TABLE IF EXISTS `new_players`;
CREATE TABLE IF NOT EXISTS `new_players` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '选手id',
  `name` varchar(120) COLLATE utf8_unicode_ci NOT NULL COMMENT '选手名称',
  `no` int(10) UNSIGNED NOT NULL COMMENT '选手编号',
  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '选后头像或图片',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 转存表中的数据 `new_players`
--

INSERT INTO `new_players` (`id`, `name`, `no`, `image`) VALUES
(1, '张三', 11, 's1.jpg'),
(2, '李四', 22, 's2.jpg');

-- --------------------------------------------------------

--
-- 表的结构 `new_votes`
--

DROP TABLE IF EXISTS `new_votes`;
CREATE TABLE IF NOT EXISTS `new_votes` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '投票记录id',
  `player_id` int(10) UNSIGNED NOT NULL COMMENT '得票人',
  `openid` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '投票微信用户的个人openid, 用于防止刷票',
  `vote` int(10) UNSIGNED NOT NULL DEFAULT '1' COMMENT '投票数，为1',
  `we_nickname` varchar(120) COLLATE utf8_unicode_ci NOT NULL COMMENT '微信用户昵称',
  `we_image` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '微信用户的头像地址',
  `ip` varchar(12) COLLATE utf8_unicode_ci NOT NULL COMMENT 'ip',
  `created_at` timestamp NULL DEFAULT NULL COMMENT '投票时间',
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 转存表中的数据 `new_votes`
--

INSERT INTO `new_votes` (`id`, `player_id`, `openid`, `vote`, `we_nickname`, `we_image`, `ip`, `created_at`, `updated_at`) VALUES
(1, 2, 'odh7zsgI75iT8FRh0fGlSojc9PWM', 1, 'overtrue', 's2.jpg', '127.0.0.1', '2016-12-07 05:03:22', '2016-12-07 05:03:22'),
(2, 1, 'odh7zsgI75iT8FRh0fGlSojc9PWM', 1, 'overtrue', 's1.jpg', '127.0.0.1', '2016-12-07 05:03:27', '2016-12-07 05:03:27'),
(3, 1, 'odh7zsgI75iT8FRh0fGlSojc9PWM', 1, 'overtrue', 's1.jpg', '127.0.0.1', '2016-12-07 05:03:57', '2016-12-07 05:03:57');

-- --------------------------------------------------------

--
-- 表的结构 `players`
--

DROP TABLE IF EXISTS `players`;
CREATE TABLE IF NOT EXISTS `players` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '选手id',
  `group_id` int(10) UNSIGNED NOT NULL COMMENT '分组id',
  `name` varchar(120) COLLATE utf8_unicode_ci NOT NULL COMMENT '选手名称',
  `no` varchar(120) COLLATE utf8_unicode_ci NOT NULL COMMENT '选手编号',
  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '选手头像或图片',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 转存表中的数据 `players`
--

INSERT INTO `players` (`id`, `group_id`, `name`, `no`, `image`) VALUES
(1, 1, '成都市青白江区人和学校乡村学校少年宫', '1', 's1.jpg'),
(2, 1, '成都新都大丰小学乡村学校少年宫', '2', 's2.jpg'),
(3, 1, '成都郫县崇宁小学', '3', 's3.jpg'),
(4, 1, '成都市新津县乡村学校少年宫', '4', 's4.jpg'),
(5, 1, '成都市广汉七一小学乡村学校少年宫', '5', 's5.jpg'),
(6, 1, '自贡五宝小学', '6', 's6.jpg'),
(7, 1, '自贡回龙镇中心校', '7', 's7.jpg'),
(8, 1, '自贡富顺狮市中学', '8', 's8.jpg'),
(9, 1, '自贡市荣县鼎新镇乡村学校少年宫', '9', 's9.jpg'),
(10, 1, '自贡市自流井区舒平乡村学校少年宫', '10', 's10.jpg'),
(11, 1, '攀枝花盐边县中学校', '11', 's11.jpg'),
(12, 1, '攀枝花市仁和区总发乡中心校', '12', 's12.jpg'),
(13, 1, '泸州江阳区分水岭中学乡村学校少年宫', '13', 's13.jpg'),
(14, 1, '泸州市古蔺县古蔺乡村学校少年宫', '14', 's14.jpg'),
(15, 1, '泸州五通镇中心校乡村学校少年宫', '15', 's15.jpg'),
(16, 1, '泸州市纳溪区合面镇中学', '16', 's16.jpg'),
(17, 1, '泸州市龙马潭区乡村学校少年宫', '17', 's17.jpg'),
(18, 1, '泸县玉蟾街道乡村学校少年宫', '18', 's18.jpg'),
(19, 2, '中江县清凉中心校', '19', 's19.jpg'),
(20, 2, '德阳市略坪小学', '20', 's20.jpg'),
(21, 2, '德阳旌阳区孝泉民族小学', '21', 's21.jpg'),
(22, 2, '绵阳市仙海区沉抗镇乡村学校少年宫', '22', 's22.jpg'),
(23, 2, '绵阳豆叩小学', '23', 's23.jpg'),
(24, 2, '绵阳江油双河小学少年宫', '24', 's24.jpg'),
(25, 2, '绵阳经开区塘汛小学少年宫', '25', 's25.jpg'),
(26, 2, '广元朝天区羊木镇小学乡村学校少年宫', '26', 's26.jpg'),
(27, 2, '广元剑阁县龙江乡村学校少年宫', '27', 's27.jpg'),
(28, 2, '广元市昭化区卫子中学乡村学校少年宫', '28', 's28.jpg'),
(29, 2, '广元青川沙洲小学', '29', 's29.jpg'),
(30, 2, '遂宁市河沙小学乡村学校少年宫', '30', 's30.jpg'),
(31, 2, '遂宁市射洪金华小学乡村学校少年宫', '31', 's31.jpg'),
(32, 2, '内江隆昌李市镇小学', '32', 's32.jpg'),
(33, 2, '内江威远县镇西镇中心校', '33', 's33.jpg'),
(34, 2, '内江市渔箭小学乡村学校少年宫', '34', 's34.jpg'),
(35, 3, '乐山市峨眉山新平小学少年宫', '35', 's35.jpg'),
(36, 3, '乐山市井研县千佛镇中心小学乡村学校少年宫', '36', 's36.jpg'),
(37, 3, '乐山市踏水中心小学乡村学校少年宫', '37', 's37.jpg'),
(38, 3, '乐山黑竹沟镇中心小学乡村学校少年宫', '38', 's38.jpg'),
(39, 3, '南充市南部县河坝镇小学', '39', 's39.jpg'),
(40, 3, '南充市仪陇县距光小学乡村学校少年宫', '40', 's40.jpg'),
(41, 3, '南充市高坪区阙家小学乡村学校少年宫', '41', 's41.jpg'),
(42, 3, '宜宾江安桐梓县乡村学校少年宫', '42', 's42.jpg'),
(43, 3, '宜宾市翠屏区南广镇中心小学少年宫', '43', 's43.jpg'),
(44, 3, '宜宾珙县珙泉镇中心小学乡村学校少年宫', '44', 's44.jpg'),
(45, 3, '宜宾市筠连县武德乡中心校', '45', 's45.jpg'),
(46, 3, '广安市广安区希望小学乡村学校少年宫', '46', 's46.jpg'),
(47, 3, '达州市渠县巨光乡村学校少年宫', '47', 's47.jpg'),
(48, 3, '巴中南江县石潭乡九年义务教育学校', '48', 's48.jpg'),
(49, 3, '巴中广纳小学乡村学校少年宫', '49', 's49.jpg'),
(50, 3, '巴中南江下两小学', '50', 's50.jpg'),
(51, 4, '雅安市宝兴县跷碛小学', '51', 's51.jpg'),
(52, 4, '雅安石棉美罗乡村学校少年宫', '52', 's52.jpg'),
(53, 4, '眉山市东坡区车辆厂小学少年宫', '53', 's53.jpg'),
(54, 4, '眉山丹棱唐河小学', '54', 's54.jpg'),
(55, 4, '眉山彭山保胜小学', '55', 's55.jpg'),
(56, 4, '眉山仁寿城北小学', '56', 's56.jpg'),
(57, 4, '资阳安岳县云峰初级中学少年宫', '57', 's57.jpg'),
(58, 4, '资阳市乐至县宝林小学', '58', 's58.jpg'),
(59, 4, '阿坝民族寄宿制学校乡村学校少年宫', '59', 's59.jpg'),
(60, 4, '阿坝茂县凤仪镇乡村学校少年宫', '60', 's60.jpg'),
(61, 4, '阿坝州九寨沟县第四小学', '61', 's61.jpg'),
(62, 4, '甘孜巴塘县中咱片区寄宿制学校', '62', 's62.jpg'),
(63, 4, '甘孜州乡城县乡村学校少年宫', '63', 's63.jpg'),
(64, 4, '凉山宁南县朝阳小学乡村学校少年宫', '64', 's64.jpg'),
(65, 4, '凉山德昌县小高镇中心完全小学', '65', 's65.jpg');

-- --------------------------------------------------------

--
-- 表的结构 `votes`
--

DROP TABLE IF EXISTS `votes`;
CREATE TABLE IF NOT EXISTS `votes` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '投票记录id',
  `player_id` int(10) UNSIGNED NOT NULL COMMENT '得票人',
  `openid` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '投票微信用户的个人openid, 用于防止刷票',
  `vote` int(10) UNSIGNED NOT NULL DEFAULT '1' COMMENT '投票数, 为1',
  `we_nickname` varchar(120) COLLATE utf8_unicode_ci NOT NULL COMMENT '微信用户昵称',
  `we_image` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '微信用户的头像地址',
  `created_at` timestamp NULL DEFAULT NULL COMMENT '投票时间',
  `updated_at` timestamp NULL DEFAULT NULL,
  `group_id` int(10) UNSIGNED NOT NULL COMMENT '分组id',
  `ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL COMMENT 'ip',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;