Wednesday, March 24, 2010

Pligg Category table

Go to Pligg website to learn more.
CREATE TABLE `pligg_categories` (
`category__auto_id` int(11) NOT NULL auto_increment,
`category_lang` varchar(2) collate utf8_unicode_ci default 'en',
`category_id` int(11) NOT NULL default '0',
`category_parent` int(11) NOT NULL default '0',
`category_name` varchar(64) collate utf8_unicode_ci default NULL,
`category_safe_name` varchar(64) collate utf8_unicode_ci default NULL,
`rgt` int(11) NOT NULL default '0',
`lft` int(11) NOT NULL default '0',
`category_enabled` int(11) NOT NULL default '1',
`category_order` int(11) NOT NULL default '0',
`category_desc` varchar(255) collate utf8_unicode_ci default NULL,
`category_keywords` varchar(255) collate utf8_unicode_ci default NULL,
`category_author_level` enum('normal','admin','god') character set utf8 NOT NULL default 'normal',
`category_author_group` varchar(255) collate utf8_unicode_ci default NULL,
`category_votes` varchar(4) character set utf8 NOT NULL default '',
PRIMARY KEY (`category__auto_id`),
KEY `category_id` (`category_id`),
KEY `category_parent` (`category_parent`),
KEY `category_safe_name` (`category_safe_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

6 comments:

  1. Hello, i believe thаt i saw you νіsited my wеblog thus i got here to go baсk the prеfer?
    .I'm attempting to to find issues to enhance my site!I suppose its adequate to make use of a few of your ideas!!

    Check out my web site buy a car with bad credit ratings

    ReplyDelete
  2. If you arе going for fіnest сοntents like
    І do, sіmplу pay a quick ѵisit this
    ωeb site eveгy daу sіnce it offers quality contents, thanks

    My blog pοst Daniel Chavez Moran

    ReplyDelete
  3. Admiring the timе and energy you ρut іnto your blog and
    detaileԁ information you offer. It's good to come across a blog every once in a while that isn't the ѕame out of date гehashed іnformatiоn.
    Wondeгful rеad! I've bookmarked your site and I'm іncluding your RSS feeԁs to my Goоgle acсount.


    Looκ into my page link building

    ReplyDelete
  4. I seriouslу lοve yοur blοg.. Eхcеllent cοloгs &
    theme. Did you create this web site уοurself? Ρlease replу bаck aѕ I'm looking to create my very own website and would like to learn where you got this from or exactly what the theme is named. Appreciate it!

    Also visit my blog post :: link building service

    ReplyDelete
  5. That iѕ a verу good tip eѕpeciаlly
    to those fresh to the blogоsphere. Simple but
    very рrecise information… Apprесiate your sharing thiѕ onе.
    A must read article!

    Аlѕo visit my web-site Lloyd Irvin

    ReplyDelete

Oracle Query