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