Blame view

database/index.txt 883 Bytes
6c4edfa3   Alexandre   First Commit LabI...
1
2
3
4
# index.txt -  database Inventirap 

Here, its's the database directory.
Index :  
4022449b   Etienne Pallier   Update database/l...
5
- labinvent_last_version.sql : Create the database and its structure. 
6c4edfa3   Alexandre   First Commit LabI...
6
7
8

- Insert_TablesFunct.sql : Insert the functionnality tables content : Sur-categories, categories, sous-categories, groupes metiers et thematiques, privileged users)

4022449b   Etienne Pallier   Update database/l...
9
10
- Insert_Users.sql : Insert a superadmin user

6c4edfa3   Alexandre   First Commit LabI...
11
12
13
14
15
16
17
18
19
20
21
22
23
- Upd_TablesConstraints.sql : Modify database structure to add some constraints on tables. 

===============================
Updates :

Last : 10/12/13

10/12/13 : Update script to create database and fill it with functionnal informations. 
Cut the script BDD_IRAP.sql to keep only the database structure. 
Create scripts : Insert_TablesFunct.sql and Upd_TablesConstraints.sql for the functionnal informations.

Janvier 2014 : 
Update Materiels table too add fields : Createur, modificateur and correponding dates