All pastes #30813 Raw Edit

Anonymous

public text v1 · immutable
#30813 ·published 2005-11-24 01:21 UTC
rendered paste body
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 (
	id,
	username,
	first_name,
	last_name,
	email,
	password,
	is_staff,
	is_active,
	is_superuser,
	last_login,
	date_joined
)
SELECT * FROM auth_users_old;

DROP TABLE auth_users_old;

COMMIT;