git_sitools_idoc / flarecast / database / MYSQL_CNES / cnes_USER_PROPERTIES.sql @ master
1 | d2a8c3fd | Marc NICOLAS | -- 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 `USER_PROPERTIES`
|
||
26 | --
|
||
27 | |||
28 | CREATE TABLE IF NOT EXISTS `USER_PROPERTIES` ( |
||
29 | `key` varchar(64) COLLATE utf8_unicode_ci NOT NULL, |
||
30 | `value` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL, |
||
31 | `identifier` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, |
||
32 | `scope` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL, |
||
33 | PRIMARY KEY (`key`, `identifier`) |
||
34 | ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
||
35 | |||
36 | --
|
||
37 | -- Contenu de la table `USER_PROPERTIES`
|
||
38 | --
|
||
39 |