Copy a table

Databases
1

I am going to add a forum to my website, and am trying to figure out how to combine my users (I allow people to register on my website by holding them in a mysql table

CREATE TABLE users (
id INT AUTO_INCREMENT,
name VARCHAR(50),
email VARCHAR(50),
phone VARCHAR(25),
avatar varchar(100),
about text,
created TIMESTAMP Default CURRENT_TIMESTAMP,
ip VARCHAR(50),
display CHAR(1),
password VARCHAR(50),
UNIQUE KEY(email),
PRIMARY KEY(id)
);

Here is the mysql table to hold users of the forum

CREATE TABLE IF NOT EXISTS `stivaforum_users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `role_id` int(10) unsigned NOT NULL,
  `email` varchar(255) default NULL,
  `password` blob,
  `name` varchar(255) default NULL,
  `phone` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `notes` text,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zip` varchar(255) DEFAULT NULL,
  `country_id` varchar(255) DEFAULT NULL,
  `avatar_path` varchar(255) DEFAULT NULL,
  `mime_type` varchar(255) DEFAULT NULL,
  `avatar_hash` varchar(255) DEFAULT NULL,
  `ip` varchar(15) default NULL,
  `modified` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `last_login` datetime default NULL,
  `is_active` enum('T','F') NOT NULL default 'F',
  `status` enum('T','F') NOT NULL default 'T',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `email` (`email`),
  KEY `role_id` (`role_id`),
  KEY `status` (`status`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

I gather I need to add a few fields to my table but im confused as to what tne purpose of avatar_hash, and the mime_type would be?

2

have you checked with stiva forums support?

3

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.