Új hozzászólás Aktív témák

• #828 Kommy veterán Sk8erPeter #827

  Új Válasz 2011-11-01 18:21:42 #828

  Új hozzászólás

  Összes hozzászólása itt Válaszok az összes hozzászólására itt Válaszok erre a hozzászólásra

  Privát üzenet küldése

  

  Kommy

  veterán

  válasz Sk8erPeter #827 üzenetére

  Comments

  CREATE TABLE IF NOT EXISTS `comments` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `url` varchar(255) collate utf8_unicode_ci NOT NULL,
  `user_id` int(11) unsigned NOT NULL,
  `username` varchar(255) collate utf8_unicode_ci NOT NULL,
  `text` text collate utf8_unicode_ci NOT NULL,
  `replyto` int(11) unsigned NOT NULL,
  `rank` int(11) unsigned NOT NULL,
  `created` int(10) unsigned NOT NULL,
  `updated` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `rank` (`rank`),
  KEY `url` (`url`),
  KEY `user_id` (`user_id`)
  )

  Entries
  CREATE TABLE IF NOT EXISTS `entries` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `file_id` int(11) unsigned NOT NULL,
  `user_id` int(11) unsigned NOT NULL,
  `startat` int(11) unsigned NOT NULL default '0',
  `title` varchar(255) collate utf8_unicode_ci NOT NULL,
  `url` varchar(255) collate utf8_unicode_ci NOT NULL,
  `summary` text collate utf8_unicode_ci NOT NULL,
  `text` text collate utf8_unicode_ci NOT NULL,
  `comments` int(11) unsigned NOT NULL default '0',
  `sticky` tinyint(2) unsigned NOT NULL default '0',
  `comment_enabled` tinyint(2) unsigned NOT NULL default '1',
  `active` tinyint(2) unsigned NOT NULL default '1',
  `rank` int(11) unsigned NOT NULL,
  `updated` int(11) unsigned NOT NULL,
  `created` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `file_id` (`file_id`),
  KEY `url_2` (`url`),
  KEY `rank` (`rank`),
  KEY `startat` (`startat`),
  KEY `sticky` (`sticky`),
  KEY `user_id` (`user_id`),
  KEY `title` (`title`),
  KEY `comment_enabled` (`comment_enabled`),
  KEY `active` (`active`),
  KEY `created` (`created`),
  KEY `updated` (`updated`)
  )

  Entries_entrycategories
  CREATE TABLE IF NOT EXISTS `entries_entrycategories` (
  `entry_id` int(10) unsigned NOT NULL,
  `entrycategory_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`entry_id`,`entrycategory_id`),
  KEY `fk_wb_entrycategories_has_wb_entries_wb_entries1` (`entry_id`)
  )

  entrycategories
  CREATE TABLE IF NOT EXISTS `entrycategories` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `lft` int(10) unsigned NOT NULL,
  `rgt` int(10) unsigned NOT NULL,
  `parent_id` int(10) unsigned NOT NULL,
  `scope` int(10) unsigned NOT NULL,
  `main` tinyint(2) unsigned NOT NULL,
  `showitems` tinyint(2) unsigned NOT NULL default '1',
  `file_id` int(10) unsigned NOT NULL,
  `title` varchar(250) collate utf8_unicode_ci NOT NULL,
  `url` varchar(250) collate utf8_unicode_ci NOT NULL,
  `jumpto` varchar(250) collate utf8_unicode_ci NOT NULL,
  `active` tinyint(3) unsigned NOT NULL default '1',
  `created` int(10) unsigned NOT NULL,
  `updated` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `url_2` (`url`),
  KEY `lft` (`lft`),
  KEY `rgt` (`rgt`),
  KEY `parent_id` (`parent_id`),
  KEY `active` (`active`),
  KEY `created` (`created`),
  KEY `file_id` (`file_id`),
  KEY `main` (`main`),
  KEY `scope` (`scope`),
  KEY `showitems` (`showitems`),
  KEY `jumpto` (`jumpto`)
  )

Új hozzászólás Aktív témák