奥壹oelove婚恋交友v10.0_10.1情感导师插件_商城插件SQL数据库导入升级方法

大家注意哈奥壹oelove的系统默认是不含情感导师插件和商城系统的，这两个插件需要再官方独立购买，有幸公司付钱购买了系统及两套商业插件，可以看我昵称找我注明CSDN我已经把数据库及模板文件提取出来了，先说下数据库把，升级系统无非就是覆盖部分模板文件和升级sql数据库，执行后就添加了对应的情感导师模块了。

CREATE TABLE IF NOT EXISTS `oelv_pre_course` (
  `courseid` int(10) unsigned NOT NULL,
  `unionid` int(10) unsigned DEFAULT '0',
  `catid` smallint(6) unsigned DEFAULT '0',
  `title` varchar(255) DEFAULT '',
  `thumbimg` varchar(100) DEFAULT '',
  `drawimg` varchar(100) DEFAULT '',
  `intro` varchar(500) DEFAULT '',
  `content` text,
  `addtime` int(10) unsigned DEFAULT '0',
  `uptime` int(10) unsigned DEFAULT '0',
  `flag` tinyint(2) unsigned DEFAULT '0',
  `onflag` tinyint(1) unsigned DEFAULT '0',
  `elite` tinyint(1) unsigned DEFAULT '0',
  `istop` tinyint(1) unsigned DEFAULT '0',
  `hits` int(10) unsigned DEFAULT '0',
  `price` decimal(10,2) unsigned DEFAULT '0.00',
  `liprice` decimal(10,2) unsigned DEFAULT '0.00',
  `score` decimal(10,2) unsigned DEFAULT '0.00',
  `goodrate` varchar(10) DEFAULT '',
  `comm_nums` smallint(6) DEFAULT '0',
  `orders` int(10) unsigned DEFAULT '0',
  `opuid` int(10) unsigned DEFAULT '0',
  `opuser` varchar(30) DEFAULT '',
  `optype` varchar(30) DEFAULT '',
  `study_times` int(10) unsigned DEFAULT '0',
  `last_study` int(10) unsigned DEFAULT '0',
  `buy_times` int(10) unsigned DEFAULT '0',
  `last_buy` int(10) unsigned DEFAULT '0',
  `buy_limit_days` int(10) unsigned DEFAULT '0',
  `remark` varchar(255) DEFAULT '',
  `chapter_nums` smallint(6) unsigned DEFAULT '0',
  `class_nums` smallint(6) unsigned DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

INSERT INTO `oelv_pre_course` (`courseid`, `unionid`, `catid`, `title`, `thumbimg`, `drawimg`, `intro`, `content`, `addtime`, `uptime`, `flag`, `onflag`, `elite`, `istop`, `hits`, `price`, `liprice`, `score`, `goodrate`, `comm_nums`, `orders`, `opuid`, `opuser`, `optype`, `study_times`, `last_study`, `buy_times`, `last_buy`, `buy_limit_days`, `remark`, `chapter_nums`, `class_nums`) VALUES
(1, 0, 4, '恋爱课程1', '', '', '恋爱课程', '恋爱课程', 1654743005, 0, 1, 1, 0, 0, 0, '99.00', '199.00', '0.00', '', 0, 0, 688, '20220222', 'admin', 0, 0, 0, 0, 90, '', 1, 1);

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

--
-- 表的结构 `oelv_pre_course_buy`
--

CREATE TABLE IF NOT EXISTS `oelv_pre_course_buy` (
  `buyid` int(10) unsigned NOT NULL,
  `courseid` int(10) unsigned DEFAULT '0',
  `userid` int(10) unsigned DEFAULT '0',
  `price` decimal(10,2) unsigned DEFAULT '0.00',
  `orderno` varchar(50) DEFAULT '',
  `addtime` int(10) unsigned DEFAULT '0',
  `valid_time` int(10) unsigned DEFAULT '0',
  `is_del` tinyint(1) unsigned DEFAULT '0',
  `deltime` int(10) unsigned DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `oelv_pre_course_cat`
--

CREATE TABLE IF NOT EXISTS `oelv_pre_course_cat` (
  `catid` smallint(6) unsigned NOT NULL,
  `catname` varchar(255) DEFAULT '',
  `catimg` varchar(100) DEFAULT '',
  `orders` smallint(6) unsigned DEFAULT '0',
  `flag` tinyint(1) unsigned DEFAULT '0',
  `addtime` int(10) unsigned DEFAULT '0',
  `parentid` smallint(6) unsigned DEFAULT '0',
  `elite` tinyint(1) unsigned DEFAULT '0',
  `intro` varchar(500) DEFAULT ''
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

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

INSERT INTO `oelv_pre_course_cat` (`catid`, `catname`, `catimg`, `orders`, `flag`, `addtime`, `parentid`, `elite`, `intro`) VALUES
(1, '挽回爱情', '', 1, 1, 1629687956, 0, 1, ''),
(2, '脱单恋爱', '', 2, 1, 1629687998, 0, 1, ''),
(3, '经营婚姻', '', 3, 1, 1629688019, 0, 1, ''),
(4, '分手挽回', '', 2, 1, 1629688160, 1, 0, ''),
(5, '挽回男友', '', 3, 1, 1629688186, 1, 0, ''),
(6, '挽回老公', '', 4, 1, 1629688192, 1, 0, ''),
(7, '恋爱宝典', '', 1, 1, 1629688221, 2, 0, ''),
(8, '相亲秘籍', '', 2, 1, 1629688247, 2, 0, ''),
(9, '约会技巧', '', 3, 1, 1629688264, 2, 0, ''),
(10, '脱单秘籍', '', 4, 1, 1629688281, 2, 0, ''),
(11, '婆媳关系', '', 1, 1, 1629688302, 3, 0, ''),
(12, '情感维系', '', 2, 1, 1629688313, 3, 0, ''),
(13, '家庭暴力', '', 3, 1, 1629688363, 3, 0, '');

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

--
-- 表的结构 `oelv_pre_course_chapter`
--

CREATE TABLE IF NOT EXISTS `oelv_pre_course_chapter` (
  `chapid` int(10) unsigned NOT NULL,
  `courseid` int(10) unsigned DEFAULT '0',
  `chapname` varchar(255) DEFAULT '',
  `orders` int(10) unsigned DEFAULT '0',
  `intro` varchar(500) DEFAULT '',
  `addtime` int(10) unsigned DEFAULT '0',
  `uptime` int(10) unsigned DEFAULT '0',
  `onflag` tinyint(1) unsigned DEFAULT '0',
  `opuid` int(10) unsigned DEFAULT '0',
  `opuser` varchar(30) DEFAULT '',
  `optype` varchar(30) DEFAULT '',
  `class_nums` int(10) unsigned DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

INSERT INTO `oelv_pre_course_chapter` (`chapid`, `courseid`, `chapname`, `orders`, `intro`, `addtime`, `uptime`, `onflag`, `opuid`, `opuser`, `optype`, `class_nums`) VALUES
(1, 1, '第一节', 1, '第一节', 1654743028, 0, 1, 688, '20220222', 'admin', 1);

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

--
-- 表的结构 `oelv_pre_course_class`
--

CREATE TABLE IF NOT EXISTS `oelv_pre_course_class` (
  `classid` int(10) unsigned NOT NULL,
  `courseid` int(10) unsigned DEFAULT '0',
  `chapid` int(10) unsigned DEFAULT '0',
  `classname` varchar(255) DEFAULT '',
  `thumbimg` varchar(100) DEFAULT '',
  `drawimg` varchar(100) DEFAULT '',
  `orders` int(10) unsigned DEFAULT '0',
  `intro` varchar(1000) DEFAULT '',
  `mediaid` int(10) unsigned DEFAULT '0',
  `type` tinyint(2) unsigned DEFAULT '0',
  `duration` int(10) unsigned DEFAULT '0',
  `addtime` int(10) unsigned DEFAULT '0',
  `uptime` int(10) unsigned DEFAULT '0',
  `flag` tinyint(1) unsigned DEFAULT '0',
  `elite` tinyint(1) unsigned DEFAULT '0',
  `onflag` tinyint(1) unsigned DEFAULT '0',
  `hits` int(10) unsigned DEFAULT '0',
  `opuid` int(10) unsigned DEFAULT '0',
  `opuser` varchar(30) DEFAULT '',
  `optype` varchar(30) DEFAULT '',
  `istry` tinyint(1) unsigned DEFAULT '0',
  `try_time` int(10) unsigned DEFAULT '0',
  `remark` varchar(255) DEFAULT ''
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

INSERT INTO `oelv_pre_course_class` (`classid`, `courseid`, `chapid`, `classname`, `thumbimg`, `drawimg`, `orders`, `intro`, `mediaid`, `type`, `duration`, `addtime`, `uptime`, `flag`, `elite`, `onflag`, `hits`, `opuid`, `opuser`, `optype`, `istry`, `try_time`, `remark`) VALUES
(1, 1, 1, '第一学时', '', '', 1, '第一学时2', 0, 2, 300, 1654743083, 1655443769, 1, 0, 1, 0, 688, '20220222', 'admin', 0, 0, '');

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

--
-- 表的结构 `oelv_pre_course_collect`
--

CREATE TABLE IF NOT EXISTS `oelv_pre_course_collect` (
  `collid` bigint(20) unsigned NOT NULL,
  `courseid` int(10) unsigned DEFAULT '0',
  `userid` int(10) unsigned DEFAULT '0',
  `addtime` int(10) unsigned DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;