Changes between Version 39 and Version 40 of BackwardsIncompatibleChanges


Ignore:
Timestamp:
11/23/2005 07:29:29 PM (10 years ago)
Author:
cthier@…
Comment:

Updated new password info with SQL to use with SQLite

Legend:

Unmodified
Added
Removed
Modified
  • BackwardsIncompatibleChanges

    v39 v40  
    315315Execute the following SQL to restore auth functionality:
    316316
    317  * PostgreSQL and SQLite (Note: I was unable to get the following to work w/ SQLite -- DavidAscher):
     317 * PostgreSQL:
    318318{{{
    319319BEGIN;
     
    331331COMMIT;
    332332}}}
     333
     334 * SQLite:
     335{{{
     336BEGIN;
     337ALTER TABLE auth_users RENAME TO auth_users_old;
     338CREATE TABLE auth_users (
     339    id integer NOT NULL PRIMARY KEY,
     340    username varchar(30) NOT NULL UNIQUE,
     341    first_name varchar(30) NOT NULL,
     342    last_name varchar(30) NOT NULL,
     343    email varchar(75) NOT NULL,
     344    password varchar(128) NOT NULL,
     345    is_staff bool NOT NULL,
     346    is_active bool NOT NULL,
     347    is_superuser bool NOT NULL,
     348    last_login datetime NOT NULL,
     349    date_joined datetime NOT NULL
     350);
     351INSERT INTO auth_users (
     352        id,
     353        username,
     354        first_name,
     355        last_name,
     356        email,
     357        password,
     358        is_staff,
     359        is_active,
     360        is_superuser,
     361        last_login,
     362        date_joined
     363)
     364SELECT * FROM auth_users_old;
     365DROP TABLE auth_users_old;
     366COMMIT;
     367}}}
Back to Top