Bugzilla – Attachment 117649 Details for
Bug 93094
Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
SQLite3 Db schema - salespeople database
salespeople.sql (text/plain), 523 bytes, created by
Alex Thurgood
on 2015-08-04 15:26:21 UTC
(
hide
)
Description:
SQLite3 Db schema - salespeople database
Filename:
MIME Type:
Creator:
Alex Thurgood
Created:
2015-08-04 15:26:21 UTC
Size:
523 bytes
patch
obsolete
>CREATE TABLE salespeople (id integer primary key, first_name text not null, last_name text not null, comission_rate real not null); >CREATE TABLE customers ( > id INTEGER PRIMARY KEY, > company_name TEXT NOT NULL, > street_address TEXT NOT NULL, > city TEXT NOT NULL, > state TEXT NOT NULL, > zip TEXT NOT NULL >); >CREATE TABLE orders ( > id INTEGER PRIMARY KEY, > customer_id INTEGER, > salesperson_id INTEGER, > FOREIGN KEY(customer_id) REFERENCES customers(id), > FOREIGN KEY(salesperson_id) REFERENCES salespeople(id) >);
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=117649">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 93094
:
117648
| 117649