Core/InitDatabase.sql at main · ZooFramework/Core · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
-- Listage de la structure de table ACCESS
CREATE TABLE IF NOT EXISTS `ACCESS` (
  `ACSNAM` varchar(200) NOT NULL,
  `PRFNAM` varchar(200) NOT NULL,
  `NUMVER` int(11) NOT NULL,
  `MODUSR` varchar(60) NOT NULL,
  `DATEFT` timestamp NOT NULL,
  PRIMARY KEY (`ACSNAM`,`PRFNAM`)
);

-- Listage de la structure de table PROFILES
CREATE TABLE IF NOT EXISTS `PROFILES` (
  `PRFNAM` varchar(200) NOT NULL,
  `PRFDES` varchar(2000),
  `PRFDEF` bit(1) NOT NULL,
  `NUMVER` int(11) NOT NULL,
  `MODUSR` varchar(60),
  `DATEFT` timestamp NOT NULL,
  PRIMARY KEY (`PRFNAM`)
);

-- Listage de la structure de table RESETPASSWORD
CREATE TABLE IF NOT EXISTS `RESETPASSWORD` (
  `USRNAM` varchar(60) NOT NULL,
  `RSTKEY` char(36),
  `EXPDAT` timestamp NOT NULL,
  `NUMVER` int(11) NOT NULL,
  `MODUSR` varchar(60),
  `DATEFT` timestamp NOT NULL,
  PRIMARY KEY (`USRNAM`)
);

-- Listage de la structure de table USERPROFILES
CREATE TABLE IF NOT EXISTS `USERPROFILES` (
  `USRNAM` varchar(300) NOT NULL,
  `PRFNAM` varchar(200) NOT NULL,
  `NUMVER` int(11) NOT NULL,
  `MODUSR` varchar(60),
  `DATEFT` timestamp NOT NULL,
  PRIMARY KEY (`USRNAM`,`PRFNAM`)
);

-- Listage de la structure de table USERS
CREATE TABLE IF NOT EXISTS `USERS` (
  `USRNAM` varchar(300) NOT NULL,
  `USRPWD` varchar(60),
  `USREML` varchar(300),
  `USRFSTNAM` varchar(100),
  `USRLSTNAM` varchar(100),
  `USRLNG` varchar(50),
  `DATEFT` timestamp NOT NULL,
  `NUMVER` int(11) NOT NULL,
  `MODUSR` varchar(60),
  PRIMARY KEY (`USRNAM`)
);