creiht

BEGIN;

ALTER TABLE auth_users RENAME TO auth_users_old;

CREATE TABLE auth_users (
    id integer NOT NULL PRIMARY KEY,
    username varchar(30) NOT NULL UNIQUE,
    first_name varchar(30) NOT NULL,
    last_name varchar(30) NOT NULL,
    email varchar(75) NOT NULL,
    password varchar(128) NOT NULL,
    is_staff bool NOT NULL,
    is_active bool NOT NULL,
    is_superuser bool NOT NULL,
    last_login datetime NOT NULL,
    date_joined datetime NOT NULL
);

INSERT INTO auth_users (
	username,
	first_name,
	last_name,
	email,
	password,
	is_staff,
	is_active,
	is_superuser,
	last_login,
	date_joined
)
SELECT
	username,
	first_name,
	last_name,
	email,
	password_md5,
	is_staff,
	is_active,
	is_superuser,
	last_login,
	date_joined
FROM auth_users_old;

DROP TABLE auth_users_old;

COMMIT;