| 1 |
d2a8c3fd
|
Marc NICOLAS
|
|
| 2 |
|
|
|
| 3 |
|
|
|
| 4 |
|
|
|
| 5 |
|
|
|
| 6 |
|
|
|
| 7 |
|
|
|
| 8 |
|
|
|
| 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 |
|
|
|
| 20 |
|
|
|
| 21 |
|
|
|
| 22 |
|
|
|
| 23 |
|
|
|
| 24 |
|
|
|
| 25 |
|
|
|
| 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 |
|
|
|
| 39 |
|
|
|
| 40 |
|
|
|
| 41 |
|
|
INSERT INTO `USERS` (`identifier`, `firstname`, `lastname`, `email`, `secret`) VALUES
|
| 42 |
|
|
('admin', 'firstname', 'lastname', 'admin-sitools@cnes.fr', 'admin'); |