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
|
/* Open a DB file for output */
filename
'map.mdb'
append
/* Create DataBase */
'CREATE DATABASE ':Map-name';'
newline
newline
/* Create table Intentions */
'CREATE TABLE Intentions ' newline
'(I_id integer PRIMARY KEY auto_increment, 'newline
'I_Name varchar(30)); 'newline
newline
/* Create table Strategies */
'CREATE TABLE Strategies 'newline
'(Strat_id integer PRIMARY KEY auto_increment, 'newline
'Strat_Name varchar(30), 'newline
'Prod_consume boolean, 'newline
'Prod_generate boolean); 'newline
newline
/* Create table Sections */
'CREATE TABLE Sections 'newline
'(Section_id integer PRIMARY KEY auto_increment, 'newline
'I_id-source integer, 'newline
'I_id-target integer, 'newline
'Strat_id varchar(30), 'newline
'Strat_id integer references Strategies(Strat_id),'newline
'I_id-source integer references Intentions(I_id), 'newline
'I_id-target integer references Intentions(I_id)); 'newline
newline
/* Create table Realized_Intention */
'CREATE TABLE Realized_Intention ' newline
'(RI_id integer PRIMARY KEY auto_increment, 'newline
'I_id integer, 'newline
'Produit varchar(30), 'newline
'I_id integer references Intentions(I_id)); 'newline
newline
/* Create table Parameters */
'CREATE TABLE Parameters 'newline
'(Id_param integer PRIMARY KEY auto_increment, 'newline
'Param varchar(30), 'newline
'Strat_id interger, 'newline
'Strat_id integer references Strategies(Strat_id));'newline
newline
/* Create table Exclusion_constraints */
'CREATE TABLE Exclusion_constraints ' newline
'(Strat_id1 integer PRIMARY KEY , 'newline
'Strat_id2 integer PRIMARY KEY, 'newline
'Type_constraints varchar(30), 'newline
'Strat_id1 integer references Strategies(Strat_id), 'newline
'Strat_id2 integer references Strategies(Strat_id)); 'newline
newline
/* Create table Scenarios */
'CREATE TABLE Scenarios ' newline
'(SC_id integer PRIMARY KEY auto_increment, 'newline
'SC_Name varchar(30)); 'newline
newline
/* Create table Goals */
'CREATE TABLE Goals ' newline
'(G_id integer PRIMARY KEY auto_increment, 'newline
'G_Name varchar(30)); 'newline
newline
/* Create table RCs */
'CREATE TABLE RCs 'newline
'(RC_id integer PRIMARY KEY auto_increment, 'newline
'RC_name varchar(30), 'newline
'SC_id interger, 'newline
'G_id interger, 'newline
'SC_id integer references Scenarios(SC_id),'newline
'G_id integer references Goals(G_id));'newline
newline
/* Create table RC_hierarchies */
'CREATE TABLE RC_hierarchies ' newline
'(RC_id integer PRIMARY KEY, 'newline
'RC1_id interger, 'newline
'RC2_id interger, 'newline
'Operators varchar(30), 'newline
'RC_id integer references RCs(RC_id),'newline
'RC1_id integer references RCs(RC1_id),'newline
'RC2_id integer references RCs(RC2_id));'newline
newline
/* Create table Candidate_sections */
'CREATE TABLE Candidate_sections ' newline
'(Candidate_id integer PRIMARY KEY auto_increment, 'newline
'RI_id interger, 'newline
'I_id-source interger, 'newline
'Strat_id interger, 'newline
'I_id-target interger, 'newline
'RC_id-in interger, 'newline
'RI_id integer references Realized_Intention(RI_id),'newline
'I_id-source integer references Intentions(I_id),'newline
'Strat_id integer references Strategies(Strat_id),'newline
'I_id-target integer references Intentions(I_id),'newline
'RC_id-in integer references RCs(RC_id));'newline
newline
/* Create table Executed_sections */
'CREATE TABLE Executed_sections ' newline
'(exe_sec_id integer PRIMARY KEY auto_increment, 'newline
'RI_source interger, 'newline
'RI_target interger, 'newline
'Strat_id interger, 'newline
'RC_id-in interger, 'newline
'RC_id-out interger, 'newline
'RI_source integer references Realized_Intention(RI_id),'newline
'RI_target integer references Realized_Intention(RI_id),'newline
'Strat_id integer references Strategies(Strat_id),'newline
'RC_id-in integer references RCs(RI_id),'newline
'RC_id-out integer references RCs(RC_id));'newline
newline
/* close the output file */
close
/* Launch the Access */
external 'map.mdb' execute
endreport |
Partager