1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
# message: Creating document position calulation tables ;
CREATE TABLE DocCalcTime (
TCalcID INT NOT NULL AUTO_INCREMENT,
TemplID INT NOT NULL,
name VARCHAR(255),
minutes INT default 0,
percent INT default 0,
stdHourSet INT default 0,
allowGlobal INT default 1,
modDate TIMESTAMP(14),
PRIMARY KEY( TCalcID),
INDEX(TemplID)
);
CREATE TABLE DocCalcFixed(
FCalcID INT NOT NULL AUTO_INCREMENT,
TemplID INT NOT NULL,
name VARCHAR(255),
amount DECIMAL(10,2) default 1.0,
price DECIMAL(10,2),
percent INT default 0,
modDate TIMESTAMP(14),
PRIMARY KEY(FCalcID),
INDEX(TemplID)
);
CREATE TABLE DocCalcMaterials(
MCalcID INT NOT NULL AUTO_INCREMENT,
TemplID INT NOT NULL,
name VARCHAR(255),
percent INT default 0,
modDate TIMESTAMP(14),
PRIMARY KEY(MCalcID),
INDEX(TemplID)
);
CREATE TABLE DocCalcMaterialDetails(
MCalcDetailID INT NOT NULL AUTO_INCREMENT,
CalcID INT NOT NULL,
materialID INT NOT NULL,
amount DECIMAL(10,2),
PRIMARY KEY(MCalcDetailID),
INDEX(CalcID)
);
|
