summaryrefslogtreecommitdiff
path: root/_content/doc/tutorial/database-access/data-access/create-tables.sql
diff options
context:
space:
mode:
Diffstat (limited to '_content/doc/tutorial/database-access/data-access/create-tables.sql')
-rw-r--r--_content/doc/tutorial/database-access/data-access/create-tables.sql16
1 files changed, 16 insertions, 0 deletions
diff --git a/_content/doc/tutorial/database-access/data-access/create-tables.sql b/_content/doc/tutorial/database-access/data-access/create-tables.sql
new file mode 100644
index 0000000..63290a0
--- /dev/null
+++ b/_content/doc/tutorial/database-access/data-access/create-tables.sql
@@ -0,0 +1,16 @@
+DROP TABLE IF EXISTS album;
+CREATE TABLE album (
+ id SERIAL,
+ title VARCHAR(128) NOT NULL,
+ artist VARCHAR(255) NOT NULL,
+ price DECIMAL(5,2) NOT NULL,
+ PRIMARY KEY (id)
+);
+
+INSERT INTO album
+ (title, artist, price)
+VALUES
+ ('Blue Train', 'John Coltrane', 56.99),
+ ('Giant Steps', 'John Coltrane', 63.99),
+ ('Jeru', 'Gerry Mulligan', 17.99),
+ ('Sarah Vaughan', 'Sarah Vaughan', 34.98);