#Sql120640_2
DROP TABLE IF EXISTS new_admin_newsletter;
DROP TABLE IF EXISTS new_indirizzi;
DROP TABLE IF EXISTS new_membri_newsletter;
CREATE TABLE `new_admin_newsletter` (
  `admin_ID` int(11) NOT NULL auto_increment,
  `user` varchar(60) NOT NULL default '',
  `password` varchar(60) NOT NULL default '',
  PRIMARY KEY  (`admin_ID`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;



CREATE TABLE `new_indirizzi` (
  `indirizzi_ID` int(11) NOT NULL auto_increment,
  `indirizzi` varchar(60) NOT NULL default '',
  PRIMARY KEY  (`indirizzi_ID`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

CREATE TABLE `new_membri_newsletter` (
  `membro_ID` int(11) NOT NULL auto_increment,
  `nome` varchar(60) NOT NULL default '',
  `mail` varchar(120) NOT NULL default '',
  PRIMARY KEY  (`membro_ID`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;


INSERT INTO new_admin_newsletter(admin_ID, user, password) VALUES(null, 'admin', 'admin');