SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `pxaserver`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `level`
--
CREATE TABLE IF NOT EXISTS `level` (
`id_level` int(4) NOT NULL auto_increment,
`level` int(2) NOT NULL,
`name` varchar(15) NOT NULL,
`description` varchar(200) NOT NULL,
PRIMARY KEY (`id_level`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
--
-- Dump dei dati per la tabella `level`
--
INSERT INTO `level` (`id_level`, `level`, `name`, `description`) VALUES
(1, 1, 'Administrator', 'Administrator of site'),
(2, 2, 'PowerUser', 'Power user of the site'),
(5, 3, 'User', 'User of the site'),
(6, 4, 'Guest', 'Guest of the site');
-- --------------------------------------------------------
--
-- Struttura della tabella `mail`
--
CREATE TABLE IF NOT EXISTS `mail` (
`id` int(11) unsigned NOT NULL auto_increment,
`from` varchar(65) NOT NULL,
`to` varchar(65) NOT NULL,
`object` varchar(255) NOT NULL,
`message` text NOT NULL,
`result` varchar(5) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dump dei dati per la tabella `mail`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `profile`
--
CREATE TABLE IF NOT EXISTS `profile` (
`id` int(5) NOT NULL auto_increment,
`name` varchar(200) character set latin1 collate latin1_general_ci NOT NULL,
`address` varchar(255) character set latin1 collate latin1_general_ci NOT NULL,
`cap` varchar(7) character set latin1 collate latin1_general_ci NOT NULL,
`state` varchar(200) character set latin1 collate latin1_general_ci NOT NULL,
`email` varchar(100) character set latin1 collate latin1_general_ci NOT NULL,
`secret` varchar(200) character set latin1 collate latin1_general_ci NOT NULL,
`sec_answer` varchar(100) character set latin1 collate latin1_general_ci NOT NULL,
`username` varchar(15) character set latin1 collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;
--
-- Dump dei dati per la tabella `profile`
--
INSERT INTO `profile` (`id`, `name`, `address`, `cap`, `state`, `email`, `secret`, `sec_answer`, `username`) VALUES
(1, 'lu guer', 'via piazza', '35027', 'italia', 'luca@ffg.loc', 'domanda segreta', 'risposta', 'lucanov'),
(2, 'topolino', 'via topi, 2', '10001', 'Disneyland', 'topolino@ffg.loc', 'topolina', 'nome fidanzata', 'topolino'),
(3, 'paperone', 'via del deposito, 1', '10001', 'Disneyland', 'paperone@ffg.loc', 'la tua prima moneta', 'onecent', 'paperone');
-- --------------------------------------------------------
--
-- Struttura della tabella `session`
--
CREATE TABLE IF NOT EXISTS `session` (
`user_id` int(4) unsigned NOT NULL,
`session_id` char(32) NOT NULL,
`login_time` char(20) NOT NULL,
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dump dei dati per la tabella `session`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(5) unsigned NOT NULL auto_increment,
`username` varchar(15) collate latin1_general_ci NOT NULL,
`password` varchar(25) collate latin1_general_ci NOT NULL,
`level` int(2) NOT NULL,
`status` varchar(1) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=68 ;
--
-- Dump dei dati per la tabella `users`
--
INSERT INTO `users` (`id`, `username`, `password`, `level`, `status`) VALUES
(1, 'luca', 'password', 1, '1'),
(2, 'pippo', 'drowssap', 2, '1'),
(3, 'topolino', 'password', 3, '1'),
(4, 'paperino', 'password', 4, '1'),
(5, 'lucanov', 'lucapass', 4, '1'),
(6, 'paperone', 'onecent', 4, '1');
|
Stumble It!
Bookmark in del.icio.us
Download
