Ú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
- Garmin Forerunner 965
- iPAD 8 (2020) 98% aksi
- LENOVO IDEAPAD GAMING 3 -15.6"FHD 120Hz - Ryzen 5 5600H - 16GB - 512GB - RTX 3050 - Win11 -1 év gari
- Bomba ár! Dell Latitude 7300Touch - i5-8G I 8GB I 256GB SSD I 13,3" FHD Touch I I Cam I W11 I Gari!
- Bomba Ár! HP ProBook 650 G1 - i5-4GEN I 8GB I 128GB SSD I 15,6" FHD I Cam I W10 I Garancia!
Állásajánlatok
Cég: Ozeki Kft.
Város: Debrecen
Cég: Promenade Publishing House Kft.
Város: Budapest