git_sitools_idoc / flarecast / database / MYSQL_CNES / cnes_USERS.sql @ master
1 |
-- phpMyAdmin SQL Dump
|
---|---|
2 |
-- version 2.11.9.5
|
3 |
-- http://www.phpmyadmin.net
|
4 |
--
|
5 |
-- Serveur: odysseus2.silogic.fr
|
6 |
-- Généré le : Mar 21 Juin 2011 à 11:03
|
7 |
-- Version du serveur: 5.1.41
|
8 |
-- Version de PHP: 5.1.6
|
9 |
|
10 |
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
11 |
|
12 |
|
13 |
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
14 |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
15 |
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
16 |
/*!40101 SET NAMES utf8 */;
|
17 |
|
18 |
--
|
19 |
-- Base de données: `cnes`
|
20 |
--
|
21 |
|
22 |
-- --------------------------------------------------------
|
23 |
|
24 |
--
|
25 |
-- Structure de la table `USERS`
|
26 |
--
|
27 |
|
28 |
CREATE TABLE IF NOT EXISTS `USERS` ( |
29 |
`identifier` varchar(64) COLLATE utf8_unicode_ci NOT NULL, |
30 |
`firstname` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, |
31 |
`lastname` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, |
32 |
`email` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, |
33 |
`secret` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL, |
34 |
PRIMARY KEY (`identifier`) |
35 |
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
36 |
|
37 |
--
|
38 |
-- Contenu de la table `USERS`
|
39 |
--
|
40 |
|
41 |
INSERT INTO `USERS` (`identifier`, `firstname`, `lastname`, `email`, `secret`) VALUES |
42 |
('admin', 'firstname', 'lastname', 'admin-sitools@cnes.fr', 'admin'); |