path: root/install/poche.sqlite

SQLite format 3�

@  


-�)
|}ys~�}km@{�{Oz�|�}>ys~��X%%
�stabletags_entriestags_entriesCREATE TABLE tags_entries (
            id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE,
            entry_id INTEGER,
            tag_id INTEGER,
            FOREIGN KEY(entry_id) REFERENCES entries(id) ON DELETE CASCADE,
            FOREIGN KEY(tag_id) REFERENCES tags(id) ON DELETE CASCADE
        )%%
�Atableusers_configusers_configCREATE TABLE users_config (id INTEGER PRIMARY KEY, user_id NUMERIC, name TEXT, value TEXT)w
�Mtableusersusers
CREATE TABLE users (id INTEGER PRIMARY KEY, username TEXT, password TEXT, name TEXT, email TEXT)�2

�;tableentriesentriesCREATE TABLE entries (id INTEGER PRIMARY KEY, title TEXT, url TEXT, is_read NUMERIC DEFAULT 0, is_fav NUMERIC DEFAULT 0, content BLOB, user_id NUMERIC)}g3}g�

�ytabletagstagsCREATE TABLE tags (
            id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE,
            value TEXT
        )';
indexsqlite_autoindex_tags_1tags}��
�{tableconfigconfigCREATE TABLE "config" ("id" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL  UNIQUE , "name" VARCHAR UNIQUE, "value" BLOB)2�2~�77K%
indexsqlite_autoindex_tags_entries_1tags_entriesP++
Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�+	?
indexsqlite_autoindex_config_2config	+?
indexsqlite_autoindex_config_1configf�/3
�
�
�
�
���
config0
�
�

y`y`�
	AS�;	inthepoche/poche · GitHubhttps://github.com/inthepoche/poche<div id="">

<p>Abandon Pocket, Instapaper and other Readability service : adopt poche. It is the same, but it is free (like in freedom) and open source. </p>

<h2>
<a name="some-features" class="anchor" href="#some-features"><span class="octicon octicon-link"/></a>Some features</h2>

<ul><li>adding, deleting, archiving and setting as favorite a link</li>
<li>import from pocket / readability / instapaper</li>
<li>share links by email and on twitter</li>
<li>a design adapted to tablets and smartphones</li>
<li>extensions for Chrome and Firefox</li>
<li>Android application</li>
<li>multi languages (very soon!)</li>
<li>multi users (very soon!)</li>
<li>update notification in configuration screen</li>
<li>many storage modes (sqlite, mysql, postgresql)</li>
<li>many templates</li>
<li>...</li>
</ul><p>To test poche, a demo website is online : <a href="http://demo.inthepoche.com">demo.inthepoche.com</a> (login poche, password poche).</p>

<h2>
<a name="installation" class="anchor" href="#installation"><span class="octicon octicon-link"/></a>Installation</h2>

<p>Read the <a href="https://github.com/inthepoche/poche/blob/master/INSTALL.md">INSTALL.md file</a>.</p>

<h2>
<a name="license" class="anchor" href="#license"><span class="octicon octicon-link"/></a>License</h2>

<p>Copyright © 2010-2013 Nicolas Lœuillet <a href="mailto:nicolas.loeuillet@gmail.com">nicolas.loeuillet@gmail.com</a>
This work is free. You can redistribute it and/or modify it under the
terms of the Do What The Fuck You Want To Public License, Version 2,
as published by Sam Hocevar. See the COPYING file for more details.</p></div>
�
�
�
�
�