How to add code to the database?

[Guest]

Hi there,

 

I'm trying to install the email templates contribution and the 2nd step in the install file is as follows:

 

Step 2: Add the following to the database:# Table structure for table `email_templates`CREATE TABLE email_templates ( id smallint(6) NOT NULL auto_increment, grp varchar(50) NOT NULL default '', title varchar(255) NOT NULL default '', subject varchar(255) NOT NULL default '', contents text NOT NULL, updated datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (id)) TYPE=MyISAM;# Template examplesINSERT INTO email_templates VALUES (1, 'Customer', 'Happy Birthday', 'Happy Birthday To You', '<P><FONT face="Verdana, Arial, Helvetica, sans-serif" size=2>Dear [CUSTOMER_NAME], <BR>Warmest greeting from our store.</FONT></P>\r\n<P><FONT face="Verdana, Arial, Helvetica, sans-serif" size=2><FONT color=#ff6600 size=5>HAPPY BIRTHDAY<BR></FONT>Your Birthday: [CUSTOMER_DOB]<BR>Your Email: [CUSTOMER_EMAIL]<BR>Your Phone: [CUSTOMER_PHONE]<BR>Your Fax: [CUSTOMER_FAX]<BR><BR></FONT></P>\r\n<P><FONT face="Verdana, Arial, Helvetica, sans-serif" size=2>Regards,<BR><STRONG><FONT color=#0066ff>Online Store</FONT></STRONG></FONT><FONT face="Verdana, Arial, Helvetica, sans-serif" size=2><BR></P></FONT>', '2005-01-25 10:16:47');INSERT INTO email_templates VALUES (2, 'Order', 'Order has been completed', 'Your order has been completed', '<P>Dear [CUSTOMER_NAME],</P>\r\n<P>We have completed your order and now on the way to your place. Thank you and enjoy our products.</P>', '2005-01-25 10:22:56');

 

I have installed a few contributions before and am aware of how to import sql files using phpMyAdmin but I arent sure how I go about performing this step. Can someone please guide me in the right direction?

 

Much appreciated.

[Jack_mcs]

There is an sql tab in phpmyadmin. Just copy the sql code from that instruction, paste it into that tab and click on go.

 

Jack

[Guest]

Thanks...got it to work!