| PRAGMA foreign_keys=OFF; |
| BEGIN TRANSACTION; |
| CREATE TABLE android_metadata (locale TEXT); |
| INSERT INTO "android_metadata" VALUES('en_US'); |
| CREATE TABLE accounts (id integer primary key autoincrement, url text, blogName text, username text, password text, imagePlacement text, centerThumbnail boolean, fullSizeImage boolean, maxImageWidth text, maxImageWidthId integer, lastCommentId integer, runService boolean, blogId integer, location boolean default false, dotcom_username text, dotcom_password text, api_key text, api_blogid text, dotcomFlag boolean default false, wpVersion text, httpuser text, httppassword text, postFormats text default '', isScaledImage boolean default false, scaledImgWidth integer default 1024, homeURL text default '', blog_options text default '', isAdmin boolean default false, isHidden boolean default 0); |
| INSERT INTO accounts VALUES(31,'https://tataliwut.wordpress.com/xmlrpc.php','Empty blog stays empty','test','','',1,0,'2000',0,NULL,0,59073674,0,NULL,NULL,NULL,NULL,1,'','','','{"audio":"Son","standard":"Par défaut","status":"Statut","gallery":"Galerie","quote":"Citation","link":"Lien","image":"Image","chat":"Discussion","aside":"En passant","video":"Vidéo"}',0,1024,'https://tataliwut.wordpress.com/','{"home_url":{"value":"http://tataliwut.wordpress.com","readonly":true,"desc":"Adresse web du site (URL)"},"post_thumbnail":{"value":true,"readonly":true,"desc":"Miniature d\u0026rsquo;article"},"software_version":{"value":"3.8.1","readonly":true,"desc":"Software Version"},"blog_public":{"value":"1","readonly":true,"desc":"Accès aux renseignements confidentiels"},"admin_url":{"value":"https://tataliwut.wordpress.com/wp-admin/","readonly":true,"desc":"L\u0026rsquo;adresse web de la zone d\u0026rsquo;administration"},"login_url":{"value":"https://tataliwut.wordpress.com/wp-login.php","readonly":true,"desc":"Adresse de connexion (URL)"}}',1,0); |
| INSERT INTO accounts VALUES(32,'https://ilovecutecats.wordpress.com/xmlrpc.php','I Love Cute Cats','test','','',0,0,'2000',0,NULL,0,61784930,'false',NULL,NULL,NULL,NULL,1,'','','','','false',1024,'https://ilovecutecats.wordpress.com/','',1,0); |
| INSERT INTO accounts VALUES(22,'https://taliwutblog.wordpress.com/xmlrpc.php','taliwut & blog','test','','',0,0,'2000',0,NULL,0,57991476,'false',NULL,NULL,NULL,NULL,1,'','','','','false',1024,'https://taliwutblog.wordpress.com/','',1,0); |
| CREATE TABLE posts (id integer primary key autoincrement, blogID text, postid text, title text default '', dateCreated date, date_created_gmt date, categories text default '', custom_fields text default '', description text default '', link text default '', mt_allow_comments boolean, mt_allow_pings boolean, mt_excerpt text default '', mt_keywords text default '', mt_text_more text default '', permaLink text default '', post_status text default '', userid integer default 0, wp_author_display_name text default '', wp_author_id text default '', wp_password text default '', wp_post_format text default '', wp_slug text default '', mediaPaths text default '', latitude real, longitude real, localDraft boolean default 0, uploaded boolean default 0, isPage boolean default 0, wp_page_parent_id text, wp_page_parent_title text, isLocalChange boolean default 0); |
| INSERT INTO posts VALUES(1,'1',NULL,'qswq',NULL,0,'[]','','<p>qwswqs<br></p>','',NULL,NULL,'','','','','publish',0,'','','','standard','','',0.0,0.0,1,1,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(5,'1','23','qswq',1392633989000,1392633989000,'["Uncategorized"]','["{value=1392633989, id=91, key=jabber_published}"]','qwswqsarst','https://tataliwut.wordpress.com/2014/02/17/qswq/',1,1,'','','','https://tataliwut.wordpress.com/2014/02/17/qswq/','publish',55434822,'taliwutt','55434822','','standard','qswq','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(26,'16','306','enft',1392134640000,1392134640000,'["Uncategorized"]','["{value=1392048234, id=1411, key=jabber_published}"]','','https://taliwutblog.wordpress.com/2014/02/11/enft/',1,1,'','','','https://taliwutblog.wordpress.com/2014/02/11/enft/','publish',55434822,'taliwutt','55434822','','standard','enft','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(27,'22','333','Fun with URLs',1392118235000,1392118235000,'["Uncategorized"]','["{value=1392118236, id=1425, key=jabber_published}"]','<a href="//">test 1</a> <a href="//login">Test 2</a>','https://taliwutblog.wordpress.com/2014/02/11/fun-with-urls/',1,1,'','','','https://taliwutblog.wordpress.com/2014/02/11/fun-with-urls/','publish',55434822,'taliwutt','55434822','','standard','fun-with-urls','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(28,'22','331','wftfwtfw',1392050448000,1392050448000,'["Uncategorized"]','["{value=1392050448, id=1418, key=jabber_published}"]','hb','https://taliwutblog.wordpress.com/2014/02/10/wftfwtfw/',1,1,'','','','https://taliwutblog.wordpress.com/2014/02/10/wftfwtfw/','publish',55434822,'taliwutt','55434822','','standard','wftfwtfw','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(29,'22','330','#BookReview Bridget Jones: Mad About the Boy',1391606384000,1391606384000,'["Uncategorized"]','["{value=57991476, id=1406, key=blog_id}","{value=1, id=1407, key=is_reblog}","{value=1391606386, id=1400, key=jabber_published}","{value=302, id=1405, key=post_id}"]','jey*','https://taliwutblog.wordpress.com/2014/02/05/bookreview-bridget-jones-mad-about-the-boy-4/',1,1,'','','','https://taliwutblog.wordpress.com/2014/02/05/bookreview-bridget-jones-mad-about-the-boy-4/','publish',55434822,'taliwutt','55434822','','standard','bookreview-bridget-jones-mad-about-the-boy-4','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(30,'22','329','#BookReview Bridget Jones: Mad About the Boy',1391606378000,1391606378000,'["Uncategorized"]','["{value=57991476, id=1397, key=blog_id}","{value=1, id=1398, key=is_reblog}","{value=1391606379, id=1391, key=jabber_published}","{value=302, id=1396, key=post_id}"]','e*','https://taliwutblog.wordpress.com/2014/02/05/bookreview-bridget-jones-mad-about-the-boy-3/',1,1,'','','','https://taliwutblog.wordpress.com/2014/02/05/bookreview-bridget-jones-mad-about-the-boy-3/','publish',55434822,'taliwutt','55434822','','standard','bookreview-bridget-jones-mad-about-the-boy-3','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(31,'22','327','Watch "NORMAN - LUIGI CLASH MARIO" on YouTube',1391604133000,1391604133000,'["Uncategorized"]','["{value=1391604135, id=1384, key=jabber_published}"]','<a href="http://www.youtube.com/watch?v=GP7aP67qQjQ">http://www.youtube.com/watch?v=GP7aP67qQjQ</a>','https://taliwutblog.wordpress.com/2014/02/05/watch-norman-luigi-clash-mario-on-youtube/',1,1,'','','','https://taliwutblog.wordpress.com/2014/02/05/watch-norman-luigi-clash-mario-on-youtube/','publish',55434822,'taliwutt','55434822','','standard','watch-norman-luigi-clash-mario-on-youtube','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(32,'22','325','Test YouTube',1391584473000,1391584473000,'["Uncategorized"]','["{value=1391584474, id=1377, key=jabber_published}"]','[youtube https://www.youtube.com/watch?v=belUlgnhu9M&w=560&h=315]','https://taliwutblog.wordpress.com/2014/02/05/test-youtube/',1,1,'','','','https://taliwutblog.wordpress.com/2014/02/05/test-youtube/','publish',55434822,'taliwutt','55434822','','standard','test-youtube','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(33,'22','324','Your Keyboard & You. I''ll Stick With Colemak',1391448765000,1391448765000,'["Uncategorized"]','["{value=56042455, id=1372, key=blog_id}","{value=1, id=1373, key=is_reblog}","{value=1391448767, id=1366, key=jabber_published}","{value=631, id=1371, key=post_id}"]','','https://taliwutblog.wordpress.com/2014/02/03/your-keyboard-you-ill-stick-with-colemak-2/',1,1,'','','','https://taliwutblog.wordpress.com/2014/02/03/your-keyboard-you-ill-stick-with-colemak-2/','publish',55434822,'taliwutt','55434822','','standard','your-keyboard-you-ill-stick-with-colemak-2','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(34,'22','323','Your Keyboard & You. I''ll Stick With Colemak',1391448756000,1391448756000,'["Uncategorized"]','["{value=56042455, id=1363, key=blog_id}","{value=1, id=1364, key=is_reblog}","{value=1391448758, id=1357, key=jabber_published}","{value=631, id=1362, key=post_id}"]','','https://taliwutblog.wordpress.com/2014/02/03/your-keyboard-you-ill-stick-with-colemak/',1,1,'','','','https://taliwutblog.wordpress.com/2014/02/03/your-keyboard-you-ill-stick-with-colemak/','publish',55434822,'taliwutt','55434822','','standard','your-keyboard-you-ill-stick-with-colemak','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(35,'22','321','Forget about turns, this is real time chess. It''s hectic, chaotic and short. The winner is the guy who is able to process everything and cope under stress. Welcome to the new chess experience',1391431046000,1391431046000,'["Uncategorized"]','["{value=1391431048, id=1350, key=jabber_published}"]','<a href="http://impactjs.com/forums/games/real-time-chess">http://impactjs.com/forums/games/real-time-chess</a>','https://taliwutblog.wordpress.com/2014/02/03/forget-about-turns-this-is-real-time-chess-its-hectic-chaotic-and-short-the-winner-is-the-guy-who-is-able-to-process-everything-and-cope-under-stress-welcome-to-the-new-chess-experience/',1,1,'','','','https://taliwutblog.wordpress.com/2014/02/03/forget-about-turns-this-is-real-time-chess-its-hectic-chaotic-and-short-the-winner-is-the-guy-who-is-able-to-process-everything-and-cope-under-stress-welcome-to-the-new-chess-experience/','publish',55434822,'taliwutt','55434822','','standard','forget-about-turns-this-is-real-time-chess-its-hectic-chaotic-and-short-the-winner-is-the-guy-who-is-able-to-process-everything-and-cope-under-stress-welcome-to-the-new-chess-experience','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(36,'22','319','Another Pony',1391428271000,1391428271000,'["Uncategorized"]','["{value=1391428272, id=1342, key=jabber_published}"]','<a href="http://taliwutblog.files.wordpress.com/2014/02/wpid-urbanherovantbarreeltje.jpg"><img title="Urbanherovantbarreeltje.JPG" class="alignnone size-full" alt="image" src="http://taliwutblog.files.wordpress.com/2014/02/wpid-urbanherovantbarreeltje.jpg" /></a>','https://taliwutblog.wordpress.com/2014/02/03/another-pony/',1,1,'','','','https://taliwutblog.wordpress.com/2014/02/03/another-pony/','publish',55434822,'taliwutt','55434822','','image','another-pony','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(37,'22','316','Cute pony',1391422828000,1391422828000,'["Uncategorized"]','["{value=1391422828, id=1333, key=jabber_published}"]','<a href="http://taliwutblog.files.wordpress.com/2014/02/wpid-pony1.jpg"><img title="pony.jpg" class="alignnone size-full" alt="image" src="http://taliwutblog.files.wordpress.com/2014/02/wpid-pony1.jpg" /></a>','https://taliwutblog.wordpress.com/2014/02/03/cute-pony-2/',1,1,'','','','https://taliwutblog.wordpress.com/2014/02/03/cute-pony-2/','publish',55434822,'taliwutt','55434822','','image','cute-pony-2','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(38,'22','313','Cute pony',1391420955000,1391420955000,'["Uncategorized"]','["{value=1391420956, id=1324, key=jabber_published}"]','<a href="http://taliwutblog.files.wordpress.com/2014/02/wpid-pony.jpg"><img title="pony.jpg" class="alignnone size-full" alt="image" src="http://taliwutblog.files.wordpress.com/2014/02/wpid-pony.jpg" /></a>','https://taliwutblog.wordpress.com/2014/02/03/cute-pony/',1,1,'','','','https://taliwutblog.wordpress.com/2014/02/03/cute-pony/','publish',55434822,'taliwutt','55434822','','image','cute-pony','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(39,'22','303','The New iOS and Android Apps Have Arrived!',1391108568000,1391108568000,'["Uncategorized"]','["{value=3584907, id=1290, key=blog_id}","{value=1, id=1291, key=is_reblog}","{value=1391108569, id=1286, key=jabber_published}","{value=23682, id=1289, key=post_id}","{value=O:8:\"stdClass\":8:{s:5:\"title\";s:42:\"The New iOS and Android Apps Have Arrived!\";s:4:\"type\";s:4:\"post\";s:9:\"mime_type\";s:0:\"\";s:6:\"format\";b:0;s:12:\"modified_gmt\";s:19:\"2014-01-30 18:59:14\";s:9:\"permalink\";s:60:\"http:\/\/en.blog.wordpress.com\/2014\/01\/30\/updated-ios-android\/\";s:7:\"content\";s:3728:\"<div class=\"reblogged-content\">More and more of us are blogging from our mobile devices. Today, we’re thrilled to announce new versions of the WordPress mobile apps for Android and iOS. Here are some of the new versions'' highlights. <img class=\"aligncenter size-full wp-image-23687\" alt=\"android26-ios39-promo\" src=\"http:\/\/taliwutblog.files.wordpress.com\/2014\/01\/android26-ios39-promo.png\" width=\"635\" height=\"423\" data-originalSrc=\"http:\/\/en.blog.files.wordpress.com\/2014\/01\/android26-ios39-promo.png\" data-rehosted=\"1\"><h3>WordPress for iOS 3.9<\/h3>\n The latest WordPress for iOS update is one of our largest app releases to date. This update is remarkable both for the significant changes we''ve introduced, and for the level of dedication it received from our hard-working team members. Version 3.9 includes a major visual redesign of the app. We decided to drop the sidebar navigation and embrace a tab bar-based layout. The app''s new design allowed us to add numerous visual improvements throughout, including revamped and enhanced Reader, Comments, and Notifications sections. We also created a seamless inline commenting experience to make it easier for you to engage with the content you love. Finally, we made visual improvements to the editing experience of posts and pages.\n Our team has embraced the latest and greatest technologies that Apple has provided us with iOS 7 to deliver you the best app possible. Version 3.9 and future updates will require iOS 7. The app also includes several other changes. On top of various bug fixes and performance improvements, it now supports deep-linking from Twitter, and features an improved login screen. Be sure to try it out: <a href=\"https:\/\/itunes.apple.com\/us\/app\/wordpress\/id335703880?mt=8\">Download from the App Store<\/a> <h3>WordPress for Android 2.6<\/h3>\n The latest update to WordPress for Android includes a new reading and setup experience, as well as significant updates to the user interface. The app Reader has been completely redesigned, and now provides a much-improved, native reading experience. You''ll definitely notice its speed -- posts appear in a snap, and images fade in as they load. You can also view users that have commented or liked posts, as well as edit the list of tags that you follow. We''ve revamped the like, reblog, and comment interfaces to make it easier than ever to respond to posts that strike your fancy.\n When signing in to the app or creating an account on WordPress.com, you’ll notice a brand new user interface that makes it super-simple to start blogging. If you keep multiple blogs on your account, they will all be automatically added for you. You can also hide whichever blogs you don''t wish to work on in the app. We''ve given the app a facelift, including a new color scheme, a refined navigation drawer layout, and sharp-looking lists in notifications, posts, pages and comments.\n You’ll also notice some changes to the post editor, with larger images and a new Post Settings area where you''ll manage post data such as status, post formats, and categories, among others. The post content area will now go full screen while you are editing, to give you maximum space to focus on your content. Give the app a try here: <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=org.wordpress.android\">Download from Google Play<\/a> <h3>What’s next?<\/h3>\n The mobile team isn’t stopping here! We have big plans for the months to come and for the rest of 2014. You can keep up with the development progress over at http:\/\/make.wordpress.org\/mobile. You can also follow the apps on twitter <a href=\"http:\/\/twitter.com\/wpandroid\">@WPAndroid<\/a> and <a href=\"http:\/\/twitter.com\/wordpressios\">@WordPressiOS<\/a>.<\/div>\";s:15:\"images_mirrored\";i:1;}, id=1297, key=reblog_snapshot}"]','','https://taliwutblog.wordpress.com/2014/01/30/the-new-ios-and-android-apps-have-arrived/',1,1,'','','','https://taliwutblog.wordpress.com/2014/01/30/the-new-ios-and-android-apps-have-arrived/','publish',50540106,'Maxime','50540106','','standard','the-new-ios-and-android-apps-have-arrived','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(40,'22','308','art',1391076000000,1391076000000,'["Uncategorized"]','["{value=1391162423, id=1304, key=jabber_published}"]','<strong>wft</strong>','https://taliwutblog.wordpress.com/2014/01/30/art/',1,1,'','','','https://taliwutblog.wordpress.com/2014/01/30/art/','publish',55434822,'taliwutt','55434822','','standard','art','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(41,'22','302','#BookReview Bridget Jones: Mad About the Boy',1390903286000,1390903286000,'["Uncategorized"]','["{value=31639867, id=1282, key=blog_id}","{value=1, id=1283, key=is_reblog}","{value=1390903288, id=1276, key=jabber_published}","{value=7493, id=1281, key=post_id}"]','ib/Tqg','https://taliwutblog.wordpress.com/2014/01/28/bookreview-bridget-jones-mad-about-the-boy-2/',1,1,'','','','https://taliwutblog.wordpress.com/2014/01/28/bookreview-bridget-jones-mad-about-the-boy-2/','publish',55434822,'taliwutt','55434822','','standard','bookreview-bridget-jones-mad-about-the-boy-2','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(42,'22','299','Cat',1390395827000,1390395827000,'["Uncategorized"]','["{value=1390395828, id=1250, key=jabber_published}"]','[caption id="" align="alignnone" width="2000" caption="Mop"]<a href="https://taliwutblog.files.wordpress.com/2013/12/wpid-wp-1388141726961.jpeg"><img title="wpid-wp-1388141726961.jpeg" class="alignnone size-full" alt="image" src="https://taliwutblog.files.wordpress.com/2013/12/wpid-wp-1388141726961.jpeg?w=2000" /></a>[/caption]','https://taliwutblog.wordpress.com/2014/01/22/cat-2/',1,1,'','','','https://taliwutblog.wordpress.com/2014/01/22/cat-2/','publish',55434822,'taliwutt','55434822','','standard','cat-2','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(43,'22','297','hd wallpaper photo - Google Search',1390395578000,1390395578000,'["Uncategorized"]','["{value=1390395578, id=1244, key=jabber_published}"]','<a href="http://www.google.com/search?hl=en&biw=384&bih=640&tbm=isch&sa=1&ei=RbLKUv-lHYem0wW8oYHABA&q=hd+wallpaper+photo&oq=hd+wallpaper+photo&gs_l=mobile-gws-serp.3..0l4j0i5.4612.5034.0.5279.4.4.0.0.0.0.203.203.2-1.1.0....0...1c.1.32.mobile-gws-serp..3.1.203.63ZBZ9KeMPs#biv=i%7C10%3Bd%7Cfmk-ugJVQIMDBM%3A">http://www.google.com/search?hl=en&biw=384&bih=640&tbm=isch&sa=1&ei=RbLKUv-lHYem0wW8oYHABA&q=hd+wallpaper+photo&oq=hd+wallpaper+photo&gs_l=mobile-gws-serp.3..0l4j0i5.4612.5034.0.5279.4.4.0.0.0.0.203.203.2-1.1.0....0...1c.1.32.mobile-gws-serp..3.1.203.63ZBZ9KeMPs#biv=i%7C10%3Bd%7Cfmk-ugJVQIMDBM%3A</a>','https://taliwutblog.wordpress.com/2014/01/22/hd-wallpaper-photo-google-search/',1,1,'','','','https://taliwutblog.wordpress.com/2014/01/22/hd-wallpaper-photo-google-search/','publish',55434822,'taliwutt','55434822','','standard','hd-wallpaper-photo-google-search','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(44,'22','296','The End of Unrecorded Life',1390394180000,1390394180000,'["Uncategorized"]','["{value=55267051, id=1241, key=blog_id}","{value=1, id=1242, key=is_reblog}","{value=1390394182, id=1235, key=jabber_published}","{value=642, id=1240, key=post_id}"]','Hai','https://taliwutblog.wordpress.com/2014/01/22/the-end-of-unrecorded-life/',1,1,'','','','https://taliwutblog.wordpress.com/2014/01/22/the-end-of-unrecorded-life/','publish',55434822,'taliwutt','55434822','','standard','the-end-of-unrecorded-life','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(45,'22','292','Geny!',1390386760000,1390386760000,'["Uncategorized"]','["{value=1390386762, id=1228, key=jabber_published}"]','<a href="http://taliwutblog.files.wordpress.com/2014/01/wpid-wp-1390386748907.jpg"><img title="wp-1390386748907.jpg" class="alignnone size-full" alt="image" src="http://taliwutblog.files.wordpress.com/2014/01/wpid-wp-1390386748907.jpg" /></a>','https://taliwutblog.wordpress.com/2014/01/22/geny/',1,1,'','','','https://taliwutblog.wordpress.com/2014/01/22/geny/','publish',55434822,'taliwutt','55434822','','image','geny','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(47,'59073674',NULL,NULL,NULL,0,'','',NULL,'',NULL,NULL,NULL,'','','',NULL,0,'','',NULL,NULL,'','',0.0,0.0,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(48,'31','333333','null postid',1392134640000,1392134640000,'["Uncategorized"]','["{value=1392048234, id=1411, key=jabber_published}"]','','https://taliwutblog.wordpress.com/2014/02/11/enft/',1,1,'','','','https://taliwutblog.wordpress.com/2014/02/11/enft/','publish',55434822,'taliwutt','55434822','','standard','enft','',NULL,NULL,0,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(49,'1',NULL,'',NULL,0,'','','','',NULL,NULL,'','','','','',0,'','','','','','',0.0,0.0,1,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(50,'1',NULL,'',NULL,0,'','','','',NULL,NULL,'','','','','',0,'','','','','','',0.0,0.0,1,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(51,'1',NULL,'',NULL,0,'','','','',NULL,NULL,'','','','','',0,'','','','','','',0.0,0.0,1,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(52,'1',NULL,'',NULL,0,'','','','',NULL,NULL,'','','','','',0,'','','','','','',0.0,0.0,1,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(53,'1',NULL,'',NULL,0,'','','','',NULL,NULL,'','','','','',0,'','','','','','',0.0,0.0,1,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(54,'1',NULL,'',NULL,0,'','','','',NULL,NULL,'','','','','',0,'','','','','','',0.0,0.0,1,0,0,NULL,NULL,0); |
| INSERT INTO posts VALUES(55,'1',NULL,'',NULL,0,'','','','',NULL,NULL,'','','','','',0,'','','','','','',0.0,0.0,1,0,0,NULL,NULL,0); |
| CREATE TABLE cats (id integer primary key autoincrement, blog_id text, wp_id integer, category_name text not null, parent_id integer default 0); |
| CREATE TABLE quickpress_shortcuts (id integer primary key autoincrement, accountId text, name text); |
| CREATE TABLE media (id integer primary key autoincrement, postID integer not null, filePath text default '', fileName text default '', title text default '', description text default '', caption text default '', horizontalAlignment integer default 0, width integer default 0, height integer default 0, mimeType text default '', featured boolean default false, isVideo boolean default false, isFeaturedInPost boolean default false, fileURL text default '', thumbnailURL text default '', mediaId text default '', blogId text default '', date_created_gmt date, uploadState default '', videoPressShortcode text default ''); |
| CREATE TABLE themes (_id integer primary key autoincrement, themeId text, name text, description text, screenshotURL text, trendingRank integer default 0, popularityRank integer default 0, launchDate date, previewURL text, blogId text, isCurrent boolean default false, isPremium boolean default false, features text); |
| CREATE TABLE notes (id integer primary key, note_id text, message text, type text, raw_note_data text, timestamp integer, placeholder boolean); |
| CREATE TABLE comments ( blog_id INTEGER DEFAULT 0, post_id INTEGER DEFAULT 0, comment_id INTEGER DEFAULT 0, comment TEXT, published TEXT, status TEXT, author_name TEXT, author_url TEXT, author_email TEXT, post_title TEXT, profile_image_url TEXT, PRIMARY KEY (blog_id, post_id, comment_id) ); |
| INSERT INTO comments VALUES(4,313,165,'ouh ouh','2014-02-10T14:46:27+0100','approve','ARST','','arst@srt.ts','Cute pony',''); |
| COMMIT; |
