penso / linuxfr-iphone

An iPhone application for the LinuxFr website

This URL has Read+Write access

linuxfr-iphone / linuxfr.sqlite
100644 5 lines (5 sloc) 7.168 kb
raw blame history 
1
2
3
4
5

SQLite format 3@  






#s~s*d#
\%indexcreatedIndexcontenuCREATE INDEX "createdIndex" ON "contenu" ("created_at" DESC)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)R	{indexurlIndexcontenuCREATE UNIQUE INDEX "urlIndex" ON "contenu" ("url" ASC)NqindextypeIndexcontenuCREATE INDEX "typeIndex" ON "contenu" ("type" ASC)/5tablecontenucontenuCREATE TABLE "contenu" ("id" INTEGER PRIMARY KEY  NOT NULL ,"title" VARCHAR NOT NULL ,"url" VARCHAR NOT NULL ,"author" VARCHAR NOT NULL ,"description" TEXT NOT NULL ,"category" VARCHAR,"created_at" DATETIME NOT NULL  DEFAULT CURRENT_DATE , "type" INTEGER NOT NULL  DEFAULT -1)