I want to set up a very simple sql database to track holocaust deaths, but sql is more crunchy than I thought. Can someone help me out/ do my homework for me?
I just want to do something like this:
Catalogue Number: Just a serial number to the claim.
Type: Article (as in a document or corpse) or Eye=Witness Testimony.
Name: Name of the article or name of the witness.
Number: Number of proven dead.
Source: HyperLink to the source material.
>>58199986
maybe add a scientific notation showing the least significant digit.
If its around 11 thousand add a column that says 11xxx.
create database holocaust;
create table victims(
catalog_num int auto_increment,
type int not null,
name varchar(30) not null,
dead_count int not null,
source text not null,
primary key(catalog_num));
>>58199986
Also, i'm not just counting jewish dead. I'm counting total dead, including jews. I'm counting everyone who died in the concentration camps who wasn't a POW or civilian casualty of war.
Imo it's really too bad that the number of people killed in the holocaust can be expressed with a 32 bit integer.
>>58200055
Noice.
how to add this?
>>58200020
burp
>>58199986
You could probably use the same table for MIA jews, but I only want KIA. ("Action" being the concentration camps)
>when your database has less than 6 million rows
>>58200261
(sigh) I guess you could add one more tag:
JEW, NOTJEW, UNKNOWN
join in the fun
>>>/his/2146501
>>58199986
some data:
Auschwitz-Birkenau, Poland
Belzec, Poland
Bergen-Belsen, Germany
Buchenwald, Germany
Chelmno, PolandDachau, Germany
Flossenburg, Germany
Gross-Rosen, Poland
Janowska, Ukraine
Kaiserwald, Latvia
Majdanek, Poland
Mauthausen, Austria
Mittelbau-Dora, Germany
Natzweiler-Struthof, France
Neuengamme, Germany
Plaszow, Germany
Ravensbruck, Germany
Sachsenhausen, Germany
Sobibor, Poland
Stutthof, Poland
Theresienstadt, Czech Republic
Treblinka, Poland
Westerbork, Netherlands
>>58199986
I don't know what I did with my sexy tranvestite hitler photos.
I mean have fun, but I fell like a project like this MUST exist already. 30 secs googling seems to imply there is.