Skip to content
Extraits de code Groupes Projets
Sélectionner une révision Git
  • be81207853b3710b90530810bf5d8b5190552320
  • master par défaut protégée
  • test
  • tichadou2015-master-patch-52256
4 résultats

nardco.py

Blame
  • Bifurcation depuis Loris TICHADOU / nardco
    Le projet source a une visibilité limitée.
    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
    );