3
# Host: localhost Database: mysqlfs
4
#--------------------------------------------------------
5
# Server version 3.23.33
8
# Table structure for table 'functions'
11
CREATE TABLE functions (
12
type enum('server','database','table','field','key') NOT NULL default 'server',
13
name char(20) NOT NULL default '',
14
sql char(128) NOT NULL default '',
15
PRIMARY KEY (type,name)
19
# Dumping data for table 'functions'
22
INSERT INTO functions VALUES ('server','uptime','SHOW STATUS like \'Uptime\'');
23
INSERT INTO functions VALUES ('server','version','SELECT VERSION()');
24
INSERT INTO functions VALUES ('table','count','SELECT COUNT(*) FROM `%table`');
25
INSERT INTO functions VALUES ('key','min','SELECT MIN(%key) FROM `%table`');
26
INSERT INTO functions VALUES ('key','max','SELECT MAX(%key) FROM `%table`');
27
INSERT INTO functions VALUES ('key','avg','SELECT AVG(%key) FROM `%table`');