git_sitools_idoc / flarecast / database / MYSQL_CNES / cnes_USER_PROPERTIES.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 `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 |
|