src/db/sql/forms.sql - master - aristeh/gui

src/db/sql/forms.sql
18 строк3 KB
aristeh
form
16 янв 2026, 16:59
16 янв 2026, 16:595c8ccdf
CREATE TABLE IF NOT EXISTS md_forms (id varchar PRIMARY KEY, name VARCHAR(100), description TEXT, width INTEGER DEFAULT 400, height INTEGER DEFAULT 300, title VARCHAR(200), form_type VARCHAR(50) NOT NULL, parameters JSON);
INSERT or replace  INTO md_forms(id, name, description, width, height, title, form_type, parameters)VALUES(1, 'login', 'форма входа', 300, 400, 'Введите данные для входа в систему', 'элемент', NULL);
CREATE TABLE IF NOT EXISTS md_data_sourse (id varchar PRIMARY KEY, sql VARCHAR, name varchar, parameters JSON);
INSERT or replace INTO md_data_sourse(id, sql, name)VALUES(1,'select name from users', '1');
CREATE TABLE IF NOT EXISTS md_form_widgets (id varchar PRIMARY KEY,  form_id varchar,  element_type VARCHAR(50) NOT NULL, parent_id varchar, parameters JSON, id_data_sourse varchar, callbacks JSON, column_name VARCHAR(100));
INSERT or replace INTO md_form_widgets(id,form_id,element_type,parent_id,parameters,callbacks)VALUES(1,1, 'VerticalLayout'  , NULL, NULL, NULL);
INSERT or replace INTO md_form_widgets(id,form_id,element_type,parent_id,parameters,callbacks)VALUES(2,1, 'HorizontalLayout', 1,NULL, NULL);
INSERT or replace INTO md_form_widgets(id,form_id,element_type,parent_id,parameters,callbacks)VALUES(3,1, 'Text',             2, NULL, NULL);
INSERT or replace INTO md_form_widgets(id,form_id,element_type,parent_id,parameters,callbacks)VALUES(4,1, 'LineEdit' ,        2, NULL, NULL);
INSERT or replace INTO md_form_widgets(id,form_id,element_type,parent_id,parameters,callbacks)VALUES(5,1, 'HorizontalLayout', 1, NULL, NULL);
INSERT or replace INTO md_form_widgets(id,form_id,element_type,parent_id,parameters,callbacks)VALUES(6,1, 'Text',             5, NULL, NULL);
INSERT or replace INTO md_form_widgets(id,form_id,element_type,parent_id,parameters,callbacks)VALUES(7,1, 'LineEdit' ,        5, NULL, NULL);
INSERT or replace INTO md_form_widgets(id,form_id,element_type,parent_id,parameters,callbacks)VALUES(8,1, 'HorizontalLayout', 1, NULL, NULL);
INSERT or replace INTO md_form_widgets(id,form_id,element_type,parent_id,parameters,callbacks)VALUES(9,1, 'Text',             8, NULL, NULL);
INSERT or replace INTO md_form_widgets(id,form_id,element_type,parent_id,parameters,callbacks)VALUES(10,1,'LineEdit',         8, NULL, NULL);
INSERT or replace INTO md_form_widgets(id,form_id,element_type,parent_id,parameters,callbacks)VALUES(11,1,'HorizontalLayout', 1, NULL, NULL);
INSERT or replace INTO md_form_widgets(id,form_id,element_type,parent_id,parameters,callbacks)VALUES(12,1,'Button',           8, NULL, NULL);
CREATE TABLE IF NOT EXISTS md_icons (id INTEGER PRIMARY KEY, name TEXT NOT NULL, category TEXT NOT NULL, tags TEXT, image_data BLOB NOT NULL, width INTEGER NOT NULL, height INTEGER NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP);