[Radiant] Any workaround for sqlite3 login problem that works?

Robert Lorimor robert.lorimor at gmail.com
Mon Jul 16 00:11:51 CDT 2007


Aitor Garay-Romero wrote:
> Could you please send us the output of the sqlite3 command ".dump users"
> on the failing data base?  Just to check the schema.
> 
>      /AITOR

Ok. Here it is:

BEGIN TRANSACTION;
CREATE TABLE users ("id" INTEGER PRIMARY KEY NOT NULL, "name" 
varchar(100) DEFAULT '''''''''''''''NULL''''''''''''''', "email" 
varchar(255) DEFAULT '''''''''''''''NULL''''''''''''''', "login" 
varchar(40) DEFAULT 
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' NOT NULL, 
"password" varchar(40) DEFAULT '''''''''''''''NULL''''''''''''''', 
"created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, 
"created_by" integer DEFAULT 0, "updated_by" integer DEFAULT 0, "admin" 
boolean DEFAULT 'f' NOT NULL, "developer" boolean DEFAULT 'f' NOT NULL, 
"notes" text, "lock_version" integer DEFAULT 0);
CREATE UNIQUE INDEX "login" ON users ("login");
COMMIT;

-- 
Posted via http://www.ruby-forum.com/.



More information about the Radiant mailing list