Új hozzászólás Aktív témák
-
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
- MacBook Pro M1MAX 64gb ram 1TB SSD Áfás
- Konzolok karbantartása - hűtőpaszta csere - takarítás (minden 10. karbantartás INGYENES)
- Samsung Galaxy S22 5G 128GB, Kártyafüggetlen, 1 Év Garanciával
- AKCIÓ! GAMER PC - RTX 3060Ti - i5 10400F/11400F - 16GB DDR4 - 500GB Nvme SSD - 500W 80+
- GAMER PC - GTX 1060 6GB - i5 10400F/11400F - 16GB RAM - 120- 480GB SSD - 500GB HDD
- Logitech Z906 5.1
- Bomba ár! HP ProBook 650 G2 - i5-6G I 8GB I 256SSD I Radeon 2GB I 15,6" FHD I Cam I W10 I Garancia!
- Logitech G29 kormány+pedál szett (PC, PS3, PS4, PS5)
- Új Bontatlan Eredeti Apple USB lightning kábel usb töltő kábel iphone töltőkábel
- Ps5 digitális verzió nem Slim makulátlan állapotban eladó!