diff options
| author | Benjamin Franzke <benjaminfranzke@googlemail.com> | 2013-01-26 22:05:40 +0100 |
|---|---|---|
| committer | Benjamin Franzke <benjaminfranzke@googlemail.com> | 2013-01-26 22:05:40 +0100 |
| commit | db71c8924c3cf7e9457dc18474766dc42fbc8d50 (patch) | |
| tree | 8fb02f47dbf8a9b23fd1fe7d2c1e41cf2d2a73f0 | |
| parent | e86308e5d8cc924d573a1c175e89d8f3a09a1437 (diff) | |
| download | sqltutor-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.sql | 10 |
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)); |