kinda got it (found the CREATE script)
c...@dv67:~/temp$ sqlite3 foo.db
SQLite version 3.6.10
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .read storage.sql
sqlite> .tables
expense_form expense_item t2_person
CREATE TABLE t2_person(
id INTEGER PRIMARY KEY AUTOINCREMENT,
name CHAR(32),
first_name CHAR(32),
last_name CHAR(32),
badge_line1 CHAR(32),
badge_line2 CHAR(32),
email CHAR(128),
password CHAR(32),
address1 CHAR(128),
address2 CHAR(128),
city CHAR(32),
state CHAR(32),
country CHAR(32),
zip_code CHAR(32),
phone_number CHAR(32),
personal_home_page CHAR(128),
company_name CHAR(32),
company_home_page CHAR(128),
hotel CHAR(32),
include_in_delegate_listing CHAR(1),
food_preference CHAR(32),
t_shirt_size CHAR(32),
sprints CHAR(32),
attendee_type CHAR(32),
donation_to_PSF DOUBLE,
tutorials TEXT,
discount_coupon CHAR(64),
captcha CHAR(32),
amount_billed DOUBLE,
amount_added DOUBLE,
amount_subtracted DOUBLE,
amount_paid DOUBLE,
amount_due DOUBLE,
speaker CHAR(1),
session_chair CHAR(1),
manager CHAR(1),
reviewer CHAR(1),
latitude DOUBLE,
longitude DOUBLE,
checkout_status CHAR(32),
pay_token CHAR(32),
registration_key CHAR(64),
picture_data BLOB,
created_by_ip CHAR(32),
created_on TIMESTAMP
);
CREATE TABLE expense_form(
id INTEGER PRIMARY KEY AUTOINCREMENT,
person REFERENCES t2_person(id) ON DELETE CASCADE,
event CHAR(20),
created_on TIMESTAMP
);
CREATE TABLE expense_item(
id INTEGER PRIMARY KEY AUTOINCREMENT,
exp_form REFERENCES expense_form(id) ON DELETE CASCADE,
seq INTEGER,
receipt_no INTEGER,
receipt_item INTEGER,
acct_code CHAR(20),
description TEXT,
serial_no CHAR(30),
location TEXT,
amount DOUBLE
);
Now to try to run the Appwiz on this.
Carl K
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[email protected]
