Andreas Zweili
|
ede47123cd
|
add changes after saving the sql studio
|
2017-07-09 20:00:24 +02:00 |
|
Andreas Zweili
|
245c555878
|
add various test data to all tables
|
2017-07-09 19:48:26 +02:00 |
|
Andreas Zweili
|
0308f06dae
|
remove unnecessary code
To remove the database it's not needed to remove all tables beforehand.
|
2017-07-09 19:01:18 +02:00 |
|
Andreas Zweili
|
0b33cd0c09
|
add code to insert all swiss cities
|
2017-07-09 18:58:42 +02:00 |
|
Andreas Zweili
|
48c795939c
|
add the identity property to all the primary keys
|
2017-07-09 18:57:47 +02:00 |
|
Andreas Zweili
|
7db40baaaa
|
add a missing comma
|
2017-07-09 18:39:26 +02:00 |
Andreas Zweili
|
68d9aff0d0
|
move email address to the members table
|
2017-07-03 21:47:34 +02:00 |
|
Andreas Zweili
|
7ba52b07ce
|
add all the required constraints
in addition I've fixed some minor bugs.
|
2017-06-26 21:18:21 +02:00 |
|
Andreas Zweili
|
1d4128e8f9
|
clean up the removal script
|
2017-06-26 21:17:54 +02:00 |
|
Andreas Zweili
|
c347e0d95f
|
closed sql studio
|
2017-06-24 20:10:22 +02:00 |
|
Andreas Zweili
|
887d168df2
|
remove unnecessary parentheses
|
2017-06-24 20:08:30 +02:00 |
|
Andreas Zweili
|
8ab5cd6957
|
switch the attribute reference and the constrait name
To create a constrait you first define the name and then
link to it's target.
|
2017-06-24 20:07:23 +02:00 |
|
Andreas Zweili
|
370af5e89b
|
first draft of the create table script
|
2017-06-24 15:32:42 +02:00 |
|
Andreas Zweili
|
cd3e9ff0d7
|
update after closing the project
|
2017-06-05 13:18:27 +02:00 |
|
Andreas Zweili
|
9171086de8
|
create project for the sql scripts
|
2017-06-05 13:11:26 +02:00 |