6 Star 0 Fork 0

要笑娟 / E-invitation

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。
克隆/下载
invitation.sql 15.98 KB
一键复制 编辑 原始数据 按行查看 历史
要笑娟 提交于 2015-10-30 17:16 . 第二版
-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: 2015-10-30 05:50:15
-- 服务器版本: 5.6.17
-- PHP Version: 5.5.12
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 utf8 */;
--
-- Database: `invitation`
--
-- --------------------------------------------------------
--
-- 表的结构 `attend`
--
CREATE TABLE IF NOT EXISTS `attend` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`invitation_id` int(11) NOT NULL COMMENT '关联用户',
`name` varchar(30) NOT NULL COMMENT '代表人',
`phone` varchar(30) NOT NULL COMMENT '联系方式',
`number` int(15) NOT NULL COMMENT '出席人数',
`create_at` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- 转存表中的数据 `attend`
--
INSERT INTO `attend` (`id`, `invitation_id`, `name`, `phone`, `number`, `create_at`) VALUES
(5, 27, '小王', '18332551234', 3, '0000-00-00 00:00:00'),
(6, 27, '张伟', '18332556987', 2, '0000-00-00 00:00:00'),
(7, 28, '小六', '18233561314', 2, '0000-00-00 00:00:00');
-- --------------------------------------------------------
--
-- 表的结构 `blessing`
--
CREATE TABLE IF NOT EXISTS `blessing` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`invitation_id` int(11) NOT NULL COMMENT '男方名字',
`name` varchar(30) NOT NULL COMMENT '祝福人',
`phone` varchar(20) NOT NULL COMMENT '祝福人联系方式',
`blessing` varchar(200) NOT NULL COMMENT '祝福内容',
`create_at` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
--
-- 转存表中的数据 `blessing`
--
INSERT INTO `blessing` (`id`, `invitation_id`, `name`, `phone`, `blessing`, `create_at`) VALUES
(9, 27, '小王', '18332551234', '祝百年好合', '0000-00-00 00:00:00'),
(10, 27, '王伟', '18332555555', '我那天有事就不参加了,祝你们新婚愉快,白您好和', '0000-00-00 00:00:00'),
(11, 27, '张伟', '18332556987', '很高兴参加你们的婚礼,我会准时参加的', '0000-00-00 00:00:00'),
(12, 27, '赵飞燕', '12345678910', '我参加不了,但祝你们百年好合', '0000-00-00 00:00:00'),
(13, 28, '小六', '18233561314', '我和我媳妇会准时参加的', '0000-00-00 00:00:00');
-- --------------------------------------------------------
--
-- 表的结构 `category`
--
CREATE TABLE IF NOT EXISTS `category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL COMMENT '名称',
`weight` smallint(6) DEFAULT '0' COMMENT '排序权重',
`is_visible` tinyint(1) DEFAULT '1' COMMENT '是否可见',
`is_delete` tinyint(1) DEFAULT '0' COMMENT '是否删除',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分类表' AUTO_INCREMENT=4 ;
--
-- 转存表中的数据 `category`
--
INSERT INTO `category` (`id`, `name`, `weight`, `is_visible`, `is_delete`) VALUES
(1, '星座', 0, 1, 0),
(2, '属相', 0, 1, 0),
(3, '父母', 0, 1, 0);
-- --------------------------------------------------------
--
-- 表的结构 `invitation`
--
CREATE TABLE IF NOT EXISTS `invitation` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '喜帖ID',
`model_id` int(11) NOT NULL COMMENT '模板id',
`music_id` int(11) DEFAULT NULL COMMENT '音乐id',
`music_url` int(200) NOT NULL,
`boy_name` varchar(10) NOT NULL,
`girl_name` varchar(10) NOT NULL,
`boy_tel` int(11) NOT NULL,
`girl_tel` int(11) NOT NULL,
`boy_birth` varchar(30) NOT NULL COMMENT '新郎生日',
`girl_birth` varchar(30) NOT NULL COMMENT '新娘生日',
`wedding_time` date NOT NULL,
`wedding_address` varchar(100) NOT NULL,
`traffic_way` varchar(300) DEFAULT NULL COMMENT '交通方式',
`invit_letter` varchar(200) DEFAULT NULL COMMENT '邀请语',
`picture_main` varchar(200) DEFAULT NULL COMMENT '头像',
`album_id` int(11) DEFAULT NULL COMMENT '相册id',
`video` varchar(200) DEFAULT NULL COMMENT '视频链接',
`user_id` int(11) NOT NULL COMMENT '模板使用者',
`is_delete` tinyint(1) DEFAULT '0' COMMENT '是否已删除',
`created_at` varchar(100) DEFAULT NULL COMMENT '创建时间',
`thanks` varchar(200) NOT NULL COMMENT '感谢语',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='请柬模板' AUTO_INCREMENT=32 ;
--
-- 转存表中的数据 `invitation`
--
INSERT INTO `invitation` (`id`, `model_id`, `music_id`, `music_url`, `boy_name`, `girl_name`, `boy_tel`, `girl_tel`, `boy_birth`, `girl_birth`, `wedding_time`, `wedding_address`, `traffic_way`, `invit_letter`, `picture_main`, `album_id`, `video`, `user_id`, `is_delete`, `created_at`, `thanks`) VALUES
(27, 1, 1, 0, '牛郎', '侄女', 2147483647, 2147483647, '2015-10-7', '2015-10-7', '2015-10-31', '河北省秦皇岛市海港区秦皇国际大酒店', '百度地图,高德地图自己导航过来吧,挺好找的', '我和我太太郑重邀请您参加我们的婚礼,望您在百忙之中抽出空闲前来参加,我们用心准备了惊喜和礼物,真心期待您分享我们的甜蜜。', 'http://7xntg1.com1.z0.glb.clouddn.com/FqBofbre1yjouwkutslmRVfTJ2uR', 44, 'http://7xntg1.com1.z0.glb.clouddn.com/FlTdVnKAlN-3-BOjO1zcrBgt3F-9', 2, 0, '2015-10-28 20:33:44', '感谢大家抛开了手中繁忙的事务,来参加我们的婚礼。今天的宴会大厅因为你们的光临而篷壁生辉,因为您们的如约而至,我们激动不已,衷心的感谢你们!感谢你们送来了温暖,送来了友情,送来了吉祥,送来了最美好的祝福。'),
(28, 2, 1, 0, '董永', '小七', 2147483647, 2147483647, '2015-09-15', '2015-09-15', '2015-10-31', '秦皇岛秦皇国际一楼宴会大厅', '请来的时候带着红包,要不然就别来了啊~~~~哈哈', '我们俩郑重的邀请您参加我们的婚礼,望您在百忙之中抽出空闲前来参加,我们用心准备了惊喜和礼物,真心期待您分享我们的甜蜜。', 'http://7xntg1.com1.z0.glb.clouddn.com/FifvHkKQyCzDMc4V4UT8cAszTlKQ', 45, 'http://7xntg1.com1.z0.glb.clouddn.com/FlTdVnKAlN-3-BOjO1zcrBgt3F-9', 2, 0, '2015-10-29 14:03:40', '谢谢亲这么给力参加我们的婚礼,以后常来我们家做客哈。'),
(29, 1, 1, 1111111111, '11', '11', 11, 11, '11', '11', '0000-00-00', '11', '11', '11', '11', 11, '11', 2, 0, '2015-10-30 09:23:29', '11'),
(30, 1, 1, 0, '1', '2', 2147483647, 2147483647, '2015-10-28', '2015-10-31', '2015-10-30', '123121', '11111', 'undefined', 'http://7xntg1.com1.z0.glb.clouddn.com/FmC5Wt1R7P2IbAwQ6O4-QatUaOLV', 49, 'http://7xntg1.com1.z0.glb.clouddn.com/Fvd3eszTyHGNjyiTwIyW3Qh7Vep-', 2, 0, '2015-10-30 09:27:37', '感谢大家抛开了手中繁忙的事务,来参加我们的婚礼。今天的宴会大厅因为你们的光临而篷壁生辉,因为您们的如约而至,我们激动不已,衷心的感谢你们!感谢你们送来了温暖,送来了友情,送来了吉祥,送来了最美好的祝福。'),
(31, 1, 1, 0, '11', '11', 2147483647, 2147483647, '2015-10-30', '2015-10-30', '2015-10-30', '111111', '1111111', 'undefined', 'http://7xntg1.com1.z0.glb.clouddn.com/Fvd3eszTyHGNjyiTwIyW3Qh7Vep-', 50, 'http://7xntg1.com1.z0.glb.clouddn.com/FveCoM74AJSDFJvaXru4khAwfY9j', 2, 0, '2015-10-30 09:58:32', '感谢大家抛开了手中繁忙的事务,来参加我们的婚礼。今天的宴会大厅因为你们的光临而篷壁生辉,因为您们的如约而至,我们激动不已,衷心的感谢你们!感谢你们送来了温暖,送来了友情,送来了吉祥,送来了最美好的祝福。');
-- --------------------------------------------------------
--
-- 表的结构 `model`
--
CREATE TABLE IF NOT EXISTS `model` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`category_id` int(11) NOT NULL COMMENT '所属分类id',
`name` varchar(40) NOT NULL COMMENT '模板名称',
`url_name` varchar(200) NOT NULL COMMENT 'url处模板名称',
`img_dir` varchar(200) DEFAULT NULL COMMENT '图片地址',
`use_num` int(11) DEFAULT '0' COMMENT '使用次数',
`created_at` datetime DEFAULT NULL COMMENT '创建时间',
`is_visible` tinyint(1) DEFAULT '1' COMMENT '是否显示',
`is_delete` tinyint(1) DEFAULT '0' COMMENT '是否已删除',
`weight` smallint(6) DEFAULT '0' COMMENT '排序权重',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章表' AUTO_INCREMENT=570 ;
--
-- 转存表中的数据 `model`
--
INSERT INTO `model` (`id`, `category_id`, `name`, `url_name`, `img_dir`, `use_num`, `created_at`, `is_visible`, `is_delete`, `weight`) VALUES
(1, 1, '模板一', '', '/uploads/images/20151027/f8aba84f9cd259e925a86fc8c0fe23d2.png', 8, '2015-10-27 00:00:00', 1, 0, 0),
(2, 2, '模板二', '', '/uploads/images/20151027/501fd73676cbcfcdcb17780c3a795f49.png', 1, '2015-10-27 00:00:00', 1, 0, 0),
(3, 3, '模板三', '', '/uploads/images/20151027/b9c9e3e6f30b0d71e4910fa17645a66e.png', 0, '2015-10-28 00:00:00', 1, 0, 0);
-- --------------------------------------------------------
--
-- 表的结构 `music`
--
CREATE TABLE IF NOT EXISTS `music` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(40) NOT NULL,
`singer` varchar(40) NOT NULL COMMENT '演唱歌手',
`dir` varchar(500) NOT NULL,
`is_visible` int(10) NOT NULL DEFAULT '1',
`is_delete` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- 转存表中的数据 `music`
--
INSERT INTO `music` (`id`, `name`, `singer`, `dir`, `is_visible`, `is_delete`) VALUES
(1, '浮夸', '林志炫', 'http://7xntg1.com1.z0.glb.clouddn.com/lqd7Iu303QoNvXEKSqFjJdgxAQxj', 1, 0);
-- --------------------------------------------------------
--
-- 表的结构 `picture`
--
CREATE TABLE IF NOT EXISTS `picture` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`invitation_id` int(11) NOT NULL COMMENT '喜帖id',
`dir` varchar(200) NOT NULL COMMENT '路径',
`created_at` datetime DEFAULT NULL COMMENT '创建时间',
`is_visible` tinyint(1) DEFAULT '1' COMMENT '是否可见',
`is_delete` tinyint(1) DEFAULT '0' COMMENT '是否已删除',
`weight` smallint(6) DEFAULT '0' COMMENT '排序权重',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='图片表' AUTO_INCREMENT=76 ;
--
-- 转存表中的数据 `picture`
--
INSERT INTO `picture` (`id`, `invitation_id`, `dir`, `created_at`, `is_visible`, `is_delete`, `weight`) VALUES
(3, 2, 'http://www.qhdqy.cn/upLoad/product/month_1301/201301051854345130.png', '2015-07-04 08:39:15', 1, 0, 0),
(4, 2, 'http://www.qhdqy.cn/upLoad/product/month_1301/201301051854345130.png', '2015-07-04 08:39:38', 1, 0, 0),
(5, 27, 'http://www.qhdqy.cn/upLoad/product/month_1212/201212071008074463.jpg', '2012-12-07 10:08:00', 1, 0, 0),
(9, 27, 'http://www.qhdqy.cn/upLoad/product/month_1301/201301051612225850.png', '2013-01-05 16:11:54', 1, 0, 0),
(10, 27, 'http://www.qhdqy.cn/upLoad/product/month_1301/201301051616425054.png', '2013-01-05 16:16:08', 1, 0, 0),
(11, 27, 'http://www.qhdqy.cn/upLoad/product/month_1301/201301051617589369.png', '2013-01-05 16:17:28', 1, 0, 0),
(12, 27, 'http://www.qhdqy.cn/upLoad/product/month_1301/201301051621338847.png', '2013-01-05 16:21:02', 1, 0, 0),
(14, 27, 'http://www.qhdqy.cn/upLoad/product/month_1301/201301051822049752.png', '2013-01-05 18:11:12', 1, 0, 0),
(15, 27, 'http://www.qhdqy.cn/upLoad/product/month_1301/201301051818061214.png', '2013-01-05 18:15:55', 1, 0, 0),
(24, 28, 'http://www.qhdqy.cn/upLoad/product/month_1212/201212071008074463.jpg', '2012-12-07 10:08:00', 1, 0, 0),
(28, 28, 'http://www.qhdqy.cn/upLoad/product/month_1301/201301051636007246.png', '2013-01-05 16:35:27', 1, 0, 0),
(29, 28, 'http://www.qhdqy.cn/upLoad/product/month_1301/201301051638375093.png', '2013-01-05 16:38:12', 1, 0, 0),
(30, 28, 'http://www.qhdqy.cn/upLoad/product/month_1301/20130105163920104.png', '2013-01-05 16:39:00', 1, 0, 0),
(31, 29, 'http://www.qhdqy.cn/upLoad/product/month_1212/201212071008074463.jpg', '2012-12-07 10:08:00', 1, 0, 0),
(35, 27, 'http://www.qhdqy.cn/upLoad/product/month_1301/201301051725318190.png', '2013-01-05 17:24:19', 1, 0, 0),
(36, 27, 'http://www.qhdqy.cn/upLoad/product/month_1301/201301051726031165.png', '2013-01-05 17:24:19', 1, 0, 0),
(37, 27, 'http://www.qhdqy.cn/upLoad/product/month_1301/201301051726218763.png', '2013-01-05 17:24:19', 1, 0, 0),
(38, 27, 'http://www.qhdqy.cn/upLoad/product/month_1301/201301051726475325.png', '2013-01-05 17:24:19', 1, 0, 0),
(39, 27, 'http://www.qhdqy.cn/upLoad/product/month_1301/201301051847083426.png', '2013-01-05 18:38:57', 1, 0, 0),
(40, 27, 'http://www.qhdqy.cn/upLoad/product/month_1301/201301051850121961.png', '2013-01-05 18:38:57', 1, 0, 0),
(41, 27, 'http://www.qhdqy.cn/upLoad/product/month_1301/201301051854345130.png', '2013-01-05 18:38:57', 1, 0, 0),
(42, 27, 'http://www.qhdqy.cn/upLoad/product/month_1301/201301051857177266.png', '2013-01-05 18:38:57', 1, 0, 0),
(43, 28, 'http://www.qhdqy.cn/upLoad/product/month_1301/201301051637389311.png', '2013-01-05 16:35:27', 1, 0, 0),
(44, 1, '1111111111', NULL, 1, 0, 0),
(45, 1, '11111', NULL, 1, 0, 0),
(46, 35, 'http://7xntg1.com1.z0.glb.clouddn.com/FmC5Wt1R7P2IbAwQ6O4-QatUaOLV', NULL, 1, 0, 0),
(47, 36, 'http://7xntg1.com1.z0.glb.clouddn.com/FmC5Wt1R7P2IbAwQ6O4-QatUaOLV', NULL, 1, 0, 0),
(48, 36, 'http://7xntg1.com1.z0.glb.clouddn.com/Fvd3eszTyHGNjyiTwIyW3Qh7Vep-', NULL, 1, 0, 0),
(49, 37, 'http://7xntg1.com1.z0.glb.clouddn.com/Fvd3eszTyHGNjyiTwIyW3Qh7Vep-', NULL, 1, 0, 0),
(50, 37, 'http://7xntg1.com1.z0.glb.clouddn.com/FveCoM74AJSDFJvaXru4khAwfY9j', NULL, 1, 0, 0),
(51, 38, 'http://7xntg1.com1.z0.glb.clouddn.com/FmC5Wt1R7P2IbAwQ6O4-QatUaOLV', NULL, 1, 0, 0),
(52, 38, 'http://7xntg1.com1.z0.glb.clouddn.com/Fvd3eszTyHGNjyiTwIyW3Qh7Vep-', NULL, 1, 0, 0),
(53, 39, 'http://7xntg1.com1.z0.glb.clouddn.com/FqBofbre1yjouwkutslmRVfTJ2uR', NULL, 1, 0, 0),
(54, 40, 'http://7xntg1.com1.z0.glb.clouddn.com/FmC5Wt1R7P2IbAwQ6O4-QatUaOLV', NULL, 1, 0, 0),
(55, 40, 'http://7xntg1.com1.z0.glb.clouddn.com/Fvd3eszTyHGNjyiTwIyW3Qh7Vep-', NULL, 1, 0, 0),
(56, 41, 'http://7xntg1.com1.z0.glb.clouddn.com/FqBofbre1yjouwkutslmRVfTJ2uR', NULL, 1, 0, 0),
(57, 41, 'http://7xntg1.com1.z0.glb.clouddn.com/Fvd3eszTyHGNjyiTwIyW3Qh7Vep-', NULL, 1, 0, 0),
(58, 42, 'http://7xntg1.com1.z0.glb.clouddn.com/Fvd3eszTyHGNjyiTwIyW3Qh7Vep-', NULL, 1, 0, 0),
(59, 42, 'http://7xntg1.com1.z0.glb.clouddn.com/FiTfoCroYsj69p0pNW7vGaGSl-yv', NULL, 1, 0, 0),
(60, 43, 'http://7xntg1.com1.z0.glb.clouddn.com/FqBofbre1yjouwkutslmRVfTJ2uR', NULL, 1, 0, 0),
(61, 44, 'http://7xntg1.com1.z0.glb.clouddn.com/FnCKMl1m4OevY1JS6u9EqsSMFjPf', NULL, 1, 0, 0),
(62, 44, 'http://7xntg1.com1.z0.glb.clouddn.com/FiTfoCroYsj69p0pNW7vGaGSl-yv', NULL, 1, 0, 0),
(63, 44, 'http://7xntg1.com1.z0.glb.clouddn.com/FveCoM74AJSDFJvaXru4khAwfY9j', NULL, 1, 0, 0),
(64, 45, 'http://7xntg1.com1.z0.glb.clouddn.com/FtnU_7eLR0vyI-rTO0jz6NTX_FkV', NULL, 1, 0, 0),
(65, 45, 'http://7xntg1.com1.z0.glb.clouddn.com/Fkqc8diat9puEExIv84AywT872CO', NULL, 1, 0, 0),
(66, 45, 'http://7xntg1.com1.z0.glb.clouddn.com/FlDVdkGQewrgmIR146n6nQUz8e8G', NULL, 1, 0, 0),
(67, 45, 'http://7xntg1.com1.z0.glb.clouddn.com/FifvHkKQyCzDMc4V4UT8cAszTlKQ', NULL, 1, 0, 0),
(68, 45, 'http://7xntg1.com1.z0.glb.clouddn.com/FoUnIA03YHwC5eccbCNVX0DRl1s2', NULL, 1, 0, 0),
(69, 46, 'http://7xntg1.com1.z0.glb.clouddn.com/Fvd3eszTyHGNjyiTwIyW3Qh7Vep-', NULL, 1, 0, 0),
(70, 46, 'http://7xntg1.com1.z0.glb.clouddn.com/FveCoM74AJSDFJvaXru4khAwfY9j', NULL, 1, 0, 0),
(71, 47, 'http://7xntg1.com1.z0.glb.clouddn.com/Fvd3eszTyHGNjyiTwIyW3Qh7Vep-', NULL, 1, 0, 0),
(72, 48, 'http://7xntg1.com1.z0.glb.clouddn.com/Fvd3eszTyHGNjyiTwIyW3Qh7Vep-', NULL, 1, 0, 0),
(73, 49, 'http://7xntg1.com1.z0.glb.clouddn.com/Fvd3eszTyHGNjyiTwIyW3Qh7Vep-', NULL, 1, 0, 0),
(74, 50, 'http://7xntg1.com1.z0.glb.clouddn.com/FmC5Wt1R7P2IbAwQ6O4-QatUaOLV', NULL, 1, 0, 0),
(75, 50, 'http://7xntg1.com1.z0.glb.clouddn.com/Fvd3eszTyHGNjyiTwIyW3Qh7Vep-', NULL, 1, 0, 0);
/*!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 */;
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/yaoxiaojuan/E-invitation.git
git@gitee.com:yaoxiaojuan/E-invitation.git
yaoxiaojuan
E-invitation
E-invitation
master

搜索帮助

344bd9b3 5694891 D2dac590 5694891