Changes between Version 39 and Version 40 of BackwardsIncompatibleChanges

Timestamp:

Nov 23, 2005, 7:29:29 PM (20 years ago)

Author:

cthier@…

Comment:

Updated new password info with SQL to use with SQLite

BackwardsIncompatibleChanges

@@ -315 +315 @@
 Execute the following SQL to restore auth functionality:
 
- * PostgreSQL and SQLite (Note: I was unable to get the following to work w/ SQLite -- DavidAscher):
+ * PostgreSQL:
 {{{
 BEGIN;
@@ -331 +331 @@
 COMMIT;
 }}}
+
+ * SQLite:
+{{{
+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;
+}}}