· 5 years ago · Jul 09, 2020, 06:32 AM
1-- MySQL dump 10.13 Distrib 5.6.43, for Win64 (x86_64)
2--
3-- Host: localhost Database: wordpress
4-- ------------------------------------------------------
5-- Server version 5.6.43
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 `wp_posts`
20--
21
22DROP TABLE IF EXISTS `wp_posts`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `wp_posts` (
26 `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
27 `post_author` bigint(20) unsigned NOT NULL DEFAULT '0',
28 `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
29 `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
30 `post_content` longtext NOT NULL,
31 `post_title` text NOT NULL,
32 `post_excerpt` text NOT NULL,
33 `post_status` varchar(20) NOT NULL DEFAULT 'publish',
34 `comment_status` varchar(20) NOT NULL DEFAULT 'open',
35 `ping_status` varchar(20) NOT NULL DEFAULT 'open',
36 `post_password` varchar(20) NOT NULL DEFAULT '',
37 `post_name` varchar(200) NOT NULL DEFAULT '',
38 `to_ping` text NOT NULL,
39 `pinged` text NOT NULL,
40 `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
41 `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
42 `post_content_filtered` longtext NOT NULL,
43 `post_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
44 `guid` varchar(255) NOT NULL DEFAULT '',
45 `menu_order` int(11) NOT NULL DEFAULT '0',
46 `post_type` varchar(20) NOT NULL DEFAULT 'post',
47 `post_mime_type` varchar(100) NOT NULL DEFAULT '',
48 `comment_count` bigint(20) NOT NULL DEFAULT '0',
49 PRIMARY KEY (`ID`)
50) ENGINE=InnoDB AUTO_INCREMENT=2296 DEFAULT CHARSET=utf8;
51/*!40101 SET character_set_client = @saved_cs_client */;
52
53--
54-- Dumping data for table `wp_posts`
55--
56
57LOCK TABLES `wp_posts` WRITE;
58/*!40000 ALTER TABLE `wp_posts` DISABLE KEYS */;
59INSERT INTO `wp_posts` VALUES (2291,3,'2007-12-15 23:50:26','0000-00-00 00:00:00','Содержимое заметки1','Название заметки1','','','','','','','','','0000-00-00 00:00:00','0000-00-00 00:00:00','',0,'',0,'','',0),(2292,4,'2007-12-15 23:50:27','0000-00-00 00:00:00','Содержимое заметки2','Название заметки2','','','','','','','','','0000-00-00 00:00:00','0000-00-00 00:00:00','',0,'',0,'','',0),(2294,1234,'2020-07-08 15:50:43','0000-00-00 00:00:00','афывафвыаыа','фывафыв','','publish','open','open','','','','','0000-00-00 00:00:00','0000-00-00 00:00:00','',0,'',0,'post','',0),(2295,0,'2020-07-08 15:50:59','0000-00-00 00:00:00','2452345','2345234','','publish','open','open','','','','','0000-00-00 00:00:00','0000-00-00 00:00:00','',0,'',0,'post','',0);
60/*!40000 ALTER TABLE `wp_posts` ENABLE KEYS */;
61UNLOCK TABLES;
62/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
63
64/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
65/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
66/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
67/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
68/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
69/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
70/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
71
72-- Dump completed on 2020-07-08 15:55:20