Skip to content
Extraits de code Groupes Projets
Sélectionner une révision Git
  • a8e424bfbc340db2894c620c81b02fe0ba2edac3
  • master par défaut protégée
2 résultats

base.sql

Blame
  • base.sql 1,05 Kio
    CREATE TABLE public.users
    (
      id SERIAL,
      pseudo character varying(255) NOT NULL,
      mdp text NOT NULL,
      adr_mail character varying(255) NOT NULL,
      su boolean DEFAULT false,
      CONSTRAINT users_pkey PRIMARY KEY (id)
    );
    
    CREATE TABLE public.toppics
    (
      id SERIAL,
      titre  character varying(255) NOT NULL,
      content text,
      date_creat date,
      users_id  SERIAL,
      CONSTRAINT toppics_pkey PRIMARY KEY (id),
      CONSTRAINT toppics_fkey FOREIGN KEY(users_id) REFERENCES users
    );
    
    CREATE TABLE public.comments
    (
      id SERIAL,
      content text NOT NULL,
      date date,
      toppics_id SERIAL,
      users_id SERIAL,
      CONSTRAINT comments_pkey PRIMARY KEY (id),
      CONSTRAINT comments_fkey FOREIGN KEY(toppics_id) REFERENCES toppics,
      CONSTRAINT comments_fkey2 FOREIGN KEY(users_id) REFERENCES users
    );
    
    CREATE TABLE public.keys
    (
      id SERIAL,
      name character varying(255) NOT NULL
    );
    
    CREATE TABLE public.keyToppics
    (
      keys_id SERIAL,
      toppics_id SERIAL,
      CONSTRAINT keyToppics_fk FOREIGN KEY(toppics_id) REFERENCES toppics,
      CONSTRAINT keyToppics_fk2 FOREIGN KEY(keys_id) REFERENCES users
    );