· 4 years ago · Aug 19, 2021, 07:32 PM
1-- MySQL dump 10.13 Distrib 5.7.35, for Linux (x86_64)
2--
3-- Host: localhost Database: ossn
4-- ------------------------------------------------------
5-- Server version 5.7.35-0ubuntu0.18.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 `ossn_annotations`
20--
21
22DROP TABLE IF EXISTS `ossn_annotations`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `ossn_annotations` (
26 `id` bigint(20) NOT NULL AUTO_INCREMENT,
27 `owner_guid` bigint(20) NOT NULL,
28 `subject_guid` bigint(20) NOT NULL,
29 `type` varchar(30) NOT NULL,
30 `time_created` int(11) NOT NULL,
31 PRIMARY KEY (`id`),
32 KEY `owner_guid` (`owner_guid`),
33 KEY `subject_guid` (`subject_guid`),
34 KEY `time_created` (`time_created`),
35 KEY `type` (`type`)
36) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
37/*!40101 SET character_set_client = @saved_cs_client */;
38
39--
40-- Dumping data for table `ossn_annotations`
41--
42
43LOCK TABLES `ossn_annotations` WRITE;
44/*!40000 ALTER TABLE `ossn_annotations` DISABLE KEYS */;
45/*!40000 ALTER TABLE `ossn_annotations` ENABLE KEYS */;
46UNLOCK TABLES;
47
48--
49-- Table structure for table `ossn_components`
50--
51
52DROP TABLE IF EXISTS `ossn_components`;
53/*!40101 SET @saved_cs_client = @@character_set_client */;
54/*!40101 SET character_set_client = utf8 */;
55CREATE TABLE `ossn_components` (
56 `id` bigint(20) NOT NULL AUTO_INCREMENT,
57 `com_id` varchar(50) NOT NULL,
58 `active` int(11) NOT NULL,
59 PRIMARY KEY (`id`)
60) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4;
61/*!40101 SET character_set_client = @saved_cs_client */;
62
63--
64-- Dumping data for table `ossn_components`
65--
66
67LOCK TABLES `ossn_components` WRITE;
68/*!40000 ALTER TABLE `ossn_components` DISABLE KEYS */;
69INSERT INTO `ossn_components` VALUES (1,'OssnProfile',1),(2,'OssnWall',1),(3,'OssnComments',1),(4,'OssnLikes',1),(5,'OssnPhotos',1),(6,'OssnNotifications',1),(7,'OssnSearch',1),(8,'OssnMessages',1),(9,'OssnAds',1),(10,'OssnGroups',1),(11,'OssnSitePages',1),(12,'OssnBlock',1),(13,'OssnChat',1),(14,'OssnPoke',1),(15,'OssnInvite',1),(16,'OssnEmbed',1),(17,'OssnSmilies',1),(18,'OssnSounds',1),(19,'OssnAutoPagination',1),(20,'OssnMessageTyping',1),(21,'OssnRealTimeComments',1),(22,'OssnPostBackground',1);
70/*!40000 ALTER TABLE `ossn_components` ENABLE KEYS */;
71UNLOCK TABLES;
72
73--
74-- Table structure for table `ossn_entities`
75--
76
77DROP TABLE IF EXISTS `ossn_entities`;
78/*!40101 SET @saved_cs_client = @@character_set_client */;
79/*!40101 SET character_set_client = utf8 */;
80CREATE TABLE `ossn_entities` (
81 `guid` bigint(20) NOT NULL AUTO_INCREMENT,
82 `owner_guid` bigint(20) NOT NULL,
83 `type` varchar(20) NOT NULL,
84 `subtype` varchar(50) NOT NULL,
85 `time_created` int(11) NOT NULL,
86 `time_updated` int(11) DEFAULT NULL,
87 `permission` int(11) NOT NULL,
88 `active` int(11) NOT NULL,
89 PRIMARY KEY (`guid`),
90 KEY `owner_guid` (`owner_guid`),
91 KEY `time_created` (`time_created`),
92 KEY `time_updated` (`time_updated`),
93 KEY `active` (`active`),
94 KEY `permission` (`permission`),
95 KEY `type` (`type`),
96 KEY `subtype` (`subtype`),
97 KEY `eky_ts` (`type`,`subtype`),
98 KEY `eky_tso` (`type`,`subtype`,`owner_guid`)
99) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
100/*!40101 SET character_set_client = @saved_cs_client */;
101
102--
103-- Dumping data for table `ossn_entities`
104--
105
106LOCK TABLES `ossn_entities` WRITE;
107/*!40000 ALTER TABLE `ossn_entities` DISABLE KEYS */;
108INSERT INTO `ossn_entities` VALUES (1,1,'user','birthdate',1629396528,0,2,1),(2,1,'user','gender',1629396528,0,2,1),(3,1,'user','password_algorithm',1629396528,0,2,1);
109/*!40000 ALTER TABLE `ossn_entities` ENABLE KEYS */;
110UNLOCK TABLES;
111
112--
113-- Table structure for table `ossn_entities_metadata`
114--
115
116DROP TABLE IF EXISTS `ossn_entities_metadata`;
117/*!40101 SET @saved_cs_client = @@character_set_client */;
118/*!40101 SET character_set_client = utf8 */;
119CREATE TABLE `ossn_entities_metadata` (
120 `id` bigint(20) NOT NULL AUTO_INCREMENT,
121 `guid` bigint(20) NOT NULL,
122 `value` longtext NOT NULL,
123 PRIMARY KEY (`id`),
124 KEY `guid` (`guid`),
125 FULLTEXT KEY `value` (`value`)
126) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
127/*!40101 SET character_set_client = @saved_cs_client */;
128
129--
130-- Dumping data for table `ossn_entities_metadata`
131--
132
133LOCK TABLES `ossn_entities_metadata` WRITE;
134/*!40000 ALTER TABLE `ossn_entities_metadata` DISABLE KEYS */;
135INSERT INTO `ossn_entities_metadata` VALUES (1,1,'03/12/1986'),(2,2,'male'),(3,3,'bcrypt');
136/*!40000 ALTER TABLE `ossn_entities_metadata` ENABLE KEYS */;
137UNLOCK TABLES;
138
139--
140-- Table structure for table `ossn_likes`
141--
142
143DROP TABLE IF EXISTS `ossn_likes`;
144/*!40101 SET @saved_cs_client = @@character_set_client */;
145/*!40101 SET character_set_client = utf8 */;
146CREATE TABLE `ossn_likes` (
147 `id` bigint(20) NOT NULL AUTO_INCREMENT,
148 `subject_id` bigint(20) NOT NULL,
149 `guid` bigint(20) NOT NULL,
150 `type` varchar(30) NOT NULL,
151 `subtype` varchar(10) DEFAULT NULL,
152 PRIMARY KEY (`id`),
153 KEY `subtype` (`subtype`)
154) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
155/*!40101 SET character_set_client = @saved_cs_client */;
156
157--
158-- Dumping data for table `ossn_likes`
159--
160
161LOCK TABLES `ossn_likes` WRITE;
162/*!40000 ALTER TABLE `ossn_likes` DISABLE KEYS */;
163/*!40000 ALTER TABLE `ossn_likes` ENABLE KEYS */;
164UNLOCK TABLES;
165
166--
167-- Table structure for table `ossn_messages`
168--
169
170DROP TABLE IF EXISTS `ossn_messages`;
171/*!40101 SET @saved_cs_client = @@character_set_client */;
172/*!40101 SET character_set_client = utf8 */;
173CREATE TABLE `ossn_messages` (
174 `id` bigint(20) NOT NULL AUTO_INCREMENT,
175 `message_from` bigint(20) NOT NULL,
176 `message_to` bigint(20) NOT NULL,
177 `message` text NOT NULL,
178 `viewed` varchar(1) DEFAULT NULL,
179 `time` int(11) NOT NULL,
180 PRIMARY KEY (`id`),
181 KEY `message_to` (`message_to`),
182 KEY `message_from` (`message_from`)
183) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
184/*!40101 SET character_set_client = @saved_cs_client */;
185
186--
187-- Dumping data for table `ossn_messages`
188--
189
190LOCK TABLES `ossn_messages` WRITE;
191/*!40000 ALTER TABLE `ossn_messages` DISABLE KEYS */;
192/*!40000 ALTER TABLE `ossn_messages` ENABLE KEYS */;
193UNLOCK TABLES;
194
195--
196-- Table structure for table `ossn_notifications`
197--
198
199DROP TABLE IF EXISTS `ossn_notifications`;
200/*!40101 SET @saved_cs_client = @@character_set_client */;
201/*!40101 SET character_set_client = utf8 */;
202CREATE TABLE `ossn_notifications` (
203 `guid` bigint(20) NOT NULL AUTO_INCREMENT,
204 `type` varchar(50) NOT NULL,
205 `poster_guid` bigint(20) NOT NULL,
206 `owner_guid` bigint(20) NOT NULL,
207 `subject_guid` bigint(20) NOT NULL,
208 `viewed` varchar(1) DEFAULT NULL,
209 `time_created` int(11) NOT NULL,
210 `item_guid` bigint(20) NOT NULL,
211 PRIMARY KEY (`guid`),
212 KEY `poster_guid` (`poster_guid`),
213 KEY `owner_guid` (`owner_guid`),
214 KEY `subject_guid` (`subject_guid`),
215 KEY `time_created` (`time_created`),
216 KEY `item_guid` (`item_guid`),
217 KEY `type` (`type`)
218) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
219/*!40101 SET character_set_client = @saved_cs_client */;
220
221--
222-- Dumping data for table `ossn_notifications`
223--
224
225LOCK TABLES `ossn_notifications` WRITE;
226/*!40000 ALTER TABLE `ossn_notifications` DISABLE KEYS */;
227/*!40000 ALTER TABLE `ossn_notifications` ENABLE KEYS */;
228UNLOCK TABLES;
229
230--
231-- Table structure for table `ossn_object`
232--
233
234DROP TABLE IF EXISTS `ossn_object`;
235/*!40101 SET @saved_cs_client = @@character_set_client */;
236/*!40101 SET character_set_client = utf8 */;
237CREATE TABLE `ossn_object` (
238 `guid` bigint(20) NOT NULL AUTO_INCREMENT,
239 `owner_guid` bigint(20) NOT NULL,
240 `type` varchar(20) NOT NULL,
241 `time_created` int(11) NOT NULL,
242 `title` text NOT NULL,
243 `description` longtext NOT NULL,
244 `subtype` varchar(30) NOT NULL,
245 PRIMARY KEY (`guid`),
246 KEY `owner_guid` (`owner_guid`),
247 KEY `time_created` (`time_created`),
248 KEY `type` (`type`),
249 KEY `subtype` (`subtype`),
250 KEY `oky_ts` (`type`,`subtype`),
251 KEY `oky_tsg` (`type`,`subtype`,`guid`)
252) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
253/*!40101 SET character_set_client = @saved_cs_client */;
254
255--
256-- Dumping data for table `ossn_object`
257--
258
259LOCK TABLES `ossn_object` WRITE;
260/*!40000 ALTER TABLE `ossn_object` DISABLE KEYS */;
261/*!40000 ALTER TABLE `ossn_object` ENABLE KEYS */;
262UNLOCK TABLES;
263
264--
265-- Table structure for table `ossn_relationships`
266--
267
268DROP TABLE IF EXISTS `ossn_relationships`;
269/*!40101 SET @saved_cs_client = @@character_set_client */;
270/*!40101 SET character_set_client = utf8 */;
271CREATE TABLE `ossn_relationships` (
272 `relation_id` bigint(20) NOT NULL AUTO_INCREMENT,
273 `relation_from` bigint(20) NOT NULL,
274 `relation_to` bigint(20) NOT NULL,
275 `type` varchar(30) NOT NULL,
276 `time` int(11) NOT NULL,
277 PRIMARY KEY (`relation_id`),
278 KEY `relation_to` (`relation_to`),
279 KEY `relation_from` (`relation_from`),
280 KEY `time` (`time`),
281 KEY `type` (`type`)
282) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
283/*!40101 SET character_set_client = @saved_cs_client */;
284
285--
286-- Dumping data for table `ossn_relationships`
287--
288
289LOCK TABLES `ossn_relationships` WRITE;
290/*!40000 ALTER TABLE `ossn_relationships` DISABLE KEYS */;
291/*!40000 ALTER TABLE `ossn_relationships` ENABLE KEYS */;
292UNLOCK TABLES;
293
294--
295-- Table structure for table `ossn_site_settings`
296--
297
298DROP TABLE IF EXISTS `ossn_site_settings`;
299/*!40101 SET @saved_cs_client = @@character_set_client */;
300/*!40101 SET character_set_client = utf8 */;
301CREATE TABLE `ossn_site_settings` (
302 `setting_id` bigint(20) NOT NULL AUTO_INCREMENT,
303 `name` varchar(30) NOT NULL,
304 `value` text NOT NULL,
305 PRIMARY KEY (`setting_id`)
306) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4;
307/*!40101 SET character_set_client = @saved_cs_client */;
308
309--
310-- Dumping data for table `ossn_site_settings`
311--
312
313LOCK TABLES `ossn_site_settings` WRITE;
314/*!40000 ALTER TABLE `ossn_site_settings` DISABLE KEYS */;
315INSERT INTO `ossn_site_settings` VALUES (1,'theme','goblue'),(2,'site_name','facespace'),(3,'language','en'),(4,'cache','1'),(5,'owner_email','someone@gcc.com'),(6,'notification_email','someone@gcc.com'),(7,'upgrades','[\"1410545706.php\",\"1411396351.php\", \"1412353569.php\",\"1415553653.php\",\"1415819862.php\", \"1423419053.php\", \"1423419054.php\", \"1439295894.php\", \"1440716428.php\", \"1440867331.php\", \"1440603377.php\", \"1443202118.php\", \"1443211017.php\", \"1443545762.php\", \"1443617470.php\", \"1446311454.php\", \"1448807613.php\", \"1453676400.php\", \"1459411815.php\", \"1468010638.php\", \"1470127853.php\", \"1480759958.php\", \"1495366993.php\", \"1513524535.php\", \"1513603766.php\", \"1513783390.php\", \"1542223614.php\", \"1564080285.php\", \"1577836800.php\", \"1597058454.php\", \"1597734806.php\", \"1598389337.php\", \"1605286634.php\"]'),(9,'display_errors','off'),(10,'site_key','4da4fe03'),(11,'last_cache','1629396534'),(12,'site_version','5.6');
316/*!40000 ALTER TABLE `ossn_site_settings` ENABLE KEYS */;
317UNLOCK TABLES;
318
319--
320-- Table structure for table `ossn_users`
321--
322
323DROP TABLE IF EXISTS `ossn_users`;
324/*!40101 SET @saved_cs_client = @@character_set_client */;
325/*!40101 SET character_set_client = utf8 */;
326CREATE TABLE `ossn_users` (
327 `guid` bigint(20) NOT NULL AUTO_INCREMENT,
328 `type` text NOT NULL,
329 `username` text NOT NULL,
330 `email` text NOT NULL,
331 `password` text NOT NULL,
332 `salt` varchar(8) NOT NULL,
333 `first_name` text NOT NULL,
334 `last_name` text NOT NULL,
335 `last_login` int(11) NOT NULL,
336 `last_activity` int(11) NOT NULL,
337 `activation` varchar(32) DEFAULT NULL,
338 `time_created` int(11) NOT NULL,
339 PRIMARY KEY (`guid`),
340 KEY `last_login` (`last_login`),
341 KEY `last_activity` (`last_activity`),
342 KEY `time_created` (`time_created`),
343 FULLTEXT KEY `type` (`type`),
344 FULLTEXT KEY `email` (`email`),
345 FULLTEXT KEY `first_name` (`first_name`),
346 FULLTEXT KEY `last_name` (`last_name`)
347) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
348/*!40101 SET character_set_client = @saved_cs_client */;
349
350--
351-- Dumping data for table `ossn_users`
352--
353
354LOCK TABLES `ossn_users` WRITE;
355/*!40000 ALTER TABLE `ossn_users` DISABLE KEYS */;
356INSERT INTO `ossn_users` VALUES (1,'admin','allknowing','someone@somewhere.net','$2y$10$3TwFrKKK4/HWVXmjiDejO.hIpCZwUWeJJLk6Rhdx1Jf/zjFgssbZO','e3067944','alan','cantrell',0,0,'',1629396528);
357/*!40000 ALTER TABLE `ossn_users` ENABLE KEYS */;
358UNLOCK TABLES;
359/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
360
361/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
362/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
363/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
364/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
365/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
366/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
367/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
368
369-- Dump completed on 2021-08-19 19:14:06