longer passwords + comments field for users

[mir.git] / dbscripts / create_pg.sql

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index 6b3501e..d9ce6ab 100755 (executable)
--- a/dbscripts/create_pg.sql
+++ b/dbscripts/create_pg.sql
@@ -77,15 +77,14 @@ CREATE SEQUENCE "webdb_users_id_seq" start 1 increment 1 maxvalue 2147483647 min
 CREATE TABLE "webdb_users" (
        "id" integer DEFAULT nextval('webdb_users_id_seq'::text) NOT NULL,
        "login" character varying(16) NOT NULL,
-       "password" character varying(16) NOT NULL,
+       "password" character varying(255) NOT NULL,
        "is_admin" boolean DEFAULT '0' NOT NULL,
+       "comment" text,
        Constraint "webdb_users_pkey" Primary Key ("id")
 );
 
 CREATE  INDEX "idx_webdb_user_log_pas_is_admin" on "webdb_users" using btree ( "login" "varchar_ops", "password" "varchar_ops", "is_admin" "bool_ops" );
 
-CREATE  INDEX "idx_webdb_user_log_pas" on "webdb_users" using btree ( "login" "varchar_ops", "password" "varchar_ops" );
-
 --
 -- article type
 --