29 lines
559 B
SQL
Executable File
29 lines
559 B
SQL
Executable File
CREATE TABLE IF NOT EXISTS `config` (
|
|
`id` INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
`mysql_root` TEXT
|
|
);
|
|
|
|
INSERT INTO `config` (`id`, `mysql_root`) VALUES (1, 'admin');
|
|
|
|
CREATE TABLE IF NOT EXISTS `databases` (
|
|
`id` INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
`pid` INTEGER,
|
|
`name` TEXT,
|
|
`username` TEXT,
|
|
`password` TEXT,
|
|
`accept` TEXT,
|
|
`ps` TEXT,
|
|
`addtime` TEXT
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS `master_replication_user` (
|
|
`id` INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
`username` TEXT,
|
|
`password` TEXT,
|
|
`accept` TEXT,
|
|
`ps` TEXT,
|
|
`addtime` TEXT
|
|
);
|
|
|
|
|