He perdido durante una migracion de bases de datos la caracteristica AUTO_INCREMENT en los campos marcados de ese modo.
Esto impedia, por ejemplo introducir nuevos temas en mi foro Dragonfly, nuevos usurios, etc...
Lo he tenido que aƱadir manualmente.
Por si a alguine le sirve en un futuro estos campos son los siguientes:
| Quote:: |
######
###### DragonflyCMS 9.2.X ######
###### AUTOINCREMENT Fields by WebNaranja.com and Aforo.es #####
######
ALTER TABLE `nuke_admins` CHANGE `admin_id` `admin_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_autonews` CHANGE `anid` `anid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_banner` CHANGE `bid` `bid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_bbattachments_desc` CHANGE `attach_id` `attach_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_bbcategories` CHANGE `cat_id` `cat_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_bbdisallow` CHANGE `disallow_id` `disallow_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_bbextension_groups` CHANGE `group_id` `group_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_bbextensions` CHANGE `ext_id` `ext_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_bbforbidden_extensions` CHANGE `ext_id` `ext_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_bbforum_prune` CHANGE `prune_id` `prune_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_bbforums` CHANGE `forum_id` `forum_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_bbgroups` CHANGE `group_id` `group_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_bbposts` CHANGE `post_id` `post_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_bbprivmsgs` CHANGE `privmsgs_id` `privmsgs_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_bbquota_limits` CHANGE `quota_limit_id` `quota_limit_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_bbranks` CHANGE `rank_id` `rank_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_bbsearch_wordlist` CHANGE `word_id` `word_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_bbsmilies` CHANGE `smilies_id` `smilies_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_bbtopic_icons` CHANGE `icon_id` `icon_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_bbtopics` CHANGE `topic_id` `topic_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_bbvote_desc` CHANGE `vote_id` `vote_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_bbwords` CHANGE `word_id` `word_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_blocks` CHANGE `bid` `bid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_comments` CHANGE `tid` `tid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_cpg_albums` CHANGE `aid` `aid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_cpg_categories` CHANGE `cid` `cid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_cpg_comments` CHANGE `msg_id` `msg_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_cpg_installs` CHANGE `cpg_id` `cpg_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_cpg_pictures` CHANGE `pid` `pid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_cpg_usergroups` CHANGE `group_id` `group_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_credits` CHANGE `cid` `cid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_headlines` CHANGE `hid` `hid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_history` CHANGE `eid` `eid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_log` CHANGE `log_id` `log_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_message` CHANGE `mid` `mid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_modules` CHANGE `mid` `mid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_modules_cat` CHANGE `cid` `cid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_modules_links` CHANGE `lid` `lid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_pages` CHANGE `pid` `pid` INT(10) NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_pages_categories` CHANGE `cid` `cid` INT(10) NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_poll_desc` CHANGE `poll_id` `poll_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_pollcomments` CHANGE `tid` `tid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_queue` CHANGE `qid` `qid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_related` CHANGE `rid` `rid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_stories` CHANGE `sid` `sid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_stories_cat` CHANGE `catid` `catid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_topics` CHANGE `topicid` `topicid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_users` CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_users_fields` CHANGE `fid` `fid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `nuke_users_temp` CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ;
|