개정판 0cf44537
issue #000: fix script and disable save image
Change-Id: Idc158907cbdf288f0b8bf3390d320b5c99e8176b
DTI_PID/DTI_PID/AppDocData.py | ||
---|---|---|
1992 | 1992 |
def update_symbol_shape(self, symbol_name, image_file, svg_file, image_display_file): |
1993 | 1993 |
"""update symbol shape""" |
1994 | 1994 | |
1995 |
# need to test on mssql |
|
1996 |
return |
|
1997 | ||
1995 | 1998 |
with self.project.database.connect() as conn: |
1996 | 1999 |
try: |
1997 | 2000 |
# Get a cursor object |
DTI_PID/DTI_PID/Scripts/MSSQL/ID2.sql | ||
---|---|---|
12 | 12 |
Category VARCHAR(64), |
13 | 13 |
Type VARCHAR(64) NOT NULL |
14 | 14 |
); |
15 |
INSERT INTO SymbolType ( |
|
16 |
Type, |
|
17 |
Category, |
|
18 |
UID |
|
19 |
) |
|
20 |
VALUES ('General','',-1), |
|
21 |
('Line','Line',0), |
|
22 |
('Column','Equipment',1), |
|
23 |
('Filter','Equipment',2), |
|
24 |
('Heat Transfer Equipment','Equipment',3), |
|
25 |
('Labels - Equipment','Equipment',4), |
|
26 |
('Mechanical','Equipment',5), |
|
27 |
('Other Equipment','Equipment',6), |
|
28 |
('Vessels','Equipment',7), |
|
29 |
('General','Equipment Components',8), |
|
30 |
('Heating Components','Equipment Components',9), |
|
31 |
('Labels - Equipment Components','Equipment Components',10), |
|
32 |
('Mechanical Components','Equipment Components',11), |
|
33 |
('Nozzles','Equipment Components',12), |
|
34 |
('Trays','Equipment Components',13), |
|
35 |
('Vessel Components','Equipment Components',14), |
|
36 |
('Actuators','Instrumentation',15), |
|
37 |
('Gaps','Instrumentation',16), |
|
38 |
('In-Line','Instrumentation',17), |
|
39 |
('Instrument OPC''s','Instrumentation',18), |
|
40 |
('Labels - General Instrument','Instrumentation',19), |
|
41 |
('Loops','Instrumentation',20), |
|
42 |
('Off-Line','Instrumentation',21), |
|
43 |
('Relief Devices','Instrumentation',22), |
|
44 |
('Signal Line','Instrumentation',24), |
|
45 |
('System Functions','Instrumentation',25), |
|
46 |
('Fire & Safety','Piping',26), |
|
47 |
('Fittings','Piping',27), |
|
48 |
('Gaps','Piping',28), |
|
49 |
('Labels - Piping Components','Instrumentation',29), |
|
50 |
('Labels - Piping Segments','Instrumentation',30), |
|
51 |
('Piping OPC''s','Piping',31), |
|
52 |
('Routing','Piping',32), |
|
53 |
('Segment Breaks','Piping',33), |
|
54 |
('Specialty Components','Piping',34), |
|
55 |
('Valves','Piping',35), |
|
56 |
('Reducers','Piping',36), |
|
57 |
('Notes','General',37), |
|
58 |
('End Break','Piping',38); |
|
59 | ||
15 |
INSERT INTO SymbolType |
|
16 |
(UID, Category, "Type") |
|
17 |
VALUES(-1, '', 'General'); |
|
18 |
INSERT INTO SymbolType |
|
19 |
(UID, Category, "Type") |
|
20 |
VALUES(0, 'Line', 'Line'); |
|
21 |
INSERT INTO SymbolType |
|
22 |
(UID, Category, "Type") |
|
23 |
VALUES(1, 'Equipment', 'Column'); |
|
24 |
INSERT INTO SymbolType |
|
25 |
(UID, Category, "Type") |
|
26 |
VALUES(2, 'Equipment', 'Filter'); |
|
27 |
INSERT INTO SymbolType |
|
28 |
(UID, Category, "Type") |
|
29 |
VALUES(3, 'Equipment', 'Heat Transfer Equipment'); |
|
30 |
INSERT INTO SymbolType |
|
31 |
(UID, Category, "Type") |
|
32 |
VALUES(4, 'Instrumentation', 'Labels - Equipment'); |
|
33 |
INSERT INTO SymbolType |
|
34 |
(UID, Category, "Type") |
|
35 |
VALUES(5, 'Equipment', 'Mechanical'); |
|
36 |
INSERT INTO SymbolType |
|
37 |
(UID, Category, "Type") |
|
38 |
VALUES(6, 'Equipment', 'Other Equipment'); |
|
39 |
INSERT INTO SymbolType |
|
40 |
(UID, Category, "Type") |
|
41 |
VALUES(7, 'Equipment', 'Vessels'); |
|
42 |
INSERT INTO SymbolType |
|
43 |
(UID, Category, "Type") |
|
44 |
VALUES(8, 'Equipment Components', 'General'); |
|
45 |
INSERT INTO SymbolType |
|
46 |
(UID, Category, "Type") |
|
47 |
VALUES(9, 'Equipment Components', 'Heating Components'); |
|
48 |
INSERT INTO SymbolType |
|
49 |
(UID, Category, "Type") |
|
50 |
VALUES(10, 'Instrumentation', 'Labels - Equipment Components'); |
|
51 |
INSERT INTO SymbolType |
|
52 |
(UID, Category, "Type") |
|
53 |
VALUES(11, 'Equipment Components', 'Mechanical Components'); |
|
54 |
INSERT INTO SymbolType |
|
55 |
(UID, Category, "Type") |
|
56 |
VALUES(12, 'Equipment Components', 'Nozzles'); |
|
57 |
INSERT INTO SymbolType |
|
58 |
(UID, Category, "Type") |
|
59 |
VALUES(13, 'Equipment Components', 'Trays'); |
|
60 |
INSERT INTO SymbolType |
|
61 |
(UID, Category, "Type") |
|
62 |
VALUES(14, 'Equipment Components', 'Vessel Components'); |
|
63 |
INSERT INTO SymbolType |
|
64 |
(UID, Category, "Type") |
|
65 |
VALUES(15, 'Instrumentation', 'Actuators'); |
|
66 |
INSERT INTO SymbolType |
|
67 |
(UID, Category, "Type") |
|
68 |
VALUES(16, 'Instrumentation', 'Gaps'); |
|
69 |
INSERT INTO SymbolType |
|
70 |
(UID, Category, "Type") |
|
71 |
VALUES(17, 'Instrumentation', 'In-Line'); |
|
72 |
INSERT INTO SymbolType |
|
73 |
(UID, Category, "Type") |
|
74 |
VALUES(18, 'Instrumentation', 'Instrument OPC''s'); |
|
75 |
INSERT INTO SymbolType |
|
76 |
(UID, Category, "Type") |
|
77 |
VALUES(19, 'Instrumentation', 'Labels - General Instrument'); |
|
78 |
INSERT INTO SymbolType |
|
79 |
(UID, Category, "Type") |
|
80 |
VALUES(20, 'Instrumentation', 'Loops'); |
|
81 |
INSERT INTO SymbolType |
|
82 |
(UID, Category, "Type") |
|
83 |
VALUES(21, 'Instrumentation', 'Off-Line'); |
|
84 |
INSERT INTO SymbolType |
|
85 |
(UID, Category, "Type") |
|
86 |
VALUES(22, 'Instrumentation', 'Relief Devices'); |
|
87 |
INSERT INTO SymbolType |
|
88 |
(UID, Category, "Type") |
|
89 |
VALUES(24, 'Instrumentation', 'Signal Line'); |
|
90 |
INSERT INTO SymbolType |
|
91 |
(UID, Category, "Type") |
|
92 |
VALUES(25, 'Instrumentation', 'System Functions'); |
|
93 |
INSERT INTO SymbolType |
|
94 |
(UID, Category, "Type") |
|
95 |
VALUES(26, 'Piping', 'Fire & Safety'); |
|
96 |
INSERT INTO SymbolType |
|
97 |
(UID, Category, "Type") |
|
98 |
VALUES(27, 'Piping', 'Fittings'); |
|
99 |
INSERT INTO SymbolType |
|
100 |
(UID, Category, "Type") |
|
101 |
VALUES(28, 'Piping', 'Gaps'); |
|
102 |
INSERT INTO SymbolType |
|
103 |
(UID, Category, "Type") |
|
104 |
VALUES(29, 'Instrumentation', 'Labels - Piping Components'); |
|
105 |
INSERT INTO SymbolType |
|
106 |
(UID, Category, "Type") |
|
107 |
VALUES(30, 'Piping', 'Labels - Piping Segments'); |
|
108 |
INSERT INTO SymbolType |
|
109 |
(UID, Category, "Type") |
|
110 |
VALUES(31, 'Piping', 'Piping OPC''s'); |
|
111 |
INSERT INTO SymbolType |
|
112 |
(UID, Category, "Type") |
|
113 |
VALUES(32, 'Piping', 'Routing'); |
|
114 |
INSERT INTO SymbolType |
|
115 |
(UID, Category, "Type") |
|
116 |
VALUES(33, 'Piping', 'Segment Breaks'); |
|
117 |
INSERT INTO SymbolType |
|
118 |
(UID, Category, "Type") |
|
119 |
VALUES(34, 'Piping', 'Specialty Components'); |
|
120 |
INSERT INTO SymbolType |
|
121 |
(UID, Category, "Type") |
|
122 |
VALUES(35, 'Piping', 'Valves'); |
|
123 |
INSERT INTO SymbolType |
|
124 |
(UID, Category, "Type") |
|
125 |
VALUES(36, 'Piping', 'Reducers'); |
|
126 |
INSERT INTO SymbolType |
|
127 |
(UID, Category, "Type") |
|
128 |
VALUES(37, 'General', 'Notes'); |
|
129 |
INSERT INTO SymbolType |
|
130 |
(UID, Category, "Type") |
|
131 |
VALUES(38, 'Piping', 'End Break'); |
|
60 | 132 | |
61 | 133 |
CREATE TABLE SymbolName ( |
62 | 134 |
UID INTEGER NOT NULL |
63 | 135 |
PRIMARY KEY, |
64 | 136 |
SymbolType_UID INTEGER REFERENCES SymbolType (UID), |
65 | 137 |
Category TEXT NOT NULL, |
66 |
Type VARCHAR(64),
|
|
138 |
Type VARCHAR(37),
|
|
67 | 139 |
Name TEXT NOT NULL |
68 | 140 |
); |
69 | 141 |
delete from SymbolName; |
... | ... | |
1266 | 1338 |
CREATE TABLE SymbolAttribute ( |
1267 | 1339 |
UID VARCHAR (37) NOT NULL |
1268 | 1340 |
PRIMARY KEY, |
1269 |
SymbolType_UID VARCHAR (37),
|
|
1341 |
SymbolType_UID INTEGER,
|
|
1270 | 1342 |
Attribute VARCHAR(32) NOT NULL, |
1271 | 1343 |
DisplayAttribute TEXT NOT NULL, |
1272 | 1344 |
AttributeType TEXT NOT NULL, |
... | ... | |
1365 | 1437 |
) |
1366 | 1438 |
); |
1367 | 1439 | |
1368 |
INSERT INTO Colors ( |
|
1369 |
VALUE, |
|
1370 |
PROPERTY, |
|
1371 |
BLUE, |
|
1372 |
GREEN, |
|
1373 |
RED, |
|
1374 |
UID |
|
1375 |
) |
|
1376 |
VALUES (NULL,NULL,0,0,255,1), |
|
1377 |
(NULL,NULL,0,255,255,2), |
|
1378 |
(NULL,NULL,0,255,0,3), |
|
1379 |
(NULL,NULL,255,0,255,6), |
|
1380 |
(NULL,NULL,0,0,189,12), |
|
1381 |
(NULL,NULL,126,126,189,13), |
|
1382 |
(NULL,NULL,86,86,129,15), |
|
1383 |
(NULL,NULL,0,63,255,20), |
|
1384 |
(NULL,NULL,0,46,189,22), |
|
1385 |
(NULL,NULL,126,141,189,23), |
|
1386 |
(NULL,NULL,0,31,129,24), |
|
1387 |
(NULL,NULL,0,127,255,30), |
|
1388 |
(NULL,NULL,0,94,189,32), |
|
1389 |
(NULL,NULL,126,157,189,33), |
|
1390 |
(NULL,NULL,0,64,129,34), |
|
1391 |
(NULL,NULL,0,52,104,36), |
|
1392 |
(NULL,NULL,0,191,255,40), |
|
1393 |
(NULL,NULL,0,141,189,42), |
|
1394 |
(NULL,NULL,126,173,189,43), |
|
1395 |
(NULL,NULL,0,96,129,44), |
|
1396 |
(NULL,NULL,86,118,129,45), |
|
1397 |
(NULL,NULL,0,78,104,46), |
|
1398 |
(NULL,NULL,69,95,104,47), |
|
1399 |
(NULL,NULL,0,255,255,50), |
|
1400 |
(NULL,NULL,0,189,189,52), |
|
1401 |
(NULL,NULL,126,189,189,53), |
|
1402 |
(NULL,NULL,0,129,129,54), |
|
1403 |
(NULL,NULL,86,129,129,55), |
|
1404 |
(NULL,NULL,0,104,104,56), |
|
1405 |
(NULL,NULL,69,104,104,57), |
|
1406 |
(NULL,NULL,0,255,191,60), |
|
1407 |
(NULL,NULL,0,189,141,62), |
|
1408 |
(NULL,NULL,126,189,173,63), |
|
1409 |
(NULL,NULL,0,129,96,64), |
|
1410 |
(NULL,NULL,86,129,118,65), |
|
1411 |
(NULL,NULL,0,104,78,66), |
|
1412 |
(NULL,NULL,69,104,95,67), |
|
1413 |
(NULL,NULL,0,255,127,70), |
|
1414 |
(NULL,NULL,0,189,94,72), |
|
1415 |
(NULL,NULL,126,189,157,73), |
|
1416 |
(NULL,NULL,0,129,64,74), |
|
1417 |
(NULL,NULL,86,129,107,75), |
|
1418 |
(NULL,NULL,0,104,52,76), |
|
1419 |
(NULL,NULL,69,104,86,77), |
|
1420 |
(NULL,NULL,0,255,63,80), |
|
1421 |
(NULL,NULL,0,189,46,82), |
|
1422 |
(NULL,NULL,126,189,141,83), |
|
1423 |
(NULL,NULL,0,129,31,84), |
|
1424 |
(NULL,NULL,86,129,96,85), |
|
1425 |
(NULL,NULL,69,104,78,87), |
|
1426 |
(NULL,NULL,0,255,0,90), |
|
1427 |
(NULL,NULL,0,189,0,92), |
|
1428 |
(NULL,NULL,126,189,126,93), |
|
1429 |
(NULL,NULL,86,129,86,95), |
|
1430 |
(NULL,NULL,69,104,69,97), |
|
1431 |
(NULL,NULL,63,255,0,100), |
|
1432 |
(NULL,NULL,46,189,0,102), |
|
1433 |
(NULL,NULL,141,189,126,103), |
|
1434 |
(NULL,NULL,31,129,0,104), |
|
1435 |
(NULL,NULL,96,129,86,105), |
|
1436 |
(NULL,NULL,78,104,69,107), |
|
1437 |
(NULL,NULL,127,255,0,110), |
|
1438 |
(NULL,NULL,94,189,0,112), |
|
1439 |
(NULL,NULL,157,189,126,113), |
|
1440 |
(NULL,NULL,64,129,0,114), |
|
1441 |
(NULL,NULL,107,129,86,115), |
|
1442 |
(NULL,NULL,52,104,0,116), |
|
1443 |
(NULL,NULL,86,104,69,117), |
|
1444 |
(NULL,NULL,191,255,0,120), |
|
1445 |
(NULL,NULL,141,189,0,122), |
|
1446 |
(NULL,NULL,173,189,126,123), |
|
1447 |
(NULL,NULL,96,129,0,124), |
|
1448 |
(NULL,NULL,118,129,86,125), |
|
1449 |
(NULL,NULL,78,104,0,126), |
|
1450 |
(NULL,NULL,255,0,63,180), |
|
1451 |
(NULL,NULL,189,0,46,182), |
|
1452 |
(NULL,NULL,189,126,141,183), |
|
1453 |
(NULL,NULL,129,0,31,184), |
|
1454 |
(NULL,NULL,129,86,96,185), |
|
1455 |
(NULL,NULL,255,0,127,190), |
|
1456 |
(NULL,NULL,189,0,94,192), |
|
1457 |
(NULL,NULL,189,126,157,193), |
|
1458 |
(NULL,NULL,129,0,64,194), |
|
1459 |
(NULL,NULL,129,86,107,195), |
|
1460 |
(NULL,NULL,104,0,52,196), |
|
1461 |
(NULL,NULL,104,69,86,197), |
|
1462 |
(NULL,NULL,255,0,191,200), |
|
1463 |
(NULL,NULL,189,0,141,202), |
|
1464 |
(NULL,NULL,189,126,173,203), |
|
1465 |
(NULL,NULL,129,0,96,204), |
|
1466 |
(NULL,NULL,129,86,118,205), |
|
1467 |
(NULL,NULL,104,0,78,206), |
|
1468 |
(NULL,NULL,104,69,95,207), |
|
1469 |
(NULL,NULL,255,0,255,210), |
|
1470 |
(NULL,NULL,189,0,189,212), |
|
1471 |
(NULL,NULL,189,126,189,213), |
|
1472 |
(NULL,NULL,129,0,129,214), |
|
1473 |
(NULL,NULL,129,86,129,215), |
|
1474 |
(NULL,NULL,104,0,104,216), |
|
1475 |
(NULL,NULL,104,69,104,217), |
|
1476 |
(NULL,NULL,191,0,255,220), |
|
1477 |
(NULL,NULL,141,0,189,222), |
|
1478 |
(NULL,NULL,173,126,189,223), |
|
1479 |
(NULL,NULL,96,0,129,224), |
|
1480 |
(NULL,NULL,118,86,129,225), |
|
1481 |
(NULL,NULL,78,0,104,226), |
|
1482 |
(NULL,NULL,95,69,104,227), |
|
1483 |
(NULL,NULL,127,0,255,230), |
|
1484 |
(NULL,NULL,94,0,189,232), |
|
1485 |
(NULL,NULL,157,126,189,233), |
|
1486 |
(NULL,NULL,64,0,129,234), |
|
1487 |
(NULL,NULL,107,86,129,235), |
|
1488 |
(NULL,NULL,52,0,104,236), |
|
1489 |
(NULL,NULL,86,69,104,237), |
|
1490 |
(NULL,NULL,63,0,255,240), |
|
1491 |
(NULL,NULL,46,0,189,242), |
|
1492 |
(NULL,NULL,141,126,189,243), |
|
1493 |
(NULL,NULL,31,0,129,244), |
|
1494 |
(NULL,NULL,96,86,129,245), |
|
1495 |
(NULL,NULL,78,69,104,247); |
|
1440 |
INSERT INTO Colors |
|
1441 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1442 |
VALUES(1, 255, 0, 0, NULL, NULL); |
|
1443 |
INSERT INTO Colors |
|
1444 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1445 |
VALUES(2, 0, 255, 0, NULL, NULL); |
|
1446 |
INSERT INTO Colors |
|
1447 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1448 |
VALUES(3, 255, 0, 255, NULL, NULL); |
|
1449 |
INSERT INTO Colors |
|
1450 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1451 |
VALUES(4, 189, 0, 0, NULL, NULL); |
|
1452 |
INSERT INTO Colors |
|
1453 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1454 |
VALUES(5, 189, 126, 126, NULL, NULL); |
|
1455 |
INSERT INTO Colors |
|
1456 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1457 |
VALUES(6, 129, 86, 86, NULL, NULL); |
|
1458 |
INSERT INTO Colors |
|
1459 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1460 |
VALUES(7, 255, 63, 0, NULL, NULL); |
|
1461 |
INSERT INTO Colors |
|
1462 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1463 |
VALUES(8, 189, 46, 0, NULL, NULL); |
|
1464 |
INSERT INTO Colors |
|
1465 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1466 |
VALUES(9, 189, 141, 126, NULL, NULL); |
|
1467 |
INSERT INTO Colors |
|
1468 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1469 |
VALUES(10, 129, 31, 0, NULL, NULL); |
|
1470 |
INSERT INTO Colors |
|
1471 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1472 |
VALUES(11, 255, 127, 0, NULL, NULL); |
|
1473 |
INSERT INTO Colors |
|
1474 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1475 |
VALUES(12, 189, 94, 0, NULL, NULL); |
|
1476 |
INSERT INTO Colors |
|
1477 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1478 |
VALUES(13, 189, 157, 126, NULL, NULL); |
|
1479 |
INSERT INTO Colors |
|
1480 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1481 |
VALUES(14, 129, 64, 0, NULL, NULL); |
|
1482 |
INSERT INTO Colors |
|
1483 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1484 |
VALUES(15, 104, 52, 0, NULL, NULL); |
|
1485 |
INSERT INTO Colors |
|
1486 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1487 |
VALUES(16, 255, 191, 0, NULL, NULL); |
|
1488 |
INSERT INTO Colors |
|
1489 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1490 |
VALUES(17, 189, 141, 0, NULL, NULL); |
|
1491 |
INSERT INTO Colors |
|
1492 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1493 |
VALUES(18, 189, 173, 126, NULL, NULL); |
|
1494 |
INSERT INTO Colors |
|
1495 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1496 |
VALUES(19, 129, 118, 86, NULL, NULL); |
|
1497 |
INSERT INTO Colors |
|
1498 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1499 |
VALUES(20, 104, 78, 0, NULL, NULL); |
|
1500 |
INSERT INTO Colors |
|
1501 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1502 |
VALUES(21, 189, 189, 0, NULL, NULL); |
|
1503 |
INSERT INTO Colors |
|
1504 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1505 |
VALUES(22, 189, 189, 126, NULL, NULL); |
|
1506 |
INSERT INTO Colors |
|
1507 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1508 |
VALUES(23, 191, 255, 0, NULL, NULL); |
|
1509 |
INSERT INTO Colors |
|
1510 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1511 |
VALUES(24, 141, 189, 0, NULL, NULL); |
|
1512 |
INSERT INTO Colors |
|
1513 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1514 |
VALUES(25, 173, 189, 126, NULL, NULL); |
|
1515 |
INSERT INTO Colors |
|
1516 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1517 |
VALUES(26, 96, 129, 0, NULL, NULL); |
|
1518 |
INSERT INTO Colors |
|
1519 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1520 |
VALUES(27, 127, 255, 0, NULL, NULL); |
|
1521 |
INSERT INTO Colors |
|
1522 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1523 |
VALUES(28, 94, 189, 0, NULL, NULL); |
|
1524 |
INSERT INTO Colors |
|
1525 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1526 |
VALUES(29, 157, 189, 126, NULL, NULL); |
|
1527 |
INSERT INTO Colors |
|
1528 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1529 |
VALUES(30, 64, 129, 0, NULL, NULL); |
|
1530 |
INSERT INTO Colors |
|
1531 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1532 |
VALUES(31, 46, 189, 0, NULL, NULL); |
|
1533 |
INSERT INTO Colors |
|
1534 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1535 |
VALUES(32, 0, 255, 0, NULL, NULL); |
|
1536 |
INSERT INTO Colors |
|
1537 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1538 |
VALUES(33, 126, 189, 141, NULL, NULL); |
|
1539 |
INSERT INTO Colors |
|
1540 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1541 |
VALUES(34, 0, 129, 31, NULL, NULL); |
|
1542 |
INSERT INTO Colors |
|
1543 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1544 |
VALUES(35, 0, 255, 127, NULL, NULL); |
|
1545 |
INSERT INTO Colors |
|
1546 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1547 |
VALUES(36, 0, 189, 94, NULL, NULL); |
|
1548 |
INSERT INTO Colors |
|
1549 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1550 |
VALUES(37, 126, 189, 157, NULL, NULL); |
|
1551 |
INSERT INTO Colors |
|
1552 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1553 |
VALUES(38, 86, 129, 107, NULL, NULL); |
|
1554 |
INSERT INTO Colors |
|
1555 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1556 |
VALUES(39, 0, 255, 191, NULL, NULL); |
|
1557 |
INSERT INTO Colors |
|
1558 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1559 |
VALUES(40, 0, 189, 141, NULL, NULL); |
|
1560 |
INSERT INTO Colors |
|
1561 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1562 |
VALUES(41, 0, 129, 96, NULL, NULL); |
|
1563 |
INSERT INTO Colors |
|
1564 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1565 |
VALUES(42, 86, 129, 118, NULL, NULL); |
|
1566 |
INSERT INTO Colors |
|
1567 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1568 |
VALUES(43, 96, 86, 129, NULL, NULL); |
|
1569 |
INSERT INTO Colors |
|
1570 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1571 |
VALUES(44, 127, 0, 255, NULL, NULL); |
|
1572 |
INSERT INTO Colors |
|
1573 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1574 |
VALUES(45, 94, 0, 189, NULL, NULL); |
|
1575 |
INSERT INTO Colors |
|
1576 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1577 |
VALUES(46, 157, 126, 189, NULL, NULL); |
|
1578 |
INSERT INTO Colors |
|
1579 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1580 |
VALUES(47, 64, 0, 129, NULL, NULL); |
|
1581 |
INSERT INTO Colors |
|
1582 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1583 |
VALUES(48, 107, 86, 129, NULL, NULL); |
|
1584 |
INSERT INTO Colors |
|
1585 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1586 |
VALUES(49, 191, 0, 255, NULL, NULL); |
|
1587 |
INSERT INTO Colors |
|
1588 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1589 |
VALUES(50, 141, 0, 189, NULL, NULL); |
|
1590 |
INSERT INTO Colors |
|
1591 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1592 |
VALUES(51, 173, 126, 189, NULL, NULL); |
|
1593 |
INSERT INTO Colors |
|
1594 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1595 |
VALUES(52, 96, 0, 129, NULL, NULL); |
|
1596 |
INSERT INTO Colors |
|
1597 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1598 |
VALUES(53, 118, 86, 129, NULL, NULL); |
|
1599 |
INSERT INTO Colors |
|
1600 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1601 |
VALUES(54, 255, 0, 255, NULL, NULL); |
|
1602 |
INSERT INTO Colors |
|
1603 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1604 |
VALUES(55, 189, 0, 189, NULL, NULL); |
|
1605 |
INSERT INTO Colors |
|
1606 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1607 |
VALUES(56, 129, 0, 129, NULL, NULL); |
|
1608 |
INSERT INTO Colors |
|
1609 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1610 |
VALUES(57, 255, 0, 191, NULL, NULL); |
|
1611 |
INSERT INTO Colors |
|
1612 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1613 |
VALUES(58, 189, 0, 141, NULL, NULL); |
|
1614 |
INSERT INTO Colors |
|
1615 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1616 |
VALUES(59, 189, 126, 173, NULL, NULL); |
|
1617 |
INSERT INTO Colors |
|
1618 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1619 |
VALUES(60, 129, 0, 96, NULL, NULL); |
|
1620 |
INSERT INTO Colors |
|
1621 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1622 |
VALUES(61, 255, 0, 127, NULL, NULL); |
|
1623 |
INSERT INTO Colors |
|
1624 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1625 |
VALUES(62, 189, 0, 94, NULL, NULL); |
|
1626 |
INSERT INTO Colors |
|
1627 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1628 |
VALUES(63, 104, 0, 52, NULL, NULL); |
|
1629 |
INSERT INTO Colors |
|
1630 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1631 |
VALUES(64, 255, 0, 63, NULL, NULL); |
|
1632 |
INSERT INTO Colors |
|
1633 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1634 |
VALUES(65, 189, 0, 46, NULL, NULL); |
|
1635 |
INSERT INTO Colors |
|
1636 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1637 |
VALUES(66, 189, 126, 141, NULL, NULL); |
|
1638 |
INSERT INTO Colors |
|
1639 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1640 |
VALUES(67, 129, 0, 31, NULL, NULL); |
|
1641 |
INSERT INTO Colors |
|
1642 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1643 |
VALUES(68, 129, 86, 96, NULL, NULL); |
|
1644 |
INSERT INTO Colors |
|
1645 |
(UID, RED, GREEN, BLUE, PROPERTY, VALUE) |
|
1646 |
VALUES(69, 104, 69, 78, NULL, NULL); |
|
1647 | ||
1496 | 1648 | |
1497 | 1649 | |
1498 | 1650 |
CREATE TABLE Configuration ( |
... | ... | |
2052 | 2204 |
NAME VARCHAR(32) NOT NULL |
2053 | 2205 |
UNIQUE, |
2054 | 2206 |
AREA TEXT, |
2055 |
[TEXT], text
|
|
2207 |
[TEXT] TEXT
|
|
2056 | 2208 |
); |
2057 | 2209 | |
2058 | 2210 |
CREATE TABLE TitleBlockValues ( |
... | ... | |
2099 | 2251 |
FOREIGN KEY(SymbolAttribute_UID) REFERENCES SymbolAttribute (UID) |
2100 | 2252 |
); |
2101 | 2253 | |
2102 |
CREATE TABLE CustomCodes ( |
|
2103 |
UID VARCHAR ( 37 ) NOT NULL, |
|
2104 |
Table_UID VARCHAR ( 37 ) NOT NULL, |
|
2105 |
[Name] VARCHAR ( 32 ) NOT NULL, |
|
2106 |
Code VARCHAR ( 32 ) NOT NULL, |
|
2107 |
Description TEXT, |
|
2108 |
Allowables TEXT, |
|
2109 |
CONSTRAINT CustomCodes_PK PRIMARY KEY(UID) |
|
2110 |
); |
|
2111 | ||
2112 |
CREATE TABLE `CustomTables` ( |
|
2113 |
`UID` VARCHAR ( 37 ) NOT NULL, |
|
2114 |
`Name` TEXT NOT NULL UNIQUE, |
|
2115 |
`Description` TEXT, |
|
2116 |
CONSTRAINT `CustomCodes_PK` PRIMARY KEY(`UID`) |
|
2254 |
CREATE TABLE CustomTables ( |
|
2255 |
UID VARCHAR ( 37 ) NOT NULL, |
|
2256 |
[Name] VARCHAR ( 32 ) NOT NULL UNIQUE, |
|
2257 |
Description TEXT, |
|
2258 |
CONSTRAINT CustomTables_PK PRIMARY KEY(UID) |
|
2117 | 2259 |
); |
2118 | 2260 | |
2119 |
CREATE TABLE `CustomCodes` (
|
|
2120 |
`UID` VARCHAR ( 37 ) NOT NULL,
|
|
2121 |
`Table_UID` VARCHAR ( 37 ) NOT NULL,
|
|
2122 |
`Code` VARCHAR ( 32 ) NOT NULL,
|
|
2123 |
`Description` TEXT,
|
|
2124 |
`Allowables` TEXT,
|
|
2125 |
CONSTRAINT `CustomCodes_PK` PRIMARY KEY(`UID`),
|
|
2126 |
FOREIGN KEY(`Table_UID`) REFERENCES `CustomTables`(`UID`)
|
|
2261 |
CREATE TABLE CustomCodes (
|
|
2262 |
UID VARCHAR ( 37 ) NOT NULL,
|
|
2263 |
Table_UID VARCHAR ( 37 ) NOT NULL,
|
|
2264 |
Code VARCHAR ( 32 ) NOT NULL,
|
|
2265 |
Description TEXT,
|
|
2266 |
Allowables TEXT,
|
|
2267 |
CONSTRAINT CustomCodes_PK PRIMARY KEY(UID),
|
|
2268 |
FOREIGN KEY(Table_UID) REFERENCES CustomTables(UID)
|
|
2127 | 2269 |
); |
DTI_PID/DTI_PID/Scripts/SQLite_Project.tables.sql | ||
---|---|---|
15 | 15 |
FOREIGN KEY(`SymbolAttribute_UID`) REFERENCES `SymbolAttribute`(`UID`) |
16 | 16 |
); |
17 | 17 | |
18 |
CREATE TABLE IF NOT EXISTS 'CustomCodes' ( |
|
19 |
`UID` VARCHAR ( 37 ) NOT NULL, |
|
20 |
`Table_UID` VARCHAR ( 37 ) NOT NULL, |
|
21 |
`Name` VARCHAR ( 32 ) NOT NULL, |
|
22 |
`Code` VARCHAR ( 32 ) NOT NULL, |
|
23 |
`Description` TEXT, |
|
24 |
`Allowables` TEXT, |
|
25 |
CONSTRAINT `CustomCodes_PK` PRIMARY KEY(`UID`) |
|
26 |
); |
|
27 | ||
28 | 18 |
CREATE TABLE IF NOT EXISTS `CustomTables` ( |
29 | 19 |
`UID` VARCHAR ( 37 ) NOT NULL, |
30 | 20 |
`Name` TEXT NOT NULL UNIQUE, |
내보내기 Unified diff