sqlstatements.txt.svn-base

来自「rmi server web service for a stock track」· SVN-BASE 代码 · 共 17 行

DROP TABLE asserts
DROP TABLE portfolios
DROP TABLE customers
CREATE TABLE customers (name char(16) primary key, password char(64), email char(40))
CREATE TABLE portfolios (id int primary key, name char(16), customer_name char(16), foreign key (customer_name) references customers(name))
CREATE TABLE asserts (id int primary key, name char(16), portfolio int, amount int, init_price real, foreign key (portfolio) references portfolios(id))
INSERT INTO customers VALUES('test', '098f6bcd4621d373cade4e832627b4f6', '[e-mail]')
INSERT INTO customers VALUES('Lionel', 'b07381bc3a2f7ebef75b2598eda272f3', '[e-mail]')
INSERT INTO portfolios VALUES(1, 'Software', 'test')
INSERT INTO portfolios VALUES(2, 'port2', 'Lionel')
INSERT INTO portfolios VALUES(3, 'Network', 'test')
INSERT INTO asserts VALUES(1, 'Google', 1, 100, 325.25)
INSERT INTO asserts VALUES(2, 'Microsoft', 1, 200, 29.49)
INSERT INTO asserts VALUES(3, 'Actuate', 2, 500, 6.9)
INSERT INTO asserts VALUES(4, 'IBM', 1, 500, 109.12)
INSERT INTO asserts VALUES(5, 'AT&T', 3, 500, 87.56)