Jump to content

insert new table


ofi

Recommended Posts

Hi

I have never done this before, i need to add in new table into SQL query from in phpmyadmin.

 

how do i do that, i got 3 mysql Databasees, i am running wordpress on my site, so i pick wordpress mysql, and there to phpmyadmin, and then what do i do ???

 

need to add this in

-- 
-- Table structure for table `wp_fim_cat`
-- 

DROP TABLE IF EXISTS `wp_fim_cat`;
CREATE TABLE IF NOT EXISTS `wp_fim_cat` (
  `catname` varchar(255) NOT NULL default '',
  `id` int(11) NOT NULL auto_increment,
  `date` datetime default NULL,
  `description` text NOT NULL,
  `folder` varchar(255) NOT NULL default '',
  `cover` varchar(50) default '',
  `status` varchar(20) NOT NULL default 'public',
  `password` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `wp_fim_comments`
-- 

DROP TABLE IF EXISTS `wp_fim_comments`;
CREATE TABLE IF NOT EXISTS `wp_fim_comments` (
  `id` int(11) NOT NULL auto_increment,
  `image_id` int(11) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `author_comment` text NOT NULL,
  `author_name` varchar(255) NOT NULL default '',
  `author_email` varchar(255) NOT NULL default '',
  `author_url` varchar(255) NOT NULL default '',
  `author_ip` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `wp_fim_images`
-- 

DROP TABLE IF EXISTS `wp_fim_images`;
CREATE TABLE IF NOT EXISTS `wp_fim_images` (
  `id` smallint(11) NOT NULL auto_increment,
  `image` varchar(255) default NULL,
  `date` datetime default NULL,
  `title` varchar(255) default NULL,
  `description` text,
  `cat` varchar(10) NOT NULL default '',
  `status` varchar(50) default 'include',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

Link to comment
https://forums.phpfreaks.com/topic/43820-insert-new-table/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.