-- phpMyAdmin SQL Dump
-- version 2.11.5.2
-- http://www.phpmyadmin.net
-- Versione MySQL: 5.0.51
-- Versione PHP: 4.4.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

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

--
-- Struttura della tabella `db_stf`
--

DROP TABLE IF EXISTS `db_stf`;
CREATE TABLE `db_stf` (
  `id_staff` int(11) NOT NULL auto_increment,
  `usr` varchar(20) NOT NULL default '',
  `pwd` varchar(20) NOT NULL default '',
  `role` varchar(20) NOT NULL default '',
  `email` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id_staff`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dump dei dati per la tabella `db_stf`
--

INSERT INTO `db_stf` (`id_staff`, `usr`, `pwd`, `role`, `email`) VALUES
(1, 'Admin', 'Admin', 'Admin', 'email@somemail.com');

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

--
-- Struttura della tabella `db_templates`
--

DROP TABLE IF EXISTS `db_templates`;
CREATE TABLE `db_templates` (
  `id_template` int(11) NOT NULL auto_increment,
  `staff` varchar(30) NOT NULL default '',
  `conf_code` text NOT NULL,
  PRIMARY KEY  (`id_template`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dump dei dati per la tabella `db_templates`
--

INSERT INTO `db_templates` (`id_template`, `staff`, `conf_code`) VALUES
(1, 'Admin', '<P><FONT face=Tahoma size=2>Dear customer, your confirmation code is: </FONT><FONT face=Tahoma size=2><FONT color=#009900><STRONG>[ConfCode]<BR></STRONG></FONT>The confirmation is Mandatory to activate your account.<BR>Thank you!<BR><BR><STRONG>_______________________________<BR>Support Team</STRONG></FONT><BR></P>');

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

--
-- Struttura della tabella `db_usr`
--

DROP TABLE IF EXISTS `db_usr`;
CREATE TABLE `db_usr` (
  `id_usr` int(11) NOT NULL auto_increment,
  `name` varchar(30) default NULL,
  `surn` varchar(30) default NULL,
  `usrnm` varchar(30) default NULL,
  `pwd` varchar(30) default NULL,
  `email` varchar(50) default NULL,
  `Country` varchar(50) default NULL,
  `activ` varchar(50) default NULL,
  `codeactiv` varchar(50) default NULL,
  `lang` varchar(50) default NULL,
  PRIMARY KEY  (`id_usr`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dump dei dati per la tabella `db_usr`
--

INSERT INTO `db_usr` (`id_usr`, `name`, `surn`, `usrnm`, `pwd`, `email`, `Country`, `activ`, `codeactiv`, `lang`) VALUES
(1, 'Test', 'User', 'Martin', 'passw', 'some@domain.com', 'Usa', 'Ok', '13302358056', 'English');