Drawer Width - Copy this React, Mui Component to your project
Create component AdminPannel. Than component gives admin user ability to add/delete/change all ra\ows in all tables in database DDL for Table ADRESA CREATE TABLE "ST67003"."ADRESA" ( "ID_ADRESY" NUMBER, "ULICE" VARCHAR2(50 BYTE), "PSC" NUMBER, "MESTO" VARCHAR2(50 BYTE), "CISLOPOPISNE" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "STUDENTI" ; DDL for Table DODAVATEL CREATE TABLE "ST67003"."DODAVATEL" ( "ID_DODAVATELU" NUMBER, "NAZEV" VARCHAR2(30 BYTE), "KONTAKTNIOSOBA" VARCHAR2(50 BYTE), "TELEFON" NUMBER, "EMAIL" VARCHAR2(50 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "STUDENTI" ; DDL for Table FAKTURA CREATE TABLE "ST67003"."FAKTURA" ( "ID_PLATBY" NUMBER, "CISLOUCTU" NUMBER, "DATUMSPLATNOSTI" DATE ) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "STUDENTI" ; DDL for Table HISTORIE_OBJEDNAVEK CREATE TABLE "ST67003"."HISTORIE_OBJEDNAVEK" ( "ID_HISTORIE" NUMBER(19,0) GENERATED ALWAYS AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE , "DATUMZMENY" DATE, "STAVZMENY" VARCHAR2(30 CHAR), "OBJEDNAVKA_ID_OBJEDNAVKY" NUMBER(19,0) ) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "STUDENTI" ; DDL for Table HOTOVOST CREATE TABLE "ST67003"."HOTOVOST" ( "ID_PLATBY" NUMBER, "PRIJATO" NUMBER, "VRACENO" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "STUDENTI" ; DDL for Table KARTA CREATE TABLE "ST67003"."KARTA" ( "ID_PLATBY" NUMBER, "CISLOKARTY" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "STUDENTI" ; DDL for Table KATEGORIE_PRODUKTU CREATE TABLE "ST67003"."KATEGORIE_PRODUKTU" ( "ID_KATEGORIE" NUMBER, "NAZEV" VARCHAR2(50 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "STUDENTI" ; DDL for Table LOG CREATE TABLE "ST67003"."LOG" ( "ID_LOGU" NUMBER, "OPERACE" VARCHAR2(50 BYTE), "NAZEVTABULKY" VARCHAR2(50 BYTE), "DATUMMODIFIKACE" DATE, "OLDVALUES" VARCHAR2(500 BYTE), "NEWVALUES" VARCHAR2(500 BYTE) ) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "STUDENTI" ; DDL for Table OBJEDNAVKA CREATE TABLE "ST67003"."OBJEDNAVKA" ( "ID_OBJEDNAVKY" NUMBER, "DATUM" DATE, "STAV" VARCHAR2(30 BYTE), "MNOZSTVIPRODUKTU" NUMBER, "POZNAMKA" CLOB, "SUPERMARKET_ID_SUPERMARKETU" NUMBER, "ZAKAZNIK_ID_ZAKAZNIKU" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "STUDENTI" LOB ("POZNAMKA") STORE AS SECUREFILE ( TABLESPACE "STUDENTI" ENABLE STORAGE IN ROW CHUNK 8192 NOCACHE LOGGING NOCOMPRESS KEEP_DUPLICATES STORAGE(INITIAL 106496 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ; DDL for Table OBJEDNAVKA_PRODUKT CREATE TABLE "ST67003"."OBJEDNAVKA_PRODUKT" ( "OBJEDNAVKA_ID_OBJEDNAVKY" NUMBER, "PRODUKT_ID_PRODUKTU" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "STUDENTI" ; DDL for Table OBRAZEK CREATE TABLE "ST67003"."OBRAZEK" ( "ID_OBRAZKU" NUMBER, "OBRAZEK" BLOB, "NAZEV" VARCHAR2(50 BYTE), "TYP" VARCHAR2(10 BYTE), "ROZSIRENI" VARCHAR2(10 BYTE), "DATUMNAHRANI" DATE, "DATUMMODIFIKACE" DATE, "AUTHOROPERACE" VARCHAR2(50 BYTE), "PRODUKT_ID_PRODUKTU" NUMBER ) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "STUDENTI" LOB ("OBRAZEK") STORE AS SECUREFILE ( TABLESPACE "STUDENTI" ENABLE STORAGE IN ROW CHUNK 8192 NOCACHE LOGGING NOCOMPRESS KEEP_DUPLICATES ) ; DDL for Table PLATBA CREATE TABLE "ST67003"."PLATBA" ( "ID_PLATBY" NUMBER, "SUMA" NUMBER, "DATUM" DATE, "TYP" VARCHAR2(10 BYTE), "OBJEDNAVKA_ID_OBJEDNAVKY" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "STUDENTI" ; DDL for Table POZICE CREATE TABLE "ST67003"."POZICE" ( "ID_POZICE" NUMBER, "NAZEV" VARCHAR2(50 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "STUDENTI" ; DDL for Table PRODUKT CREATE TABLE "ST67003"."PRODUKT" ( "ID_PRODUKTU" NUMBER, "NAZEV" VARCHAR2(50 BYTE), "CENA" NUMBER, "POPIS" CLOB, "KAT_PROD_ID_KATEGORIE" NUMBER, "SKLAD_ID_SKLADU" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "STUDENTI" LOB ("POPIS") STORE AS SECUREFILE ( TABLESPACE "STUDENTI" ENABLE STORAGE IN ROW CHUNK 8192 NOCACHE LOGGING NOCOMPRESS KEEP_DUPLICATES STORAGE(INITIAL 106496 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ; DDL for Table PRODUKT_DODAVATEL CREATE TABLE "ST67003"."PRODUKT_DODAVATEL" ( "DODAVATEL_ID_DODAVATELU" NUMBER, "PRODUKT_ID_PRODUKTU" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "STUDENTI" ; DDL for Table ROLE CREATE TABLE "ST67003"."ROLE" ( "ID_ROLE" NUMBER, "ROLENAME" VARCHAR2(30 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "STUDENTI" ; DDL for Table SKLAD CREATE TABLE "ST67003"."SKLAD" ( "ID_SKLADU" NUMBER, "NAZEV" VARCHAR2(30 BYTE), "TELEFON" NUMBER, "EMAIL" VARCHAR2(50 BYTE), "ADRESA_ID_ADRESY" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "STUDENTI" ; DDL for Table SUPERMARKET CREATE TABLE "ST67003"."SUPERMARKET" ( "ID_SUPERMARKETU" NUMBER, "NAZEV" VARCHAR2(20 BYTE), "TELEFON" NUMBER, "EMAIL" VARCHAR2(50 BYTE), "ADRESA_ID_ADRESY" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "STUDENTI" ; DDL for Table USER CREATE TABLE "ST67003"."USER" ( "ID_USER" NUMBER, "JMENO" VARCHAR2(30 BYTE), "PRIJMENI" VARCHAR2(30 BYTE), "EMAIL" VARCHAR2(50 BYTE), "PASSWORD" VARCHAR2(128 BYTE), "ROLE_ID_ROLE" NUMBER, "ZAKAZNIK_ID_ZAKAZNIKU" NUMBER, "ZAMNESTNANEC_ID_ZAMNESTNANCE" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "STUDENTI" ; DDL for Table ZAKAZNIK CREATE TABLE "ST67003"."ZAKAZNIK" ( "ID_ZAKAZNIKU" NUMBER, "TELEFON" NUMBER, "ADRESA_ID_ADRESY" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "STUDENTI" ; DDL for Table ZAMNESTNANEC CREATE TABLE "ST67003"."ZAMNESTNANEC" ( "ID_ZAMNESTNANCE" NUMBER, "DATUMZAMESTNANI" DATE, "PRACOVNIDOBA" NUMBER, "SUPERMARKET_ID_SUPERMARKETU" NUMBER, "POZICE_ID_POZICE" NUMBER, "SKLAD_ID_SKLADU" NUMBER, "ZAMNESTNANEC_ID_ZAMNESTNANCE" NUMBER, "ADRESA_ID_ADRESY" NUMBER, "JMENO" VARCHAR2(20 CHAR), "PRIJMENI" VARCHAR2(20 CHAR), "MZDA" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "STUDENTI" ;
