#734: "no such table: tg_user " error
---------------------------+------------------------------------------------
Reporter: Italo.Maia | Owner: anonymous
Type: defect | Status: new
Priority: normal | Milestone: 0.9a5
Component: Identity | Version: 0.9a4
Severity: blocker | Resolution:
Keywords: tg_user, user |
---------------------------+------------------------------------------------
Comment (by godoy):
I forgot posting the contents of the database. I used sqlite for the
test:
{{{
sqlite> .databases
seq name file
--- ---------------
----------------------------------------------------------
0 main /home/godoy/tmp/test_app.db
sqlite> .dump
BEGIN TRANSACTION;
CREATE TABLE tg_visit (
id INTEGER PRIMARY KEY,
visit_key VARCHAR(40) NOT NULL UNIQUE,
created TIMESTAMP,
expiry TIMESTAMP
);
INSERT INTO "tg_visit" VALUES(1,
'ffec5f6b4d48983ae8e9996f2bb8477d06e42437', '2006-04-07 01:29:05', '2006-
04-07 01:49:29');
CREATE TABLE tg_user (
id INTEGER PRIMARY KEY,
child_name VARCHAR(255),
user_id VARCHAR(16) NOT NULL UNIQUE,
email_address VARCHAR(255) NOT NULL UNIQUE,
display_name VARCHAR(255),
password VARCHAR(40),
created TIMESTAMP
);
INSERT INTO "tg_user" VALUES(1, 'Usuario', 'godoy', '[EMAIL PROTECTED]',
'godoy', 'teste', '2006-04-07 01:29:00');
CREATE TABLE tg_group (
id INTEGER PRIMARY KEY,
child_name VARCHAR(255),
group_id VARCHAR(16) NOT NULL UNIQUE,
display_name VARCHAR(255),
created TIMESTAMP
);
CREATE TABLE tg_user_group (
group_id INT NOT NULL,
user_id INT NOT NULL
);
CREATE TABLE tg_group_permission (
group_id INT NOT NULL,
permission_id INT NOT NULL
);
CREATE TABLE tg_group_permission (
group_id INT NOT NULL,
permission_id INT NOT NULL
);
CREATE TABLE tg_permission (
id INTEGER PRIMARY KEY,
child_name VARCHAR(255),
permission_id VARCHAR(16) NOT NULL UNIQUE,
description VARCHAR(255)
);
CREATE TABLE tg_visit_identity (
id INTEGER PRIMARY KEY,
visit_id INT NOT NULL UNIQUE,
user_id INT
);
CREATE TABLE usuario (
id INTEGER PRIMARY KEY,
child_name VARCHAR(255),
nome_completo VARCHAR(255) NOT NULL
);
INSERT INTO "usuario" VALUES(1, NULL, 'Jorge Godoy');
COMMIT;
sqlite>
}}}
--
Ticket URL: <http://trac.turbogears.org/turbogears/ticket/734>
TurboGears <http://www.turbogears.org/>
TurboGears front-to-back web development
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears Tickets" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears-tickets
-~----------~----~----~----~------~----~------~--~---
