2.0.0_znote_config.sql

main 26 lines · 1 KB Raw
Alex Alex Commit Initial commit 01/10/2026 09:20
1-- ---------------------------------------------------------------------------
2-- ZnoteX 2.0.0 - settings table (needed by the layout system)
3--
4-- Only needed for databases created BEFORE 2.0.0. A fresh import of
5-- SQL/znote_schema.sql already contains this table.
6--
7-- Key/value settings written from the admin panel. The active layout is the
8-- first user of it; anything else the panel should be able to change without
9-- editing config.php belongs here too.
10--
11-- Run once:
12-- mysql -u <user> -p <database> < SQL/migrations/2.0.0_znote_config.sql
13-- ---------------------------------------------------------------------------
14
15CREATE TABLE IF NOT EXISTS `znote_config` (
16 `key` varchar(64) NOT NULL,
17 `value` text NOT NULL,
18 PRIMARY KEY (`key`)
19) ENGINE=InnoDB;
20
21-- Existing sites keep the look they have: 'default' is the current Snavy
22-- layout, moved from layout/ to layouts/default/.
23INSERT INTO `znote_config` (`key`, `value`) VALUES
24('layout', 'default')
25ON DUPLICATE KEY UPDATE `key` = `key`;
26
Top