1
CREATE SCHEMA data_dictionary;
3
SELECT count(*) FROM plugins;
6
SELECT count(*) FROM modules;
9
show create table MODULES ;
11
MODULES CREATE TABLE `modules` (
12
`MODULE_NAME` varchar(64) NOT NULL DEFAULT '',
13
`MODULE_VERSION` varchar(20) NOT NULL DEFAULT '',
14
`MODULE_AUTHOR` varchar(64) NOT NULL DEFAULT '',
15
`IS_BUILTIN` varchar(5) NOT NULL DEFAULT '',
16
`MODULE_LIBRARY` varchar(254) NOT NULL DEFAULT '',
17
`MODULE_DESCRIPTION` varchar(254) NOT NULL DEFAULT '',
18
`MODULE_LICENSE` varchar(80) NOT NULL DEFAULT ''
19
) ENGINE=FunctionEngine
20
show create table PLUGINS ;
22
PLUGINS CREATE TABLE `plugins` (
23
`PLUGIN_NAME` varchar(64) NOT NULL DEFAULT '',
24
`PLUGIN_TYPE` varchar(64) NOT NULL DEFAULT '',
25
`IS_ACTIVE` varchar(5) NOT NULL DEFAULT '',
26
`MODULE_NAME` varchar(64) NOT NULL DEFAULT ''
27
) ENGINE=FunctionEngine
28
CREATE SCHEMA drizzleslap;
29
DROP SCHEMA drizzleslap;
30
DROP SCHEMA data_dictionary;