· 6 years ago · Apr 23, 2019, 06:22 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 5.1.41 - Source distribution
4-- Server OS: Win32
5-- HeidiSQL Version: 10.1.0.5479
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12
13
14-- Dumping database structure for payrightlight
15CREATE DATABASE IF NOT EXISTS `payrightlight` /*!40100 DEFAULT CHARACTER SET latin1 */;
16USE `payrightlight`;
17
18-- Dumping structure for table payrightlight.payright_version
19CREATE TABLE IF NOT EXISTS `payright_version` (
20 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
21 `solution` enum('MAJOR','MINOR','REVISION','BUILD') DEFAULT 'BUILD',
22 `version` varchar(50) DEFAULT NULL,
23 `full_version` varchar(50) DEFAULT NULL,
24 `description` text,
25 `parent_id` int(11) NOT NULL DEFAULT '0',
26 `publish` tinyint(1) unsigned NOT NULL DEFAULT '0',
27 `notes` text,
28 `create_date` datetime DEFAULT NULL,
29 `create_user` int(11) unsigned NOT NULL DEFAULT '0',
30 `edit_date` datetime DEFAULT NULL,
31 `edit_user` int(11) unsigned NOT NULL DEFAULT '0',
32 `delete_date` datetime DEFAULT NULL,
33 `delete_user` int(11) unsigned NOT NULL DEFAULT '0',
34 `active` tinyint(1) unsigned NOT NULL DEFAULT '1',
35 PRIMARY KEY (`id`)
36) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;
37
38-- Dumping data for table payrightlight.payright_version: 20 rows
39/*!40000 ALTER TABLE `payright_version` DISABLE KEYS */;
40INSERT INTO `payright_version` (`id`, `solution`, `version`, `full_version`, `description`, `parent_id`, `publish`, `notes`, `create_date`, `create_user`, `edit_date`, `edit_user`, `delete_date`, `delete_user`, `active`) VALUES
41 (3, 'MAJOR', '1.0', '1.0.0.0', 'Final Release\n', 1, 1, 'Update dibatalkan', '2018-08-10 14:06:25', 1, '2018-08-10 23:17:36', 1, '2018-08-10 23:17:36', 1, 1),
42 (4, 'BUILD', '1.0.0.1', '1.0.0.1', '* New Built-in skin\n<br /><br />\n+ Added broadcast notification feature\n<br />\n+ Added Dark mode to chat\n<br />\n+ Added the ability to play shorten (SHN) audio file\n<br />\n+ Added the ability to show playlist thumbnail at 16:9\n<br /><br />\n- Improved handling in length calculation of MPEG file\n<br />\n- Fixed an issue that can\'t play certain MPEG files\n<br />\n- Improved H264 DSC handling of video capture\n<br />\n- Improved cue playback processing\n<br />\n- Fixed a problem where subtitle navigation did not work properly\n<br />\n- Fixed a problem that screen was broken when playing certain WMV3\n<br />\n- Fixed a problem where subtitles did not synchronize finely when playing FLV file\n', 3, 1, 'The ancestral version has been deleted', '2018-08-10 14:06:37', 1, '2018-08-10 23:17:36', 1, '2018-08-10 23:17:36', 1, 1),
43 (5, 'REVISION', '1.0.1', '1.0.1.0', '* New Built-in skin\n<br /><br />\n+ Added broadcast notification feature\n<br />\n+ Added Dark mode to chat\n<br />\n+ Added the ability to play shorten (SHN) audio file\n<br />\n+ Added the ability to show playlist thumbnail at 16:9\n<br /><br />\n- Improved handling in length calculation of MPEG file\n<br />\n- Fixed an issue that can\'t play certain MPEG files\n<br />\n- Improved H264 DSC handling of video capture\n<br />\n- Improved cue playback processing\n<br />\n- Fixed a problem where subtitle navigation did not work properly\n<br />\n- Fixed a problem that screen was broken when playing certain WMV3\n<br />\n- Fixed a problem where subtitles did not synchronize finely when playing FLV file\n', 3, 1, 'The ancestral version has been deleted', '2018-08-10 15:37:37', 1, '2018-08-10 23:17:36', 1, '2018-08-10 23:17:36', 1, 1),
44 (6, 'BUILD', '1.0.1.1', '1.0.1.1', 'test', 5, 0, 'The ancestral version has been deleted', '2018-08-10 15:37:56', 1, '2018-08-10 23:17:36', 1, '2018-08-10 23:17:36', 1, 1),
45 (7, 'BUILD', '1.0.1.2', '1.0.1.2', 'test', 5, 0, 'The ancestral version has been deleted', '2018-08-10 15:44:08', 1, '2018-08-10 23:17:36', 1, '2018-08-14 13:25:14', 1, 0),
46 (8, 'MAJOR', '2.0', '2.0.0.0', NULL, 1, 0, NULL, '2018-08-13 16:02:03', 1, NULL, 0, '2018-08-13 16:02:20', 1, 0),
47 (1, 'MAJOR', '0.0', '0.0.0.0', 'Alpha', 0, 0, NULL, '2018-08-10 14:06:02', 1, NULL, 0, NULL, 0, 1),
48 (2, 'MINOR', '0.1', '0.1.0.0', 'Beta\n', 1, 0, NULL, '2018-08-10 14:06:14', 1, '2018-08-10 14:53:17', 1, '2018-08-10 15:50:10', 1, 0),
49 (9, 'MAJOR', '2.0', '2.0.0.0', 'OKE', 1, 0, NULL, '2018-08-13 16:09:01', 1, NULL, 0, '2018-08-13 16:09:19', 1, 0),
50 (10, 'MAJOR', '2.0', '2.0.0.0', '* New Built-in skin\r\n<br /><br />\r\n+ Added broadcast notification feature\r\n<br />\r\n+ Added Dark mode to chat\r\n<br />\r\n+ Added the ability to play shorten (SHN) audio file\r\n<br />\r\n+ Added the ability to show playlist thumbnail at 16:9\r\n<br /><br />\r\n- Improved handling in length calculation of MPEG file\r\n<br />\r\n- Fixed an issue that can\'t play certain MPEG files\r\n<br />\r\n- Improved H264 DSC handling of video capture\r\n<br />\r\n- Improved cue playback processing\r\n<br />\r\n- Fixed a problem where subtitle navigation did not work properly\r\n<br />\r\n- Fixed a problem that screen was broken when playing certain WMV3\r\n<br />\r\n- Fixed a problem where subtitles did not synchronize finely when playing FLV file\r\n', 1, 0, NULL, '2018-08-14 11:27:28', 1, NULL, 0, NULL, 0, 1),
51 (21, 'MAJOR', '6.0', '6.0.0.0', '{"user":{"new":["New Built-in skin"],"add":["Added broadcast notification feature ","Added Dark mode to chat","Added the ability to play shorten (SHN) audio file","Added the ability to show playlist thumbnail at 16:9 "],"fix":["Improved handling in length calculation of MPEG file","Fixed an issue that can\'t play certain MPEG files","Improved H264 DSC handling of video capture"],"notes":["Test Notes User"]},"dev":{"new":["New Built-in skin "],"add":["Added the ability to play shorten (SHN) audio file","Added the ability to show playlist thumbnail at 16:9 "],"fix":["Improved cue playback processing"],"notes":["This Notes"]}}', 1, 0, NULL, '2018-08-15 10:15:57', 1, '2018-08-15 10:52:13', 1, NULL, 0, 1),
52 (19, 'MAJOR', '4.0', '4.0.0.0', '{"user":{"new":["aaaa"]}}', 1, 0, NULL, '2018-08-14 17:01:03', 1, NULL, 0, NULL, 0, 1),
53 (20, 'MAJOR', '5.0', '5.0.0.0', '{"user":{"notes":["desc user"]}}', 1, 0, NULL, '2018-08-15 09:58:32', 1, NULL, 0, NULL, 0, 1),
54 (18, 'MAJOR', '3.0', '3.0.0.0', '{"user":{"new":["u"],"add":["d"],"fix":["fg","err"]},"dev":{"new":["aac"],"add":["d"]}}', 1, 0, NULL, '2018-08-14 16:48:01', 1, NULL, 0, '2018-08-15 10:52:34', 1, 0),
55 (22, 'MAJOR', '7.0', '7.0.0.0', '{"user":{"new":["eee"],"add":["2222"],"fix":["2222","3333"],"notes":["Test"]},"dev":{"new":["44"],"add":["345353","345435"],"notes":["333"]}}', 1, 0, NULL, '2018-08-15 10:57:14', 1, NULL, 0, '2018-08-15 10:57:36', 1, 0),
56 (23, 'MAJOR', '7.0', '7.0.0.0', '{"user":{"new":["test"],"add":["aaa"],"fix":["ddfc"],"notes":["ca"]},"dev":{"new":["ee"],"notes":["asdf"]}}', 1, 1, NULL, '2018-08-15 11:12:42', 1, NULL, 0, NULL, 0, 1),
57 (24, 'MAJOR', '8.0', '8.0.0.0', '{"dev":{"new":["sdfasdf"],"add":["Add"],"fix":["sdfsafd"],"notes":["Developer Notes"]}}', 1, 0, NULL, '2018-08-15 11:12:54', 1, '2018-08-15 11:16:20', 1, NULL, 0, 1),
58 (25, 'MAJOR', '9.0', '9.0.0.0', '{"dev":{"new":["new"],"notes":["ddd"]}}', 1, 0, NULL, '2018-08-15 11:23:51', 1, '2018-08-15 11:55:53', 1, NULL, 0, 1),
59 (26, 'MAJOR', '10.0', '10.0.0.0', '{"user":{"notes":["<ul>\\n<li>Test <span style=\\"color: #0000ff;\\"><strong>Notes<\\/strong><\\/span><\\/li>\\n<li><span style=\\"color: #ff0000;\\"><strong>2<\\/strong><\\/span><\\/li>\\n<li><span style=\\"background-color: #ffff00;\\"><em><strong>3<\\/strong><\\/em><\\/span><\\/li>\\n<\\/ul>"]}}', 1, 1, NULL, '2018-08-23 13:35:31', 1, '2018-08-23 13:42:35', 1, NULL, 0, 1),
60 (27, 'MAJOR', '11.0', '11.0.0.0', '{"user":{"notes":["<ul>\\n<li><span style=\\"color: #008080;\\"><strong><em>TextArea<\\/em><\\/strong><\\/span><\\/li>\\n<\\/ul>"]}}', 1, 1, NULL, '2018-08-23 13:47:58', 1, '2018-08-23 14:25:09', 1, NULL, 0, 1);
61/*!40000 ALTER TABLE `payright_version` ENABLE KEYS */;
62
63/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
64/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
65/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;