-
Notifications
You must be signed in to change notification settings - Fork 5
/
Copy pathdbscript.sql
155 lines (154 loc) · 4.05 KB
/
dbscript.sql
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
drop table glyph;
drop table glyphoutline;
drop table glyphparam;
drop table master;
drop table globalparam;
drop table localparam;
drop table groupparam;
CREATE TABLE glyph (
idglyph INT AUTO_INCREMENT,
glyphName varchar(3),
width integer,
unicode TEXT,
primary key (idglyph)
);
CREATE TABLE glyphoutline (
id INT ,
glyphName VARCHAR(3),
PointNr VARCHAR(4),
x integer,
y integer,
contrp integer default 0,
idmaster INT,
pip INT,
vdate TIMESTAMP default now(),
primary key (idmaster,id,glyphName)
);
CREATE TABLE glyphparam (
id INT ,
glyphName VARCHAR(3),
PointName VARCHAR(5),
groupname VARCHAR(10),
startp INT,
doubledash INT,
tripledash INT,
superleft float,
superright float,
leftp INT,
rightp INT,
downp INT,
upp INT,
dir varchar(30),
leftp2 INT,
rightp2 INT,
downp2 INT,
upp2 INT,
dir2 varchar(30),
tension varchar(30),
tensionand varchar(10),
cycle INT,
penshifted varchar(30),
pointshifted varchar(30),
angle varchar(30),
penwidth varchar(30),
overx VARCHAR(10),
overbase VARCHAR(10),
overcap VARCHAR(10),
overasc VARCHAR(10),
overdesc VARCHAR(10),
ascpoint INT,
descpoint INT,
stemcutter VARCHAR(30),
stemshift VARCHAR(30),
inktrap_l float,
inktrap_r float,
idmaster INT,
vdate TIMESTAMP default now(),
primary key (idmaster,id,glyphName)
);
CREATE TABLE groupparam (
groupname varchar(10),
startp INT,
doubledash INT,
tripledash INT,
superleft float,
superright float,
leftp INT,
rightp INT,
downp INT,
upp INT,
dir varchar(30),
leftp2 INT,
rightp2 INT,
downp2 INT,
upp2 INT,
dir2 varchar(30),
tension varchar(30),
tensionand varchar(30),
cycle INT,
penshifted varchar(30),
pointshifted varchar(30),
angle varchar(30),
penwidth varchar(30),
overx VARCHAR(10),
overbase VARCHAR(10),
overcap VARCHAR(10),
overasc VARCHAR(10),
overdesc VARCHAR(10),
ascpoint INT,
descpoint INT,
stemcutter VARCHAR(30),
stemshift VARCHAR(30),
inktrap_l float,
inktrap_r float,
idmaster INT,
vdate TIMESTAMP default now(),
primary key (idmaster,groupname)
);
CREATE TABLE master (
idmaster INT AUTO_INCREMENT,
FontName TEXT,
FontNameA varchar(30),
FontNameB varchar(30),
idglobal INT,
vdate TIMESTAMP default now(),
primary key (idmaster)
);
CREATE TABLE globalparam (
idglobal INT ,
metapolation float,
unitwidth float,
fontsize integer default 10,
mean float default 5.0,
cap float default 8.0,
ascl float default 2.0,
des float default 2.0,
box float default 10,
primary key (idglobal)
);
CREATE TABLE localparam (
idlocal INT ,
px float default 0,
width float default 1,
space float default 0,
xheight float default 5.0,
capital float default 8.0,
boxheight float default 10.0,
ascender float default 8.0,
descender float default 2.0,
inktrap integer default 10,
stemcut integer default 20,
skeleton float default 0.0,
superness float default 1.0,
over float default 0.1,
primary key (idlocal)
);
insert into master (FontName,FontNameA,FontNameB,idglobal) Values ("Foxtail", "FoxtailA.ufo","FoxtailA.ufo",1);
insert into master (FontName,FontNameA,FontNameB,idglobal) Values ("My First Metapolator Font", "GaramondSansA.ufo","GaramondSansB.ufo",2);
insert into master (FontName,FontNameA,FontNameB,idglobal) Values ("Generic Sans", "SeanA.ufo","SeanB.ufo",3);
insert into globalparam (idglobal,metapolation,unitwidth,fontsize) Values (1, 0,1,10);
insert into globalparam (idglobal,metapolation,unitwidth,fontsize) Values (2, 1,1,10);
insert into localparam (idlocal) values (1);
insert into localparam (idlocal) values (2);
insert into localparam (idlocal) values (3);
insert into localparam (idlocal) values (4);