ukladani nastaveni pri importu dat

[pohadkar]

pribyla nova tabulka:

-- Struktura tabulky t_imported_settings

CREATE TABLE t_imported_settings ( c_uid int(11) NOT NULL, c_schema varchar(15) NOT NULL, c_layout tinyint(4) NOT NULL, c_name varchar(100) NOT NULL, c_setting text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- -- Klíče pro exportované tabulky

-- -- Klíče pro tabulku t_imported_settings

ALTER TABLE t_imported_settings ADD PRIMARY KEY (c_uid);

-- -- AUTO_INCREMENT pro tabulky

-- -- AUTO_INCREMENT pro tabulku t_imported_settings

ALTER TABLE t_imported_settings MODIFY c_uid int(11) NOT NULL AUTO_INCREMENT;

a tahle je testovaci pro data, ale tu tam asi uz mas

-- -- Struktura tabulky t_imported_data

CREATE TABLE t_imported_data ( c_uid int(11) NOT NULL, c_data json NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- -- Klíče pro exportované tabulky

-- -- Klíče pro tabulku t_imported_data

ALTER TABLE t_imported_data ADD PRIMARY KEY (c_uid);

-- -- AUTO_INCREMENT pro tabulky

-- -- AUTO_INCREMENT pro tabulku t_imported_data

ALTER TABLE t_imported_data MODIFY c_uid int(11) NOT NULL AUTO_INCREMENT;