프로젝트

일반

사용자정보

개정판 0cf44537

ID0cf44537fd05764c602868f0910acad386275ca1
상위 5cd31914
하위 2ac0bada, ef4aed65

함의성이(가) 약 5년 전에 추가함

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