diff options
| author | Petr Šmerkl <46304018+SveterCZE@users.noreply.github.com> | 2021-05-02 12:24:41 +0200 |
|---|---|---|
| committer | Petr Šmerkl <46304018+SveterCZE@users.noreply.github.com> | 2021-05-02 12:24:41 +0200 |
| commit | b63d109e25191c0e366bd2746091c4520136c766 (patch) | |
| tree | 242e40e91d09853080fc5614c9a1772d8178c5d6 /db_creation | |
| parent | 4c27334c5313225437c207120501d002a1a61734 (diff) | |
| download | justice-b63d109e25191c0e366bd2746091c4520136c766.tar.gz | |
clean-up redundant files
Diffstat (limited to 'db_creation')
| -rw-r--r-- | db_creation | 97 |
1 files changed, 0 insertions, 97 deletions
diff --git a/db_creation b/db_creation deleted file mode 100644 index 9fc44e0..0000000 --- a/db_creation +++ /dev/null @@ -1,97 +0,0 @@ -CREATE TABLE "companies" ( - "id" INTEGER, - "ico" TEXT NOT NULL UNIQUE, - "nazev" TEXT, - "zapis" DATE, - "sidlo" TEXT, - "oddil" TEXT, - "vlozka" TEXT, - "soud" TEXT, - PRIMARY KEY("id" AUTOINCREMENT) -) - -CREATE TABLE "insolvency_events" ( - "id" INTEGER NOT NULL UNIQUE, - "company_id" TEXT NOT NULL, - "insolvency_event" TEXT UNIQUE, - FOREIGN KEY("company_id") REFERENCES "companies"("id"), - PRIMARY KEY("id" AUTOINCREMENT) -) - -CREATE TABLE "obce" ( - "id" INTEGER NOT NULL, - "obec_jmeno" TEXT NOT NULL UNIQUE, - PRIMARY KEY("id" AUTOINCREMENT) -) - -CREATE TABLE "obce_relation" ( - "company_id" INTEGER NOT NULL UNIQUE, - "obec_id" INTEGER NOT NULL, - FOREIGN KEY("obec_id") REFERENCES "obce"("id"), - FOREIGN KEY("company_id") REFERENCES "companies"("id") -) - -CREATE TABLE "osoby" ( - "id" INTEGER NOT NULL, - "osoba_jmeno" TEXT UNIQUE, - PRIMARY KEY("id" AUTOINCREMENT) -) - -CREATE TABLE "pravni_formy" ( - "id" INTEGER NOT NULL, - "pravni_forma" TEXT NOT NULL UNIQUE, - PRIMARY KEY("id" AUTOINCREMENT) -) - -CREATE TABLE "pravni_formy_relation" ( - "company_id" INTEGER NOT NULL UNIQUE, - "pravni_forma_id" INTEGER NOT NULL, - FOREIGN KEY("pravni_forma_id") REFERENCES "pravni_formy"("id"), - FOREIGN KEY("company_id") REFERENCES "companies"("id") -) - -CREATE TABLE sqlite_sequence(name,seq) - -CREATE TABLE "ulice" ( - "id" INTEGER NOT NULL, - "ulice_jmeno" TEXT NOT NULL UNIQUE, - PRIMARY KEY("id" AUTOINCREMENT) -) - -CREATE TABLE "ulice_relation" ( - "company_id" INTEGER NOT NULL UNIQUE, - "ulice_id" INTEGER NOT NULL, - FOREIGN KEY("company_id") REFERENCES "companies"("id"), - FOREIGN KEY("ulice_id") REFERENCES "ulice"("id") -) - -CREATE TABLE "predmety_cinnosti_relation" ( - "company_id" INTEGER NOT NULL, - "predmet_cinnosti_id" INTEGER NOT NULL, - "zapis_datum" DATE, - "vymaz_datum" DATE, - FOREIGN KEY("company_id") REFERENCES "companies"("id"), - FOREIGN KEY("predmet_cinnosti_id") REFERENCES "predmety_cinnosti"("id") -) - -CREATE TABLE "predmety_podnikani_relation" ( - "company_id" INTEGER NOT NULL, - "predmet_podnikani_id" INTEGER NOT NULL, - "zapis_datum" DATE, - "vymaz_datum" DATE, - FOREIGN KEY("company_id") REFERENCES "companies"("id"), - FOREIGN KEY("predmet_podnikani_id") REFERENCES "predmety_podnikani"("id") -) - -CREATE TABLE "predmety_cinnosti" ( - "id" INTEGER NOT NULL, - "predmet_cinnosti" TEXT NOT NULL UNIQUE, - PRIMARY KEY("id" AUTOINCREMENT) -) - -CREATE TABLE "predmety_podnikani" ( - "id" INTEGER NOT NULL, - "predmet_podnikani" TEXT NOT NULL UNIQUE, - PRIMARY KEY("id" AUTOINCREMENT) -) - |