[Kick-developers] CVS: kick init.sql,1.2,1.3

[Michael R. <mr...@us...>]

Update of /cvsroot/kick/kick
In directory usw-pr-cvs1:/tmp/cvs-serv6373

Modified Files:
	init.sql 
Log Message:

SQL auf Standard Datenbank (MS Access) ausgerichtet.

Index: init.sql
===================================================================
RCS file: /cvsroot/kick/kick/init.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** init.sql	19 Mar 2002 09:07:45 -0000	1.2
--- init.sql	29 Apr 2002 04:15:20 -0000	1.3
***************
*** 11,15 ****
  
  CREATE TABLE teilhaber (
!     id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
      nachname CHAR(50) NOT NULL,
      vorname CHAR(50) NOT NULL,
--- 11,15 ----
  
  CREATE TABLE teilhaber (
!     id AUTOINCREMENT PRIMARY KEY,
      nachname CHAR(50) NOT NULL,
      vorname CHAR(50) NOT NULL,
***************
*** 27,31 ****
  
  CREATE TABLE konten (
!     id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
      titel CHAR(50) NOT NULL,
      bank CHAR(50),
--- 27,31 ----
  
  CREATE TABLE konten (
!     id AUTOINCREMENT PRIMARY KEY,
      titel CHAR(50) NOT NULL,
      bank CHAR(50),
***************
*** 36,40 ****
  
  CREATE TABLE posten (
!     id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
      titel CHAR(50) NOT NULL,
      CONSTRAINT idx UNIQUE (titel)
--- 36,40 ----
  
  CREATE TABLE posten (
!     id AUTOINCREMENT PRIMARY KEY,
      titel CHAR(50) NOT NULL,
      CONSTRAINT idx UNIQUE (titel)
***************
*** 42,46 ****
  
  CREATE TABLE depots (
!     id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
      titel CHAR(50) NOT NULL,
      CONSTRAINT idx UNIQUE (titel)
--- 42,46 ----
  
  CREATE TABLE depots (
!     id AUTOINCREMENT PRIMARY KEY,
      titel CHAR(50) NOT NULL,
      CONSTRAINT idx UNIQUE (titel)
***************
*** 48,52 ****
  
  CREATE TABLE wptypen (
!     id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
      titel CHAR(50) NOT NULL,
      CONSTRAINT idx UNIQUE (titel)
--- 48,52 ----
  
  CREATE TABLE wptypen (
!     id AUTOINCREMENT PRIMARY KEY,
      titel CHAR(50) NOT NULL,
      CONSTRAINT idx UNIQUE (titel)
***************
*** 54,61 ****
  
  CREATE TABLE wertpapiere (
!     id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
      titel CHAR(50) NOT NULL,
!     xdepot INT NOT NULL REFERENCES depots(id),
!     xwptyp INT NOT NULL REFERENCES wptypen(id),
      CONSTRAINT idx UNIQUE (titel)
  );
--- 54,61 ----
  
  CREATE TABLE wertpapiere (
!     id AUTOINCREMENT PRIMARY KEY,
      titel CHAR(50) NOT NULL,
!     xdepot INT REFERENCES depots(id) NOT NULL,
!     xwptyp INT REFERENCES wptypen(id) NOT NULL,
      CONSTRAINT idx UNIQUE (titel)
  );
***************
*** 63,67 ****
  CREATE TABLE abschluss (
      datum DATE PRIMARY KEY NOT NULL,
!     id INT NOT NULL AUTO_INCREMENT,
      preis DOUBLE,
      CONSTRAINT idx UNIQUE (id)
--- 63,67 ----
  CREATE TABLE abschluss (
      datum DATE PRIMARY KEY NOT NULL,
!     id AUTOINCREMENT,
      preis DOUBLE,
      CONSTRAINT idx UNIQUE (id)
***************
*** 81,96 ****
  
  CREATE TABLE bbuchungen (
!     id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
      datum date NOT NULL,
      waehrung double,
      betrag double NOT NULL,
      bemerkung CHAR(50),
!     xPosten INT NOT NULL REFERENCES posten(id),
!     xEnde INT NOT NULL REFERENCES abschluss(id),
!     xKonto INT NOT NULL REFERENCES konten(id)
  );
  
  CREATE TABLE tbuchungen (
!     id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
      datum date NOT NULL,
      waehrung double,
--- 81,96 ----
  
  CREATE TABLE bbuchungen (
!     id AUTOINCREMENT PRIMARY KEY,
      datum date NOT NULL,
      waehrung double,
      betrag double NOT NULL,
      bemerkung CHAR(50),
!     xPosten INT REFERENCES posten(id) NOT NULL,
!     xEnde INT REFERENCES abschluss(id) NOT NULL,
!     xKonto INT REFERENCES konten(id) NOT NULL
  );
  
  CREATE TABLE tbuchungen (
!     id AUTOINCREMENT PRIMARY KEY,
      datum date NOT NULL,
      waehrung double,
***************
*** 98,135 ****
      anteile double NOT NULL,
      bemerkung CHAR(50),
!     xPosten INT NOT NULL REFERENCES posten(id),
!     xKonto INT NOT NULL REFERENCES konten(id),
!     xEnde INT NOT NULL REFERENCES abschluss(id),
!     xTeilhaber INT NOT NULL REFERENCES teilhaber(id)
  );
  
  CREATE TABLE ubuchungen (
!     id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
      datum date NOT NULL,
      waehrung double,
      betrag double NOT NULL,
      bemerkung CHAR(50),
!     xPosten INT NOT NULL REFERENCES posten(id),
!     xKonto INT NOT NULL REFERENCES konten(id),
!     xEnde INT NOT NULL REFERENCES abschluss(id),
!     xBuchung INT NOT NULL REFERENCES bBuchungen(id)
  );
  
  CREATE TABLE abuchungen (
!     id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
      datum date NOT NULL,
      waehrung double,
      bemerkung CHAR(50),
!     xPosten INT NOT NULL REFERENCES posten(id),
!     xKonto INT NOT NULL REFERENCES konten(id),
      anteile DOUBLE,
      kurs DOUBLE,
      gebuehr DOUBLE,
!     xEnde INT NOT NULL REFERENCES abschluss(id),
!     xWPapier INT NOT NULL REFERENCES wertpapiere (id)
  );
  
  CREATE TABLE dbuchungen (
!     id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
      datum date NOT NULL,
      waehrung double,
--- 98,135 ----
      anteile double NOT NULL,
      bemerkung CHAR(50),
!     xPosten INT REFERENCES posten(id) NOT NULL,
!     xKonto INT REFERENCES konten(id) NOT NULL,
!     xEnde INT REFERENCES abschluss(id) NOT NULL,
!     xTeilhaber INT REFERENCES teilhaber(id) NOT NULL
  );
  
  CREATE TABLE ubuchungen (
!     id AUTOINCREMENT PRIMARY KEY,
      datum date NOT NULL,
      waehrung double,
      betrag double NOT NULL,
      bemerkung CHAR(50),
!     xPosten INT REFERENCES posten(id) NOT NULL,
!     xKonto INT REFERENCES konten(id) NOT NULL,
!     xEnde INT REFERENCES abschluss(id) NOT NULL,
!     xBuchung INT REFERENCES bBuchungen(id) NOT NULL
  );
  
  CREATE TABLE abuchungen (
!     id AUTOINCREMENT PRIMARY KEY,
      datum date NOT NULL,
      waehrung double,
      bemerkung CHAR(50),
!     xPosten INT REFERENCES posten(id) NOT NULL,
!     xKonto INT REFERENCES konten(id) NOT NULL,
      anteile DOUBLE,
      kurs DOUBLE,
      gebuehr DOUBLE,
!     xEnde INT REFERENCES abschluss(id) NOT NULL,
!     xWPapier INT REFERENCES wertpapiere (id) NOT NULL
  );
  
  CREATE TABLE dbuchungen (
!     id AUTOINCREMENT PRIMARY KEY,
      datum date NOT NULL,
      waehrung double,
***************
*** 137,153 ****
      bemerkung CHAR(50),
      steuer double,
!     xPosten INT NOT NULL REFERENCES posten(id),
!     xKonto INT NOT NULL REFERENCES konten(id),
!     xEnde INT NOT NULL REFERENCES abschluss(id),
!     xWPapier INT NOT NULL REFERENCES wertpapiere (id)
  );
  
  CREATE TABLE wertungen (
!     id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
      datum date NOT NULL,
      waehrung DOUBLE,
      kurs double NOT NULL,
      bemerkung CHAR(50),
!     xEnde INT NOT NULL REFERENCES abschluss(id),
!     xWPapier INT NOT NULL REFERENCES wertpapiere (id)
  );
--- 137,154 ----
      bemerkung CHAR(50),
      steuer double,
!     xPosten INT REFERENCES posten(id) NOT NULL,
!     xKonto INT REFERENCES konten(id) NOT NULL,
!     xEnde INT REFERENCES abschluss(id) NOT NULL,
!     xWPapier INT REFERENCES wertpapiere (id) NOT NULL
  );
  
  CREATE TABLE wertungen (
!     id AUTOINCREMENT PRIMARY KEY,
      datum date NOT NULL,
      waehrung DOUBLE,
      kurs double NOT NULL,
      bemerkung CHAR(50),
!     xEnde INT REFERENCES abschluss(id) NOT NULL,
!     xWPapier INT REFERENCES wertpapiere (id) NOT NULL
  );
+