TrPZ0TEQ

1IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='UnitsDef' AND xtype='U')
2CREATE TABLE UnitsDef
3(
4    UnitsID INTEGER PRIMARY KEY,
5    UnitsName NVARCHAR(32) NOT NULL,
6    UnitsDisplay NVARCHAR(8) NOT NULL
7);
8
9IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='Dimensions' AND xtype='U')
10CREATE TABLE Dimensions
11(
12    DimID INTEGER PRIMARY KEY IDENTITY(0,1),
13    DimX FLOAT,
14    DimXUnitsID INTEGER DEFAULT 0,
15    DimY FLOAT,
16    DimYUnitsID INTEGER DEFAULT 0,
17    DimZ FLOAT,
18    DimZUnitsID INTEGER DEFAULT 0,
19    FOREIGN KEY (DimXUnitsID) REFERENCES UnitsDef(UnitsID), 
20    FOREIGN KEY (DimYUnitsID) REFERENCES UnitsDef(UnitsID),
21    FOREIGN KEY (DimZUnitsID) REFERENCES UnitsDef(UnitsID)
22);
23	
24INSERT INTO UnitsDef (UnitsID, UnitsName, UnitsDisplay) VALUES (0, 'inch', 'in.');
25INSERT INTO UnitsDef (UnitsID, UnitsName, UnitsDisplay) VALUES (1, 'millimeter', 'mm');
26INSERT INTO UnitsDef (UnitsID, UnitsName, UnitsDisplay) VALUES (2, 'degree', '°');