From a40fad78790c7e58585b1d0c9ed10b52bbc3f7ec Mon Sep 17 00:00:00 2001 From: Simon Rettberg Date: Tue, 26 May 2015 14:32:26 +0200 Subject: Update SQL schema dump --- install/content.sql | 2 +- install/schema.sql | 118 +++++++++++++++++++++------------------------------- 2 files changed, 48 insertions(+), 72 deletions(-) (limited to 'install') diff --git a/install/content.sql b/install/content.sql index 10028c5a..d5c5f2ac 100644 --- a/install/content.sql +++ b/install/content.sql @@ -1,2 +1,2 @@ -INSERT INTO property (name, dateline, value) VALUES ('webif-version', 0, 8); +INSERT INTO property (name, dateline, value) VALUES ('webif-version', 0, 10); diff --git a/install/schema.sql b/install/schema.sql index cd9c02c8..2cc68861 100644 --- a/install/schema.sql +++ b/install/schema.sql @@ -1,33 +1,28 @@ SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; --- --- Database: `openslx` --- --- -------------------------------------------------------- --- --- Table structure for table `callback` --- + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; +/*!40101 SET NAMES utf8 */; + + CREATE TABLE `callback` ( `taskid` varchar(40) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `dateline` int(10) unsigned NOT NULL, `cbfunction` varchar(16) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, + `args` text NOT NULL, PRIMARY KEY (`taskid`,`cbfunction`), KEY `dateline` (`dateline`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --- -------------------------------------------------------- --- --- Table structure for table `cat_setting` --- + CREATE TABLE `cat_setting` ( `catid` int(10) unsigned NOT NULL, `sortval` smallint(5) unsigned NOT NULL, PRIMARY KEY (`catid`), KEY `sortval` (`sortval`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --- -------------------------------------------------------- --- --- Table structure for table `clientlog` --- + CREATE TABLE `clientlog` ( `logid` int(10) unsigned NOT NULL AUTO_INCREMENT, `dateline` int(10) unsigned NOT NULL, @@ -40,44 +35,35 @@ CREATE TABLE `clientlog` ( KEY `logtypeid` (`logtypeid`,`dateline`), KEY `clientip` (`clientip`,`dateline`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --- -------------------------------------------------------- --- --- Table structure for table `configtgz` --- + CREATE TABLE `configtgz` ( `configid` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(200) NOT NULL, `filepath` varchar(255) NOT NULL, + `status` enum('OK','OUTDATED','MISSING') NOT NULL DEFAULT 'MISSING', PRIMARY KEY (`configid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --- -------------------------------------------------------- --- --- Table structure for table `configtgz_module` --- + CREATE TABLE `configtgz_module` ( `moduleid` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(200) NOT NULL, `moduletype` varchar(16) NOT NULL, `filepath` varchar(250) NOT NULL, `contents` text NOT NULL, + `version` int(10) unsigned NOT NULL DEFAULT '0', + `status` enum('OK','MISSING','OUTDATED') NOT NULL DEFAULT 'MISSING', PRIMARY KEY (`moduleid`), KEY `title` (`title`), KEY `moduletype` (`moduletype`,`title`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --- -------------------------------------------------------- --- --- Table structure for table `configtgz_x_module` --- + CREATE TABLE `configtgz_x_module` ( `configid` int(10) unsigned NOT NULL, `moduleid` int(10) unsigned NOT NULL, PRIMARY KEY (`configid`,`moduleid`), KEY `moduleid` (`moduleid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --- -------------------------------------------------------- --- --- Table structure for table `eventlog` --- + CREATE TABLE `eventlog` ( `logid` int(10) unsigned NOT NULL AUTO_INCREMENT, `dateline` int(10) unsigned NOT NULL, @@ -88,10 +74,7 @@ CREATE TABLE `eventlog` ( KEY `dateline` (`dateline`), KEY `logtypeid` (`logtypeid`,`dateline`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --- -------------------------------------------------------- --- --- Table structure for table `news` --- + CREATE TABLE `news` ( `newsid` int(10) unsigned NOT NULL AUTO_INCREMENT, `dateline` int(10) unsigned NOT NULL, @@ -100,20 +83,14 @@ CREATE TABLE `news` ( PRIMARY KEY (`newsid`), KEY `dateline` (`dateline`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --- -------------------------------------------------------- --- --- Table structure for table `permission` --- + CREATE TABLE `permission` ( `mask` int(10) unsigned NOT NULL, `identifier` varchar(32) NOT NULL, PRIMARY KEY (`mask`), UNIQUE KEY `identifier` (`identifier`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --- -------------------------------------------------------- --- --- Table structure for table `property` --- + CREATE TABLE `property` ( `name` varchar(50) NOT NULL, `dateline` int(10) unsigned NOT NULL DEFAULT '0', @@ -121,10 +98,7 @@ CREATE TABLE `property` ( PRIMARY KEY (`name`), KEY `dateline` (`dateline`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --- -------------------------------------------------------- --- --- Table structure for table `setting` --- + CREATE TABLE `setting` ( `setting` varchar(28) NOT NULL, `catid` int(10) unsigned NOT NULL, @@ -134,30 +108,36 @@ CREATE TABLE `setting` ( PRIMARY KEY (`setting`), KEY `catid` (`catid`,`setting`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --- -------------------------------------------------------- --- --- Table structure for table `setting_distro` --- + CREATE TABLE `setting_distro` ( `distroid` int(10) unsigned NOT NULL, `setting` varchar(28) NOT NULL, `value` text NOT NULL, + `displayvalue` text NOT NULL, PRIMARY KEY (`distroid`,`setting`), KEY `setting` (`setting`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --- -------------------------------------------------------- --- --- Table structure for table `setting_global` --- + CREATE TABLE `setting_global` ( `setting` varchar(28) NOT NULL, `value` text NOT NULL, + `displayvalue` text NOT NULL, PRIMARY KEY (`setting`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --- -------------------------------------------------------- --- --- Table structure for table `user` --- + +CREATE TABLE `statistic` ( + `logid` int(10) unsigned NOT NULL AUTO_INCREMENT, + `dateline` int(10) unsigned NOT NULL, + `typeid` varchar(30) NOT NULL, + `clientip` varchar(40) NOT NULL, + `username` varchar(255) NOT NULL, + `data` varchar(255) NOT NULL, + PRIMARY KEY (`logid`), + KEY `dateline` (`dateline`), + KEY `logtypeid` (`typeid`,`dateline`), + KEY `clientip` (`clientip`,`dateline`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + CREATE TABLE `user` ( `userid` int(10) unsigned NOT NULL AUTO_INCREMENT, `login` varchar(100) NOT NULL, @@ -170,22 +150,18 @@ CREATE TABLE `user` ( PRIMARY KEY (`userid`), UNIQUE KEY `login` (`login`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --- --- Constraints for dumped tables --- --- --- Constraints for table `configtgz_x_module` --- + + ALTER TABLE `configtgz_x_module` ADD CONSTRAINT `configtgz_x_module_ibfk_1` FOREIGN KEY (`configid`) REFERENCES `configtgz` (`configid`) ON DELETE CASCADE, ADD CONSTRAINT `configtgz_x_module_ibfk_2` FOREIGN KEY (`moduleid`) REFERENCES `configtgz_module` (`moduleid`); --- --- Constraints for table `setting` --- + ALTER TABLE `setting` ADD CONSTRAINT `setting_ibfk_1` FOREIGN KEY (`catid`) REFERENCES `cat_setting` (`catid`) ON UPDATE CASCADE; --- --- Constraints for table `setting_distro` --- + ALTER TABLE `setting_distro` ADD CONSTRAINT `setting_distro_ibfk_1` FOREIGN KEY (`setting`) REFERENCES `setting` (`setting`) ON DELETE CASCADE ON UPDATE CASCADE; + +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; -- cgit v1.2.3-55-g7522