[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