summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBenjamin Franzke <benjaminfranzke@googlemail.com>2013-01-26 22:05:40 +0100
committerBenjamin Franzke <benjaminfranzke@googlemail.com>2013-01-26 22:05:40 +0100
commitdb71c8924c3cf7e9457dc18474766dc42fbc8d50 (patch)
tree8fb02f47dbf8a9b23fd1fe7d2c1e41cf2d2a73f0
parente86308e5d8cc924d573a1c175e89d8f3a09a1437 (diff)
downloadsqltutor-plugin-db71c8924c3cf7e9457dc18474766dc42fbc8d50.tar.gz
sqltutor-plugin-db71c8924c3cf7e9457dc18474766dc42fbc8d50.tar.bz2
sqltutor-plugin-db71c8924c3cf7e9457dc18474766dc42fbc8d50.zip
kapv-schema: Add fixes to actually be compatible with the exported data
-rw-r--r--oracle-conversion/kapv-schema.sql10
1 files changed, 5 insertions, 5 deletions
diff --git a/oracle-conversion/kapv-schema.sql b/oracle-conversion/kapv-schema.sql
index 4e81170..7c3c95f 100644
--- a/oracle-conversion/kapv-schema.sql
+++ b/oracle-conversion/kapv-schema.sql
@@ -13,10 +13,10 @@
create table Adressen (
Adress_ID numeric(10) not null primary key,
Postleitzahl numeric(5) not null,
- Ort varchar(1) not null,
- Strae varchar(1) not null,
+ Ort varchar(255) not null,
+ Strae varchar(255) not null,
Hausnummer char(5) not null,
- Staat varchar(1) not null);
+ Staat varchar(2) not null);
create table Auftrag (
Auftragsstatus varchar(12) not null,
@@ -60,9 +60,9 @@ create table Produktlager (
Preis numeric(10 ,2) not null,
Stueckzahl numeric(10) not null,
Produktnummer char(8) not null,
- Bezeichnung varchar(1) not null,
+ Bezeichnung varchar(255) not null,
Produktionsdatum date not null,
- Material varchar(1) not null,
+ Material varchar(255) not null,
Groesse varchar(1) not null,
primary key(Produktnummer));