Skip to content

Instantly share code, notes, and snippets.

@zorkian

zorkian/gist:bbf5bc7a8a814ae1f893 Secret

Created February 1, 2013 05:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save zorkian/bbf5bc7a8a814ae1f893 to your computer and use it in GitHub Desktop.
Save zorkian/bbf5bc7a8a814ae1f893 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
CREATE TABLE `posts_raw` (
`journal_id` int(10) unsigned NOT NULL,
`jitemid` int(10) unsigned NOT NULL,
`id` int(10) unsigned NOT NULL,
`poster_id` int(10) unsigned NOT NULL,
`security_bits` varchar(255) NOT NULL,
`allow_global_search` enum('0','1') NOT NULL DEFAULT '1',
`is_deleted` enum('0','1') NOT NULL DEFAULT '0',
`date_posted` int(10) unsigned NOT NULL,
`title` varchar(255) DEFAULT NULL,
`data` mediumtext,
`revtime` int(10) unsigned NOT NULL,
`touchtime` int(10) unsigned NOT NULL,
PRIMARY KEY (`journal_id`,`jitemid`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `counter` (
`counter_id` int(11) NOT NULL,
`max_doc_id` int(11) NOT NULL,
PRIMARY KEY (`counter_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
@afuna
Copy link

afuna commented Feb 14, 2013

poke Hey this still says posts_raw instead of items_raw btw!

@afuna
Copy link

afuna commented Feb 14, 2013

Also journal_id => journalid, and missing jtalkid in there!

@kareila
Copy link

kareila commented Mar 6, 2015

Sigh, I went to fix posts_raw -> items_raw on the wiki, only to discover it was a gist. Since this seems to be the only documentation we have for this database, can we please get it corrected? Thanks :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment