Opened 15 years ago

Last modified 7 years ago

#20 closed task

Intégration du codier csp — at Version 4

Reported by: cedric Owned by: cedric
Priority: major Milestone:
Component: SIG-data Version: EDA2.0
Keywords: POSTGRES Cc:

Description (last modified by cedric)


Change History (5)

comment:1 Changed 15 years ago by cedric

  • Status changed from new to accepted

comment:2 Changed 15 years ago by cedric

creation de la base

comment:3 Changed 15 years ago by cedric

  • Description modified (diff)

comment:4 Changed 15 years ago by cedric

  • Description modified (diff)

script sql

create schema csp;
drop  table if exists csp.codier
create table csp.codier ("cd_id" integer,
			"cd_fc_id" integer,
			"cd_code" varchar(10),
			"cd_libc" varchar(10),
			"cd_libl" varchar(10),
			"cd_chaine1" integer,
			"cd_chaine2" varchar(10),
			"cd_num1" integer,
			"cd_num2" integer,
			"cd_date1" timestamp,
			"cd_date2" timestamp,
			"cd_dt_cre"timestamp,
			"cd_dt_maj" timestamp,
			"cd_qi_maj" varchar(20),
			CONSTRAINT c_pk_cd_id PRIMARY KEY (cd_id)
			);

Changed 15 years ago by cedric

CSP.codier au format utf8

Note: See TracTickets for help on using tickets.