delete_data.sql 1.17 KB
SELECT
    set_config('var.user_id', '0', FALSE);
DELETE FROM dictionary_inputform;
DELETE FROM dictionary_inputlexeme;
DELETE FROM history;
DELETE FROM dictionary_savedexportdata;
DELETE FROM dictionary_savedfilter;
DELETE FROM dictionary_lexemeform;
DELETE FROM paradygmatywsjp;
DELETE FROM warianty;
DELETE FROM odsylacze;
DELETE FROM typyodsylaczy;
DELETE FROM leksemy_w_slownikach;
DELETE FROM kwalifikatory_odmieniasiow;
DELETE FROM odmieniasie;
DELETE FROM dictionary_lexemecv;
DELETE FROM kwalifikatory_leksemow;
DELETE FROM dictionary_lexemeav;
DELETE FROM dictionary_lexemeattributevalue;
DELETE FROM dictionary_lexemeattribute_parts_of_speech;
DELETE FROM dictionary_lexemeattribute;
DELETE FROM leksemy;
DELETE FROM kwalifikatory_zakonczen;
DELETE FROM zakonczenia;
DELETE FROM wzory;
DELETE FROM typywzorow;
DELETE FROM charfle;
DELETE FROM efobazy;
DELETE FROM klasygramatyczne;
DELETE FROM czescimowy;
DELETE FROM kwalifikatory;
DELETE FROM klasy_wykluczania;

--delete from wartosci_klasyfikacji;
--delete from klasyfikacje;

--delete from slowniki_managers;
--delete from slowniki_editors;
--delete from slowniki_classifications;
--delete from slowniki_viewers;
--delete from slowniki;