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
| //********************************************************** table SegControl
req:= 'CREATE TABLE SEGCONTROL (' +
' SEGCONTROL_NO AUTOINCREMENT, ' +
' SEGCONTROL_CONTROL_NO INTEGER NOT NULL, ' +
' CONSTRAINT FK_SegControl2Control FOREIGN KEY (SEGCONTROL_CONTROL_NO) '+
' REFERENCES CONTROL(CONTROL_NO) ON UPDATE CASCADE ON DELETE CASCADE, '+
' SEGCONTROL_SEGNO INTEGER NOT NULL, ' +
' SEGCONTROL_COLOR INTEGER NOT NULL, ' +
' SEGCONTROL_DE SINGLE NOT NULL, ' +
' SEGCONTROL_PERCENT SINGLE NOT NULL, ' +
' SEGCONTROL_L_MAX SINGLE NOT NULL, ' +
' SEGCONTROL_C_MAX SINGLE NOT NULL, ' +
' SEGCONTROL_H_MAX SINGLE NOT NULL, ' +
' SEGCONTROL_L_MIN SINGLE NOT NULL, ' +
' SEGCONTROL_C_MIN SINGLE NOT NULL, ' +
' SEGCONTROL_H_MIN SINGLE NOT NULL, ' +
' SEGCONTROL_L SINGLE NOT NULL, ' +
' SEGCONTROL_A SINGLE NOT NULL, ' +
' SEGCONTROL_B SINGLE NOT NULL, ' +
' SEGCONTROL_DELTA_E_OK_BY_SEG VARCHAR(2) DEFAULT 0, ' +
' SEGCONTROL_USED VARCHAR(2) DEFAULT -1 '+
')';
ADOCommand1.CommandText := req;
ADOCommand1.Execute;
// ==================== Clé primaire
req := 'ALTER TABLE SEGCONTROL ADD CONSTRAINT PK_SEGCONTROL '+
'PRIMARY KEY (SEGCONTROL_NO);';
ADOCommand1.CommandText := req;
ADOCommand1.Execute; |
Partager