Project

General

Profile

Download (612 Bytes)

requête sql de la nouvelle base de données grr » user_validation.sql

add the table user_validation to mrisessions - Volker Baecker, 06/12/2012 10:54 AM

 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

use mrisessions;
drop table IF EXISTS `user_validation`;
CREATE TABLE IF NOT EXISTS `user_validation` (
`login` varchar(255),
`nom` text,
`prenom` text,
`password` text,
`email` text,
`statut` text,
`etat` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
alter table `user_validation` add primary key (`login`);
(2-2/3)