[prev in list] [next in list] [prev in thread] [next in thread]
List: kde-commits
Subject: playground/office/kraft
From: Klaas Freitag <freitag () suse ! de>
Date: 2006-11-30 22:11:27
Message-ID: 1164924687.590782.2187.nullmailer () svn ! kde ! org
[Download RAW message or body]
SVN commit 609471 by freitag:
- removed useless tables from db create script
- added organisation to invoice doc template
M +2 -21 database/create_schema.sql
M +2 -2 reports/invoice.trml
--- trunk/playground/office/kraft/database/create_schema.sql #609470:609471
@@ -120,9 +120,9 @@
-CREATE TABLE stockMat (
+CREATE TABLE stockMaterial (
matID INT NOT NULL AUTO_INCREMENT,
- matChapter INT NOT NULL default 1,
+ chapterID INT NOT NULL default 1,
material mediumtext,
unitID INT NOT NULL,
perPack DECIMAL(6,2),
@@ -133,25 +133,6 @@
INDEX(matChapter)
);
-
-
-CREATE TABLE stockMatChapter (
- stockMatChapterID INT NOT NULL AUTO_INCREMENT,
- matKatID INT NOT NULL,
- stockMatChapter VARCHAR(255),
- sortID INT,
-
- PRIMARY KEY(stockMatChapterID)
-);
-
-CREATE TABLE matKats(
- matKatID INT NOT NULL AUTO_INCREMENT,
- matKatName VARCHAR(255),
-
- PRIMARY KEY(matKatID)
-
-);
-
CREATE TABLE stdSaetze(
stdSaetzeID INT NOT NULL AUTO_INCREMENT,
name VARCHAR(255),
--- trunk/playground/office/kraft/reports/invoice.trml #609470:609471
@@ -11,7 +11,7 @@
<lineMode width="0.5" />
<lines>2cm 2.2cm 19cm 2.2cm</lines>
<fill color="darkgreen" />
- <drawCentredString x="105mm" y="2.3cm"><!-- MY.NAME \
--></drawCentredString> + <drawCentredString x="105mm" y="2.3cm"><!-- \
MY.NAME --> <!-- MY.ORGANISATION --></drawCentredString> <setFont name="Times-Roman" \
size="10" /> <fill color="black" />
<drawCentredString x="105mm" y="1.8cm"><!-- MY.STREET --> - <!-- \
MY.POSTCODE --> <!-- MY.LOCALITY --></drawCentredString> @@ -32,7 +32,7 @@
<lineMode width="0.5" />
<lines>2cm 2.2cm 19cm 2.2cm</lines>
<fill color="darkgreen" />
- <drawCentredString x="105mm" y="2.3cm"><!-- MY.NAME \
--></drawCentredString> + <drawCentredString x="105mm" y="2.3cm"><!-- \
MY.NAME --> <!-- MY.ORGANISATION --></drawCentredString> <setFont name="Times-Roman" \
size="10" /> <fill color="black" />
<drawCentredString x="105mm" y="1.8cm"><!-- MY.STREET --> - <!-- \
MY.POSTCODE --> <!-- MY.LOCALITY --></drawCentredString>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic