summaryrefslogtreecommitdiff
path: root/graphs/sql/a_new_dawn/req02.sql
diff options
context:
space:
mode:
Diffstat (limited to 'graphs/sql/a_new_dawn/req02.sql')
-rw-r--r--graphs/sql/a_new_dawn/req02.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/graphs/sql/a_new_dawn/req02.sql b/graphs/sql/a_new_dawn/req02.sql
new file mode 100644
index 0000000..6c705da
--- /dev/null
+++ b/graphs/sql/a_new_dawn/req02.sql
@@ -0,0 +1,8 @@
+ALTER TABLE nexus.employees
+ADD email VARCHAR(50);
+ALTER TABLE nexus_it.software_assets
+DROP IF EXISTS license_key;
+ALTER TABLE nexus_food.products
+RENAME COLUMN product_name TO product_title;
+ALTER TABLE nexus.employees
+ALTER COLUMN salary TYPE INTEGER;