XaCdFCmw

1console.log('haha')
2var mysql = require('mysql');
3
4var con = mysql.createConnection({
5  host: "localhost",
6  user: "root",
7  password: "root",
8  database: "test1"
9});
10
11con.connect(function(err) {
12  if (err) throw err;
13    console.log("Connected!");
14    let createProjects = `create table if not exists projects(
15        id int primary key auto_increment,
16        name varchar(255)not null,
17        material_price_markup int,
18        delivery_price_markup int,
19        change_suggestions varchar(255),
20        created timestamp,
21        updated timestamp
22    )`;
23
24    let createChangeSuggetions = `create table if not exists change_suggestions(
25        id int primary key auto_increment,
26        change_description varchar(255),
27        status varchar(255),
28        log varchar(255),
29        comments_cost_calculation varchar(255),
30        comments_not_material_cost varchar(255),
31        comments_delivery_plan varchar(255),
32        project_id int,
33        created timestamp,
34        updated timestamp
35    )`;
36
37    let createRates = `create table if not exists rates(
38        id int primary key auto_increment,
39        name varchar(255),
40        rate float,
41        project_id int,
42        created timestamp,
43        updated timestamp
44    )`;
45
46    let createPrice = `create table if not exists price(
47        id int primary key auto_increment,
48        price float,
49        margin float,
50        target_cost float,
51        project_id int,
52        created timestamp,
53        updated timestamp
54    )`;
55
56    let createCosts = `create table if not exists costs(
57        id int primary key auto_increment,
58        material int,
59        NRE int,
60        misc int,
61        quantity int,
62        descripition varchar(255),
63        change_suggestions_id int,
64        rates_id int ,
65        created timestamp,
66        updated timestamp
67    )`;
68
69    let createLogs = `create table if not exists logs(
70        id int primary key auto_increment,
71        what_happened_CS varchar(255),
72        costumer_send_back_and_no_order varchar(255),
73        change_suggestions_id int,
74        created timestamp,
75        updated timestamp
76    )`;
77
78    let createReferences = 
79    `ALTER TABLE change_suggestions ADD FOREIGN KEY (project_id) REFERENCES projects (id);`; 
80    
81    let createReferences2 =
82    `ALTER TABLE price ADD FOREIGN KEY (project_id) REFERENCES projects (id);`;
83
84    let createReferences3 =
85    `ALTER TABLE costs ADD FOREIGN KEY (rates_id) REFERENCES rates (id);`;
86
87    let createReferences4 =
88    `ALTER TABLE projects ADD FOREIGN KEY (id) REFERENCES price (project_id);`;
89
90    let createReferences5 =
91    `ALTER TABLE logs ADD FOREIGN KEY (change_suggestions_id) REFERENCES change_suggestions (id)`;
92
93    let createReferences6 =
94    `ALTER TABLE costs ADD FOREIGN KEY (change_suggestions_id) REFERENCES change_suggestions (id)`;
95
96    let insertdata = `INSERT INTO costs
97    (id, material)
98    VALUES(2, 3);
99    `
100    con.query(insertdata, function(err){
101        if (err) 
102        {
103            console.log(err.message)
104        }
105    })
106    con.query(createProjects, function(err){
107        if (err) {
108            console.log(err.message);
109        }
110    });
111
112    con.query(createChangeSuggetions, function(err){
113        if (err) {
114            console.log(err.message);
115        }
116    });
117
118    con.query(createRates, function(err){
119        if (err) {
120            console.log(err.message);
121        }
122    });
123
124    con.query(createPrice, function(err){
125        if (err) {
126            console.log(err.message);
127        }
128    });
129
130    con.query(createCosts, function(err){
131        if (err) {
132            console.log(err.message);
133        }
134    });
135
136    con.query(createLogs, function(err){
137        if (err) {
138            console.log(err.message);
139        }
140    });
141
142    con.query(createReferences, function(err){
143        if (err) {
144            console.log(err.message);
145        }
146    });
147
148    con.query(createReferences2, function(err){
149        if (err) {
150            console.log(err.message);
151        }
152    });
153
154    con.query(createReferences3, function(err){
155        if (err) {
156            console.log(err.message);
157        }
158    });
159
160    con.query(createReferences4, function(err){
161        if (err) {
162            console.log(err.message);
163        }
164    });
165
166    con.query(createReferences5, function(err){
167        if (err) {
168            console.log(err.message);
169        }
170    });
171
172    con.query(createReferences6, function(err){
173        if (err) {
174            console.log(err.message)
175        }
176    });
177
178    console.log(createCosts)
179
180    con.end(function(err){
181        if (err){
182            return console.log(err.message);
183        }
184    });
185});