CREATE TABLE users
(
  mail_address character varying(100),
  nickname character varying(100),
  last_name character varying(100),
  first_name character varying(100),
  pass character varying(40),
  phone character varying(14),
  id serial NOT NULL,
  cookie_code character varying(40),
  date_register date DEFAULT ('now'::text)::date,
  siren_number character(9),
  CONSTRAINT pk_user PRIMARY KEY (id )
)
WITH (
  OIDS=FALSE
);
ALTER TABLE users
  OWNER TO admin;

-- Index: pki_user

-- DROP INDEX pki_user;

CREATE INDEX pki_user
  ON users
  USING btree
  (id );

CREATE TABLE projects
(
  id serial NOT NULL,
  title character varying(100),
  description text,
  id_tarif integer,
  date_rec date DEFAULT ('now'::text)::date,
  id_user integer NOT NULL,
  CONSTRAINT pk_project PRIMARY KEY (id ),
  CONSTRAINT fk_tarif FOREIGN KEY (id_tarif)
      REFERENCES tarifs (id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE CASCADE,
  CONSTRAINT fk_user FOREIGN KEY (id_user)
      REFERENCES users (id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE CASCADE
)
WITH (
  OIDS=FALSE
);
ALTER TABLE projects
  OWNER TO admin;

-- Index: fki_tarif

-- DROP INDEX fki_tarif;

CREATE INDEX fki_tarif
  ON projects
  USING btree
  (id_tarif );

-- Index: fki_user

-- DROP INDEX fki_user;

CREATE INDEX fki_user
  ON projects
  USING btree
  (id_user );