| 1 |
-- Base de donnees framework om5 "openmairie" |
| 2 |
|
| 3 |
-- schema |
| 4 |
-- SET search_path = openfoncier, pg_catalog; |
| 5 |
|
| 6 |
|
| 7 |
CREATE TABLE om_collectivite ( |
| 8 |
om_collectivite int8 NOT NULL, |
| 9 |
libelle varchar(100) NOT NULL, |
| 10 |
niveau varchar(1) NOT NULL, |
| 11 |
PRIMARY KEY (om_collectivite) |
| 12 |
); |
| 13 |
|
| 14 |
CREATE TABLE om_parametre ( |
| 15 |
om_parametre int8 NOT NULL, |
| 16 |
libelle varchar(20) NOT NULL, |
| 17 |
valeur varchar(50) NOT NULL, |
| 18 |
om_collectivite int8 NOT NULL, |
| 19 |
PRIMARY KEY (om_parametre) |
| 20 |
); |
| 21 |
|
| 22 |
-- droit -- |
| 23 |
|
| 24 |
CREATE TABLE om_profil ( |
| 25 |
om_profil varchar(2) NOT NULL default '0', |
| 26 |
libelle varchar(30) NOT NULL, |
| 27 |
PRIMARY KEY (om_profil) |
| 28 |
); |
| 29 |
|
| 30 |
CREATE TABLE om_droit ( |
| 31 |
om_droit varchar(30) NOT NULL, |
| 32 |
om_profil varchar(2) NOT NULL default '0', |
| 33 |
PRIMARY KEY (om_droit) |
| 34 |
); |
| 35 |
|
| 36 |
---------------------------------------- |
| 37 |
-- SPECIFIQUE : telephone et instructeur |
| 38 |
---------------------------------------- |
| 39 |
|
| 40 |
CREATE TABLE om_utilisateur ( |
| 41 |
om_utilisateur int8 NOT NULL default '0', |
| 42 |
nom varchar(30) NOT NULL default '', |
| 43 |
email varchar(40) NOT NULL default '', |
| 44 |
Login varchar(30) NOT NULL default '', |
| 45 |
Pwd varchar(100) NOT NULL default '', |
| 46 |
om_profil varchar(2) NOT NULL default '', |
| 47 |
om_collectivite int8 NOT NULL, |
| 48 |
om_type varchar(20) NOT NULL, |
| 49 |
PRIMARY KEY (om_utilisateur) |
| 50 |
); |
| 51 |
|
| 52 |
-- etat / sousetat / lettretype |
| 53 |
|
| 54 |
CREATE TABLE om_etat ( |
| 55 |
om_etat int8 NOT NULL, |
| 56 |
om_collectivite int8 NOT NULL, |
| 57 |
id varchar(50) NOT NULL, |
| 58 |
libelle varchar(50) NOT NULL, |
| 59 |
actif varchar(3) NOT NULL, |
| 60 |
orientation varchar(2) NOT NULL, |
| 61 |
format varchar(5) NOT NULL, |
| 62 |
footerfont varchar(20) NOT NULL, |
| 63 |
footerattribut varchar(20) NOT NULL, |
| 64 |
footertaille int8 NOT NULL, |
| 65 |
logo varchar(30) NOT NULL, |
| 66 |
logoleft int8 NOT NULL, |
| 67 |
logotop int8 NOT NULL, |
| 68 |
titre text NOT NULL, |
| 69 |
titreleft int8 NOT NULL, |
| 70 |
titretop int8 NOT NULL, |
| 71 |
titrelargeur int8 NOT NULL, |
| 72 |
titrehauteur int8 NOT NULL, |
| 73 |
titrefont varchar(20) NOT NULL, |
| 74 |
titreattribut varchar(20) NOT NULL, |
| 75 |
titretaille int8 NOT NULL, |
| 76 |
titrebordure varchar(20) NOT NULL, |
| 77 |
titrealign varchar(20) NOT NULL, |
| 78 |
corps text NOT NULL, |
| 79 |
corpsleft int8 NOT NULL, |
| 80 |
corpstop int8 NOT NULL, |
| 81 |
corpslargeur int8 NOT NULL, |
| 82 |
corpshauteur int8 NOT NULL, |
| 83 |
corpsfont varchar(20) NOT NULL, |
| 84 |
corpsattribut varchar(20) NOT NULL, |
| 85 |
corpstaille int8 NOT NULL, |
| 86 |
corpsbordure varchar(20) NOT NULL, |
| 87 |
corpsalign varchar(20) NOT NULL, |
| 88 |
om_sql text NOT NULL, |
| 89 |
sousetat text NOT NULL, |
| 90 |
se_font varchar(20) NOT NULL, |
| 91 |
se_margeleft int8 NOT NULL, |
| 92 |
se_margetop int8 NOT NULL, |
| 93 |
se_margeright int8 NOT NULL, |
| 94 |
se_couleurtexte varchar(11) NOT NULL, |
| 95 |
PRIMARY KEY (om_etat) |
| 96 |
); |
| 97 |
|
| 98 |
CREATE TABLE om_sousetat ( |
| 99 |
om_sousetat int8 NOT NULL, |
| 100 |
om_collectivite int8 NOT NULL, |
| 101 |
id varchar(50) NOT NULL, |
| 102 |
libelle varchar(50) NOT NULL, |
| 103 |
actif VARCHAR( 3 ) NOT NULL, |
| 104 |
titre text NOT NULL, |
| 105 |
titrehauteur int8 NOT NULL, |
| 106 |
titrefont varchar(20) NOT NULL, |
| 107 |
titreattribut varchar(20) NOT NULL, |
| 108 |
titretaille int8 NOT NULL, |
| 109 |
titrebordure varchar(20) NOT NULL, |
| 110 |
titrealign varchar(20) NOT NULL, |
| 111 |
titrefond varchar(20) NOT NULL, |
| 112 |
titrefondcouleur varchar(11) NOT NULL, |
| 113 |
titretextecouleur varchar(11) NOT NULL, |
| 114 |
intervalle_debut int8 NOT NULL, |
| 115 |
intervalle_fin int8 NOT NULL, |
| 116 |
entete_flag varchar(20) NOT NULL, |
| 117 |
entete_fond varchar(20) NOT NULL, |
| 118 |
entete_orientation text NOT NULL, |
| 119 |
entete_hauteur int8 NOT NULL, |
| 120 |
entetecolone_bordure varchar(200) NOT NULL, |
| 121 |
entetecolone_align varchar(100) NOT NULL, |
| 122 |
entete_fondcouleur varchar(11) NOT NULL, |
| 123 |
entete_textecouleur varchar(11) NOT NULL, |
| 124 |
tableau_largeur int8 NOT NULL, |
| 125 |
tableau_bordure varchar(20) NOT NULL, |
| 126 |
tableau_fontaille int8 NOT NULL, |
| 127 |
bordure_couleur varchar(11) NOT NULL, |
| 128 |
se_fond1 varchar(11) NOT NULL, |
| 129 |
se_fond2 varchar(11) NOT NULL, |
| 130 |
cellule_fond varchar(20) NOT NULL, |
| 131 |
cellule_hauteur int8 NOT NULL, |
| 132 |
cellule_largeur varchar(200) NOT NULL, |
| 133 |
cellule_bordure_un varchar(200) NOT NULL, |
| 134 |
cellule_bordure varchar(200) NOT NULL, |
| 135 |
cellule_align varchar(100) NOT NULL, |
| 136 |
cellule_fond_total varchar(20) NOT NULL, |
| 137 |
cellule_fontaille_total int8 NOT NULL, |
| 138 |
cellule_hauteur_total int8 NOT NULL, |
| 139 |
cellule_fondcouleur_total varchar(11) NOT NULL, |
| 140 |
cellule_bordure_total varchar(200) NOT NULL, |
| 141 |
cellule_align_total varchar(100) NOT NULL, |
| 142 |
cellule_fond_moyenne varchar(20) NOT NULL, |
| 143 |
cellule_fontaille_moyenne int8 NOT NULL, |
| 144 |
cellule_hauteur_moyenne int8 NOT NULL, |
| 145 |
cellule_fondcouleur_moyenne varchar(11) NOT NULL, |
| 146 |
cellule_bordure_moyenne varchar(200) NOT NULL, |
| 147 |
cellule_align_moyenne varchar(100) NOT NULL, |
| 148 |
cellule_fond_nbr varchar(20) NOT NULL, |
| 149 |
cellule_fontaille_nbr int8 NOT NULL, |
| 150 |
cellule_hauteur_nbr int8 NOT NULL, |
| 151 |
cellule_fondcouleur_nbr varchar(11) NOT NULL, |
| 152 |
cellule_bordure_nbr varchar(200) NOT NULL, |
| 153 |
cellule_align_nbr varchar(100) NOT NULL, |
| 154 |
cellule_numerique varchar(200) NOT NULL, |
| 155 |
cellule_total varchar(100) NOT NULL, |
| 156 |
cellule_moyenne varchar(100) NOT NULL, |
| 157 |
cellule_compteur varchar(100) NOT NULL, |
| 158 |
om_sql text NOT NULL, |
| 159 |
PRIMARY KEY (om_sousetat) |
| 160 |
); |
| 161 |
|
| 162 |
CREATE TABLE om_lettretype ( |
| 163 |
om_lettretype int8 NOT NULL, |
| 164 |
om_collectivite int8 NOT NULL, |
| 165 |
id varchar(50) NOT NULL, |
| 166 |
libelle varchar(50) NOT NULL, |
| 167 |
actif varchar(3) NOT NULL, |
| 168 |
orientation varchar(2) NOT NULL, |
| 169 |
format varchar(5) NOT NULL, |
| 170 |
logo varchar(30) NOT NULL, |
| 171 |
logoleft int8 NOT NULL, |
| 172 |
logotop int8 NOT NULL, |
| 173 |
titre text NOT NULL, |
| 174 |
titreleft int8 NOT NULL, |
| 175 |
titretop int8 NOT NULL, |
| 176 |
titrelargeur int8 NOT NULL, |
| 177 |
titrehauteur int8 NOT NULL, |
| 178 |
titrefont varchar(20) NOT NULL, |
| 179 |
titreattribut varchar(20) NOT NULL, |
| 180 |
titretaille int8 NOT NULL, |
| 181 |
titrebordure varchar(20) NOT NULL, |
| 182 |
titrealign varchar(20) NOT NULL, |
| 183 |
corps text NOT NULL, |
| 184 |
corpsleft int8 NOT NULL, |
| 185 |
corpstop int8 NOT NULL, |
| 186 |
corpslargeur int8 NOT NULL, |
| 187 |
corpshauteur int8 NOT NULL, |
| 188 |
corpsfont varchar(20) NOT NULL, |
| 189 |
corpsattribut varchar(20) NOT NULL, |
| 190 |
corpstaille int8 NOT NULL, |
| 191 |
corpsbordure varchar(20) NOT NULL, |
| 192 |
corpsalign varchar(20) NOT NULL, |
| 193 |
om_sql text NOT NULL, |
| 194 |
PRIMARY KEY (om_lettretype) |
| 195 |
); |
| 196 |
|
| 197 |
-- tableau de bord |
| 198 |
|
| 199 |
CREATE TABLE om_widget ( |
| 200 |
om_widget integer NOT NULL, |
| 201 |
om_collectivite integer NOT NULL, |
| 202 |
libelle varchar(40) NOT NULL, |
| 203 |
lien varchar(80) NOT NULL, |
| 204 |
texte text NOT NULL, |
| 205 |
om_profil varchar(2), |
| 206 |
PRIMARY KEY (om_widget) |
| 207 |
) ; |
| 208 |
|
| 209 |
CREATE TABLE om_tdb ( |
| 210 |
om_tdb integer NOT NULL, |
| 211 |
login varchar(40) NOT NULL, |
| 212 |
bloc varchar(10) NOT NULL, |
| 213 |
position integer, |
| 214 |
om_widget integer NOT NULL, |
| 215 |
PRIMARY KEY (om_tdb) |
| 216 |
) ; |
| 217 |
|
| 218 |
CREATE TABLE om_sig_map |
| 219 |
( |
| 220 |
om_sig_map integer NOT NULL, |
| 221 |
om_collectivite integer NOT NULL, |
| 222 |
id character varying(50) NOT NULL, |
| 223 |
libelle character varying(50) NOT NULL, |
| 224 |
actif character varying(3), |
| 225 |
zoom character varying(3) NOT NULL, |
| 226 |
fond_osm character varying(3) NOT NULL, |
| 227 |
fond_bing character varying(3) NOT NULL, |
| 228 |
fond_sat character varying(3) NOT NULL, |
| 229 |
layer_info character varying(3) NOT NULL, |
| 230 |
etendue character varying(60) NOT NULL, |
| 231 |
projection_externe character varying(60) NOT NULL, |
| 232 |
url text NOT NULL, |
| 233 |
om_sql text NOT NULL, |
| 234 |
maj character varying(3) NOT NULL, |
| 235 |
table_update character varying(30) NOT NULL, |
| 236 |
champ character varying(30) NOT NULL, |
| 237 |
retour character varying(50) NOT NULL, |
| 238 |
type_geometrie character varying(30), |
| 239 |
lib_geometrie character varying(50), |
| 240 |
PRIMARY KEY (om_sig_map) |
| 241 |
); |
| 242 |
|
| 243 |
CREATE TABLE om_sig_wms |
| 244 |
( |
| 245 |
om_sig_wms integer NOT NULL, |
| 246 |
libelle character varying(50) NOT NULL, |
| 247 |
om_collectivite integer NOT NULL, |
| 248 |
id character varying(50) NOT NULL, |
| 249 |
chemin character varying(255) NOT NULL, |
| 250 |
couches character varying(255) NOT NULL, |
| 251 |
PRIMARY KEY (om_sig_wms) |
| 252 |
); |
| 253 |
|
| 254 |
CREATE TABLE om_sig_map_wms |
| 255 |
( |
| 256 |
om_sig_map_wms integer NOT NULL, |
| 257 |
om_sig_wms integer NOT NULL, |
| 258 |
om_sig_map integer NOT NULL, |
| 259 |
ol_map character varying(50) NOT NULL, |
| 260 |
ordre integer NOT NULL, |
| 261 |
visibility character varying(3) NOT NULL, |
| 262 |
panier character varying(3), |
| 263 |
pa_nom character varying(50), |
| 264 |
pa_layer character varying(50), |
| 265 |
pa_attribut character varying(50), |
| 266 |
pa_encaps character varying(3), |
| 267 |
pa_sql text, |
| 268 |
pa_type_geometrie character varying(30), |
| 269 |
PRIMARY KEY (om_sig_map_wms) |
| 270 |
); |
| 271 |
|
| 272 |
CREATE TABLE om_sig_map_comp |
| 273 |
( |
| 274 |
om_sig_map_comp integer NOT NULL, |
| 275 |
om_sig_map integer NOT NULL, |
| 276 |
libelle character varying(50) NOT NULL, |
| 277 |
ordre integer NOT NULL, |
| 278 |
actif character varying(3), |
| 279 |
comp_maj character varying(3), |
| 280 |
type_geometrie character varying(30), |
| 281 |
comp_table_update character varying(30), |
| 282 |
comp_champ character varying(30), |
| 283 |
PRIMARY KEY (om_sig_map_comp) |
| 284 |
); |
| 285 |
|
| 286 |
-- foreign key |
| 287 |
|
| 288 |
ALTER TABLE ONLY om_utilisateur |
| 289 |
ADD CONSTRAINT om_utilisateur_om_profil_fkey FOREIGN KEY (om_profil) REFERENCES om_profil(om_profil); |
| 290 |
ALTER TABLE ONLY om_utilisateur |
| 291 |
ADD CONSTRAINT om_utilisateur_om_collectivite_fkey FOREIGN KEY (om_collectivite) REFERENCES om_collectivite(om_collectivite); |
| 292 |
ALTER TABLE ONLY om_droit |
| 293 |
ADD CONSTRAINT om_droit_om_profil_fkey FOREIGN KEY (om_profil) REFERENCES om_profil(om_profil); |
| 294 |
ALTER TABLE ONLY om_parametre |
| 295 |
ADD CONSTRAINT om_parametre_om_collectivite_fkey FOREIGN KEY (om_collectivite) REFERENCES om_collectivite(om_collectivite); |
| 296 |
ALTER TABLE ONLY om_etat |
| 297 |
ADD CONSTRAINT om_etat_om_collectivite_fkey FOREIGN KEY (om_collectivite) REFERENCES om_collectivite(om_collectivite); |
| 298 |
ALTER TABLE ONLY om_sousetat |
| 299 |
ADD CONSTRAINT om_sousetat_om_collectivite_fkey FOREIGN KEY (om_collectivite) REFERENCES om_collectivite(om_collectivite); |
| 300 |
ALTER TABLE ONLY om_lettretype |
| 301 |
ADD CONSTRAINT om_lettretype_om_collectivite_fkey FOREIGN KEY (om_collectivite) REFERENCES om_collectivite(om_collectivite); |
| 302 |
ALTER TABLE ONLY om_widget |
| 303 |
ADD CONSTRAINT om_widget_om_collectivite_fkey FOREIGN KEY (om_collectivite) REFERENCES om_collectivite(om_collectivite); |
| 304 |
ALTER TABLE ONLY om_tdb |
| 305 |
ADD CONSTRAINT om_tdb_om_widget_fkey FOREIGN KEY (om_widget) REFERENCES om_widget(om_widget); |
| 306 |
ALTER TABLE ONLY om_sig_map |
| 307 |
ADD CONSTRAINT om_sig_map_om_collectivite_fkey FOREIGN KEY (om_collectivite) REFERENCES om_collectivite(om_collectivite); |
| 308 |
ALTER TABLE ONLY om_sig_wms |
| 309 |
ADD CONSTRAINT om_sig_wms_om_collectivite_fkey FOREIGN KEY (om_collectivite) REFERENCES om_collectivite(om_collectivite); |
| 310 |
ALTER TABLE ONLY om_sig_map_wms |
| 311 |
ADD CONSTRAINT om_sig_map_wms_om_sig_map_fkey FOREIGN KEY (om_sig_map) REFERENCES om_sig_map(om_sig_map); |
| 312 |
ALTER TABLE ONLY om_sig_map_wms |
| 313 |
ADD CONSTRAINT om_sig_map_wms_om_sig_wms_fkey FOREIGN KEY (om_sig_wms) REFERENCES om_sig_wms(om_sig_wms); |
| 314 |
ALTER TABLE ONLY om_sig_map_comp |
| 315 |
ADD CONSTRAINT om_sig_map_comp_om_sig_map_fkey FOREIGN KEY (om_sig_map) REFERENCES om_sig_map(om_sig_map); |
| 316 |
|
| 317 |
|
| 318 |
-- sequences et initialisation -- |
| 319 |
|
| 320 |
CREATE SEQUENCE om_collectivite_seq |
| 321 |
INCREMENT 1 |
| 322 |
MINVALUE 1 |
| 323 |
MAXVALUE 9223372036854775807 |
| 324 |
START 1 |
| 325 |
CACHE 1; |
| 326 |
|
| 327 |
CREATE SEQUENCE om_parametre_seq |
| 328 |
INCREMENT 1 |
| 329 |
MINVALUE 1 |
| 330 |
MAXVALUE 9223372036854775807 |
| 331 |
START 1 |
| 332 |
CACHE 1; |
| 333 |
|
| 334 |
CREATE SEQUENCE om_utilisateur_seq |
| 335 |
INCREMENT 1 |
| 336 |
MINVALUE 1 |
| 337 |
MAXVALUE 9223372036854775807 |
| 338 |
START 1 |
| 339 |
CACHE 1; |
| 340 |
|
| 341 |
CREATE SEQUENCE om_etat_seq |
| 342 |
INCREMENT 1 |
| 343 |
MINVALUE 1 |
| 344 |
MAXVALUE 9223372036854775807 |
| 345 |
START 1 |
| 346 |
CACHE 1; |
| 347 |
|
| 348 |
CREATE SEQUENCE om_sousetat_seq |
| 349 |
INCREMENT 1 |
| 350 |
MINVALUE 1 |
| 351 |
MAXVALUE 9223372036854775807 |
| 352 |
START 1 |
| 353 |
CACHE 1; |
| 354 |
|
| 355 |
CREATE SEQUENCE om_lettretype_seq |
| 356 |
INCREMENT 1 |
| 357 |
MINVALUE 1 |
| 358 |
MAXVALUE 9223372036854775807 |
| 359 |
START 1 |
| 360 |
CACHE 1; |
| 361 |
|
| 362 |
CREATE SEQUENCE om_widget_seq |
| 363 |
INCREMENT 1 |
| 364 |
MINVALUE 1 |
| 365 |
MAXVALUE 9223372036854775807 |
| 366 |
START 1 |
| 367 |
CACHE 1; |
| 368 |
|
| 369 |
CREATE SEQUENCE om_tdb_seq |
| 370 |
INCREMENT 1 |
| 371 |
MINVALUE 1 |
| 372 |
MAXVALUE 9223372036854775807 |
| 373 |
START 1 |
| 374 |
CACHE 1; |
| 375 |
|
| 376 |
CREATE SEQUENCE om_sig_wms_seq |
| 377 |
INCREMENT 1 |
| 378 |
MINVALUE 1 |
| 379 |
MAXVALUE 9223372036854775807 |
| 380 |
START 1 |
| 381 |
CACHE 1; |
| 382 |
|
| 383 |
|
| 384 |
CREATE SEQUENCE om_sig_map_wms_seq |
| 385 |
INCREMENT 1 |
| 386 |
MINVALUE 1 |
| 387 |
MAXVALUE 9223372036854775807 |
| 388 |
START 1 |
| 389 |
CACHE 1; |
| 390 |
|
| 391 |
CREATE SEQUENCE om_sig_map_comp_seq |
| 392 |
INCREMENT 1 |
| 393 |
MINVALUE 1 |
| 394 |
MAXVALUE 9223372036854775807 |
| 395 |
START 1 |
| 396 |
CACHE 1; |
| 397 |
|
| 398 |
CREATE SEQUENCE om_sig_map_seq |
| 399 |
INCREMENT 1 |
| 400 |
MINVALUE 1 |
| 401 |
MAXVALUE 9223372036854775807 |
| 402 |
START 1 |
| 403 |
CACHE 1; |
| 404 |
|
| 405 |
-- data de base |
| 406 |
|
| 407 |
-- coll |
| 408 |
INSERT INTO om_collectivite (om_collectivite, libelle, niveau) VALUES |
| 409 |
(1, 'ARLES', '2'); |
| 410 |
INSERT INTO om_parametre (om_parametre, libelle, valeur, om_collectivite) VALUES |
| 411 |
(nextval('om_parametre_seq'), 'maire', 'O PENMAIRIE', 1), |
| 412 |
(nextval('om_parametre_seq'), 'ville', 'Libreville', 1); |
| 413 |
|
| 414 |
-- droit |
| 415 |
|
| 416 |
INSERT INTO om_profil VALUES (99, 'NON UTILISE'); |
| 417 |
INSERT INTO om_profil VALUES (5, 'ADMINISTRATEUR'); |
| 418 |
INSERT INTO om_profil VALUES (4, 'SUPER UTILISATEUR'); |
| 419 |
INSERT INTO om_profil VALUES (3, 'UTILISATEUR'); |
| 420 |
INSERT INTO om_profil VALUES (2, 'UTILISATEUR LIMITE'); |
| 421 |
INSERT INTO om_profil VALUES (1, 'CONSULTATION'); |
| 422 |
|
| 423 |
INSERT INTO om_droit VALUES ('om_utilisateur', 5); |
| 424 |
INSERT INTO om_droit VALUES ('om_droit', 5); |
| 425 |
INSERT INTO om_droit VALUES ('om_profil', 5); |
| 426 |
INSERT INTO om_droit VALUES ('om_collectivite', 5); |
| 427 |
INSERT INTO om_droit VALUES ('om_parametre', 4); |
| 428 |
INSERT INTO om_droit VALUES ('om_etat', 4); |
| 429 |
INSERT INTO om_droit VALUES ('om_sousetat', 4); |
| 430 |
INSERT INTO om_droit VALUES ('om_lettretype', 4); |
| 431 |
INSERT INTO om_droit VALUES ('om_sig_point', 4); |
| 432 |
INSERT INTO om_droit VALUES ('om_widget', 4); |
| 433 |
INSERT INTO om_droit VALUES ('gen', 5); |
| 434 |
INSERT INTO om_droit VALUES ('password', 4); |
| 435 |
INSERT INTO om_droit VALUES ('directory', 99); |
| 436 |
|
| 437 |
INSERT INTO om_utilisateur (om_utilisateur, nom, Login, Pwd, om_profil, email, om_collectivite,om_type) VALUES |
| 438 |
(nextval('om_utilisateur_seq'), 'ADMINISTRATEUR', 'admin', '21232f297a57a5a743894a0e4a801fc3', '5', '[email protected]', 1,''), |
| 439 |
(nextval('om_utilisateur_seq'), 'demo', 'demo', 'fe01ce2a7fbac8fafaed7c982a04e229', '5', '[email protected]', 1,''), |
| 440 |
(nextval('om_utilisateur_seq'), 'util', 'util', '05c7e24700502a079cdd88012b5a76d3', '5', '', 1,''); |
| 441 |
|
| 442 |
-- etat |
| 443 |
|
| 444 |
INSERT INTO om_etat ("om_etat", "om_collectivite", "id", "libelle", "actif", "orientation", "format", "footerfont", "footerattribut", "footertaille", "logo", "logoleft", "logotop", "titre", "titreleft", "titretop", "titrelargeur", "titrehauteur", "titrefont", "titreattribut", "titretaille", "titrebordure", "titrealign", "corps", "corpsleft", "corpstop", "corpslargeur", "corpshauteur", "corpsfont", "corpsattribut", "corpstaille", "corpsbordure", "corpsalign", "om_sql", "sousetat", "se_font", "se_margeleft", "se_margetop", "se_margeright", "se_couleurtexte") |
| 445 |
VALUES(nextval('om_etat_seq'), 1, 'om_collectivite', 'om_collectivite gen le 12/11/2010', 'Oui', 'P', 'A4', 'helvetica', 'I', 8, 'logopdf.png', 58, 7, 'le &aujourdhui', 41, 36, 130, 10, 'helvetica', 'B', 15, '0', 'C', '[om_collectivite]\r\n[libelle]\r\n[niveau]', 7, 57, 195, 5, 'helvetica', '', 10, '0', 'J', 'select om_collectivite.om_collectivite as om_collectivite,om_collectivite.libelle as libelle,om_collectivite.niveau as niveau from &DB_PREFIXEom_collectivite where om_collectivite.om_collectivite=''&idx''', 'om_parametre.om_collectivite', 'helvetica', 8, 5, 5, '0-0-0'); |
| 446 |
|
| 447 |
INSERT INTO om_sousetat VALUES |
| 448 |
(nextval('om_sousetat_seq'), 1, 'om_parametre.om_collectivite', 'gen le 12/11/2010', 'Oui', 'liste om_parametre', 10, 'helvetica', 'B', 10, '0', 'L', '0', '255-255-255', '0-0-0', 0, 5, '1', '1', '0|0|0', 7, 'TLB|TLB|LTBR', 'C|C|C', '255-255-255', '0-0-0', 195, '1', 10, '0-0-0', '243-246-246', '255-255-255', '1', 7, '65|65|65', 'TLB|TLB|LTBR', 'TLB|TLB|LTBR', 'C|C|C', '1', 10, 15, '255-255-255', 'TLB|TLB|LTBR', 'C|C|C', '1', 10, 5, '212-219-220', 'TLB|TLB|LTBR', 'C|C|C', '1', 10, 7, '255-255-255', 'TLB|TLB|LTBR', 'C|C|C', '999|999|999', '0|0|0', '0|0|0', '0|0|0', 'select om_parametre.om_parametre as om_parametre,om_parametre.libelle as libelle,om_parametre.valeur as valeur from &DB_PREFIXEom_parametre where om_parametre.om_collectivite=''&idx'''); |
| 449 |
|
| 450 |
INSERT INTO om_lettretype (om_lettretype, om_collectivite, id, libelle,actif , orientation, format, logo, logoleft, logotop, titre, titreleft, titretop, titrelargeur, titrehauteur, titrefont, titreattribut, titretaille, titrebordure, titrealign, corps, corpsleft, corpstop, corpslargeur, corpshauteur, corpsfont, corpsattribut, corpstaille, corpsbordure, corpsalign, om_sql) VALUES |
| 451 |
(nextval('om_lettretype_seq'), 1, 'om_utilisateur', 'lettre aux utilisateur','Oui', 'P', 'A4', 'logo.png', 10, 10, 'le &datecourrier\r\n\r\n\r\n[nom]\r\n[collectivite]', 130, 16, 0, 10, 'arial', '', 14, '0', 'L', 'Nous avons le plaisir de vous envoyer votre login et votre mot de passe\r\n\r\nvotre login [login]\r\nvotre mot de passe ******\r\n\r\nVous souhaitant bonne reception.\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n Votre administrateur', 40, 106, 110, 5, 'times', '', 10, '0', 'J', 'select nom,login,om_collectivite.libelle as collectivite\r\nfrom &DB_PREFIXEom_utilisateur inner join &DB_PREFIXEom_collectivite\r\non om_collectivite.om_collectivite=om_utilisateur.om_collectivite\r\nwhere om_utilisateur= &idx'); |
Parent Directory
| 
Revision Log