pyHUkNYg

1-- MySQL dump 10.13  Distrib 5.7.22, for Linux (x86_64)
2--
3-- Host: localhost    Database: asset_manager
4-- ------------------------------------------------------
5-- Server version	5.7.22-0ubuntu0.16.04.1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `assetmgr_asset_file`
20--
21
22DROP TABLE IF EXISTS `assetmgr_asset_file`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `assetmgr_asset_file` (
26  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier for asset file.',
27  `fk_asset_version_id` bigint(20) NOT NULL COMMENT 'Active version id linked to the file.',
28  `fk_repository_id` smallint(6) NOT NULL COMMENT 'Asset repository identifier linked from asset_repository.',
29  `fk_content_sub_type_id` smallint(6) NOT NULL COMMENT 'Content sub type mapped to the asset file.',
30  `file_name` varchar(250) NOT NULL COMMENT 'asset file name',
31  `asset_path` varchar(510) NOT NULL COMMENT 'Asset file path.',
32  `preview_path` varchar(510) DEFAULT NULL COMMENT 'Asset preview file path.',
33  `cover_image_path` varchar(510) NOT NULL COMMENT 'Asset cover image path.',
34  `file_size` int(11) DEFAULT NULL COMMENT 'Asset file size, in bytes',
35  `hash` varchar(255) DEFAULT NULL COMMENT 'Hash value for the asset.',
36  `repository_params` text COMMENT 'Additional repository parameters if any.',
37  `tika_metatags` text COMMENT 'Tika metatags',
38  `created_by` int(11) DEFAULT NULL COMMENT 'This field has information about the asset file created by user id.',
39  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'This field has information about the asset file created date and time.',
40  `updated_by` int(11) DEFAULT NULL COMMENT 'This field has information about the asset file last updated by user id.',
41  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'This field has information about the last updated asset file.',
42  PRIMARY KEY (`id`),
43  KEY `Asset to repository relationship_idx` (`fk_repository_id`),
44  KEY `mime type id_idx` (`fk_content_sub_type_id`),
45  KEY `Asset content to asset relationship` (`fk_asset_version_id`),
46  CONSTRAINT `Asset content to asset relationship` FOREIGN KEY (`fk_asset_version_id`) REFERENCES `assetmgr_asset_version` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
47  CONSTRAINT `Asset to repository relationship` FOREIGN KEY (`fk_repository_id`) REFERENCES `assetmgr_repository` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
48  CONSTRAINT `mime type id` FOREIGN KEY (`fk_content_sub_type_id`) REFERENCES `assetmgr_content_sub_type` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
49) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='This table has all the information related to the actual asset storage repository based on the content sub type, paths to the asset, its cover image and preview image and file size. ';
50/*!40101 SET character_set_client = @saved_cs_client */;
51
52--
53-- Dumping data for table `assetmgr_asset_file`
54--
55
56LOCK TABLES `assetmgr_asset_file` WRITE;
57/*!40000 ALTER TABLE `assetmgr_asset_file` DISABLE KEYS */;
58INSERT INTO `assetmgr_asset_file` VALUES (1,1,1,22,'Pat-and-Stan-Opera-short.mp4','VIDEO/CP4_VIDEO_5b360a5443f0d/1/20180629160100_CP4_VIDEO_5b360a5443f0d_528867384.mp4','VIDEO/CP4_VIDEO_5b360a5443f0d/1/20180629160104_CP4_COVERIMAGE_5b360a5443f0d_1335940042.jpg','VIDEO/CP4_VIDEO_5b360a5443f0d/1/20180629160104_CP4_COVERIMAGE_5b360a5443f0d_1335940042.jpg',1543725,'35132341a8e1b05174db98f2600bbe22',NULL,'{\"Content-Type\":\"video/mp4\",\"Creation-Date\":\"1904-01-01T00:00:00Z\",\"Last-Modified\":\"2014-01-25T08:29:24Z\",\"Last-Save-Date\":\"2014-01-25T08:29:24Z\",\"X-Parsed-By\":[\"org.apache.tika.parser.DefaultParser\",\"org.apache.tika.parser.mp4.MP4Parser\"],\"date\":\"2014-01-25T08:29:24Z\",\"dcterms:created\":\"1904-01-01T00:00:00Z\",\"dcterms:modified\":\"2014-01-25T08:29:24Z\",\"language\":\"\",\"meta:creation-date\":\"1904-01-01T00:00:00Z\",\"meta:save-date\":\"2014-01-25T08:29:24Z\",\"modified\":\"2014-01-25T08:29:24Z\",\"tiff:ImageLength\":\"360\",\"tiff:ImageWidth\":\"640\",\"xmpDM:audioSampleRate\":\"600\",\"xmpDM:duration\":\"27.49\"}',2,'2018-06-29 10:30:43',NULL,NULL),(2,1,2,22,'Pat-and-Stan-Opera-short.mp4','VIDEO/CP4_VIDEO_5b360a5443f0d/1/20180629160100_CP4_VIDEO_5b360a5443f0d_528867384.mp4','videos/XyJVtuQw.mp4','VIDEO/CP4_VIDEO_5b360a5443f0d/1/20180629160104_CP4_COVERIMAGE_5b360a5443f0d_1335940042.jpg',1543725,'35132341a8e1b05174db98f2600bbe22',NULL,'{\"Content-Type\":\"video/mp4\",\"Creation-Date\":\"1904-01-01T00:00:00Z\",\"Last-Modified\":\"2014-01-25T08:29:24Z\",\"Last-Save-Date\":\"2014-01-25T08:29:24Z\",\"X-Parsed-By\":[\"org.apache.tika.parser.DefaultParser\",\"org.apache.tika.parser.mp4.MP4Parser\"],\"date\":\"2014-01-25T08:29:24Z\",\"dcterms:created\":\"1904-01-01T00:00:00Z\",\"dcterms:modified\":\"2014-01-25T08:29:24Z\",\"language\":\"\",\"meta:creation-date\":\"1904-01-01T00:00:00Z\",\"meta:save-date\":\"2014-01-25T08:29:24Z\",\"modified\":\"2014-01-25T08:29:24Z\",\"tiff:ImageLength\":\"360\",\"tiff:ImageWidth\":\"640\",\"xmpDM:audioSampleRate\":\"600\",\"xmpDM:duration\":\"27.49\"}',2,'2018-06-29 10:30:44',NULL,NULL);
59/*!40000 ALTER TABLE `assetmgr_asset_file` ENABLE KEYS */;
60UNLOCK TABLES;
61
62--
63-- Table structure for table `assetmgr_asset_master`
64--
65
66DROP TABLE IF EXISTS `assetmgr_asset_master`;
67/*!40101 SET @saved_cs_client     = @@character_set_client */;
68/*!40101 SET character_set_client = utf8 */;
69CREATE TABLE `assetmgr_asset_master` (
70  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier for the asset.',
71  `asset_code` varchar(100) NOT NULL COMMENT 'Access code for the asset.',
72  `asset_url_path` varchar(200) DEFAULT NULL,
73  `fk_content_type_id` smallint(6) NOT NULL COMMENT 'Content type of the asset.',
74  `editorial_version` decimal(4,2) DEFAULT NULL COMMENT 'Latest version of the asset.',
75  `published_version` decimal(2,0) DEFAULT NULL,
76  `fk_editorial_status_id` smallint(5) NOT NULL COMMENT 'Status of the asset whether it is in authored status or published status.',
77  `asset_status_id` smallint(6) DEFAULT NULL COMMENT 'status of the asset',
78  `steward_id` int(11) DEFAULT NULL,
79  `created_by` int(11) DEFAULT NULL COMMENT 'This field has information about the asset is created by the user id.',
80  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'This field has information about the asset is created date and time.',
81  `updated_by` int(11) DEFAULT NULL COMMENT 'This field has information about the asset is last updated by the user id.',
82  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'This field has information about the asset is last updated date and time.',
83  PRIMARY KEY (`id`),
84  KEY `Asset Change Status_idx` (`fk_editorial_status_id`),
85  KEY `Content type` (`fk_content_type_id`),
86  CONSTRAINT `Asset Change Status` FOREIGN KEY (`fk_editorial_status_id`) REFERENCES `assetmgr_status_master` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
87  CONSTRAINT `Content type` FOREIGN KEY (`fk_content_type_id`) REFERENCES `assetmgr_content_type` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
88) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='The master table for all the assets in the Asset Manager Component. Asset table would contain the basic information about the asset and the linking to the latest version of an asset, latest editorial status, content type of the asset and whether asset is soft deleted flag.';
89/*!40101 SET character_set_client = @saved_cs_client */;
90
91--
92-- Dumping data for table `assetmgr_asset_master`
93--
94
95LOCK TABLES `assetmgr_asset_master` WRITE;
96/*!40000 ALTER TABLE `assetmgr_asset_master` DISABLE KEYS */;
97INSERT INTO `assetmgr_asset_master` VALUES (1,'CP4_VIDEO_5b360a5443f0d',NULL,8,1.00,NULL,5,1,1,2,'2018-06-29 10:30:43',NULL,'2018-06-29 10:30:43');
98/*!40000 ALTER TABLE `assetmgr_asset_master` ENABLE KEYS */;
99UNLOCK TABLES;
100
101--
102-- Table structure for table `assetmgr_asset_metadata`
103--
104
105DROP TABLE IF EXISTS `assetmgr_asset_metadata`;
106/*!40101 SET @saved_cs_client     = @@character_set_client */;
107/*!40101 SET character_set_client = utf8 */;
108CREATE TABLE `assetmgr_asset_metadata` (
109  `assetmgr_asset_metadata_id` int(11) NOT NULL AUTO_INCREMENT,
110  `metadata_id` int(11) NOT NULL COMMENT 'meta data mapping id',
111  `fk_asset_version_id` bigint(20) NOT NULL COMMENT 'reference to asset version table',
112  `metadata_value` varchar(255) NOT NULL,
113  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
114  `created_by` int(11) DEFAULT NULL,
115  `updated_at` timestamp NULL DEFAULT NULL,
116  `updated_by` int(11) DEFAULT NULL,
117  PRIMARY KEY (`assetmgr_asset_metadata_id`),
118  KEY `fk_assetmgr_asset_metadata_assetmgr_asset_version1_idx` (`fk_asset_version_id`),
119  CONSTRAINT `fk_assetmgr_asset_metadata_assetmgr_asset_version1` FOREIGN KEY (`fk_asset_version_id`) REFERENCES `assetmgr_asset_version` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
120) ENGINE=InnoDB DEFAULT CHARSET=latin1;
121/*!40101 SET character_set_client = @saved_cs_client */;
122
123--
124-- Dumping data for table `assetmgr_asset_metadata`
125--
126
127LOCK TABLES `assetmgr_asset_metadata` WRITE;
128/*!40000 ALTER TABLE `assetmgr_asset_metadata` DISABLE KEYS */;
129/*!40000 ALTER TABLE `assetmgr_asset_metadata` ENABLE KEYS */;
130UNLOCK TABLES;
131
132--
133-- Table structure for table `assetmgr_asset_version`
134--
135
136DROP TABLE IF EXISTS `assetmgr_asset_version`;
137/*!40101 SET @saved_cs_client     = @@character_set_client */;
138/*!40101 SET character_set_client = utf8 */;
139CREATE TABLE `assetmgr_asset_version` (
140  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier for the version created for assets.',
141  `asset_id` bigint(20) NOT NULL COMMENT 'Asset id to which the version was created.',
142  `version` decimal(4,2) NOT NULL COMMENT 'Version of the asset.',
143  `name` varchar(255) NOT NULL COMMENT 'Title of the asset.',
144  `description` varchar(1000) DEFAULT NULL COMMENT 'Description of the asset.',
145  `effective_date` date DEFAULT NULL COMMENT 'From which the asset would be effective usage date.',
146  `terminate_date` date DEFAULT NULL COMMENT 'Expiry of the asset.',
147  `fk_status_id` smallint(6) NOT NULL COMMENT 'Status of the version.',
148  `version_comments` varchar(255) DEFAULT NULL,
149  `keywords` varchar(1000) DEFAULT NULL COMMENT 'meta keywords for the asset',
150  `created_by` int(11) DEFAULT NULL COMMENT 'This field has information about the asset version created by user id.',
151  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'This field has information about the asset version created date and time.',
152  `updated_by` int(11) DEFAULT NULL COMMENT 'This field has information about the asset version is last updated by user id.',
153  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'This field has information about the asset version is last updated date and time.',
154  PRIMARY KEY (`id`),
155  KEY `Revision to asset relationship_idx` (`asset_id`),
156  CONSTRAINT `Revision to asset relationship` FOREIGN KEY (`asset_id`) REFERENCES `assetmgr_asset_master` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
157) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='This table has different versions of the asset edits with the basic details on the date and time edited or versioned.';
158/*!40101 SET character_set_client = @saved_cs_client */;
159
160--
161-- Dumping data for table `assetmgr_asset_version`
162--
163
164LOCK TABLES `assetmgr_asset_version` WRITE;
165/*!40000 ALTER TABLE `assetmgr_asset_version` DISABLE KEYS */;
166INSERT INTO `assetmgr_asset_version` VALUES (1,1,1.00,'Pat-and-Stan-Opera-short','Pat-and-Stan-Opera-short Video upload test','2018-05-02','2018-05-14',5,'v1.0','video,mp4,JWPlayer,coverimage,subtitles',NULL,'2018-06-29 10:30:43',NULL,NULL);
167/*!40000 ALTER TABLE `assetmgr_asset_version` ENABLE KEYS */;
168UNLOCK TABLES;
169
170--
171-- Table structure for table `assetmgr_content_sub_type`
172--
173
174DROP TABLE IF EXISTS `assetmgr_content_sub_type`;
175/*!40101 SET @saved_cs_client     = @@character_set_client */;
176/*!40101 SET character_set_client = utf8 */;
177CREATE TABLE `assetmgr_content_sub_type` (
178  `id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier for the content sub type.',
179  `content_type_id` smallint(6) NOT NULL COMMENT 'Content type id mapping. ',
180  `name` varchar(255) NOT NULL COMMENT 'Name of the content sub type.',
181  `description` varchar(1000) DEFAULT NULL COMMENT 'Description of the content sub type.',
182  `mime_type` varchar(255) NOT NULL COMMENT 'MIME type of the content sub type.',
183  `created_by` int(11) DEFAULT NULL COMMENT 'This field has information about the content sub type created by user id.',
184  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'This field has information about the content sub type created at date and time.',
185  `updated_by` int(11) DEFAULT NULL COMMENT 'This field has information about the content sub type last updated by user id.',
186  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'This field has information about the content sub type last updated date and time.',
187  PRIMARY KEY (`id`),
188  KEY `content_type__content_mime_type_idx` (`content_type_id`),
189  CONSTRAINT `content_type__content_mime_type` FOREIGN KEY (`content_type_id`) REFERENCES `assetmgr_content_type` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
190) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COMMENT='This table would contain the sub types of the content for example for word document content type we would have multiple sub types like doc, docx etc.';
191/*!40101 SET character_set_client = @saved_cs_client */;
192
193--
194-- Dumping data for table `assetmgr_content_sub_type`
195--
196
197LOCK TABLES `assetmgr_content_sub_type` WRITE;
198/*!40000 ALTER TABLE `assetmgr_content_sub_type` DISABLE KEYS */;
199INSERT INTO `assetmgr_content_sub_type` VALUES (1,1,'.pdf','pdf content sub types','application/pdf',1,'2018-03-19 11:00:49',NULL,'2018-05-28 09:43:03'),(2,3,'.html','htmlcontent sub types','text/html',1,'2018-03-19 11:00:49',NULL,'2018-05-28 09:43:03'),(4,2,'.ppt','ppt mime type','application/vnd.ms-powerpoint',1,'2018-03-19 11:00:49',NULL,'2018-05-28 09:43:03'),(5,2,'.pot','ppt mime type','application/vnd.ms-powerpoint',1,'2018-03-19 11:00:49',NULL,'2018-05-28 09:43:03'),(6,2,'.pps','ppt mime type','application/vnd.ms-powerpoint',1,'2018-03-19 11:00:49',NULL,'2018-05-28 09:43:03'),(7,2,'.ppa','ppt mime type','application/vnd.ms-powerpoint',1,'2018-03-19 11:00:49',NULL,'2018-05-28 09:43:03'),(8,2,'.pptx','ppt mime type','applicationapplication/vnd.openxmlformats-officedocument.presentationml.presentation',1,'2018-03-19 11:00:49',NULL,'2018-05-28 09:43:03'),(9,2,'.potx','ppt mime type','applicationapplication/vnd.openxmlformats-officedocument.presentationml.template',1,'2018-03-19 11:00:49',NULL,'2018-05-28 09:43:03'),(10,2,'.ppsx','ppt mime type','applicationapplication/vnd.openxmlformats-officedocument.presentationml.slideshow',1,'2018-03-19 11:00:49',NULL,'2018-05-28 09:43:03'),(11,2,'.ppam','ppt mime type','applicationapplication/vnd.ms-powerpoint.addin.macroEnabled.12',1,'2018-03-19 11:00:49',NULL,'2018-05-28 09:43:03'),(12,2,'.pptm','ppt mime type','applicationapplication/vnd.ms-powerpoint.presentation.macroEnabled.12',1,'2018-03-19 11:00:49',NULL,'2018-05-28 09:43:03'),(13,2,'.potm','ppt mime type','applicationapplication/vnd.ms-powerpoint.template.macroEnabled.12',1,'2018-03-19 11:00:49',NULL,'2018-05-28 09:43:03'),(14,2,'.ppsm','ppt mime type','applicationapplication/vnd.ms-powerpoint.slideshow.macroEnabled.12',1,'2018-03-19 11:00:49',NULL,'2018-05-28 09:43:03'),(15,5,'.jpg','jpg mime type','image/jpeg',1,'2018-06-08 12:13:16',NULL,NULL),(16,5,'.jpeg','jpeg mime type','image/jpeg',1,'2018-06-08 12:13:16',NULL,NULL),(17,5,'.png','png mime type','image/png',1,'2018-06-08 12:13:16',NULL,NULL),(18,5,'.gif','gif mime type','image/gif',1,'2018-06-08 12:13:16',NULL,NULL),(19,4,'.doc','doc mime type','application/msword',1,'2018-06-09 20:27:01',NULL,NULL),(20,4,'.docx','docx mime type','application/vnd.openxmlformats-officedocument.wordprocessingml.document',1,'2018-06-11 07:18:02',NULL,NULL),(21,4,'.docx','docx mime type','application/zip',1,'2018-06-18 10:41:31',NULL,NULL),(22,8,'.mp4','mp4 mime type','video/mp4',1,'2018-06-19 09:53:26',NULL,'2018-06-25 07:20:06'),(23,8,'.flv','flv mime type','video/x-flv',1,'2018-06-19 09:53:26',NULL,'2018-06-25 07:20:06'),(24,8,'.3gp','3gp mime type','video/octate-stream',1,'2018-06-19 09:53:26',NULL,'2018-06-25 07:20:06'),(26,8,'.avi','avi mime type','video/x-msvideo',1,'2018-06-19 09:53:26',NULL,'2018-06-25 07:20:06'),(27,8,'.wmv','wmv mime type','video/x-ms-wmv',1,'2018-06-19 09:53:26',NULL,'2018-06-25 07:20:06'),(28,8,'.mkv','mkv mime type','video/x-matroska',1,'2018-06-19 10:05:13',NULL,'2018-06-25 07:20:06'),(29,8,'.3gp','3gp mime type','video/3gpp',1,'2018-06-19 10:27:47',NULL,'2018-06-25 07:20:06');
200/*!40000 ALTER TABLE `assetmgr_content_sub_type` ENABLE KEYS */;
201UNLOCK TABLES;
202
203--
204-- Table structure for table `assetmgr_content_type`
205--
206
207DROP TABLE IF EXISTS `assetmgr_content_type`;
208/*!40101 SET @saved_cs_client     = @@character_set_client */;
209/*!40101 SET character_set_client = utf8 */;
210CREATE TABLE `assetmgr_content_type` (
211  `id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier for the content type.',
212  `name` varchar(255) NOT NULL COMMENT 'Name of the content type.',
213  `description` varchar(1000) DEFAULT NULL COMMENT 'Description of the content type.',
214  `created_by` int(11) DEFAULT NULL COMMENT 'This field has information about the content type is created by user id.',
215  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'This field has information about the content type is created date and time.',
216  `updated_by` int(11) DEFAULT NULL COMMENT 'This field has information about the conent type is last updated by date and time.',
217  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'This field has information about the content type is last updated date and time.',
218  PRIMARY KEY (`id`)
219) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='This table contains the different content types available for assets, like word, pdf, ppt, video or audio. Multiple assets can belong to a single content type.';
220/*!40101 SET character_set_client = @saved_cs_client */;
221
222--
223-- Dumping data for table `assetmgr_content_type`
224--
225
226LOCK TABLES `assetmgr_content_type` WRITE;
227/*!40000 ALTER TABLE `assetmgr_content_type` DISABLE KEYS */;
228INSERT INTO `assetmgr_content_type` VALUES (1,'PDF','pdf content type',1,'2018-03-19 10:58:21',NULL,NULL),(2,'PPT','power point content type',1,'2018-03-19 10:59:53',NULL,NULL),(3,'HTML','HTML content type',1,'2018-03-19 10:59:53',NULL,NULL),(4,'WORD','Word content type',1,'2018-03-19 10:59:53',NULL,NULL),(5,'IMAGE','Image content type',1,'2018-03-19 10:59:53',NULL,NULL),(6,'ARTICULATE360','Articulate360 content type',1,'2018-06-19 09:46:48',NULL,'2018-06-25 07:17:25'),(7,'LMSCATRIDGE','LMS Catridge content type',1,'2018-06-25 07:17:25',NULL,'2018-06-25 07:19:01'),(8,'VIDEO','Video content type',1,'2018-06-25 07:17:25',NULL,NULL);
229/*!40000 ALTER TABLE `assetmgr_content_type` ENABLE KEYS */;
230UNLOCK TABLES;
231
232--
233-- Table structure for table `assetmgr_content_type_handler`
234--
235
236DROP TABLE IF EXISTS `assetmgr_content_type_handler`;
237/*!40101 SET @saved_cs_client     = @@character_set_client */;
238/*!40101 SET character_set_client = utf8 */;
239CREATE TABLE `assetmgr_content_type_handler` (
240  `handler_id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier for the content sub type.',
241  `content_type_id` smallint(6) NOT NULL COMMENT 'Content type id mapping. ',
242  `name` varchar(255) NOT NULL COMMENT 'Name of the content type handler.',
243  `created_by` int(11) DEFAULT NULL COMMENT 'This field has information about the content handler created by user id.',
244  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'This field has information about the content handler created at date and time.',
245  `updated_by` int(11) DEFAULT NULL COMMENT 'This field has information about the content handler last updated by user id.',
246  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'This field has information about the content handler last updated date and time.',
247  PRIMARY KEY (`handler_id`)
248) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
249/*!40101 SET character_set_client = @saved_cs_client */;
250
251--
252-- Dumping data for table `assetmgr_content_type_handler`
253--
254
255LOCK TABLES `assetmgr_content_type_handler` WRITE;
256/*!40000 ALTER TABLE `assetmgr_content_type_handler` DISABLE KEYS */;
257INSERT INTO `assetmgr_content_type_handler` VALUES (1,1,'PdfHandler',NULL,'2018-05-29 10:28:59',NULL,NULL),(2,2,'PptHandler',NULL,'2018-05-29 10:28:59',NULL,NULL),(3,3,'HtmlHandler',NULL,'2018-05-29 10:28:59',NULL,NULL),(4,4,'WordHandler',NULL,'2018-05-29 10:28:59',NULL,NULL),(5,5,'ImageHandler',NULL,'2018-05-29 10:28:59',NULL,NULL),(6,6,'Articulate360Handler',NULL,'2018-05-29 10:28:59',NULL,'2018-06-25 07:19:17'),(7,7,'LmsCatridgeHandler',NULL,'2018-06-25 07:19:17',NULL,NULL),(8,8,'VideoHandler',NULL,'2018-06-25 07:19:17',NULL,NULL);
258/*!40000 ALTER TABLE `assetmgr_content_type_handler` ENABLE KEYS */;
259UNLOCK TABLES;
260
261--
262-- Table structure for table `assetmgr_html`
263--
264
265DROP TABLE IF EXISTS `assetmgr_html`;
266/*!40101 SET @saved_cs_client     = @@character_set_client */;
267/*!40101 SET character_set_client = utf8 */;
268CREATE TABLE `assetmgr_html` (
269  `id` bigint(20) NOT NULL AUTO_INCREMENT,
270  `fk_css_id` smallint(6) NOT NULL,
271  `fk_asset_version_id` bigint(20) NOT NULL,
272  PRIMARY KEY (`id`),
273  KEY `Default CSS linked_idx` (`fk_css_id`),
274  KEY `Version Mapping_idx` (`fk_asset_version_id`),
275  CONSTRAINT `Default CSS linked` FOREIGN KEY (`fk_css_id`) REFERENCES `assetmgr_html_css_master` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
276  CONSTRAINT `Version Mapping` FOREIGN KEY (`fk_asset_version_id`) REFERENCES `assetmgr_asset_version` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
277) ENGINE=InnoDB DEFAULT CHARSET=utf8;
278/*!40101 SET character_set_client = @saved_cs_client */;
279
280--
281-- Dumping data for table `assetmgr_html`
282--
283
284LOCK TABLES `assetmgr_html` WRITE;
285/*!40000 ALTER TABLE `assetmgr_html` DISABLE KEYS */;
286/*!40000 ALTER TABLE `assetmgr_html` ENABLE KEYS */;
287UNLOCK TABLES;
288
289--
290-- Table structure for table `assetmgr_html_css_master`
291--
292
293DROP TABLE IF EXISTS `assetmgr_html_css_master`;
294/*!40101 SET @saved_cs_client     = @@character_set_client */;
295/*!40101 SET character_set_client = utf8 */;
296CREATE TABLE `assetmgr_html_css_master` (
297  `id` smallint(6) NOT NULL AUTO_INCREMENT,
298  `name` varchar(100) NOT NULL,
299  `file_path` varchar(255) NOT NULL,
300  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
301  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
302  PRIMARY KEY (`id`)
303) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table to store the default css available for HTML Asset';
304/*!40101 SET character_set_client = @saved_cs_client */;
305
306--
307-- Dumping data for table `assetmgr_html_css_master`
308--
309
310LOCK TABLES `assetmgr_html_css_master` WRITE;
311/*!40000 ALTER TABLE `assetmgr_html_css_master` DISABLE KEYS */;
312/*!40000 ALTER TABLE `assetmgr_html_css_master` ENABLE KEYS */;
313UNLOCK TABLES;
314
315--
316-- Table structure for table `assetmgr_repository`
317--
318
319DROP TABLE IF EXISTS `assetmgr_repository`;
320/*!40101 SET @saved_cs_client     = @@character_set_client */;
321/*!40101 SET character_set_client = utf8 */;
322CREATE TABLE `assetmgr_repository` (
323  `id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'Uniuqe identifier for the repositories.',
324  `name` varchar(50) NOT NULL COMMENT 'Name of the repository.',
325  `access_details` text COMMENT 'Access details for the repositorY.',
326  `created_by` int(11) DEFAULT NULL COMMENT 'This field has information about the repository created by user id.',
327  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'This field has information about the repository created date and time.',
328  `updated_by` int(11) DEFAULT NULL COMMENT 'This field has information about the asset updated by user id.',
329  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'This field has information about the repository updated date and time.',
330  PRIMARY KEY (`id`)
331) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='This table contains the repository specific information for assets and access details for the repository for different repository types.';
332/*!40101 SET character_set_client = @saved_cs_client */;
333
334--
335-- Dumping data for table `assetmgr_repository`
336--
337
338LOCK TABLES `assetmgr_repository` WRITE;
339/*!40000 ALTER TABLE `assetmgr_repository` DISABLE KEYS */;
340INSERT INTO `assetmgr_repository` VALUES (1,'S3 Bucket','key=7438hdsfdsgsfdsfw432',1,'2018-03-29 10:39:23',NULL,NULL),(2,'jwplayer','{  \n   \"key\":\"3LDsUl2g\",\n   \"secret_key\":\"VGNsixzB6ZpCKS18o9vjVS3E\",\n   \"jw_thumb_url\":\"/videos/thumbnails/update\",\n   \"jw_tracks_create_url\":\"/videos/tracks/create\",\n   \"jw_video_create_url\":\"/videos/create\",\n   \"render_url\":\"http://content.jwplatform.com\",\n   \"player_id\":\"U8rebkrx\",\n   \"botr_api_format\":\"json\",\n   \"jw_tracks_update_url\":\"/videos/tracks/update\",\n   \"video_update_url\":\"/videos/update\"\n}',1,'2018-06-21 11:00:00',NULL,'2018-06-26 10:47:22');
341/*!40000 ALTER TABLE `assetmgr_repository` ENABLE KEYS */;
342UNLOCK TABLES;
343
344--
345-- Table structure for table `assetmgr_status_master`
346--
347
348DROP TABLE IF EXISTS `assetmgr_status_master`;
349/*!40101 SET @saved_cs_client     = @@character_set_client */;
350/*!40101 SET character_set_client = utf8 */;
351CREATE TABLE `assetmgr_status_master` (
352  `id` smallint(5) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier for editorial statuses.',
353  `name` varchar(255) NOT NULL COMMENT 'Name of the status.',
354  `description` varchar(1000) DEFAULT NULL COMMENT 'Description about the editorial status.',
355  `status_category` varchar(100) DEFAULT NULL COMMENT 'category to which the status belongs',
356  `created_by` int(11) DEFAULT NULL COMMENT 'This field has information about the asset is created by the user id.',
357  `updated_by` int(11) DEFAULT NULL COMMENT 'This field has information about the asset is last updated by the user id.',
358  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'This field has information about the asset is created date and time.',
359  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'This field has information about the asset is updated date and time.',
360  PRIMARY KEY (`id`)
361) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='This table contains the editorial status of the asset.';
362/*!40101 SET character_set_client = @saved_cs_client */;
363
364--
365-- Dumping data for table `assetmgr_status_master`
366--
367
368LOCK TABLES `assetmgr_status_master` WRITE;
369/*!40000 ALTER TABLE `assetmgr_status_master` DISABLE KEYS */;
370INSERT INTO `assetmgr_status_master` VALUES (1,'ACTIVE','Active','DAFAULT',1,NULL,'2018-03-19 11:41:35',NULL),(2,'INACTIVE','Inactive','DEFAULT',1,NULL,'2018-03-19 11:44:40',NULL),(3,'DELETED','Deleted','DEFAULT',1,NULL,'2018-03-19 11:44:40',NULL),(4,'PUBLISHED','Published','EDITORIAL',1,NULL,'2018-03-19 11:44:40',NULL),(5,'AUTHORING','Authoring','EDITORIAL',1,NULL,'2018-03-19 11:44:40','2018-04-02 08:23:17');
371/*!40000 ALTER TABLE `assetmgr_status_master` ENABLE KEYS */;
372UNLOCK TABLES;
373
374--
375-- Table structure for table `assetmgr_video`
376--
377
378DROP TABLE IF EXISTS `assetmgr_video`;
379/*!40101 SET @saved_cs_client     = @@character_set_client */;
380/*!40101 SET character_set_client = utf8 */;
381CREATE TABLE `assetmgr_video` (
382  `id` int(11) NOT NULL AUTO_INCREMENT,
383  `asset_version_id` bigint(11) NOT NULL,
384  `resolution` varchar(50) DEFAULT NULL,
385  `duration` int(11) DEFAULT NULL,
386  `custom_data` text,
387  `created_by` int(11) DEFAULT NULL,
388  `created_at` datetime DEFAULT NULL,
389  `updated_by` int(11) DEFAULT NULL,
390  `updated_at` datetime DEFAULT NULL,
391  PRIMARY KEY (`id`),
392  KEY `assetmgr_video__assetmgr_asset_version_idx` (`asset_version_id`),
393  CONSTRAINT `fk_assetmgr_video_1` FOREIGN KEY (`asset_version_id`) REFERENCES `assetmgr_asset_version` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
394) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COMMENT='This table has the specific asset video information with its specific propertied like resolution, duration and custom data.';
395/*!40101 SET character_set_client = @saved_cs_client */;
396
397--
398-- Dumping data for table `assetmgr_video`
399--
400
401LOCK TABLES `assetmgr_video` WRITE;
402/*!40000 ALTER TABLE `assetmgr_video` DISABLE KEYS */;
403INSERT INTO `assetmgr_video` VALUES (1,1,'360x640',27,'{\"status\":\"ok\",\"media\":{\"type\":\"video\",\"key\":\"XyJVtuQw\"},\"file\":{\"md5\":\"35132341a8e1b05174db98f2600bbe22\",\"size\":\"1543725\"},\"redirect_link\":null,\"extension\":\"mp4\"}',NULL,NULL,NULL,NULL);
404/*!40000 ALTER TABLE `assetmgr_video` ENABLE KEYS */;
405UNLOCK TABLES;
406
407--
408-- Table structure for table `assetmgr_video_cc_file`
409--
410
411DROP TABLE IF EXISTS `assetmgr_video_cc_file`;
412/*!40101 SET @saved_cs_client     = @@character_set_client */;
413/*!40101 SET character_set_client = utf8 */;
414CREATE TABLE `assetmgr_video_cc_file` (
415  `id` int(11) NOT NULL AUTO_INCREMENT,
416  `asset_file_id` bigint(11) NOT NULL,
417  `assetmgr_video_id` int(11) NOT NULL,
418  `language` varchar(10) DEFAULT NULL,
419  `repository_id` smallint(11) DEFAULT NULL,
420  `repository_params` text,
421  `cc_path` varchar(1000) DEFAULT NULL,
422  `created_by` int(11) DEFAULT NULL,
423  `created_at` datetime DEFAULT NULL,
424  `updated_by` int(11) DEFAULT NULL,
425  `updated_at` datetime DEFAULT NULL,
426  PRIMARY KEY (`id`),
427  KEY `assetmgr_video_cc_file__assetmgr_video_idx` (`asset_file_id`),
428  KEY `assetmgr_video_cc_file__repository_idx` (`repository_id`),
429  KEY `fk_assetmgr_video_cc_file_1_idx` (`asset_file_id`,`assetmgr_video_id`),
430  KEY `fk_assetmgr_video_cc_file_2_idx` (`assetmgr_video_id`),
431  CONSTRAINT `fk_assetmgr_video_cc_file_1` FOREIGN KEY (`asset_file_id`) REFERENCES `assetmgr_asset_file` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
432  CONSTRAINT `fk_assetmgr_video_cc_file_2` FOREIGN KEY (`assetmgr_video_id`) REFERENCES `assetmgr_video` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
433  CONSTRAINT `fk_assetmgr_video_cc_file_3` FOREIGN KEY (`repository_id`) REFERENCES `assetmgr_repository` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
434) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='This table contains the Video Closed Caption files linked to a single video file and would contain the video closed caption specific storage/repository information.';
435/*!40101 SET character_set_client = @saved_cs_client */;
436
437--
438-- Dumping data for table `assetmgr_video_cc_file`
439--
440
441LOCK TABLES `assetmgr_video_cc_file` WRITE;
442/*!40000 ALTER TABLE `assetmgr_video_cc_file` DISABLE KEYS */;
443INSERT INTO `assetmgr_video_cc_file` VALUES (1,1,1,'',2,'[\"\\/var\\/www\\/html\\/assets-api\\/uploads\\/VIDEO\\/CC_en_GB_1530268244.srt\",{\"status\":\"ok\",\"media\":{\"type\":\"track\",\"key\":\"z7hpOY7Z\"},\"file\":{\"md5\":\"5de78016d2e376502071644c830183af\",\"size\":\"169\"},\"redirect_link\":null}]','\"\\/var\\/www\\/html\\/assets-api\\/uploads\\/VIDEO\\/CC_en_GB_1530268244.srt\"',NULL,NULL,NULL,NULL);
444/*!40000 ALTER TABLE `assetmgr_video_cc_file` ENABLE KEYS */;
445UNLOCK TABLES;
446
447--
448-- Table structure for table `common_steward_master`
449--
450
451DROP TABLE IF EXISTS `common_steward_master`;
452/*!40101 SET @saved_cs_client     = @@character_set_client */;
453/*!40101 SET character_set_client = utf8 */;
454CREATE TABLE `common_steward_master` (
455  `id` int(11) NOT NULL AUTO_INCREMENT,
456  `name` varchar(255) NOT NULL,
457  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
458  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
459  PRIMARY KEY (`id`),
460  UNIQUE KEY `name_UNIQUE` (`name`)
461) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
462/*!40101 SET character_set_client = @saved_cs_client */;
463
464--
465-- Dumping data for table `common_steward_master`
466--
467
468LOCK TABLES `common_steward_master` WRITE;
469/*!40000 ALTER TABLE `common_steward_master` DISABLE KEYS */;
470INSERT INTO `common_steward_master` VALUES (1,'Nursing Standard',NULL,NULL);
471/*!40000 ALTER TABLE `common_steward_master` ENABLE KEYS */;
472UNLOCK TABLES;
473/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
474
475/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
476/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
477/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
478/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
479/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
480/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
481/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
482
483-- Dump completed on 2018-06-29 16:54:05