You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
152 lines
5.5 KiB
152 lines
5.5 KiB
-- phpMyAdmin SQL Dump
|
|
-- version 4.7.7
|
|
-- https://www.phpmyadmin.net/
|
|
--
|
|
-- Host: localhost
|
|
-- Generation Time: Apr 02, 2018 at 08:36 AM
|
|
-- Server version: 10.2.13-MariaDB
|
|
-- PHP Version: 7.2.3
|
|
|
|
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
|
SET AUTOCOMMIT = 0;
|
|
START TRANSACTION;
|
|
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: `coze_training`
|
|
--
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `actions`
|
|
--
|
|
|
|
CREATE TABLE `actions` (
|
|
`id` int(11) NOT NULL,
|
|
`label` varchar(255) NOT NULL,
|
|
`description` text NOT NULL,
|
|
`mid` int(11) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
--
|
|
-- Dumping data for table `actions`
|
|
--
|
|
|
|
INSERT INTO `actions` (`id`, `label`, `description`, `mid`) VALUES
|
|
(13, 'sdbf', 'xg', 22),
|
|
(14, 'sdbfASFDV', 'xgSDF ', 20),
|
|
(15, 'wwwwwwww', 'wwwwwwww', 21),
|
|
(16, 'xxxxxxxxx', 'xxxxxxxxxx', 20),
|
|
(17, 'wwwwwwww', 'wwwwwwww', 21),
|
|
(18, 'xxxxxxxxx', 'xxxxxxxxxx', 23),
|
|
(19, 'ascd', 'dsvf', 22),
|
|
(20, 'ddddddddddddd', 'ddddddddddd', 21),
|
|
(21, 'fffffffff', 'ffffffffff', 22),
|
|
(22, 'Action 1', 'Description of action 1', 24),
|
|
(23, 'Action 2', 'Description of action 2 (Goto message 1)', 24),
|
|
(24, 'Action 3', 'Description of action 3 (Goto message 2)', 25);
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `messages`
|
|
--
|
|
|
|
CREATE TABLE `messages` (
|
|
`id` int(11) NOT NULL,
|
|
`sid` int(11) NOT NULL,
|
|
`title` varchar(255) NOT NULL,
|
|
`short_text` text NOT NULL,
|
|
`long_text` text NOT NULL,
|
|
`image` varchar(255) NOT NULL,
|
|
`actions` varchar(100) NOT NULL,
|
|
`timer` time NOT NULL,
|
|
`progress` int(11) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
--
|
|
-- Dumping data for table `messages`
|
|
--
|
|
|
|
INSERT INTO `messages` (`id`, `sid`, `title`, `short_text`, `long_text`, `image`, `actions`, `timer`, `progress`) VALUES
|
|
(24, 5, 'Test message 1', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. <strong>Donec quam felis</strong>, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo.<em> Nullam dictum felis</em> eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. <br />', 'Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a, tellus. Phasellus viverra nulla ut metus varius laoreet. Quisque rutrum. Aenean imperdiet. <span style=\"text-decoration: underline;\">Etiam ultricies nisi vel augue</span>. Curabitur ullamcorper ultricies nisi. Nam eget dui. Etiam rhoncus. Maecenas tempus, tellus eget condimentum rhoncus, sem quam semper libero, sit amet adipiscing sem neque sed ipsum. Nam quam nunc, blandit vel, luctus pulvinar, hendrerit id, lorem. Maecenas nec odio et ante tincidunt tempus. Donec vitae sapien ut libero venenatis faucibus. Nullam quis ante. Etiam sit amet orci eget eros faucibus tincidunt. Duis leo. Sed fringilla mauris sit amet nibh. Donec sodales sagittis magna. Sed consequat, leo eget bibendum sodales, augue velit cursus nunc,', '/images/upload/20180402082649.jpg', '', '00:00:00', 0),
|
|
(25, 5, 'Test message 2', 'Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a, tellus. Phasellus viverra nulla ut metus varius laoreet. Quisque rutrum. Aenean imperdiet. Etiam ultricies nisi vel augue.', '', '', '22', '00:00:10', 0),
|
|
(26, 5, 'Test message 3', 'Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem.', '', '', '23,24', '00:00:00', 1);
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `session`
|
|
--
|
|
|
|
CREATE TABLE `session` (
|
|
`id` int(11) NOT NULL,
|
|
`name` varchar(255) NOT NULL,
|
|
`link` varchar(255) NOT NULL,
|
|
`start` datetime NOT NULL,
|
|
`stop` datetime NOT NULL,
|
|
`enabled` tinyint(1) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
--
|
|
-- Dumping data for table `session`
|
|
--
|
|
|
|
INSERT INTO `session` (`id`, `name`, `link`, `start`, `stop`, `enabled`) VALUES
|
|
(5, 'Test session 1', 'Test-session-1', '2018-04-02 10:32:00', '2018-04-02 10:35:00', 1);
|
|
|
|
--
|
|
-- Indexes for dumped tables
|
|
--
|
|
|
|
--
|
|
-- Indexes for table `actions`
|
|
--
|
|
ALTER TABLE `actions`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indexes for table `messages`
|
|
--
|
|
ALTER TABLE `messages`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indexes for table `session`
|
|
--
|
|
ALTER TABLE `session`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- AUTO_INCREMENT for dumped tables
|
|
--
|
|
|
|
--
|
|
-- AUTO_INCREMENT for table `actions`
|
|
--
|
|
ALTER TABLE `actions`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
|
|
|
|
--
|
|
-- AUTO_INCREMENT for table `messages`
|
|
--
|
|
ALTER TABLE `messages`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
|
|
|
|
--
|
|
-- AUTO_INCREMENT for table `session`
|
|
--
|
|
ALTER TABLE `session`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
|
|
COMMIT;
|
|
|
|
/*!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 */;
|