diff -r e2a2e2045c0e -r b65843860274 db/db-schema.sql --- a/db/db-schema.sql Fri Apr 20 08:26:22 2012 +0200 +++ b/db/db-schema.sql Fri Apr 20 08:26:22 2012 +0200 @@ -4,6 +4,7 @@ "l1" bigint not null, "i18n" boolean not null, "name" varchar(100) not null, + "updated_at" timestamp not null, "ol2" bigint, "s3" varchar(200) not null, "id" bigint primary key not null, @@ -20,10 +21,13 @@ "s1" varchar(200) not null, "note" varchar(10240), "os2" varchar(200), + "created_at" timestamp not null, + "created_by" bigint, "i2" integer not null, "oi3" integer, "l2" bigint not null, "ol3" bigint, + "updated_by" bigint, "os3" varchar(200), "deleted" boolean not null ); @@ -32,9 +36,13 @@ create index "code_list_item_code_list_idx" on "code_list_item" ("code_list"); create table "user" ( "name" varchar(100) not null, + "updated_at" timestamp not null, "id" bigint primary key not null, "note" varchar(10240), + "created_at" timestamp not null, + "created_by" bigint, "login" varchar(40) not null, + "updated_by" bigint, "deleted" boolean not null, "active" boolean not null, "password" varchar(128) not null @@ -44,9 +52,13 @@ create index "user_login_idx" on "user" ("login"); create table "city" ( "name" varchar(100) not null, + "updated_at" timestamp not null, "id" bigint primary key not null, "country_id" bigint not null, - "note" varchar(10240) + "note" varchar(10240), + "created_at" timestamp not null, + "created_by" bigint, + "updated_by" bigint ); create sequence "s_city_id"; create table "address" ( @@ -60,13 +72,18 @@ create table "country" ( "iso3" varchar(3) not null, "name" varchar(100) not null, + "updated_at" timestamp not null, "id" bigint primary key not null, "iso2" varchar(2) not null, - "note" varchar(10240) + "note" varchar(10240), + "created_at" timestamp not null, + "created_by" bigint, + "updated_by" bigint ); create sequence "s_country_id"; create table "contact" ( "name" varchar(100) not null, + "updated_at" timestamp not null, "id" bigint primary key not null, "work_mobile" varchar(40) not null, "private_mail" varchar(256), @@ -75,9 +92,12 @@ "first_name" varchar(80) not null, "fax" varchar(40), "note" varchar(10240), + "created_at" timestamp not null, + "created_by" bigint, "other_mail" varchar(256), "position" varchar(40), "other_mobile" varchar(40), + "updated_by" bigint, "private_mobile" varchar(40), "private_phone" varchar(40), "work_phone" varchar(40) @@ -85,11 +105,15 @@ create sequence "contact_id_seq"; create table "company" ( "name" varchar(100) not null, + "updated_at" timestamp not null, "id" bigint primary key not null, "partner" integer not null, "ico" varchar(40) not null, "note" varchar(10240), + "created_at" timestamp not null, + "created_by" bigint, "corresp_address_id" bigint, + "updated_by" bigint, "pin" integer not null, "address_id" bigint not null );