Project

General

Profile

Download (1.22 KB) Statistics
| Branch: | Revision:

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');