/[openfoncier]/trunk/data/pgsql/init.sql
ViewVC logotype

Diff of /trunk/data/pgsql/init.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 206 by fraynaud, Mon Oct 17 13:35:08 2011 UTC revision 223 by fmichon, Wed Oct 19 08:23:29 2011 UTC
# Line 6  Line 6 
6    
7  -- coll  -- coll
8    
9    -- version base de donnees
10    
11    CREATE TABLE om_version (
12      om_version character varying(100) NOT NULL
13    ) ;
14    INSERT INTO om_version (om_version) VALUES ('3.0.0-b2');
15    
16    
17  CREATE TABLE om_collectivite (  CREATE TABLE om_collectivite (
18    om_collectivite int8 NOT NULL,    om_collectivite int8 NOT NULL,
19    libelle varchar(100) NOT NULL,    libelle varchar(100) NOT NULL,
# Line 343  INSERT INTO om_parametre (om_parametre, Line 351  INSERT INTO om_parametre (om_parametre,
351  (2, 'ville', 'Ville d''ARLES', 1);  (2, 'ville', 'Ville d''ARLES', 1);
352    
353  -- droit  -- droit
354    
355    INSERT INTO om_profil VALUES (99, 'NON UTILISE');
356  INSERT INTO om_profil VALUES (5, 'ADMINISTRATEUR');  INSERT INTO om_profil VALUES (5, 'ADMINISTRATEUR');
357  INSERT INTO om_profil VALUES (4, 'SUPER UTILISATEUR');  INSERT INTO om_profil VALUES (4, 'SUPER UTILISATEUR');
358  INSERT INTO om_profil VALUES (3, 'UTILISATEUR');  INSERT INTO om_profil VALUES (3, 'UTILISATEUR');
# Line 359  INSERT INTO om_droit VALUES ('om_souseta Line 369  INSERT INTO om_droit VALUES ('om_souseta
369  INSERT INTO om_droit VALUES ('om_lettretype', 4);  INSERT INTO om_droit VALUES ('om_lettretype', 4);
370  INSERT INTO om_droit VALUES ('gen', 5);  INSERT INTO om_droit VALUES ('gen', 5);
371  INSERT INTO om_droit VALUES ('password', 4);  INSERT INTO om_droit VALUES ('password', 4);
372    INSERT INTO om_droit VALUES ('directory', 99);
373    
374  INSERT INTO om_utilisateur (om_utilisateur, nom, Login, Pwd, om_profil, email, om_collectivite,om_type) VALUES  INSERT INTO om_utilisateur (om_utilisateur, nom, Login, Pwd, om_profil, email, om_collectivite,om_type) VALUES
375  (1, 'ADMINISTRATEUR', 'admin', '21232f297a57a5a743894a0e4a801fc3', '5', '[email protected]', 1,''),  (1, 'ADMINISTRATEUR', 'admin', '21232f297a57a5a743894a0e4a801fc3', '5', '[email protected]', 1,''),
Legend:
Removed from v.206  
changed lines
  Added in v.223
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26