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

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

Parent Directory | Revision Log | View Patch Patch

-revision 16 by fraynaud,
Fri Jul  1 09:40:58 2011 UTC
+revision 20 by fraynaud,
Mon Jul 18 15:27:17 2011 UTC
 Line 1
  -- Base de donnees: "openmairie"
- -- CREATE DATABASE openmairie
- --  WITH OWNER = postgres
- --       ENCODING = 'SQL_ASCII';
  -- tables openmairie --
+ -- rajout de om_tdb, om_widget et om_sig_point
+ -- SPECIFIC : om_utilisateur instructeur
  -- coll
-Line 194 
 CREATE TABLE om_lettretype (
+Line 193 
 CREATE TABLE om_lettretype (
    PRIMARY KEY  (om_lettretype)
  );
+ -- sig
+ CREATE TABLE om_sig_point
+ (
+   om_sig_point integer NOT NULL,
+   om_collectivite integer NOT NULL,
+   id varchar(50) NOT NULL,
+   libelle varchar(50) NOT NULL,
+   actif varchar(3),
+   zoom varchar(3) NOT NULL,
+   fond_osm varchar(3) NOT NULL,
+   fond_bing varchar(3) NOT NULL,
+   fond_sat varchar(3) NOT NULL,
+   layer_info varchar(3) NOT NULL,
+   etendue varchar(60) NOT NULL,
+   projection_externe varchar(60) NOT NULL,
+   url text NOT NULL,
+   om_sql text NOT NULL,
+   maj varchar(3) NOT NULL,
+   table_update varchar(30) NOT NULL,
+   champ varchar(30) NOT NULL,
+   retour varchar(50) NOT NULL,
+   PRIMARY KEY  (om_sig_point)
+ );
+ -- tableau de bord
+ CREATE TABLE om_widget (
+   om_widget integer NOT NULL,
+   om_collectivite integer NOT NULL,
+   libelle varchar(40) NOT NULL,
+   lien varchar(80) NOT NULL,
+   texte text NOT NULL,
+   om_profil varchar(2),
+   PRIMARY KEY  (om_widget)
+ ) ;
+ CREATE TABLE om_tdb (
+   om_tdb integer NOT NULL,
+   login varchar(40) NOT NULL,
+   bloc varchar(10) NOT NULL,
+   position integer,
+   om_widget integer NOT NULL,
+   PRIMARY KEY  (om_tdb)
+ ) ;
  -- foreign key
  ALTER TABLE ONLY om_utilisateur
-Line 210 
 ALTER TABLE ONLY om_sousetat
+Line 255 
 ALTER TABLE ONLY om_sousetat
      ADD CONSTRAINT om_sousetat_om_collectivite_fkey FOREIGN KEY (om_collectivite) REFERENCES om_collectivite(om_collectivite);
  ALTER TABLE ONLY om_lettretype
      ADD CONSTRAINT om_lettretype_om_collectivite_fkey FOREIGN KEY (om_collectivite) REFERENCES om_collectivite(om_collectivite);
+ ALTER TABLE ONLY om_widget
+     ADD CONSTRAINT om_widget_om_collectivite_fkey FOREIGN KEY (om_collectivite) REFERENCES om_collectivite(om_collectivite);
+ ALTER TABLE ONLY om_sig_point
+     ADD CONSTRAINT om_sig_point_om_collectivite_fkey FOREIGN KEY (om_collectivite) REFERENCES om_collectivite(om_collectivite);
+ ALTER TABLE ONLY om_tdb
+     ADD CONSTRAINT om_tdb_om_widget_fkey FOREIGN KEY (om_widget) REFERENCES om_widget(om_widget);
  -- sequences
-Line 255 
 CREATE SEQUENCE om_lettretype_seq
+Line 306 
 CREATE SEQUENCE om_lettretype_seq
    START 2
    CACHE 1;
+ CREATE SEQUENCE om_sig_point_seq
+   INCREMENT 1
+   MINVALUE 1
+   MAXVALUE 9223372036854775807
+   START 3
+   CACHE 1;
+ CREATE SEQUENCE om_widget_seq
+   INCREMENT 1
+   MINVALUE 1
+   MAXVALUE 9223372036854775807
+   START 1
+   CACHE 1;
+ CREATE SEQUENCE om_tdb_seq
+   INCREMENT 1
+   MINVALUE 1
+   MAXVALUE 9223372036854775807
+   START 3
+   CACHE 1;
  -- data --
  -- coll

 Legend:



Removed from v.16
 


changed lines


 
Added in v.20
 Legend:



Removed from v.16
 


changed lines


 
Added in v.20
-Removed from v.16
+Added in v.20

[email protected]	ViewVC Help
Powered by ViewVC 1.1.26