| 4 |
jpm |
1 |
<?xml version="1.0" standalone="yes" ?>
|
|
|
2 |
<DBMODEL Version="4.0">
|
|
|
3 |
<SETTINGS>
|
|
|
4 |
<GLOBALSETTINGS ModelName="modele_genesia_general1" IDModel="0" IDVersion="0" VersionStr="1.0.0.0" Comments="" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="100.00" XPos="226" YPos="360" DefaultDataType="5" DefaultTablePrefix="0" DefSaveDBConn="" DefSyncDBConn="" DefQueryDBConn="" Printer="" HPageCount="4.0" PageAspectRatio="1.440892512336408" PageOrientation="1" PageFormat="A4 (210x297 mm, 8.26x11.7 inches)" SelectedPages="" UsePositionGrid="0" PositionGridX="20" PositionGridY="20" TableNameInRefs="0" DefaultTableType="0" ActivateRefDefForNewRelations="1" FKPrefix="" FKPostfix="" CreateFKRefDefIndex="1" DBQuoteCharacter="`" CreateSQLforLinkedObjects="0" DefModelFont="Nimbus Sans L" CanvasWidth="4096" CanvasHeight="2842" />
|
|
|
5 |
<DATATYPEGROUPS>
|
|
|
6 |
<DATATYPEGROUP Name="Numeric Types" Icon="1" />
|
|
|
7 |
<DATATYPEGROUP Name="Date and Time Types" Icon="2" />
|
|
|
8 |
<DATATYPEGROUP Name="String Types" Icon="3" />
|
|
|
9 |
<DATATYPEGROUP Name="Blob and Text Types" Icon="4" />
|
|
|
10 |
<DATATYPEGROUP Name="User defined Types" Icon="5" />
|
|
|
11 |
<DATATYPEGROUP Name="Geographic Types" Icon="6" />
|
|
|
12 |
</DATATYPEGROUPS>
|
|
|
13 |
<DATATYPES>
|
|
|
14 |
<DATATYPE ID="1" IDGroup="0" TypeName="TINYINT" Description="A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
15 |
<PARAMS>
|
|
|
16 |
<PARAM Name="length" />
|
|
|
17 |
</PARAMS>
|
|
|
18 |
<OPTIONS>
|
|
|
19 |
<OPTION Name="UNSIGNED" Default="1" />
|
|
|
20 |
<OPTION Name="ZEROFILL" Default="0" />
|
|
|
21 |
</OPTIONS>
|
|
|
22 |
</DATATYPE>
|
|
|
23 |
<DATATYPE ID="2" IDGroup="0" TypeName="SMALLINT" Description="A small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
24 |
<PARAMS>
|
|
|
25 |
<PARAM Name="length" />
|
|
|
26 |
</PARAMS>
|
|
|
27 |
<OPTIONS>
|
|
|
28 |
<OPTION Name="UNSIGNED" Default="1" />
|
|
|
29 |
<OPTION Name="ZEROFILL" Default="0" />
|
|
|
30 |
</OPTIONS>
|
|
|
31 |
</DATATYPE>
|
|
|
32 |
<DATATYPE ID="3" IDGroup="0" TypeName="MEDIUMINT" Description="A medium-size integer. The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
33 |
<PARAMS>
|
|
|
34 |
<PARAM Name="length" />
|
|
|
35 |
</PARAMS>
|
|
|
36 |
<OPTIONS>
|
|
|
37 |
<OPTION Name="UNSIGNED" Default="1" />
|
|
|
38 |
<OPTION Name="ZEROFILL" Default="0" />
|
|
|
39 |
</OPTIONS>
|
|
|
40 |
</DATATYPE>
|
|
|
41 |
<DATATYPE ID="4" IDGroup="0" TypeName="INT" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
42 |
<PARAMS>
|
|
|
43 |
<PARAM Name="length" />
|
|
|
44 |
</PARAMS>
|
|
|
45 |
<OPTIONS>
|
|
|
46 |
<OPTION Name="UNSIGNED" Default="0" />
|
|
|
47 |
<OPTION Name="ZEROFILL" Default="0" />
|
|
|
48 |
</OPTIONS>
|
|
|
49 |
</DATATYPE>
|
|
|
50 |
<DATATYPE ID="5" IDGroup="0" TypeName="INTEGER" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
51 |
<PARAMS>
|
|
|
52 |
<PARAM Name="length" />
|
|
|
53 |
</PARAMS>
|
|
|
54 |
<OPTIONS>
|
|
|
55 |
<OPTION Name="UNSIGNED" Default="1" />
|
|
|
56 |
<OPTION Name="ZEROFILL" Default="0" />
|
|
|
57 |
</OPTIONS>
|
|
|
58 |
</DATATYPE>
|
|
|
59 |
<DATATYPE ID="6" IDGroup="0" TypeName="BIGINT" Description="A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
60 |
<PARAMS>
|
|
|
61 |
<PARAM Name="length" />
|
|
|
62 |
</PARAMS>
|
|
|
63 |
<OPTIONS>
|
|
|
64 |
<OPTION Name="UNSIGNED" Default="0" />
|
|
|
65 |
<OPTION Name="ZEROFILL" Default="0" />
|
|
|
66 |
</OPTIONS>
|
|
|
67 |
</DATATYPE>
|
|
|
68 |
<DATATYPE ID="7" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
69 |
<PARAMS>
|
|
|
70 |
<PARAM Name="precision" />
|
|
|
71 |
</PARAMS>
|
|
|
72 |
<OPTIONS>
|
|
|
73 |
<OPTION Name="ZEROFILL" Default="0" />
|
|
|
74 |
</OPTIONS>
|
|
|
75 |
</DATATYPE>
|
|
|
76 |
<DATATYPE ID="8" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
77 |
<PARAMS>
|
|
|
78 |
<PARAM Name="length" />
|
|
|
79 |
<PARAM Name="decimals" />
|
|
|
80 |
</PARAMS>
|
|
|
81 |
<OPTIONS>
|
|
|
82 |
<OPTION Name="ZEROFILL" Default="0" />
|
|
|
83 |
</OPTIONS>
|
|
|
84 |
</DATATYPE>
|
|
|
85 |
<DATATYPE ID="9" IDGroup="0" TypeName="DOUBLE" Description="A normal-size (double-precision) floating-point number. Cannot be unsigned. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
86 |
<PARAMS>
|
|
|
87 |
<PARAM Name="length" />
|
|
|
88 |
<PARAM Name="decimals" />
|
|
|
89 |
</PARAMS>
|
|
|
90 |
<OPTIONS>
|
|
|
91 |
<OPTION Name="ZEROFILL" Default="0" />
|
|
|
92 |
</OPTIONS>
|
|
|
93 |
</DATATYPE>
|
|
|
94 |
<DATATYPE ID="10" IDGroup="0" TypeName="DOUBLE PRECISION" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
95 |
<PARAMS>
|
|
|
96 |
<PARAM Name="length" />
|
|
|
97 |
<PARAM Name="decimals" />
|
|
|
98 |
</PARAMS>
|
|
|
99 |
<OPTIONS>
|
|
|
100 |
<OPTION Name="ZEROFILL" Default="0" />
|
|
|
101 |
</OPTIONS>
|
|
|
102 |
</DATATYPE>
|
|
|
103 |
<DATATYPE ID="11" IDGroup="0" TypeName="REAL" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
104 |
<PARAMS>
|
|
|
105 |
<PARAM Name="length" />
|
|
|
106 |
<PARAM Name="decimals" />
|
|
|
107 |
</PARAMS>
|
|
|
108 |
<OPTIONS>
|
|
|
109 |
<OPTION Name="ZEROFILL" Default="0" />
|
|
|
110 |
</OPTIONS>
|
|
|
111 |
</DATATYPE>
|
|
|
112 |
<DATATYPE ID="12" IDGroup="0" TypeName="DECIMAL" Description="An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR column." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
113 |
<PARAMS>
|
|
|
114 |
<PARAM Name="length" />
|
|
|
115 |
<PARAM Name="decimals" />
|
|
|
116 |
</PARAMS>
|
|
|
117 |
<OPTIONS>
|
|
|
118 |
<OPTION Name="ZEROFILL" Default="0" />
|
|
|
119 |
</OPTIONS>
|
|
|
120 |
</DATATYPE>
|
|
|
121 |
<DATATYPE ID="13" IDGroup="0" TypeName="NUMERIC" Description="This is a synonym for DECIMAL." ParamCount="2" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
122 |
<PARAMS>
|
|
|
123 |
<PARAM Name="length" />
|
|
|
124 |
<PARAM Name="decimals" />
|
|
|
125 |
</PARAMS>
|
|
|
126 |
<OPTIONS>
|
|
|
127 |
<OPTION Name="ZEROFILL" Default="0" />
|
|
|
128 |
</OPTIONS>
|
|
|
129 |
</DATATYPE>
|
|
|
130 |
<DATATYPE ID="14" IDGroup="1" TypeName="DATE" Description="A date. The supported range is \a1000-01-01\a to \a9999-12-31\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
131 |
</DATATYPE>
|
|
|
132 |
<DATATYPE ID="15" IDGroup="1" TypeName="DATETIME" Description="A date and time combination. The supported range is \a1000-01-01 00:00:00\a to \a9999-12-31 23:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
133 |
</DATATYPE>
|
|
|
134 |
<DATATYPE ID="16" IDGroup="1" TypeName="TIMESTAMP" Description="A timestamp. The range is \a1970-01-01 00:00:00\a to sometime in the year 2037. The length can be 14 (or missing), 12, 10, 8, 6, 4, or 2 representing YYYYMMDDHHMMSS, ... , YYYYMMDD, ... , YY formats." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
135 |
<PARAMS>
|
|
|
136 |
<PARAM Name="length" />
|
|
|
137 |
</PARAMS>
|
|
|
138 |
</DATATYPE>
|
|
|
139 |
<DATATYPE ID="17" IDGroup="1" TypeName="TIME" Description="A time. The range is \a-838:59:59\a to \a838:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
140 |
</DATATYPE>
|
|
|
141 |
<DATATYPE ID="18" IDGroup="1" TypeName="YEAR" Description="A year in 2- or 4-digit format (default is 4-digit)." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
142 |
<PARAMS>
|
|
|
143 |
<PARAM Name="length" />
|
|
|
144 |
</PARAMS>
|
|
|
145 |
</DATATYPE>
|
|
|
146 |
<DATATYPE ID="19" IDGroup="2" TypeName="CHAR" Description="A fixed-length string (1 to 255 characters) that is always right-padded with spaces to the specified length when stored. values are sorted and compared in case-insensitive fashion according to the default character set unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
147 |
<PARAMS>
|
|
|
148 |
<PARAM Name="length" />
|
|
|
149 |
</PARAMS>
|
|
|
150 |
<OPTIONS>
|
|
|
151 |
<OPTION Name="BINARY" Default="0" />
|
|
|
152 |
</OPTIONS>
|
|
|
153 |
</DATATYPE>
|
|
|
154 |
<DATATYPE ID="20" IDGroup="2" TypeName="VARCHAR" Description="A variable-length string (1 to 255 characters). Values are sorted and compared in case-sensitive fashion unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
155 |
<PARAMS>
|
|
|
156 |
<PARAM Name="length" />
|
|
|
157 |
</PARAMS>
|
|
|
158 |
<OPTIONS>
|
|
|
159 |
<OPTION Name="BINARY" Default="0" />
|
|
|
160 |
</OPTIONS>
|
|
|
161 |
</DATATYPE>
|
|
|
162 |
<DATATYPE ID="21" IDGroup="2" TypeName="BIT" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
163 |
</DATATYPE>
|
|
|
164 |
<DATATYPE ID="22" IDGroup="2" TypeName="BOOL" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
165 |
</DATATYPE>
|
|
|
166 |
<DATATYPE ID="23" IDGroup="3" TypeName="TINYBLOB" Description="A column maximum length of 255 (2^8 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
167 |
</DATATYPE>
|
|
|
168 |
<DATATYPE ID="24" IDGroup="3" TypeName="BLOB" Description="A column maximum length of 65535 (2^16 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
169 |
</DATATYPE>
|
|
|
170 |
<DATATYPE ID="25" IDGroup="3" TypeName="MEDIUMBLOB" Description="A column maximum length of 16777215 (2^24 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
171 |
</DATATYPE>
|
|
|
172 |
<DATATYPE ID="26" IDGroup="3" TypeName="LONGBLOB" Description="A column maximum length of 4294967295 (2^32 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
173 |
</DATATYPE>
|
|
|
174 |
<DATATYPE ID="27" IDGroup="3" TypeName="TINYTEXT" Description="A column maximum length of 255 (2^8 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
175 |
</DATATYPE>
|
|
|
176 |
<DATATYPE ID="28" IDGroup="3" TypeName="TEXT" Description="A column maximum length of 65535 (2^16 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
177 |
</DATATYPE>
|
|
|
178 |
<DATATYPE ID="29" IDGroup="3" TypeName="MEDIUMTEXT" Description="A column maximum length of 16777215 (2^24 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
179 |
</DATATYPE>
|
|
|
180 |
<DATATYPE ID="30" IDGroup="3" TypeName="LONGTEXT" Description="A column maximum length of 4294967295 (2^32 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
181 |
</DATATYPE>
|
|
|
182 |
<DATATYPE ID="31" IDGroup="3" TypeName="ENUM" Description="An enumeration. A string object that can have only one value, chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
183 |
<PARAMS>
|
|
|
184 |
<PARAM Name="values" />
|
|
|
185 |
</PARAMS>
|
|
|
186 |
</DATATYPE>
|
|
|
187 |
<DATATYPE ID="32" IDGroup="3" TypeName="SET" Description="A set. A string object that can have zero or more values, each of which must be chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
188 |
<PARAMS>
|
|
|
189 |
<PARAM Name="values" />
|
|
|
190 |
</PARAMS>
|
|
|
191 |
</DATATYPE>
|
|
|
192 |
<DATATYPE ID="33" IDGroup="4" TypeName="Varchar(20)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
193 |
<OPTIONS>
|
|
|
194 |
<OPTION Name="BINARY" Default="0" />
|
|
|
195 |
</OPTIONS>
|
|
|
196 |
</DATATYPE>
|
|
|
197 |
<DATATYPE ID="34" IDGroup="4" TypeName="Varchar(45)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
198 |
<OPTIONS>
|
|
|
199 |
<OPTION Name="BINARY" Default="0" />
|
|
|
200 |
</OPTIONS>
|
|
|
201 |
</DATATYPE>
|
|
|
202 |
<DATATYPE ID="35" IDGroup="4" TypeName="Varchar(255)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
203 |
<OPTIONS>
|
|
|
204 |
<OPTION Name="BINARY" Default="0" />
|
|
|
205 |
</OPTIONS>
|
|
|
206 |
</DATATYPE>
|
|
|
207 |
<DATATYPE ID="36" IDGroup="5" TypeName="GEOMETRY" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
208 |
</DATATYPE>
|
|
|
209 |
<DATATYPE ID="38" IDGroup="5" TypeName="LINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
210 |
</DATATYPE>
|
|
|
211 |
<DATATYPE ID="39" IDGroup="5" TypeName="POLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
212 |
</DATATYPE>
|
|
|
213 |
<DATATYPE ID="40" IDGroup="5" TypeName="MULTIPOINT" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
214 |
</DATATYPE>
|
|
|
215 |
<DATATYPE ID="41" IDGroup="5" TypeName="MULTILINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
216 |
</DATATYPE>
|
|
|
217 |
<DATATYPE ID="42" IDGroup="5" TypeName="MULTIPOLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
218 |
</DATATYPE>
|
|
|
219 |
<DATATYPE ID="43" IDGroup="5" TypeName="GEOMETRYCOLLECTION" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
|
|
|
220 |
</DATATYPE>
|
|
|
221 |
</DATATYPES>
|
|
|
222 |
<COMMON_DATATYPES>
|
|
|
223 |
<COMMON_DATATYPE ID="5" />
|
|
|
224 |
<COMMON_DATATYPE ID="8" />
|
|
|
225 |
<COMMON_DATATYPE ID="20" />
|
|
|
226 |
<COMMON_DATATYPE ID="15" />
|
|
|
227 |
<COMMON_DATATYPE ID="22" />
|
|
|
228 |
<COMMON_DATATYPE ID="28" />
|
|
|
229 |
<COMMON_DATATYPE ID="26" />
|
|
|
230 |
<COMMON_DATATYPE ID="33" />
|
|
|
231 |
<COMMON_DATATYPE ID="34" />
|
|
|
232 |
<COMMON_DATATYPE ID="35" />
|
|
|
233 |
</COMMON_DATATYPES>
|
|
|
234 |
<TABLEPREFIXES>
|
|
|
235 |
<TABLEPREFIX Name="Defaut (pas de pr\233fixe)" />
|
|
|
236 |
</TABLEPREFIXES>
|
|
|
237 |
<REGIONCOLORS>
|
|
|
238 |
<REGIONCOLOR Color="Red=#FFEEEC" />
|
|
|
239 |
<REGIONCOLOR Color="Yellow=#FEFDED" />
|
|
|
240 |
<REGIONCOLOR Color="Green=#EAFFE5" />
|
|
|
241 |
<REGIONCOLOR Color="Cyan=#ECFDFF" />
|
|
|
242 |
<REGIONCOLOR Color="Blue=#F0F1FE" />
|
|
|
243 |
<REGIONCOLOR Color="Magenta=#FFEBFA" />
|
|
|
244 |
</REGIONCOLORS>
|
|
|
245 |
<POSITIONMARKERS>
|
|
|
246 |
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
|
|
|
247 |
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
|
|
|
248 |
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
|
|
|
249 |
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
|
|
|
250 |
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
|
|
|
251 |
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
|
|
|
252 |
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
|
|
|
253 |
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
|
|
|
254 |
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
|
|
|
255 |
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
|
|
|
256 |
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
|
|
|
257 |
</POSITIONMARKERS>
|
|
|
258 |
</SETTINGS>
|
|
|
259 |
<METADATA>
|
|
|
260 |
<REGIONS>
|
|
|
261 |
<REGION ID="6948" RegionName="G\233n\233sia - Abr\233viation : gen" XPos="2" YPos="3" Width="1773" Height="1715" RegionColor="0" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Contient les tables du noyau de G\233n\233sia." IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="21" />
|
|
|
262 |
</REGIONS>
|
|
|
263 |
<TABLES>
|
|
|
264 |
<TABLE ID="6929" Tablename="gen_menu_cache" PrevTableName="CACHE" XPos="867" YPos="793" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\nChunks=2\nChunkSize=64\n" Comments="Contient les pages en cache du site." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="6393" OrderPos="2" >
|
|
|
265 |
<COLUMNS>
|
|
|
266 |
<COLUMN ID="1034" ColName="gmcac_id_md5_url" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(32)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Valeur md5 de l\aurl.">
|
|
|
267 |
<OPTIONSELECTED>
|
|
|
268 |
<OPTIONSELECT Value="0" />
|
|
|
269 |
</OPTIONSELECTED>
|
|
|
270 |
</COLUMN>
|
|
|
271 |
<COLUMN ID="6807" ColName="gmcac_ce_site" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
272 |
<OPTIONSELECTED>
|
|
|
273 |
<OPTIONSELECT Value="1" />
|
|
|
274 |
<OPTIONSELECT Value="0" />
|
|
|
275 |
</OPTIONSELECTED>
|
|
|
276 |
</COLUMN>
|
|
|
277 |
<COLUMN ID="1036" ColName="gmcac_corps" PrevColName="" Pos="3" idDatatype="26" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Contenu sous forme de bits de la page compress\233.">
|
|
|
278 |
<OPTIONSELECTED>
|
|
|
279 |
</OPTIONSELECTED>
|
|
|
280 |
</COLUMN>
|
|
|
281 |
<COLUMN ID="1037" ColName="gmcac_date_heure" PrevColName="" Pos="4" idDatatype="15" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00 00:00:00" Comments="Date et heure de ka mise en cache.">
|
|
|
282 |
<OPTIONSELECTED>
|
|
|
283 |
</OPTIONSELECTED>
|
|
|
284 |
</COLUMN>
|
|
|
285 |
<COLUMN ID="1038" ColName="gmcac_taille" PrevColName="" Pos="5" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Taille de la page avant compression.">
|
|
|
286 |
<OPTIONSELECTED>
|
|
|
287 |
<OPTIONSELECT Value="0" />
|
|
|
288 |
<OPTIONSELECT Value="0" />
|
|
|
289 |
</OPTIONSELECTED>
|
|
|
290 |
</COLUMN>
|
|
|
291 |
<COLUMN ID="1039" ColName="gmcac_gz_taille" PrevColName="" Pos="6" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Taille de la page compress\233e.">
|
|
|
292 |
<OPTIONSELECTED>
|
|
|
293 |
<OPTIONSELECT Value="0" />
|
|
|
294 |
<OPTIONSELECT Value="0" />
|
|
|
295 |
</OPTIONSELECTED>
|
|
|
296 |
</COLUMN>
|
|
|
297 |
</COLUMNS>
|
|
|
298 |
<RELATIONS_END>
|
|
|
299 |
<RELATION_END ID="6949" />
|
|
|
300 |
</RELATIONS_END>
|
|
|
301 |
<INDICES>
|
|
|
302 |
<INDEX ID="1040" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
303 |
<INDEXCOLUMNS>
|
|
|
304 |
<INDEXCOLUMN idColumn="1034" LengthParam="0" />
|
|
|
305 |
</INDEXCOLUMNS>
|
|
|
306 |
</INDEX>
|
|
|
307 |
<INDEX ID="6827" IndexName="gen_menu_cache_FKIndex1" IndexKind="1" FKRefDef_Obj_id="6418">
|
|
|
308 |
<INDEXCOLUMNS>
|
|
|
309 |
<INDEXCOLUMN idColumn="6807" LengthParam="0" />
|
|
|
310 |
</INDEXCOLUMNS>
|
|
|
311 |
</INDEX>
|
|
|
312 |
</INDICES>
|
|
|
313 |
</TABLE>
|
|
|
314 |
<TABLE ID="6930" Tablename="gen_menu_relation" PrevTableName="MENU_LEVEL_1" XPos="952" YPos="1193" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\nChunks=2\nChunkSize=64\n" Comments="Table permettant de connaitre les relations unissant les menus entre eux." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="6396" OrderPos="3" >
|
|
|
315 |
<COLUMNS>
|
|
|
316 |
<COLUMN ID="6662" ColName="gmr_id_menu_01" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du menu 01.">
|
|
|
317 |
<OPTIONSELECTED>
|
|
|
318 |
<OPTIONSELECT Value="1" />
|
|
|
319 |
<OPTIONSELECT Value="0" />
|
|
|
320 |
</OPTIONSELECTED>
|
|
|
321 |
</COLUMN>
|
|
|
322 |
<COLUMN ID="6664" ColName="gmr_id_menu_02" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du menu 02.">
|
|
|
323 |
<OPTIONSELECTED>
|
|
|
324 |
<OPTIONSELECT Value="1" />
|
|
|
325 |
<OPTIONSELECT Value="0" />
|
|
|
326 |
</OPTIONSELECTED>
|
|
|
327 |
</COLUMN>
|
|
|
328 |
<COLUMN ID="6736" ColName="gmr_id_valeur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
329 |
<OPTIONSELECTED>
|
|
|
330 |
<OPTIONSELECT Value="1" />
|
|
|
331 |
<OPTIONSELECT Value="0" />
|
|
|
332 |
</OPTIONSELECTED>
|
|
|
333 |
</COLUMN>
|
|
|
334 |
<COLUMN ID="6691" ColName="gmr_ordre" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Ordre des relations quand on a le meme identifiant de menu 01 et le meme type de relation.">
|
|
|
335 |
<OPTIONSELECTED>
|
|
|
336 |
<OPTIONSELECT Value="1" />
|
|
|
337 |
<OPTIONSELECT Value="0" />
|
|
|
338 |
</OPTIONSELECTED>
|
|
|
339 |
</COLUMN>
|
|
|
340 |
</COLUMNS>
|
|
|
341 |
<RELATIONS_END>
|
|
|
342 |
<RELATION_END ID="6965" />
|
|
|
343 |
<RELATION_END ID="6966" />
|
|
|
344 |
<RELATION_END ID="6968" />
|
|
|
345 |
</RELATIONS_END>
|
|
|
346 |
<INDICES>
|
|
|
347 |
<INDEX ID="1273" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
348 |
<INDEXCOLUMNS>
|
|
|
349 |
<INDEXCOLUMN idColumn="6662" LengthParam="0" />
|
|
|
350 |
<INDEXCOLUMN idColumn="6664" LengthParam="0" />
|
|
|
351 |
<INDEXCOLUMN idColumn="6736" LengthParam="0" />
|
|
|
352 |
</INDEXCOLUMNS>
|
|
|
353 |
</INDEX>
|
|
|
354 |
<INDEX ID="6663" IndexName="gen_menu_relation_FKIndex2" IndexKind="1" FKRefDef_Obj_id="6656">
|
|
|
355 |
<INDEXCOLUMNS>
|
|
|
356 |
<INDEXCOLUMN idColumn="6662" LengthParam="0" />
|
|
|
357 |
</INDEXCOLUMNS>
|
|
|
358 |
</INDEX>
|
|
|
359 |
<INDEX ID="6665" IndexName="gen_menu_relation_FKIndex3" IndexKind="1" FKRefDef_Obj_id="6659">
|
|
|
360 |
<INDEXCOLUMNS>
|
|
|
361 |
<INDEXCOLUMN idColumn="6664" LengthParam="0" />
|
|
|
362 |
</INDEXCOLUMNS>
|
|
|
363 |
</INDEX>
|
|
|
364 |
<INDEX ID="6737" IndexName="gen_menu_relation_FKIndex3" IndexKind="1" FKRefDef_Obj_id="6705">
|
|
|
365 |
<INDEXCOLUMNS>
|
|
|
366 |
<INDEXCOLUMN idColumn="6736" LengthParam="0" />
|
|
|
367 |
</INDEXCOLUMNS>
|
|
|
368 |
</INDEX>
|
|
|
369 |
</INDICES>
|
|
|
370 |
</TABLE>
|
|
|
371 |
<TABLE ID="6931" Tablename="gen_site" PrevTableName="PROJECT" XPos="583" YPos="290" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Contient les informations sur les sites g\233r\233s par G\233n\233sia." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="6397" OrderPos="4" >
|
|
|
372 |
<COLUMNS>
|
|
|
373 |
<COLUMN ID="1108" ColName="gs_id_site" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indentifiant du site.">
|
|
|
374 |
<OPTIONSELECTED>
|
|
|
375 |
<OPTIONSELECT Value="1" />
|
|
|
376 |
<OPTIONSELECT Value="0" />
|
|
|
377 |
</OPTIONSELECTED>
|
|
|
378 |
</COLUMN>
|
|
|
379 |
<COLUMN ID="6800" ColName="gs_ce_i18n" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(8)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Langue du site.">
|
|
|
380 |
<OPTIONSELECTED>
|
|
|
381 |
<OPTIONSELECT Value="0" />
|
|
|
382 |
</OPTIONSELECTED>
|
|
|
383 |
</COLUMN>
|
|
|
384 |
<COLUMN ID="6798" ColName="gs_ce_auth" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="0" Comments="Poss\232de une valeur diff\233rente de 0 si le site utilise l\aauthentification des utilisateurs.">
|
|
|
385 |
<OPTIONSELECTED>
|
|
|
386 |
<OPTIONSELECT Value="1" />
|
|
|
387 |
<OPTIONSELECT Value="0" />
|
|
|
388 |
</OPTIONSELECTED>
|
|
|
389 |
</COLUMN>
|
|
|
390 |
<COLUMN ID="1115" ColName="gs_fichier_squelette" PrevColName="" Pos="8" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Chemin et nom du fichier squelette \224 utiliser par d\233faut pour ce site.">
|
|
|
391 |
<OPTIONSELECTED>
|
|
|
392 |
<OPTIONSELECT Value="0" />
|
|
|
393 |
</OPTIONSELECTED>
|
|
|
394 |
</COLUMN>
|
|
|
395 |
<COLUMN ID="6838" ColName="gs_code_num" PrevColName="" Pos="14" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Un site d\aorigine ainsi que ses traductions ont le meme code num\233rique.">
|
|
|
396 |
<OPTIONSELECTED>
|
|
|
397 |
<OPTIONSELECT Value="1" />
|
|
|
398 |
<OPTIONSELECT Value="0" />
|
|
|
399 |
</OPTIONSELECTED>
|
|
|
400 |
</COLUMN>
|
|
|
401 |
<COLUMN ID="5777" ColName="gs_code_alpha" PrevColName="gs_code" Pos="12" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Un site d\aorigine ainsi que ses traductions ont le meme code alphanum\233rique.">
|
|
|
402 |
<OPTIONSELECTED>
|
|
|
403 |
<OPTIONSELECT Value="0" />
|
|
|
404 |
</OPTIONSELECTED>
|
|
|
405 |
</COLUMN>
|
|
|
406 |
<COLUMN ID="5776" ColName="gs_nom" PrevColName="" Pos="11" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom du site dans la langue de ce site..">
|
|
|
407 |
<OPTIONSELECTED>
|
|
|
408 |
<OPTIONSELECT Value="0" />
|
|
|
409 |
</OPTIONSELECTED>
|
|
|
410 |
</COLUMN>
|
|
|
411 |
<COLUMN ID="6816" ColName="gs_raccourci_clavier" PrevColName="" Pos="10" idDatatype="19" DatatypeParams="(1)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Raccourci clavier pour acc\233der au lien menant vers ce site.">
|
|
|
412 |
<OPTIONSELECTED>
|
|
|
413 |
<OPTIONSELECT Value="0" />
|
|
|
414 |
</OPTIONSELECTED>
|
|
|
415 |
</COLUMN>
|
|
|
416 |
<COLUMN ID="6815" ColName="gs_titre" PrevColName="" Pos="11" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Titre par d\233faut des menus du site, dans la langue du site.">
|
|
|
417 |
<OPTIONSELECTED>
|
|
|
418 |
<OPTIONSELECT Value="0" />
|
|
|
419 |
</OPTIONSELECTED>
|
|
|
420 |
</COLUMN>
|
|
|
421 |
<COLUMN ID="6817" ColName="gs_mots_cles" PrevColName="gs_mot_cles" Pos="11" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Mots cl\233, dans la langue du site, d\233finissant le contenu g\233n\233ral de ce site. Utilis\233 par d\233faut pour les menus.">
|
|
|
422 |
<OPTIONSELECTED>
|
|
|
423 |
</OPTIONSELECTED>
|
|
|
424 |
</COLUMN>
|
|
|
425 |
<COLUMN ID="6189" ColName="gs_description" PrevColName="" Pos="10" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Description du contenu g\233n\233ral du site dans la langue de ce site. Utilis\233 par d\233faut pour les menus.">
|
|
|
426 |
<OPTIONSELECTED>
|
|
|
427 |
</OPTIONSELECTED>
|
|
|
428 |
</COLUMN>
|
|
|
429 |
<COLUMN ID="6818" ColName="gs_auteur" PrevColName="" Pos="12" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Auteur du site. G\233n\233ralement la structure \224 l\aorigine du site.">
|
|
|
430 |
<OPTIONSELECTED>
|
|
|
431 |
<OPTIONSELECT Value="0" />
|
|
|
432 |
</OPTIONSELECTED>
|
|
|
433 |
</COLUMN>
|
|
|
434 |
<COLUMN ID="6821" ColName="gs_date_creation" PrevColName="" Pos="15" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date de cr\233ation du site.">
|
|
|
435 |
<OPTIONSELECTED>
|
|
|
436 |
</OPTIONSELECTED>
|
|
|
437 |
</COLUMN>
|
|
|
438 |
<COLUMN ID="6801" ColName="gs_ce_admin" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de l\aadministrateur \224 l\aorigine de ce site.">
|
|
|
439 |
<OPTIONSELECTED>
|
|
|
440 |
<OPTIONSELECT Value="1" />
|
|
|
441 |
<OPTIONSELECT Value="0" />
|
|
|
442 |
</OPTIONSELECTED>
|
|
|
443 |
</COLUMN>
|
|
|
444 |
</COLUMNS>
|
|
|
445 |
<RELATIONS_START>
|
|
|
446 |
<RELATION_START ID="6949" />
|
|
|
447 |
<RELATION_START ID="6958" />
|
|
|
448 |
<RELATION_START ID="6971" />
|
|
|
449 |
<RELATION_START ID="6972" />
|
|
|
450 |
</RELATIONS_START>
|
|
|
451 |
<RELATIONS_END>
|
|
|
452 |
<RELATION_END ID="6951" />
|
|
|
453 |
<RELATION_END ID="6957" />
|
|
|
454 |
<RELATION_END ID="6960" />
|
|
|
455 |
</RELATIONS_END>
|
|
|
456 |
<INDICES>
|
|
|
457 |
<INDEX ID="3637" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
458 |
<INDEXCOLUMNS>
|
|
|
459 |
<INDEXCOLUMN idColumn="1108" LengthParam="0" />
|
|
|
460 |
</INDEXCOLUMNS>
|
|
|
461 |
</INDEX>
|
|
|
462 |
<INDEX ID="5778" IndexName="idx_gsi_abreviation" IndexKind="2" FKRefDef_Obj_id="-1">
|
|
|
463 |
<INDEXCOLUMNS>
|
|
|
464 |
<INDEXCOLUMN idColumn="5777" LengthParam="0" />
|
|
|
465 |
</INDEXCOLUMNS>
|
|
|
466 |
</INDEX>
|
|
|
467 |
<INDEX ID="6474" IndexName="idx_fk_gsi_ce_auth" IndexKind="1" FKRefDef_Obj_id="6426">
|
|
|
468 |
<INDEXCOLUMNS>
|
|
|
469 |
<INDEXCOLUMN idColumn="6798" LengthParam="0" />
|
|
|
470 |
</INDEXCOLUMNS>
|
|
|
471 |
</INDEX>
|
|
|
472 |
<INDEX ID="6609" IndexName="gen_site_FKIndex3" IndexKind="1" FKRefDef_Obj_id="6535">
|
|
|
473 |
<INDEXCOLUMNS>
|
|
|
474 |
<INDEXCOLUMN idColumn="6800" LengthParam="0" />
|
|
|
475 |
</INDEXCOLUMNS>
|
|
|
476 |
</INDEX>
|
|
|
477 |
<INDEX ID="6625" IndexName="gen_site_FKIndex4" IndexKind="1" FKRefDef_Obj_id="6623">
|
|
|
478 |
<INDEXCOLUMNS>
|
|
|
479 |
<INDEXCOLUMN idColumn="6801" LengthParam="0" />
|
|
|
480 |
</INDEXCOLUMNS>
|
|
|
481 |
</INDEX>
|
|
|
482 |
</INDICES>
|
|
|
483 |
</TABLE>
|
|
|
484 |
<TABLE ID="6932" Tablename="gen_annuaire" PrevTableName="annu_USERS" XPos="63" YPos="914" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Contient les informations sur les administrateurs de G\233n\233sia." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="6398" OrderPos="5" >
|
|
|
485 |
<COLUMNS>
|
|
|
486 |
<COLUMN ID="1164" ColName="ga_id_administrateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Identifiant d\aune personne participant \224 l\aadministration de G\233n\233sia.">
|
|
|
487 |
<OPTIONSELECTED>
|
|
|
488 |
<OPTIONSELECT Value="1" />
|
|
|
489 |
<OPTIONSELECT Value="0" />
|
|
|
490 |
</OPTIONSELECTED>
|
|
|
491 |
</COLUMN>
|
|
|
492 |
<COLUMN ID="6565" ColName="ga_ce_i18n" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(8)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
493 |
<OPTIONSELECTED>
|
|
|
494 |
<OPTIONSELECT Value="0" />
|
|
|
495 |
</OPTIONSELECTED>
|
|
|
496 |
</COLUMN>
|
|
|
497 |
<COLUMN ID="1167" ColName="ga_nom" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(32)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de la personne.">
|
|
|
498 |
<OPTIONSELECTED>
|
|
|
499 |
<OPTIONSELECT Value="0" />
|
|
|
500 |
</OPTIONSELECTED>
|
|
|
501 |
</COLUMN>
|
|
|
502 |
<COLUMN ID="1168" ColName="ga_prenom" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="(32)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pr\233nom de la personne.">
|
|
|
503 |
<OPTIONSELECTED>
|
|
|
504 |
<OPTIONSELECT Value="0" />
|
|
|
505 |
</OPTIONSELECTED>
|
|
|
506 |
</COLUMN>
|
|
|
507 |
<COLUMN ID="1172" ColName="ga_mot_de_passe" PrevColName="" Pos="9" idDatatype="20" DatatypeParams="(32)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="X X" Comments="Mot de passe pour acc\233der \224 l\ainterface d\aadministration.">
|
|
|
508 |
<OPTIONSELECTED>
|
|
|
509 |
<OPTIONSELECT Value="0" />
|
|
|
510 |
</OPTIONSELECTED>
|
|
|
511 |
</COLUMN>
|
|
|
512 |
<COLUMN ID="1173" ColName="ga_mail" PrevColName="" Pos="10" idDatatype="20" DatatypeParams="(128)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Mail de la personne.">
|
|
|
513 |
<OPTIONSELECTED>
|
|
|
514 |
<OPTIONSELECT Value="0" />
|
|
|
515 |
</OPTIONSELECTED>
|
|
|
516 |
</COLUMN>
|
|
|
517 |
</COLUMNS>
|
|
|
518 |
<RELATIONS_START>
|
|
|
519 |
<RELATION_START ID="6950" />
|
|
|
520 |
<RELATION_START ID="6959" />
|
|
|
521 |
<RELATION_START ID="6960" />
|
|
|
522 |
</RELATIONS_START>
|
|
|
523 |
<RELATIONS_END>
|
|
|
524 |
<RELATION_END ID="6956" />
|
|
|
525 |
</RELATIONS_END>
|
|
|
526 |
<INDICES>
|
|
|
527 |
<INDEX ID="1189" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
528 |
<INDEXCOLUMNS>
|
|
|
529 |
<INDEXCOLUMN idColumn="1164" LengthParam="0" />
|
|
|
530 |
</INDEXCOLUMNS>
|
|
|
531 |
</INDEX>
|
|
|
532 |
<INDEX ID="6534" IndexName="gen_annuaire_FKIndex1" IndexKind="1" FKRefDef_Obj_id="6532">
|
|
|
533 |
<INDEXCOLUMNS>
|
|
|
534 |
<INDEXCOLUMN idColumn="6565" LengthParam="0" />
|
|
|
535 |
</INDEXCOLUMNS>
|
|
|
536 |
</INDEX>
|
|
|
537 |
</INDICES>
|
|
|
538 |
</TABLE>
|
|
|
539 |
<TABLE ID="6933" Tablename="gen_application" PrevTableName="APPLICATION" XPos="1364" YPos="610" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Contient les informations sur les applications ou les applettes disponibles pour G\233n\233sia.\nUne application est sp\233cifiquement appel\233e par un menu et ce menu lui transmet des param\232tres.\nUne applette est appell\233e via une balise pr\233sente dans un squelette et poss\232de ses propres param\232tres.\nUne applette sera donc commune \224 toutes les pages utilisant le squelette en question." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="6399" OrderPos="6" >
|
|
|
540 |
<COLUMNS>
|
|
|
541 |
<COLUMN ID="5193" ColName="gap_id_application" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant de l\aapplication">
|
|
|
542 |
<OPTIONSELECTED>
|
|
|
543 |
<OPTIONSELECT Value="1" />
|
|
|
544 |
<OPTIONSELECT Value="0" />
|
|
|
545 |
</OPTIONSELECTED>
|
|
|
546 |
</COLUMN>
|
|
|
547 |
<COLUMN ID="5195" ColName="gap_nom" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(100)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de l\aapplication.">
|
|
|
548 |
<OPTIONSELECTED>
|
|
|
549 |
<OPTIONSELECT Value="0" />
|
|
|
550 |
</OPTIONSELECTED>
|
|
|
551 |
</COLUMN>
|
|
|
552 |
<COLUMN ID="5196" ColName="gap_description" PrevColName="" Pos="4" idDatatype="29" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Champs libre pour d\233crire une application.">
|
|
|
553 |
<OPTIONSELECTED>
|
|
|
554 |
</OPTIONSELECTED>
|
|
|
555 |
</COLUMN>
|
|
|
556 |
<COLUMN ID="5204" ColName="gap_chemin" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Chemin menant au fichier principal de l\aapplication (ancien nom : gp_chemin_application).">
|
|
|
557 |
<OPTIONSELECTED>
|
|
|
558 |
<OPTIONSELECT Value="0" />
|
|
|
559 |
</OPTIONSELECTED>
|
|
|
560 |
</COLUMN>
|
|
|
561 |
<COLUMN ID="5807" ColName="gap_bool_applette" PrevColName="" Pos="5" idDatatype="1" DatatypeParams="(1)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Boul\233en permettant de savoir si on a \224 faire \224 une applette (1) ou pas (0).">
|
|
|
562 |
<OPTIONSELECTED>
|
|
|
563 |
<OPTIONSELECT Value="1" />
|
|
|
564 |
<OPTIONSELECT Value="0" />
|
|
|
565 |
</OPTIONSELECTED>
|
|
|
566 |
</COLUMN>
|
|
|
567 |
<COLUMN ID="5800" ColName="gap_applette_balise" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Balise permettant d\aappeler l\aapplette depuis un squelette.">
|
|
|
568 |
<OPTIONSELECTED>
|
|
|
569 |
<OPTIONSELECT Value="0" />
|
|
|
570 |
</OPTIONSELECTED>
|
|
|
571 |
</COLUMN>
|
|
|
572 |
<COLUMN ID="5808" ColName="gap_applette_arguments" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Arguments \224 transmettre \224 l\aapplette.">
|
|
|
573 |
<OPTIONSELECTED>
|
|
|
574 |
<OPTIONSELECT Value="0" />
|
|
|
575 |
</OPTIONSELECTED>
|
|
|
576 |
</COLUMN>
|
|
|
577 |
</COLUMNS>
|
|
|
578 |
<RELATIONS_START>
|
|
|
579 |
<RELATION_START ID="6962" />
|
|
|
580 |
</RELATIONS_START>
|
|
|
581 |
<INDICES>
|
|
|
582 |
<INDEX ID="5201" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
583 |
<INDEXCOLUMNS>
|
|
|
584 |
<INDEXCOLUMN idColumn="5193" LengthParam="0" />
|
|
|
585 |
</INDEXCOLUMNS>
|
|
|
586 |
</INDEX>
|
|
|
587 |
</INDICES>
|
|
|
588 |
</TABLE>
|
|
|
589 |
<TABLE ID="6934" Tablename="gen_menu_url_alternative" PrevTableName="Table_10" XPos="680" YPos="1537" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Contient les url alternative pour un menu d\aun site dans une langue donn\233e." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="6400" OrderPos="7" >
|
|
|
590 |
<COLUMNS>
|
|
|
591 |
<COLUMN ID="5211" ColName="gmua_id_url" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Identifiant num\233rique d\aun raccourci.">
|
|
|
592 |
<OPTIONSELECTED>
|
|
|
593 |
<OPTIONSELECT Value="1" />
|
|
|
594 |
<OPTIONSELECT Value="0" />
|
|
|
595 |
</OPTIONSELECTED>
|
|
|
596 |
</COLUMN>
|
|
|
597 |
<COLUMN ID="6630" ColName="gmua_ce_menu" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
598 |
<OPTIONSELECTED>
|
|
|
599 |
<OPTIONSELECT Value="1" />
|
|
|
600 |
<OPTIONSELECT Value="0" />
|
|
|
601 |
</OPTIONSELECTED>
|
|
|
602 |
</COLUMN>
|
|
|
603 |
<COLUMN ID="5214" ColName="gmua_url" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Url du raccourci ou d\aune ancienne adresse.">
|
|
|
604 |
<OPTIONSELECTED>
|
|
|
605 |
<OPTIONSELECT Value="0" />
|
|
|
606 |
</OPTIONSELECTED>
|
|
|
607 |
</COLUMN>
|
|
|
608 |
</COLUMNS>
|
|
|
609 |
<RELATIONS_END>
|
|
|
610 |
<RELATION_END ID="6961" />
|
|
|
611 |
</RELATIONS_END>
|
|
|
612 |
<INDICES>
|
|
|
613 |
<INDEX ID="5212" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
614 |
<INDEXCOLUMNS>
|
|
|
615 |
<INDEXCOLUMN idColumn="5211" LengthParam="0" />
|
|
|
616 |
</INDEXCOLUMNS>
|
|
|
617 |
</INDEX>
|
|
|
618 |
<INDEX ID="6629" IndexName="gen_menu_url_alternative_FKIndex1" IndexKind="1" FKRefDef_Obj_id="6627">
|
|
|
619 |
<INDEXCOLUMNS>
|
|
|
620 |
<INDEXCOLUMN idColumn="6630" LengthParam="0" />
|
|
|
621 |
</INDEXCOLUMNS>
|
|
|
622 |
</INDEX>
|
|
|
623 |
</INDICES>
|
|
|
624 |
</TABLE>
|
|
|
625 |
<TABLE ID="6935" Tablename="gen_menu" PrevTableName="Table_12" XPos="497" YPos="787" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Contient les informations sur les menus constituant un site.\nLes informations d\aun menu permettent de g\233n\233rer les entetes Dublin Core." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="6403" OrderPos="8" >
|
|
|
626 |
<COLUMNS>
|
|
|
627 |
<COLUMN ID="5823" ColName="gm_id_menu" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aun menu.">
|
|
|
628 |
<OPTIONSELECTED>
|
|
|
629 |
<OPTIONSELECT Value="1" />
|
|
|
630 |
<OPTIONSELECT Value="0" />
|
|
|
631 |
</OPTIONSELECTED>
|
|
|
632 |
</COLUMN>
|
|
|
633 |
<COLUMN ID="6805" ColName="gm_ce_site" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
634 |
<OPTIONSELECTED>
|
|
|
635 |
<OPTIONSELECT Value="1" />
|
|
|
636 |
<OPTIONSELECT Value="0" />
|
|
|
637 |
</OPTIONSELECTED>
|
|
|
638 |
</COLUMN>
|
|
|
639 |
<COLUMN ID="6642" ColName="gm_ce_i18n" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(8)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
640 |
<OPTIONSELECTED>
|
|
|
641 |
<OPTIONSELECT Value="0" />
|
|
|
642 |
</OPTIONSELECTED>
|
|
|
643 |
</COLUMN>
|
|
|
644 |
<COLUMN ID="6634" ColName="gm_ce_application" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de l\aapplication g\233n\233rant le contenu de ce menu.">
|
|
|
645 |
<OPTIONSELECTED>
|
|
|
646 |
<OPTIONSELECT Value="1" />
|
|
|
647 |
<OPTIONSELECT Value="0" />
|
|
|
648 |
</OPTIONSELECTED>
|
|
|
649 |
</COLUMN>
|
|
|
650 |
<COLUMN ID="6670" ColName="gm_application_arguments" PrevColName="" Pos="36" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Argument de l\aapplication qui g\233n\232rera le contenu de ce menu.">
|
|
|
651 |
<OPTIONSELECTED>
|
|
|
652 |
<OPTIONSELECT Value="0" />
|
|
|
653 |
</OPTIONSELECTED>
|
|
|
654 |
</COLUMN>
|
|
|
655 |
<COLUMN ID="6671" ColName="gm_fichier_squelette" PrevColName="" Pos="37" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Chemin d\aacc\232s au fichier de squelette de ce menu s\ail en poss\232de un.">
|
|
|
656 |
<OPTIONSELECTED>
|
|
|
657 |
<OPTIONSELECT Value="0" />
|
|
|
658 |
</OPTIONSELECTED>
|
|
|
659 |
</COLUMN>
|
|
|
660 |
<COLUMN ID="6836" ColName="gm_code_num" PrevColName="" Pos="37" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Un menu d\aorigine ainsi que ses traductions ont le meme code num\233rique.">
|
|
|
661 |
<OPTIONSELECTED>
|
|
|
662 |
<OPTIONSELECT Value="1" />
|
|
|
663 |
<OPTIONSELECT Value="0" />
|
|
|
664 |
</OPTIONSELECTED>
|
|
|
665 |
</COLUMN>
|
|
|
666 |
<COLUMN ID="6583" ColName="gm_code_alpha" PrevColName="gm_code" Pos="30" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Un menu d\aorigine, ainsi que ses traductions ont le meme code alphanum\233rique.">
|
|
|
667 |
<OPTIONSELECTED>
|
|
|
668 |
<OPTIONSELECT Value="0" />
|
|
|
669 |
</OPTIONSELECTED>
|
|
|
670 |
</COLUMN>
|
|
|
671 |
<COLUMN ID="6688" ColName="gm_nom" PrevColName="" Pos="41" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom unique d\aun menu.">
|
|
|
672 |
<OPTIONSELECTED>
|
|
|
673 |
<OPTIONSELECT Value="0" />
|
|
|
674 |
</OPTIONSELECTED>
|
|
|
675 |
</COLUMN>
|
|
|
676 |
<COLUMN ID="6672" ColName="gm_raccourci_clavier" PrevColName="" Pos="38" idDatatype="19" DatatypeParams="(1)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Raccourci clavier utilis\233 pour acc\233der \224 ce menu.">
|
|
|
677 |
<OPTIONSELECTED>
|
|
|
678 |
<OPTIONSELECT Value="0" />
|
|
|
679 |
</OPTIONSELECTED>
|
|
|
680 |
</COLUMN>
|
|
|
681 |
<COLUMN ID="6356" ColName="gm_robot" PrevColName="" Pos="25" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="index,follow" Comments="Valeur pour l\aindexation par les robots.">
|
|
|
682 |
<OPTIONSELECTED>
|
|
|
683 |
<OPTIONSELECT Value="0" />
|
|
|
684 |
</OPTIONSELECTED>
|
|
|
685 |
</COLUMN>
|
|
|
686 |
<COLUMN ID="5838" ColName="gm_titre" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Titre du document.">
|
|
|
687 |
<OPTIONSELECTED>
|
|
|
688 |
<OPTIONSELECT Value="0" />
|
|
|
689 |
</OPTIONSELECTED>
|
|
|
690 |
</COLUMN>
|
|
|
691 |
<COLUMN ID="5839" ColName="gm_titre_alternatif" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Titre alternatif du document.">
|
|
|
692 |
<OPTIONSELECTED>
|
|
|
693 |
<OPTIONSELECT Value="0" />
|
|
|
694 |
</OPTIONSELECTED>
|
|
|
695 |
</COLUMN>
|
|
|
696 |
<COLUMN ID="5841" ColName="gm_mots_cles" PrevColName="" Pos="4" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Mots-clefs : utiliser des mots-clefs choisis dans le cadre d\aune politique de classement.">
|
|
|
697 |
<OPTIONSELECTED>
|
|
|
698 |
</OPTIONSELECTED>
|
|
|
699 |
</COLUMN>
|
|
|
700 |
<COLUMN ID="5843" ColName="gm_description_libre" PrevColName="" Pos="6" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Texte libre d\233crivant le document.">
|
|
|
701 |
<OPTIONSELECTED>
|
|
|
702 |
</OPTIONSELECTED>
|
|
|
703 |
</COLUMN>
|
|
|
704 |
<COLUMN ID="5842" ColName="gm_description_resume" PrevColName="" Pos="5" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type MIME des feuilles de styles de la page.">
|
|
|
705 |
<OPTIONSELECTED>
|
|
|
706 |
</OPTIONSELECTED>
|
|
|
707 |
</COLUMN>
|
|
|
708 |
<COLUMN ID="5850" ColName="gm_description_table_matieres" PrevColName="" Pos="12" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Table des mati\232res du document.">
|
|
|
709 |
<OPTIONSELECTED>
|
|
|
710 |
</OPTIONSELECTED>
|
|
|
711 |
</COLUMN>
|
|
|
712 |
<COLUMN ID="5895" ColName="gm_source" PrevColName="" Pos="19" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Lien web (URI) vers la source du document pr\233sent.">
|
|
|
713 |
<OPTIONSELECTED>
|
|
|
714 |
<OPTIONSELECT Value="0" />
|
|
|
715 |
</OPTIONSELECTED>
|
|
|
716 |
</COLUMN>
|
|
|
717 |
<COLUMN ID="5840" ColName="gm_auteur" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Auteur (cr\233ateur) du document : nom de la personne, de l\aorganisation ou du service \224 l\aorigine de la r\233daction du document.">
|
|
|
718 |
<OPTIONSELECTED>
|
|
|
719 |
<OPTIONSELECT Value="0" />
|
|
|
720 |
</OPTIONSELECTED>
|
|
|
721 |
</COLUMN>
|
|
|
722 |
<COLUMN ID="5846" ColName="gm_contributeur" PrevColName="" Pos="8" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de la personne, de l\aorganisation ou du service ayant contribu\233 \224 l\a\233laboration du document. Plusieurs noms peuvent etre indiqu\233 en les s\233parant par des virgules eux meme encadr\233 d\aespace.">
|
|
|
723 |
<OPTIONSELECTED>
|
|
|
724 |
</OPTIONSELECTED>
|
|
|
725 |
</COLUMN>
|
|
|
726 |
<COLUMN ID="5845" ColName="gm_editeur" PrevColName="" Pos="7" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de la personne, de l\aorganisation ou du service \224 l\aorigine de la publication du document. Plusieurs noms peuvent etre indiqu\233 en les s\233parant par des virgules eux meme encadr\233 d\aespace.">
|
|
|
727 |
<OPTIONSELECTED>
|
|
|
728 |
</OPTIONSELECTED>
|
|
|
729 |
</COLUMN>
|
|
|
730 |
<COLUMN ID="5881" ColName="gm_date_creation" PrevColName="" Pos="13" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date de cr\233ation du document (format W3CDTF).">
|
|
|
731 |
<OPTIONSELECTED>
|
|
|
732 |
</OPTIONSELECTED>
|
|
|
733 |
</COLUMN>
|
|
|
734 |
<COLUMN ID="5887" ColName="gm_date_soumission" PrevColName="" Pos="17" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date de soumission du document (format W3CDTF).">
|
|
|
735 |
<OPTIONSELECTED>
|
|
|
736 |
</OPTIONSELECTED>
|
|
|
737 |
</COLUMN>
|
|
|
738 |
<COLUMN ID="5888" ColName="gm_date_acceptation" PrevColName="" Pos="18" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date d\aacceptation du document (format W3CDTF).">
|
|
|
739 |
<OPTIONSELECTED>
|
|
|
740 |
</OPTIONSELECTED>
|
|
|
741 |
</COLUMN>
|
|
|
742 |
<COLUMN ID="6579" ColName="gm_date_publication" PrevColName="" Pos="29" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date \224 laquelle la page a \233t\233 r\233ellement mise en ligne (format W3CDTF).">
|
|
|
743 |
<OPTIONSELECTED>
|
|
|
744 |
</OPTIONSELECTED>
|
|
|
745 |
</COLUMN>
|
|
|
746 |
<COLUMN ID="6586" ColName="gm_date_debut_validite" PrevColName="" Pos="31" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date de d\233but de validit\233 du document, \224 laquelle la page doit etre mise en ligne (format W3CDTF).">
|
|
|
747 |
<OPTIONSELECTED>
|
|
|
748 |
</OPTIONSELECTED>
|
|
|
749 |
</COLUMN>
|
|
|
750 |
<COLUMN ID="5882" ColName="gm_date_fin_validite" PrevColName="" Pos="14" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date de fin de validit\233 du document, \224 laquelle la page doit etre retir\233 de la mise en ligne (format W3CDTF).">
|
|
|
751 |
<OPTIONSELECTED>
|
|
|
752 |
</OPTIONSELECTED>
|
|
|
753 |
</COLUMN>
|
|
|
754 |
<COLUMN ID="5885" ColName="gm_date_copyright" PrevColName="" Pos="16" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date du copyright (format W3CDTF).">
|
|
|
755 |
<OPTIONSELECTED>
|
|
|
756 |
</OPTIONSELECTED>
|
|
|
757 |
</COLUMN>
|
|
|
758 |
<COLUMN ID="5847" ColName="gm_licence" PrevColName="" Pos="9" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Lien web vers les droits relatifs \224 la ressource : permet de donner des informations sur le statut des droits du document, par exemple la pr\233sence d\aun copyright, ou un lien vers le d\233tenteur des droits. L\aabsence de cet \233l\233ment ne pr\233sume pas que le document est libre de droits.">
|
|
|
759 |
<OPTIONSELECTED>
|
|
|
760 |
<OPTIONSELECT Value="0" />
|
|
|
761 |
</OPTIONSELECTED>
|
|
|
762 |
</COLUMN>
|
|
|
763 |
<COLUMN ID="6577" ColName="gm_categorie" PrevColName="" Pos="28" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Grande cat\233gorie de document.">
|
|
|
764 |
<OPTIONSELECTED>
|
|
|
765 |
<OPTIONSELECT Value="0" />
|
|
|
766 |
</OPTIONSELECTED>
|
|
|
767 |
</COLUMN>
|
|
|
768 |
<COLUMN ID="5848" ColName="gm_public" PrevColName="" Pos="10" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Public vis\233 par le document : le public repr\233sente le groupe de personnes \224 qui le document est destin\233">
|
|
|
769 |
<OPTIONSELECTED>
|
|
|
770 |
<OPTIONSELECT Value="0" />
|
|
|
771 |
</OPTIONSELECTED>
|
|
|
772 |
</COLUMN>
|
|
|
773 |
<COLUMN ID="5849" ColName="gm_public_niveau" PrevColName="" Pos="11" idDatatype="20" DatatypeParams="(45)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Niveau du public demand\233e pour ce document dans un contexte de formation.">
|
|
|
774 |
<OPTIONSELECTED>
|
|
|
775 |
<OPTIONSELECT Value="0" />
|
|
|
776 |
</OPTIONSELECTED>
|
|
|
777 |
</COLUMN>
|
|
|
778 |
<COLUMN ID="5899" ColName="gm_ce_type_portee_spatiale" PrevColName="" Pos="21" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aun type de port\233e spatiale du document. 0 inconnu, 1 :iso-3166, 2 : point g\233ographique, 3 : r\233gion g\233ographique, 4 : TGN.">
|
|
|
779 |
<OPTIONSELECTED>
|
|
|
780 |
<OPTIONSELECT Value="1" />
|
|
|
781 |
<OPTIONSELECT Value="0" />
|
|
|
782 |
</OPTIONSELECTED>
|
|
|
783 |
</COLUMN>
|
|
|
784 |
<COLUMN ID="5900" ColName="gm_portee_spatiale" PrevColName="" Pos="22" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Valeur de la port\233e spatiale.">
|
|
|
785 |
<OPTIONSELECTED>
|
|
|
786 |
<OPTIONSELECT Value="0" />
|
|
|
787 |
</OPTIONSELECTED>
|
|
|
788 |
</COLUMN>
|
|
|
789 |
<COLUMN ID="5901" ColName="gm_ce_type_portee_temporelle" PrevColName="" Pos="23" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aun type de port\233e temporelle du document. 0 : inconnu, 1 : Period, 2 W3CDTF.">
|
|
|
790 |
<OPTIONSELECTED>
|
|
|
791 |
<OPTIONSELECT Value="1" />
|
|
|
792 |
<OPTIONSELECT Value="0" />
|
|
|
793 |
</OPTIONSELECTED>
|
|
|
794 |
</COLUMN>
|
|
|
795 |
<COLUMN ID="5902" ColName="gm_portee_temporelle" PrevColName="" Pos="24" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Valeur de la port\233e temporelle.">
|
|
|
796 |
<OPTIONSELECTED>
|
|
|
797 |
<OPTIONSELECT Value="0" />
|
|
|
798 |
</OPTIONSELECTED>
|
|
|
799 |
</COLUMN>
|
|
|
800 |
<COLUMN ID="6622" ColName="gm_ce_admin" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de l\aadministrateur cr\233ant, modifiant ou validant ce menu.">
|
|
|
801 |
<OPTIONSELECTED>
|
|
|
802 |
<OPTIONSELECT Value="1" />
|
|
|
803 |
<OPTIONSELECT Value="0" />
|
|
|
804 |
</OPTIONSELECTED>
|
|
|
805 |
</COLUMN>
|
|
|
806 |
</COLUMNS>
|
|
|
807 |
<RELATIONS_START>
|
|
|
808 |
<RELATION_START ID="6961" />
|
|
|
809 |
<RELATION_START ID="6963" />
|
|
|
810 |
<RELATION_START ID="6965" />
|
|
|
811 |
<RELATION_START ID="6966" />
|
|
|
812 |
</RELATIONS_START>
|
|
|
813 |
<RELATIONS_END>
|
|
|
814 |
<RELATION_END ID="6958" />
|
|
|
815 |
<RELATION_END ID="6959" />
|
|
|
816 |
<RELATION_END ID="6962" />
|
|
|
817 |
<RELATION_END ID="6964" />
|
|
|
818 |
</RELATIONS_END>
|
|
|
819 |
<INDICES>
|
|
|
820 |
<INDEX ID="5824" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
821 |
<INDEXCOLUMNS>
|
|
|
822 |
<INDEXCOLUMN idColumn="5823" LengthParam="0" />
|
|
|
823 |
</INDEXCOLUMNS>
|
|
|
824 |
</INDEX>
|
|
|
825 |
<INDEX ID="6621" IndexName="gen_menu_FKIndex2" IndexKind="1" FKRefDef_Obj_id="6619">
|
|
|
826 |
<INDEXCOLUMNS>
|
|
|
827 |
<INDEXCOLUMN idColumn="6622" LengthParam="0" />
|
|
|
828 |
</INDEXCOLUMNS>
|
|
|
829 |
</INDEX>
|
|
|
830 |
<INDEX ID="6633" IndexName="gen_menu_FKIndex3" IndexKind="1" FKRefDef_Obj_id="6631">
|
|
|
831 |
<INDEXCOLUMNS>
|
|
|
832 |
<INDEXCOLUMN idColumn="6634" LengthParam="0" />
|
|
|
833 |
</INDEXCOLUMNS>
|
|
|
834 |
</INDEX>
|
|
|
835 |
<INDEX ID="6641" IndexName="gen_menu_FKIndex4" IndexKind="1" FKRefDef_Obj_id="6639">
|
|
|
836 |
<INDEXCOLUMNS>
|
|
|
837 |
<INDEXCOLUMN idColumn="6642" LengthParam="0" />
|
|
|
838 |
</INDEXCOLUMNS>
|
|
|
839 |
</INDEX>
|
|
|
840 |
<INDEX ID="6828" IndexName="gen_menu_FKIndex4" IndexKind="1" FKRefDef_Obj_id="6615">
|
|
|
841 |
<INDEXCOLUMNS>
|
|
|
842 |
<INDEXCOLUMN idColumn="6805" LengthParam="0" />
|
|
|
843 |
</INDEXCOLUMNS>
|
|
|
844 |
</INDEX>
|
|
|
845 |
</INDICES>
|
|
|
846 |
</TABLE>
|
|
|
847 |
<TABLE ID="6936" Tablename="gen_menu_contenu" PrevTableName="Table_13" XPos="373" YPos="1537" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Permet de suivre l\a\233volution d\aune page et d\aobtenir ses informations d\aentete et son contenu associ\233." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="6404" OrderPos="9" >
|
|
|
848 |
<COLUMNS>
|
|
|
849 |
<COLUMN ID="6611" ColName="gmc_id_contenu" PrevColName="" Pos="7" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aun contenu.">
|
|
|
850 |
<OPTIONSELECTED>
|
|
|
851 |
<OPTIONSELECT Value="1" />
|
|
|
852 |
<OPTIONSELECT Value="0" />
|
|
|
853 |
</OPTIONSELECTED>
|
|
|
854 |
</COLUMN>
|
|
|
855 |
<COLUMN ID="6811" ColName="gmc_ce_admin" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
856 |
<OPTIONSELECTED>
|
|
|
857 |
<OPTIONSELECT Value="1" />
|
|
|
858 |
<OPTIONSELECT Value="0" />
|
|
|
859 |
</OPTIONSELECTED>
|
|
|
860 |
</COLUMN>
|
|
|
861 |
<COLUMN ID="6638" ColName="gmc_ce_menu" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du menu poss\233dant ce contenu.">
|
|
|
862 |
<OPTIONSELECTED>
|
|
|
863 |
<OPTIONSELECT Value="1" />
|
|
|
864 |
<OPTIONSELECT Value="0" />
|
|
|
865 |
</OPTIONSELECTED>
|
|
|
866 |
</COLUMN>
|
|
|
867 |
<COLUMN ID="6607" ColName="gmc_ce_type_contenu" PrevColName="" Pos="9" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type du contenu : 1, pour XHTML, 2 pour WIKINI.">
|
|
|
868 |
<OPTIONSELECTED>
|
|
|
869 |
<OPTIONSELECT Value="1" />
|
|
|
870 |
<OPTIONSELECT Value="0" />
|
|
|
871 |
</OPTIONSELECTED>
|
|
|
872 |
</COLUMN>
|
|
|
873 |
<COLUMN ID="6608" ColName="gmc_contenu" PrevColName="" Pos="10" idDatatype="29" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le contenu du menu.">
|
|
|
874 |
<OPTIONSELECTED>
|
|
|
875 |
</OPTIONSELECTED>
|
|
|
876 |
</COLUMN>
|
|
|
877 |
<COLUMN ID="6605" ColName="gmc_ce_type_modification" PrevColName="" Pos="7" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type de modification effectu\233e sur le menu : 1 pour mineure, 2 pour majeure.">
|
|
|
878 |
<OPTIONSELECTED>
|
|
|
879 |
<OPTIONSELECT Value="1" />
|
|
|
880 |
<OPTIONSELECT Value="0" />
|
|
|
881 |
</OPTIONSELECTED>
|
|
|
882 |
</COLUMN>
|
|
|
883 |
<COLUMN ID="6606" ColName="gmc_resume_modification" PrevColName="" Pos="8" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="R\233sum\233 de la modification, si majeure.">
|
|
|
884 |
<OPTIONSELECTED>
|
|
|
885 |
<OPTIONSELECT Value="0" />
|
|
|
886 |
</OPTIONSELECTED>
|
|
|
887 |
</COLUMN>
|
|
|
888 |
<COLUMN ID="6603" ColName="gmc_date_modification" PrevColName="" Pos="5" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date et heure de modification du contenu.">
|
|
|
889 |
<OPTIONSELECTED>
|
|
|
890 |
</OPTIONSELECTED>
|
|
|
891 |
</COLUMN>
|
|
|
892 |
<COLUMN ID="6604" ColName="gmc_bool_dernier" PrevColName="" Pos="6" idDatatype="1" DatatypeParams="(1)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="1" Comments="Bool\233\233n indiquant le dernier contenu pour le menu.">
|
|
|
893 |
<OPTIONSELECTED>
|
|
|
894 |
<OPTIONSELECT Value="1" />
|
|
|
895 |
<OPTIONSELECT Value="0" />
|
|
|
896 |
</OPTIONSELECTED>
|
|
|
897 |
</COLUMN>
|
|
|
898 |
</COLUMNS>
|
|
|
899 |
<RELATIONS_END>
|
|
|
900 |
<RELATION_END ID="6950" />
|
|
|
901 |
<RELATION_END ID="6963" />
|
|
|
902 |
</RELATIONS_END>
|
|
|
903 |
<INDICES>
|
|
|
904 |
<INDEX ID="6612" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
905 |
<INDEXCOLUMNS>
|
|
|
906 |
<INDEXCOLUMN idColumn="6611" LengthParam="0" />
|
|
|
907 |
</INDEXCOLUMNS>
|
|
|
908 |
</INDEX>
|
|
|
909 |
<INDEX ID="6482" IndexName="idx_fk_gp_ce_admin" IndexKind="1" FKRefDef_Obj_id="6424">
|
|
|
910 |
<INDEXCOLUMNS>
|
|
|
911 |
<INDEXCOLUMN idColumn="6811" LengthParam="0" />
|
|
|
912 |
</INDEXCOLUMNS>
|
|
|
913 |
</INDEX>
|
|
|
914 |
<INDEX ID="6637" IndexName="gen_menu_contenu_FKIndex2" IndexKind="1" FKRefDef_Obj_id="6635">
|
|
|
915 |
<INDEXCOLUMNS>
|
|
|
916 |
<INDEXCOLUMN idColumn="6638" LengthParam="0" />
|
|
|
917 |
</INDEXCOLUMNS>
|
|
|
918 |
</INDEX>
|
|
|
919 |
</INDICES>
|
|
|
920 |
</TABLE>
|
|
|
921 |
<TABLE ID="6937" Tablename="gen_site_auth" PrevTableName="Table_15" XPos="1357" YPos="14" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Contient les informations communes aux diff\233rents syst\232mes d\aidentification.\nLe type d\aidentification permet de savoir dans quel table chercher les informations d\aidentifications sp\233cifique au mode d\aidentification." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="6406" OrderPos="10" >
|
|
|
922 |
<COLUMNS>
|
|
|
923 |
<COLUMN ID="6265" ColName="gsa_id_auth" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant des informations d\aidentification.">
|
|
|
924 |
<OPTIONSELECTED>
|
|
|
925 |
<OPTIONSELECT Value="1" />
|
|
|
926 |
<OPTIONSELECT Value="0" />
|
|
|
927 |
</OPTIONSELECTED>
|
|
|
928 |
</COLUMN>
|
|
|
929 |
<COLUMN ID="6267" ColName="gsa_ce_type_auth" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type d\aidentification : 0 inconnu, 1 : base de donn\233es, 2 : ldap.">
|
|
|
930 |
<OPTIONSELECTED>
|
|
|
931 |
<OPTIONSELECT Value="1" />
|
|
|
932 |
<OPTIONSELECT Value="0" />
|
|
|
933 |
</OPTIONSELECTED>
|
|
|
934 |
</COLUMN>
|
|
|
935 |
<COLUMN ID="6840" ColName="gsa_nom" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de l\aauthentification.">
|
|
|
936 |
<OPTIONSELECTED>
|
|
|
937 |
<OPTIONSELECT Value="0" />
|
|
|
938 |
</OPTIONSELECTED>
|
|
|
939 |
</COLUMN>
|
|
|
940 |
<COLUMN ID="6341" ColName="gsa_ce_auth_bdd" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des informations pour un identification via une base de donn\233es. ">
|
|
|
941 |
<OPTIONSELECTED>
|
|
|
942 |
<OPTIONSELECT Value="1" />
|
|
|
943 |
<OPTIONSELECT Value="0" />
|
|
|
944 |
</OPTIONSELECTED>
|
|
|
945 |
</COLUMN>
|
|
|
946 |
<COLUMN ID="6340" ColName="gsa_ce_auth_ldap" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des informations pour un identification via LDAP. ">
|
|
|
947 |
<OPTIONSELECTED>
|
|
|
948 |
<OPTIONSELECT Value="1" />
|
|
|
949 |
<OPTIONSELECT Value="0" />
|
|
|
950 |
</OPTIONSELECTED>
|
|
|
951 |
</COLUMN>
|
|
|
952 |
</COLUMNS>
|
|
|
953 |
<RELATIONS_START>
|
|
|
954 |
<RELATION_START ID="6951" />
|
|
|
955 |
</RELATIONS_START>
|
|
|
956 |
<RELATIONS_END>
|
|
|
957 |
<RELATION_END ID="6952" />
|
|
|
958 |
<RELATION_END ID="6953" />
|
|
|
959 |
</RELATIONS_END>
|
|
|
960 |
<INDICES>
|
|
|
961 |
<INDEX ID="6266" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
962 |
<INDEXCOLUMNS>
|
|
|
963 |
<INDEXCOLUMN idColumn="6265" LengthParam="0" />
|
|
|
964 |
</INDEXCOLUMNS>
|
|
|
965 |
</INDEX>
|
|
|
966 |
<INDEX ID="6483" IndexName="idx_fk_gsa_ce_auth_ldap" IndexKind="1" FKRefDef_Obj_id="6427">
|
|
|
967 |
<INDEXCOLUMNS>
|
|
|
968 |
<INDEXCOLUMN idColumn="6340" LengthParam="0" />
|
|
|
969 |
</INDEXCOLUMNS>
|
|
|
970 |
</INDEX>
|
|
|
971 |
<INDEX ID="6484" IndexName="idx_fk_gsa_ce_auth_bdd" IndexKind="1" FKRefDef_Obj_id="6428">
|
|
|
972 |
<INDEXCOLUMNS>
|
|
|
973 |
<INDEXCOLUMN idColumn="6341" LengthParam="0" />
|
|
|
974 |
</INDEXCOLUMNS>
|
|
|
975 |
</INDEX>
|
|
|
976 |
</INDICES>
|
|
|
977 |
</TABLE>
|
|
|
978 |
<TABLE ID="6938" Tablename="gen_site_auth_bdd" PrevTableName="Table_16" XPos="1484" YPos="187" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Contient les informations pour identification via une base de donn\233es." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="6407" OrderPos="11" >
|
|
|
979 |
<COLUMNS>
|
|
|
980 |
<COLUMN ID="6279" ColName="gsab_id_auth_bdd" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aune identification par base de donn\233es.">
|
|
|
981 |
<OPTIONSELECTED>
|
|
|
982 |
<OPTIONSELECT Value="1" />
|
|
|
983 |
<OPTIONSELECT Value="0" />
|
|
|
984 |
</OPTIONSELECTED>
|
|
|
985 |
</COLUMN>
|
|
|
986 |
<COLUMN ID="6281" ColName="gsab_dsn" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Valeur du dsn.">
|
|
|
987 |
<OPTIONSELECTED>
|
|
|
988 |
<OPTIONSELECT Value="0" />
|
|
|
989 |
</OPTIONSELECTED>
|
|
|
990 |
</COLUMN>
|
|
|
991 |
<COLUMN ID="6282" ColName="gsab_nom_table" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de la table o\249 sont stock\233s les logins et mot de passes.">
|
|
|
992 |
<OPTIONSELECTED>
|
|
|
993 |
<OPTIONSELECT Value="0" />
|
|
|
994 |
</OPTIONSELECTED>
|
|
|
995 |
</COLUMN>
|
|
|
996 |
<COLUMN ID="6283" ColName="gsab_nom_champ_login" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom du champ o\249 se trouve les logins.">
|
|
|
997 |
<OPTIONSELECTED>
|
|
|
998 |
<OPTIONSELECT Value="0" />
|
|
|
999 |
</OPTIONSELECTED>
|
|
|
1000 |
</COLUMN>
|
|
|
1001 |
<COLUMN ID="6284" ColName="gsab_nom_champ_mdp" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom du champ o\249 se trouve les mots de passe.">
|
|
|
1002 |
<OPTIONSELECTED>
|
|
|
1003 |
<OPTIONSELECT Value="0" />
|
|
|
1004 |
</OPTIONSELECTED>
|
|
|
1005 |
</COLUMN>
|
|
|
1006 |
<COLUMN ID="6285" ColName="gsab_cryptage_mdp" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type de cryptage du mot de passe.">
|
|
|
1007 |
<OPTIONSELECTED>
|
|
|
1008 |
<OPTIONSELECT Value="0" />
|
|
|
1009 |
</OPTIONSELECTED>
|
|
|
1010 |
</COLUMN>
|
|
|
1011 |
</COLUMNS>
|
|
|
1012 |
<RELATIONS_START>
|
|
|
1013 |
<RELATION_START ID="6953" />
|
|
|
1014 |
</RELATIONS_START>
|
|
|
1015 |
<INDICES>
|
|
|
1016 |
<INDEX ID="6280" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
1017 |
<INDEXCOLUMNS>
|
|
|
1018 |
<INDEXCOLUMN idColumn="6279" LengthParam="0" />
|
|
|
1019 |
</INDEXCOLUMNS>
|
|
|
1020 |
</INDEX>
|
|
|
1021 |
</INDICES>
|
|
|
1022 |
</TABLE>
|
|
|
1023 |
<TABLE ID="6939" Tablename="gen_site_auth_ldap" PrevTableName="Table_17" XPos="1241" YPos="191" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Contient les information sp\233cifique \224 une identification via LDAP." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="6408" OrderPos="12" >
|
|
|
1024 |
<COLUMNS>
|
|
|
1025 |
<COLUMN ID="6288" ColName="gsal_id_auth_ldap" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identfiant des informations d\aidentification via ldap.">
|
|
|
1026 |
<OPTIONSELECTED>
|
|
|
1027 |
<OPTIONSELECT Value="1" />
|
|
|
1028 |
<OPTIONSELECT Value="0" />
|
|
|
1029 |
</OPTIONSELECTED>
|
|
|
1030 |
</COLUMN>
|
|
|
1031 |
<COLUMN ID="6290" ColName="gsal_serveur" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom du serveur ldap.">
|
|
|
1032 |
<OPTIONSELECTED>
|
|
|
1033 |
<OPTIONSELECT Value="0" />
|
|
|
1034 |
</OPTIONSELECTED>
|
|
|
1035 |
</COLUMN>
|
|
|
1036 |
<COLUMN ID="6291" ColName="gsal_port" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Port du serveur ldap.">
|
|
|
1037 |
<OPTIONSELECTED>
|
|
|
1038 |
<OPTIONSELECT Value="1" />
|
|
|
1039 |
<OPTIONSELECT Value="0" />
|
|
|
1040 |
</OPTIONSELECTED>
|
|
|
1041 |
</COLUMN>
|
|
|
1042 |
<COLUMN ID="6292" ColName="gsal_base_dn" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Base dn.">
|
|
|
1043 |
<OPTIONSELECTED>
|
|
|
1044 |
<OPTIONSELECT Value="0" />
|
|
|
1045 |
</OPTIONSELECTED>
|
|
|
1046 |
</COLUMN>
|
|
|
1047 |
<COLUMN ID="6293" ColName="gsal_uid" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Uid.">
|
|
|
1048 |
<OPTIONSELECTED>
|
|
|
1049 |
<OPTIONSELECT Value="0" />
|
|
|
1050 |
</OPTIONSELECTED>
|
|
|
1051 |
</COLUMN>
|
|
|
1052 |
</COLUMNS>
|
|
|
1053 |
<RELATIONS_START>
|
|
|
1054 |
<RELATION_START ID="6952" />
|
|
|
1055 |
</RELATIONS_START>
|
|
|
1056 |
<INDICES>
|
|
|
1057 |
<INDEX ID="6289" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
1058 |
<INDEXCOLUMNS>
|
|
|
1059 |
<INDEXCOLUMN idColumn="6288" LengthParam="0" />
|
|
|
1060 |
</INDEXCOLUMNS>
|
|
|
1061 |
</INDEX>
|
|
|
1062 |
</INDICES>
|
|
|
1063 |
</TABLE>
|
|
|
1064 |
<TABLE ID="6940" Tablename="gen_i18n" PrevTableName="LOCALE" XPos="105" YPos="199" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Contient les informations sur le couple langue / pays autrement appel\233 Internationalisation ou i18n." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="6524" OrderPos="13" >
|
|
|
1065 |
<COLUMNS>
|
|
|
1066 |
<COLUMN ID="1015" ColName="gi_id_i18n" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(8)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aune langue (voir RFC 1766). Exemple : fr-FR.">
|
|
|
1067 |
<OPTIONSELECTED>
|
|
|
1068 |
<OPTIONSELECT Value="0" />
|
|
|
1069 |
</OPTIONSELECTED>
|
|
|
1070 |
</COLUMN>
|
|
|
1071 |
<COLUMN ID="6558" ColName="gi_ce_langue" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(2)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la langue.">
|
|
|
1072 |
<OPTIONSELECTED>
|
|
|
1073 |
<OPTIONSELECT Value="0" />
|
|
|
1074 |
</OPTIONSELECTED>
|
|
|
1075 |
</COLUMN>
|
|
|
1076 |
<COLUMN ID="6556" ColName="gi_ce_pays" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(2)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du pays.">
|
|
|
1077 |
<OPTIONSELECTED>
|
|
|
1078 |
<OPTIONSELECT Value="0" />
|
|
|
1079 |
</OPTIONSELECTED>
|
|
|
1080 |
</COLUMN>
|
|
|
1081 |
<COLUMN ID="1018" ColName="gi_jeu_de_caracteres" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Jeu de caract\232re de la langue. Exemple : iso-8859-15 pour le fran\231ais.">
|
|
|
1082 |
<OPTIONSELECTED>
|
|
|
1083 |
<OPTIONSELECT Value="0" />
|
|
|
1084 |
</OPTIONSELECTED>
|
|
|
1085 |
</COLUMN>
|
|
|
1086 |
<COLUMN ID="1021" ColName="gi_nom" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Informations sur la langue. Peut apparaitre dans l\aattribut alt de l\aimage repr\233sentant la langue.">
|
|
|
1087 |
<OPTIONSELECTED>
|
|
|
1088 |
<OPTIONSELECT Value="0" />
|
|
|
1089 |
</OPTIONSELECTED>
|
|
|
1090 |
</COLUMN>
|
|
|
1091 |
</COLUMNS>
|
|
|
1092 |
<RELATIONS_START>
|
|
|
1093 |
<RELATION_START ID="6956" />
|
|
|
1094 |
<RELATION_START ID="6957" />
|
|
|
1095 |
<RELATION_START ID="6964" />
|
|
|
1096 |
</RELATIONS_START>
|
|
|
1097 |
<RELATIONS_END>
|
|
|
1098 |
<RELATION_END ID="6954" />
|
|
|
1099 |
<RELATION_END ID="6955" />
|
|
|
1100 |
</RELATIONS_END>
|
|
|
1101 |
<INDICES>
|
|
|
1102 |
<INDEX ID="1024" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
1103 |
<INDEXCOLUMNS>
|
|
|
1104 |
<INDEXCOLUMN idColumn="1015" LengthParam="0" />
|
|
|
1105 |
</INDEXCOLUMNS>
|
|
|
1106 |
</INDEX>
|
|
|
1107 |
<INDEX ID="6570" IndexName="gen_i18n_FKIndex1" IndexKind="1" FKRefDef_Obj_id="6527">
|
|
|
1108 |
<INDEXCOLUMNS>
|
|
|
1109 |
<INDEXCOLUMN idColumn="6556" LengthParam="0" />
|
|
|
1110 |
</INDEXCOLUMNS>
|
|
|
1111 |
</INDEX>
|
|
|
1112 |
<INDEX ID="6571" IndexName="gen_i18n_FKIndex2" IndexKind="1" FKRefDef_Obj_id="6528">
|
|
|
1113 |
<INDEXCOLUMNS>
|
|
|
1114 |
<INDEXCOLUMN idColumn="6558" LengthParam="0" />
|
|
|
1115 |
</INDEXCOLUMNS>
|
|
|
1116 |
</INDEX>
|
|
|
1117 |
</INDICES>
|
|
|
1118 |
</TABLE>
|
|
|
1119 |
<TABLE ID="6941" Tablename="gen_i18n_pays" PrevTableName="Table_04" XPos="232" YPos="41" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Cette table contient les diff\233rents pays du monde et leur nom par d\233faut (en fran\231ais). Ainsi qu\aun nom de fichier pour le drapeaux." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="6525" OrderPos="14" >
|
|
|
1120 |
<COLUMNS>
|
|
|
1121 |
<COLUMN ID="1092" ColName="gip_id_pays" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="(2)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant du pays code iso639.">
|
|
|
1122 |
<OPTIONSELECTED>
|
|
|
1123 |
<OPTIONSELECT Value="0" />
|
|
|
1124 |
</OPTIONSELECTED>
|
|
|
1125 |
</COLUMN>
|
|
|
1126 |
<COLUMN ID="1098" ColName="gip_nom" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le nom par d\233faut, en fran\231ais.">
|
|
|
1127 |
<OPTIONSELECTED>
|
|
|
1128 |
<OPTIONSELECT Value="0" />
|
|
|
1129 |
</OPTIONSELECTED>
|
|
|
1130 |
</COLUMN>
|
|
|
1131 |
<COLUMN ID="1108" ColName="gip_fichier_drapeau" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Un fichier graphique pour le drapeau.">
|
|
|
1132 |
<OPTIONSELECTED>
|
|
|
1133 |
<OPTIONSELECT Value="0" />
|
|
|
1134 |
</OPTIONSELECTED>
|
|
|
1135 |
</COLUMN>
|
|
|
1136 |
</COLUMNS>
|
|
|
1137 |
<RELATIONS_START>
|
|
|
1138 |
<RELATION_START ID="6954" />
|
|
|
1139 |
</RELATIONS_START>
|
|
|
1140 |
<INDICES>
|
|
|
1141 |
<INDEX ID="1093" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
1142 |
<INDEXCOLUMNS>
|
|
|
1143 |
<INDEXCOLUMN idColumn="1092" LengthParam="0" />
|
|
|
1144 |
</INDEXCOLUMNS>
|
|
|
1145 |
</INDEX>
|
|
|
1146 |
</INDICES>
|
|
|
1147 |
</TABLE>
|
|
|
1148 |
<TABLE ID="6942" Tablename="gen_i18n_langue" PrevTableName="Table_05" XPos="8" YPos="42" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Cette table contient les langues, leur noms par d\233faut, en fran\231ais en g\233n\233ral et la direction d\a\233criture (ltr left to right ou rtl right to left)" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="6526" OrderPos="15" >
|
|
|
1149 |
<COLUMNS>
|
|
|
1150 |
<COLUMN ID="1102" ColName="gil_id_langue" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="(2)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant de la langue. Iso3166.">
|
|
|
1151 |
<OPTIONSELECTED>
|
|
|
1152 |
<OPTIONSELECT Value="0" />
|
|
|
1153 |
</OPTIONSELECTED>
|
|
|
1154 |
</COLUMN>
|
|
|
1155 |
<COLUMN ID="1104" ColName="gil_nom" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le nom dans la langue par d\233faut.">
|
|
|
1156 |
<OPTIONSELECTED>
|
|
|
1157 |
<OPTIONSELECT Value="0" />
|
|
|
1158 |
</OPTIONSELECTED>
|
|
|
1159 |
</COLUMN>
|
|
|
1160 |
<COLUMN ID="1106" ColName="gil_direction" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="La direction d\a\233criture ltr ou rtl.">
|
|
|
1161 |
<OPTIONSELECTED>
|
|
|
1162 |
<OPTIONSELECT Value="0" />
|
|
|
1163 |
</OPTIONSELECTED>
|
|
|
1164 |
</COLUMN>
|
|
|
1165 |
</COLUMNS>
|
|
|
1166 |
<RELATIONS_START>
|
|
|
1167 |
<RELATION_START ID="6955" />
|
|
|
1168 |
</RELATIONS_START>
|
|
|
1169 |
<INDICES>
|
|
|
1170 |
<INDEX ID="1103" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
1171 |
<INDEXCOLUMNS>
|
|
|
1172 |
<INDEXCOLUMN idColumn="1102" LengthParam="0" />
|
|
|
1173 |
</INDEXCOLUMNS>
|
|
|
1174 |
</INDEX>
|
|
|
1175 |
</INDICES>
|
|
|
1176 |
</TABLE>
|
|
|
1177 |
<TABLE ID="6943" Tablename="gen_menu_categorie_valeur" PrevTableName="Table_18" XPos="952" YPos="1062" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="6676" OrderPos="16" >
|
|
|
1178 |
<COLUMNS>
|
|
|
1179 |
<COLUMN ID="6693" ColName="gmcv_id_valeur" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1180 |
<OPTIONSELECTED>
|
|
|
1181 |
<OPTIONSELECT Value="1" />
|
|
|
1182 |
<OPTIONSELECT Value="0" />
|
|
|
1183 |
</OPTIONSELECTED>
|
|
|
1184 |
</COLUMN>
|
|
|
1185 |
<COLUMN ID="6776" ColName="gmcv_id_categorie" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
1186 |
<OPTIONSELECTED>
|
|
|
1187 |
<OPTIONSELECT Value="1" />
|
|
|
1188 |
<OPTIONSELECT Value="0" />
|
|
|
1189 |
</OPTIONSELECTED>
|
|
|
1190 |
</COLUMN>
|
|
|
1191 |
<COLUMN ID="6695" ColName="gmcv_intitule_valeur" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1192 |
<OPTIONSELECTED>
|
|
|
1193 |
<OPTIONSELECT Value="0" />
|
|
|
1194 |
</OPTIONSELECTED>
|
|
|
1195 |
</COLUMN>
|
|
|
1196 |
</COLUMNS>
|
|
|
1197 |
<RELATIONS_START>
|
|
|
1198 |
<RELATION_START ID="6968" />
|
|
|
1199 |
</RELATIONS_START>
|
|
|
1200 |
<RELATIONS_END>
|
|
|
1201 |
<RELATION_END ID="6967" />
|
|
|
1202 |
</RELATIONS_END>
|
|
|
1203 |
<INDICES>
|
|
|
1204 |
<INDEX ID="6694" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
1205 |
<INDEXCOLUMNS>
|
|
|
1206 |
<INDEXCOLUMN idColumn="6693" LengthParam="0" />
|
|
|
1207 |
</INDEXCOLUMNS>
|
|
|
1208 |
</INDEX>
|
|
|
1209 |
<INDEX ID="6738" IndexName="gen_menu_categorie_valeur_FKIndex1" IndexKind="1" FKRefDef_Obj_id="6684">
|
|
|
1210 |
<INDEXCOLUMNS>
|
|
|
1211 |
<INDEXCOLUMN idColumn="6776" LengthParam="0" />
|
|
|
1212 |
</INDEXCOLUMNS>
|
|
|
1213 |
</INDEX>
|
|
|
1214 |
</INDICES>
|
|
|
1215 |
</TABLE>
|
|
|
1216 |
<TABLE ID="6944" Tablename="gen_menu_categorie" PrevTableName="Table_19" XPos="943" YPos="963" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="6677" OrderPos="17" >
|
|
|
1217 |
<COLUMNS>
|
|
|
1218 |
<COLUMN ID="6702" ColName="gmca_id_categorie" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1219 |
<OPTIONSELECTED>
|
|
|
1220 |
<OPTIONSELECT Value="1" />
|
|
|
1221 |
<OPTIONSELECT Value="0" />
|
|
|
1222 |
</OPTIONSELECTED>
|
|
|
1223 |
</COLUMN>
|
|
|
1224 |
<COLUMN ID="6704" ColName="gmca_intitule_categorie" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1225 |
<OPTIONSELECTED>
|
|
|
1226 |
<OPTIONSELECT Value="0" />
|
|
|
1227 |
</OPTIONSELECTED>
|
|
|
1228 |
</COLUMN>
|
|
|
1229 |
</COLUMNS>
|
|
|
1230 |
<RELATIONS_START>
|
|
|
1231 |
<RELATION_START ID="6967" />
|
|
|
1232 |
</RELATIONS_START>
|
|
|
1233 |
<INDICES>
|
|
|
1234 |
<INDEX ID="6703" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
1235 |
<INDEXCOLUMNS>
|
|
|
1236 |
<INDEXCOLUMN idColumn="6702" LengthParam="0" />
|
|
|
1237 |
</INDEXCOLUMNS>
|
|
|
1238 |
</INDEX>
|
|
|
1239 |
</INDICES>
|
|
|
1240 |
</TABLE>
|
|
|
1241 |
<TABLE ID="6945" Tablename="gen_site_relation" PrevTableName="MENU_LEVEL_1" XPos="991" YPos="373" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\nChunks=2\nChunkSize=64\n" Comments="Table permettant de connaitre les relations unissant les menus entre eux." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="6739" OrderPos="18" >
|
|
|
1242 |
<COLUMNS>
|
|
|
1243 |
<COLUMN ID="6809" ColName="gsr_id_site_01" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
1244 |
<OPTIONSELECTED>
|
|
|
1245 |
<OPTIONSELECT Value="1" />
|
|
|
1246 |
<OPTIONSELECT Value="0" />
|
|
|
1247 |
</OPTIONSELECTED>
|
|
|
1248 |
</COLUMN>
|
|
|
1249 |
<COLUMN ID="6808" ColName="gsr_id_site_02" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
1250 |
<OPTIONSELECTED>
|
|
|
1251 |
<OPTIONSELECT Value="1" />
|
|
|
1252 |
<OPTIONSELECT Value="0" />
|
|
|
1253 |
</OPTIONSELECTED>
|
|
|
1254 |
</COLUMN>
|
|
|
1255 |
<COLUMN ID="6784" ColName="gsr_id_valeur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
1256 |
<OPTIONSELECTED>
|
|
|
1257 |
<OPTIONSELECT Value="1" />
|
|
|
1258 |
<OPTIONSELECT Value="0" />
|
|
|
1259 |
</OPTIONSELECTED>
|
|
|
1260 |
</COLUMN>
|
|
|
1261 |
<COLUMN ID="6743" ColName="gsr_ordre" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Ordre des relations quand on a le meme identifiant de menu 01 et le meme type de relation.">
|
|
|
1262 |
<OPTIONSELECTED>
|
|
|
1263 |
<OPTIONSELECT Value="1" />
|
|
|
1264 |
<OPTIONSELECT Value="0" />
|
|
|
1265 |
</OPTIONSELECTED>
|
|
|
1266 |
</COLUMN>
|
|
|
1267 |
</COLUMNS>
|
|
|
1268 |
<RELATIONS_END>
|
|
|
1269 |
<RELATION_END ID="6970" />
|
|
|
1270 |
<RELATION_END ID="6971" />
|
|
|
1271 |
<RELATION_END ID="6972" />
|
|
|
1272 |
</RELATIONS_END>
|
|
|
1273 |
<INDICES>
|
|
|
1274 |
<INDEX ID="6774" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
1275 |
<INDEXCOLUMNS>
|
|
|
1276 |
<INDEXCOLUMN idColumn="6809" LengthParam="0" />
|
|
|
1277 |
<INDEXCOLUMN idColumn="6808" LengthParam="0" />
|
|
|
1278 |
<INDEXCOLUMN idColumn="6784" LengthParam="0" />
|
|
|
1279 |
</INDEXCOLUMNS>
|
|
|
1280 |
</INDEX>
|
|
|
1281 |
<INDEX ID="6829" IndexName="gen_site_relation_FKIndex1" IndexKind="1" FKRefDef_Obj_id="6746">
|
|
|
1282 |
<INDEXCOLUMNS>
|
|
|
1283 |
<INDEXCOLUMN idColumn="6784" LengthParam="0" />
|
|
|
1284 |
</INDEXCOLUMNS>
|
|
|
1285 |
</INDEX>
|
|
|
1286 |
<INDEX ID="6830" IndexName="gen_site_relation_FKIndex2" IndexKind="1" FKRefDef_Obj_id="6777">
|
|
|
1287 |
<INDEXCOLUMNS>
|
|
|
1288 |
<INDEXCOLUMN idColumn="6809" LengthParam="0" />
|
|
|
1289 |
</INDEXCOLUMNS>
|
|
|
1290 |
</INDEX>
|
|
|
1291 |
<INDEX ID="6831" IndexName="gen_site_relation_FKIndex3" IndexKind="1" FKRefDef_Obj_id="6780">
|
|
|
1292 |
<INDEXCOLUMNS>
|
|
|
1293 |
<INDEXCOLUMN idColumn="6808" LengthParam="0" />
|
|
|
1294 |
</INDEXCOLUMNS>
|
|
|
1295 |
</INDEX>
|
|
|
1296 |
</INDICES>
|
|
|
1297 |
</TABLE>
|
|
|
1298 |
<TABLE ID="6946" Tablename="gen_site_categorie_valeur" PrevTableName="Table_18" XPos="980" YPos="234" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="6751" OrderPos="19" >
|
|
|
1299 |
<COLUMNS>
|
|
|
1300 |
<COLUMN ID="6752" ColName="gscv_id_valeur" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1301 |
<OPTIONSELECTED>
|
|
|
1302 |
<OPTIONSELECT Value="1" />
|
|
|
1303 |
<OPTIONSELECT Value="0" />
|
|
|
1304 |
</OPTIONSELECTED>
|
|
|
1305 |
</COLUMN>
|
|
|
1306 |
<COLUMN ID="6799" ColName="gsc_id_categorie" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
1307 |
<OPTIONSELECTED>
|
|
|
1308 |
<OPTIONSELECT Value="1" />
|
|
|
1309 |
<OPTIONSELECT Value="0" />
|
|
|
1310 |
</OPTIONSELECTED>
|
|
|
1311 |
</COLUMN>
|
|
|
1312 |
<COLUMN ID="6754" ColName="gscv_intitule_valeur" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1313 |
<OPTIONSELECTED>
|
|
|
1314 |
<OPTIONSELECT Value="0" />
|
|
|
1315 |
</OPTIONSELECTED>
|
|
|
1316 |
</COLUMN>
|
|
|
1317 |
</COLUMNS>
|
|
|
1318 |
<RELATIONS_START>
|
|
|
1319 |
<RELATION_START ID="6970" />
|
|
|
1320 |
</RELATIONS_START>
|
|
|
1321 |
<RELATIONS_END>
|
|
|
1322 |
<RELATION_END ID="6969" />
|
|
|
1323 |
</RELATIONS_END>
|
|
|
1324 |
<INDICES>
|
|
|
1325 |
<INDEX ID="6756" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
1326 |
<INDEXCOLUMNS>
|
|
|
1327 |
<INDEXCOLUMN idColumn="6752" LengthParam="0" />
|
|
|
1328 |
</INDEXCOLUMNS>
|
|
|
1329 |
</INDEX>
|
|
|
1330 |
<INDEX ID="6832" IndexName="gen_site_categorie_valeur_FKIndex1" IndexKind="1" FKRefDef_Obj_id="6755">
|
|
|
1331 |
<INDEXCOLUMNS>
|
|
|
1332 |
<INDEXCOLUMN idColumn="6799" LengthParam="0" />
|
|
|
1333 |
</INDEXCOLUMNS>
|
|
|
1334 |
</INDEX>
|
|
|
1335 |
</INDICES>
|
|
|
1336 |
</TABLE>
|
|
|
1337 |
<TABLE ID="6947" Tablename="gen_site_categorie" PrevTableName="Table_19" XPos="971" YPos="107" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="6758" OrderPos="20" >
|
|
|
1338 |
<COLUMNS>
|
|
|
1339 |
<COLUMN ID="6759" ColName="gsc_id_categorie" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1340 |
<OPTIONSELECTED>
|
|
|
1341 |
<OPTIONSELECT Value="1" />
|
|
|
1342 |
<OPTIONSELECT Value="0" />
|
|
|
1343 |
</OPTIONSELECTED>
|
|
|
1344 |
</COLUMN>
|
|
|
1345 |
<COLUMN ID="6760" ColName="gsc_intitule_categorie" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1346 |
<OPTIONSELECTED>
|
|
|
1347 |
<OPTIONSELECT Value="0" />
|
|
|
1348 |
</OPTIONSELECTED>
|
|
|
1349 |
</COLUMN>
|
|
|
1350 |
</COLUMNS>
|
|
|
1351 |
<RELATIONS_START>
|
|
|
1352 |
<RELATION_START ID="6969" />
|
|
|
1353 |
</RELATIONS_START>
|
|
|
1354 |
<INDICES>
|
|
|
1355 |
<INDEX ID="6761" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
1356 |
<INDEXCOLUMNS>
|
|
|
1357 |
<INDEXCOLUMN idColumn="6759" LengthParam="0" />
|
|
|
1358 |
</INDEXCOLUMNS>
|
|
|
1359 |
</INDEX>
|
|
|
1360 |
</INDICES>
|
|
|
1361 |
</TABLE>
|
|
|
1362 |
</TABLES>
|
|
|
1363 |
<RELATIONS>
|
|
|
1364 |
<RELATION ID="6949" RelationName="fk_GS_GMCAC" Kind="2" SrcTable="6931" DestTable="6929" FKFields="gs_id_site=gmcac_ce_site\n" FKFieldsComments="\n" relDirection="3" MidOffset="1" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="-48" StartIntervalOffsetX="11" StartIntervalOffsetY="-28" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6827" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="22" />
|
|
|
1365 |
<RELATION ID="6950" RelationName="fk_GA_GMC" Kind="2" SrcTable="6932" DestTable="6936" FKFields="ga_id_administrateur=gmc_ce_admin\n" FKFieldsComments="\n" relDirection="3" MidOffset="215" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-53" CaptionOffsetY="-23" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6482" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="23" />
|
|
|
1366 |
<RELATION ID="6951" RelationName="fk_GSA_GS" Kind="2" SrcTable="6937" DestTable="6931" FKFields="gsa_id_auth=gs_ce_auth\n" FKFieldsComments="\n" relDirection="4" MidOffset="-236" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="-10" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="-9" EndIntervalOffsetY="-3" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6474" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="24" />
|
|
|
1367 |
<RELATION ID="6952" RelationName="fk_GSAL_GSA" Kind="5" SrcTable="6939" DestTable="6937" FKFields="gsal_id_auth_ldap=gsa_ce_auth_ldap\n" FKFieldsComments="\n" relDirection="1" MidOffset="-1" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6483" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="25" />
|
|
|
1368 |
<RELATION ID="6953" RelationName="fk_GSAB_GSA" Kind="5" SrcTable="6938" DestTable="6937" FKFields="gsab_id_auth_bdd=gsa_ce_auth_bdd\n" FKFieldsComments="\n" relDirection="1" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-69" CaptionOffsetY="-8" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6484" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="26" />
|
|
|
1369 |
<RELATION ID="6954" RelationName="fk_GIP_GI" Kind="2" SrcTable="6941" DestTable="6940" FKFields="gip_id_pays=gi_ce_pays\n" FKFieldsComments="\n" relDirection="3" MidOffset="1" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="3" CaptionOffsetY="-3" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6570" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="27" />
|
|
|
1370 |
<RELATION ID="6955" RelationName="fk_GIL_GI" Kind="2" SrcTable="6942" DestTable="6940" FKFields="gil_id_langue=gi_ce_langue\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="53" CaptionOffsetY="-22" StartIntervalOffsetX="6" StartIntervalOffsetY="4" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6571" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="28" />
|
|
|
1371 |
<RELATION ID="6956" RelationName="fk_GI_GA" Kind="2" SrcTable="6940" DestTable="6932" FKFields="gi_id_i18n=ga_ce_i18n\n" FKFieldsComments="\n" relDirection="3" MidOffset="-30" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="47" CaptionOffsetY="-20" StartIntervalOffsetX="0" StartIntervalOffsetY="5" EndIntervalOffsetX="-3" EndIntervalOffsetY="-5" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6534" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="29" />
|
|
|
1372 |
<RELATION ID="6957" RelationName="fk_GI_GS" Kind="2" SrcTable="6940" DestTable="6931" FKFields="gi_id_i18n=gs_ce_i18n\n" FKFieldsComments="\n" relDirection="2" MidOffset="5" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6609" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="30" />
|
|
|
1373 |
<RELATION ID="6958" RelationName="fk_GS_GM" Kind="2" SrcTable="6931" DestTable="6935" FKFields="gs_id_site=gm_ce_site\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6828" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="31" />
|
|
|
1374 |
<RELATION ID="6959" RelationName="fk_GA_GM" Kind="2" SrcTable="6932" DestTable="6935" FKFields="ga_id_administrateur=gm_ce_admin\n" FKFieldsComments="\n" relDirection="2" MidOffset="3" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6621" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
|
|
|
1375 |
<RELATION ID="6960" RelationName="fk_GA_GS" Kind="2" SrcTable="6932" DestTable="6931" FKFields="ga_id_administrateur=gs_ce_admin\n" FKFieldsComments="\n" relDirection="2" MidOffset="-40" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6625" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="33" />
|
|
|
1376 |
<RELATION ID="6961" RelationName="fk_GM_GMUA" Kind="2" SrcTable="6935" DestTable="6934" FKFields="gm_id_menu=gmua_ce_menu\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-62" CaptionOffsetY="-6" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6629" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="34" />
|
|
|
1377 |
<RELATION ID="6962" RelationName="fk_GAP_GM" Kind="2" SrcTable="6933" DestTable="6935" FKFields="gap_id_application=gm_ce_application\n" FKFieldsComments="\n" relDirection="4" MidOffset="190" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6633" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="35" />
|
|
|
1378 |
<RELATION ID="6963" RelationName="fk_GM_GMC" Kind="2" SrcTable="6935" DestTable="6936" FKFields="gm_id_menu=gmc_ce_menu\n" FKFieldsComments="\n" relDirection="3" MidOffset="3" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="53" CaptionOffsetY="-5" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6637" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="36" />
|
|
|
1379 |
<RELATION ID="6964" RelationName="fk_GI_GM" Kind="2" SrcTable="6940" DestTable="6935" FKFields="gi_id_i18n=gm_ce_i18n\n" FKFieldsComments="\n" relDirection="3" MidOffset="40" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6641" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="37" />
|
|
|
1380 |
<RELATION ID="6965" RelationName="fk_GM_GMR_01" Kind="1" SrcTable="6935" DestTable="6930" FKFields="gm_id_menu=gmr_id_menu_01\n" FKFieldsComments="\n" relDirection="2" MidOffset="10" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="16" EndIntervalOffsetY="-5" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6663" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="38" />
|
|
|
1381 |
<RELATION ID="6966" RelationName="fk_GM_GMR_02" Kind="1" SrcTable="6935" DestTable="6930" FKFields="gm_id_menu=gmr_id_menu_02\n" FKFieldsComments="\n" relDirection="2" MidOffset="9" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="1" CaptionOffsetY="-60" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="17" EndIntervalOffsetY="-6" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6665" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="39" />
|
|
|
1382 |
<RELATION ID="6967" RelationName="fk_GMCA_GMVC" Kind="2" SrcTable="6944" DestTable="6943" FKFields="gmca_id_categorie=gmcv_id_categorie\n" FKFieldsComments="\n" relDirection="3" MidOffset="19" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="72" CaptionOffsetY="-23" StartIntervalOffsetX="1" StartIntervalOffsetY="5" EndIntervalOffsetX="1" EndIntervalOffsetY="-8" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6738" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="40" />
|
|
|
1383 |
<RELATION ID="6968" RelationName="fk_GMCV_GMR" Kind="1" SrcTable="6943" DestTable="6930" FKFields="gmcv_id_valeur=gmr_id_valeur\n" FKFieldsComments="\n" relDirection="3" MidOffset="1" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="64" CaptionOffsetY="-28" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6737" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="41" />
|
|
|
1384 |
<RELATION ID="6969" RelationName="fk_GSC_GSCV" Kind="2" SrcTable="6947" DestTable="6946" FKFields="gsc_id_categorie=gsc_id_categorie\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="62" CaptionOffsetY="-20" StartIntervalOffsetX="0" StartIntervalOffsetY="5" EndIntervalOffsetX="1" EndIntervalOffsetY="-4" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6832" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="42" />
|
|
|
1385 |
<RELATION ID="6970" RelationName="fk_GSCV_GSR" Kind="1" SrcTable="6946" DestTable="6945" FKFields="gscv_id_valeur=gsr_id_valeur\n" FKFieldsComments="\n" relDirection="3" MidOffset="-10" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="70" CaptionOffsetY="-24" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6829" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="43" />
|
|
|
1386 |
<RELATION ID="6971" RelationName="fk_GS_GSR_01" Kind="1" SrcTable="6931" DestTable="6945" FKFields="gs_id_site=gsr_id_site_01\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-17" CaptionOffsetY="4" StartIntervalOffsetX="9" StartIntervalOffsetY="0" EndIntervalOffsetX="-12" EndIntervalOffsetY="-23" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6830" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="44" />
|
|
|
1387 |
<RELATION ID="6972" RelationName="fk_GS_GSR_02" Kind="1" SrcTable="6931" DestTable="6945" FKFields="gs_id_site=gsr_id_site_02\n" FKFieldsComments="\n" relDirection="2" MidOffset="1" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-3" CaptionOffsetY="-53" StartIntervalOffsetX="11" StartIntervalOffsetY="0" EndIntervalOffsetX="-12" EndIntervalOffsetY="-27" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="6831" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="45" />
|
|
|
1388 |
</RELATIONS>
|
|
|
1389 |
<NOTES>
|
|
|
1390 |
</NOTES>
|
|
|
1391 |
<IMAGES>
|
|
|
1392 |
</IMAGES>
|
|
|
1393 |
</METADATA>
|
|
|
1394 |
<PLUGINDATA>
|
|
|
1395 |
<PLUGINDATARECORDS>
|
|
|
1396 |
</PLUGINDATARECORDS>
|
|
|
1397 |
</PLUGINDATA>
|
|
|
1398 |
<QUERYDATA>
|
|
|
1399 |
<QUERYRECORDS>
|
|
|
1400 |
</QUERYRECORDS>
|
|
|
1401 |
</QUERYDATA>
|
|
|
1402 |
<LINKEDMODELS>
|
|
|
1403 |
</LINKEDMODELS>
|
|
|
1404 |
</DBMODEL>
|