populate.sql

来自「ruby on rails web敏捷开发之路第二版 源代码」· SQL 代码 · 共 10 行

insert into products values(1, "Programming Ruby, 2nd Edition", "",
"", 44.95, now());
insert into products values(2, "Pragmatic Project Automation", "",
"", 29.95, now());

insert into orders values(1, "Dave Thomas", "[e-mail]", "", "", null);

insert into line_items values(1, 1, 1, 1, 44.95);
insert into line_items values(2, 2, 1, 2, 44.95);