
diff -r 2f089a5d97da -r 9409e7ab3f9d db/db-schema.sql
--- a/db/db-schema.sql	Thu Apr 12 14:39:51 2012 +0200
+++ b/db/db-schema.sql	Thu Apr 12 17:07:35 2012 +0200
@@ -30,6 +30,18 @@
 create sequence "code_list_item_id_seq";
 -- indexes on code_list_item
 create index "code_list_item_code_list_idx" on "code_list_item" ("code_list");
+create table "user" (
+    "name" varchar(100) not null,
+    "id" bigint primary key not null,
+    "note" varchar(10240),
+    "login" varchar(40) not null,
+    "deleted" boolean not null,
+    "active" boolean not null,
+    "password" varchar(128) not null
+  );
+create sequence "user_id_seq";
+-- indexes on user
+create index "user_login_idx" on "user" ("login");
 create table "city" (
     "name" varchar(100) not null,
     "id" bigint primary key not null,
@@ -96,3 +108,5 @@
 alter table "company" add constraint "companyFK3" foreign key ("address_id") references "address"("id");
 alter table "company" add constraint "companyFK4" foreign key ("corresp_address_id") references "address"("id");
 alter table "bank_account" add constraint "bank_accountFK5" foreign key ("company_id") references "company"("id");
+-- column group indexes :
+create index "user_deleted_active_idx" on "user" ("deleted","active");




