MyBB Community Forums

MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.4 > MyBB 1.4 General Support > How to change table creation philosphy?
Full Version: How to change table creation philosphy?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

XLXHost-Fakher

2008-09-12, 04:34 AM
Hello all,
How can i change change table creation philosphy?

for example against each user MyBB creates a uniqe ID and this ID is assigned to variable 'UID' in Users Table in mybb Data Base.

for example mu DB is with prefix mybb

so user table in Data Base mybb_users looks like this

-- phpMyAdmin SQL Dump
-- version 2.11.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 13, 2008 at 12:12 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `mybb14`
--

-- --------------------------------------------------------

--
-- Table structure for table `mybb_users`
--

CREATE TABLE IF NOT EXISTS `mybb_users` (
  `uid` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(120) NOT NULL default '',
  `password` varchar(120) NOT NULL default '',
  `salt` varchar(10) NOT NULL default '',
  `loginkey` varchar(50) NOT NULL default '',
  `email` varchar(220) NOT NULL default '',
  `postnum` int(10) NOT NULL default '0',
  `avatar` varchar(200) NOT NULL default '',
  `avatardimensions` varchar(10) NOT NULL default '',
  `avatartype` varchar(10) NOT NULL default '0',
  `usergroup` smallint(5) unsigned NOT NULL default '0',
  `additionalgroups` varchar(200) NOT NULL default '',
  `displaygroup` smallint(5) unsigned NOT NULL default '0',
  `usertitle` varchar(250) NOT NULL default '',
  `regdate` bigint(30) NOT NULL default '0',
  `lastactive` bigint(30) NOT NULL default '0',
  `lastvisit` bigint(30) NOT NULL default '0',
  `lastpost` bigint(30) NOT NULL default '0',
  `website` varchar(200) NOT NULL default '',
  `icq` varchar(10) NOT NULL default '',
  `aim` varchar(50) NOT NULL default '',
  `yahoo` varchar(50) NOT NULL default '',
  `msn` varchar(75) NOT NULL default '',
  `birthday` varchar(15) NOT NULL default '',
  `birthdayprivacy` varchar(4) NOT NULL default 'all',
  `signature` text NOT NULL,
  `allownotices` int(1) NOT NULL default '0',
  `hideemail` int(1) NOT NULL default '0',
  `subscriptionmethod` int(1) NOT NULL default '0',
  `invisible` int(1) NOT NULL default '0',
  `receivepms` int(1) NOT NULL default '0',
  `pmnotice` int(1) NOT NULL default '0',
  `pmnotify` int(1) NOT NULL default '0',
  `remember` int(1) NOT NULL default '0',
  `threadmode` varchar(8) NOT NULL default '',
  `showsigs` int(1) NOT NULL default '0',
  `showavatars` int(1) NOT NULL default '0',
  `showquickreply` int(1) NOT NULL default '0',
  `showredirect` int(1) NOT NULL default '0',
  `ppp` smallint(6) NOT NULL default '0',
  `tpp` smallint(6) NOT NULL default '0',
  `daysprune` smallint(6) NOT NULL default '0',
  `dateformat` varchar(4) NOT NULL default '',
  `timeformat` varchar(4) NOT NULL default '',
  `timezone` varchar(4) NOT NULL default '',
  `dst` int(1) NOT NULL default '0',
  `dstcorrection` int(1) NOT NULL default '0',
  `buddylist` text NOT NULL,
  `ignorelist` text NOT NULL,
  `style` smallint(5) unsigned NOT NULL default '0',
  `away` int(1) NOT NULL default '0',
  `awaydate` int(10) unsigned NOT NULL default '0',
  `returndate` varchar(15) NOT NULL default '',
  `awayreason` varchar(200) NOT NULL default '',
  `pmfolders` text NOT NULL,
  `notepad` text NOT NULL,
  `referrer` int(10) unsigned NOT NULL default '0',
  `reputation` bigint(30) NOT NULL default '0',
  `regip` varchar(50) NOT NULL default '',
  `lastip` varchar(50) NOT NULL default '',
  `longregip` int(10) NOT NULL default '0',
  `longlastip` int(10) NOT NULL default '0',
  `language` varchar(50) NOT NULL default '',
  `timeonline` bigint(30) NOT NULL default '0',
  `showcodebuttons` int(1) NOT NULL default '1',
  `totalpms` int(10) NOT NULL default '0',
  `unreadpms` int(10) NOT NULL default '0',
  `warningpoints` int(3) NOT NULL default '0',
  `moderateposts` int(1) NOT NULL default '0',
  `moderationtime` bigint(30) NOT NULL default '0',
  `suspendposting` int(1) NOT NULL default '0',
  `suspensiontime` bigint(30) NOT NULL default '0',
  `coppauser` int(1) NOT NULL default '0',
  `classicpostbit` int(1) NOT NULL default '0',
  PRIMARY KEY  (`uid`),
  UNIQUE KEY `username` (`username`),
  KEY `usergroup` (`usergroup`),
  KEY `birthday` (`birthday`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mybb_users`
--

INSERT INTO `mybb_users` (`uid`, `username`, `password`, `salt`, `loginkey`, `email`, `postnum`, `avatar`, `avatardimensions`, `avatartype`, `usergroup`, `additionalgroups`, `displaygroup`, `usertitle`, `regdate`, `lastactive`, `lastvisit`, `lastpost`, `website`, `icq`, `aim`, `yahoo`, `msn`, `birthday`, `birthdayprivacy`, `signature`, `allownotices`, `hideemail`, `subscriptionmethod`, `invisible`, `receivepms`, `pmnotice`, `pmnotify`, `remember`, `threadmode`, `showsigs`, `showavatars`, `showquickreply`, `showredirect`, `ppp`, `tpp`, `daysprune`, `dateformat`, `timeformat`, `timezone`, `dst`, `dstcorrection`, `buddylist`, `ignorelist`, `style`, `away`, `awaydate`, `returndate`, `awayreason`, `pmfolders`, `notepad`, `referrer`, `reputation`, `regip`, `lastip`, `longregip`, `longlastip`, `language`, `timeonline`, `showcodebuttons`, `totalpms`, `unreadpms`, `warningpoints`, `moderateposts`, `moderationtime`, `suspendposting`, `suspensiontime`, `coppauser`, `classicpostbit`) VALUES
(1, 'Fakher', '03dea55d6b3729c85e402300cfe41aa9', 'NlwrxbDj', 'yHDoentg4iB3LQANLoS3tjrRI9rCNrjrphvkFMaeFlSlQRRfSQ', 'admin@localhost', 2, '', '', '0', 4, '', 0, '', 1221104799, 1221251718, 1221245786, 1221159872, '', '', '', '', '', '', 'all', '', 1, 0, 0, 0, 1, 1, 1, 1, '', 1, 1, 1, 1, 0, 0, 0, '', '', '0', 0, 0, '', '', 0, 0, 0, '', '', '', '', 0, 0, '127.0.0.1', '127.0.0.1', 2130706433, 2130706433, '', 14540, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0);

Now herev there is a primary key for the table that is

  PRIMARY KEY  (`uid`),

I want to change this key as say like this

  PRIMARY KEY  (`user_id`),

How can I do that?
I mean from where do MyBB run that query to create this table?
in install foler or somewhere?

Dennis Tsang

2008-09-12, 05:25 AM
It's in install/resources/mysql_db_tables.php, but you're going to have to make many code modifications if you're renaming the table fields.

XLXHost-Fakher

2008-09-12, 06:24 AM
oki you means to say i have to change the new table name in each of the page the older one was used????

luke83

2008-09-12, 07:15 AM
(2008-09-12, 06:24 AM)MyBBmodding Wrote: [ -> ]oki you means to say i have to change the new table name in each of the page the older one was used????

of course. Sad

XLXHost-Fakher

2008-09-12, 07:42 AM
hmmmm quit a bit of work Smile

oki i ll try it the day i ll be having no work at all Toungue
what would be the easiest way to do this???
MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.4 > MyBB 1.4 General Support > How to change table creation philosphy?