| Server IP : 93.86.61.54 / Your IP : 216.73.216.206 Web Server : Apache/2.4.62 (Ubuntu) System : Linux rasin.ddns.net 6.8.0-124-generic #124~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Tue May 26 21:05:19 UTC x86_64 User : www-data ( 33) PHP Version : 8.4.22 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/projects/isvtgme/db/ |
Upload File : |
/* Navicat MySQL Data Transfer Source Server : NET-NAS Source Server Version : 50130 Source Host : 192.168.213.25:3306 Source Database : isvtg Target Server Type : MYSQL Target Server Version : 50130 File Encoding : 65001 Date: 2023-04-07 22:17:57 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `datalog` -- ---------------------------- DROP TABLE IF EXISTS `datalog`; CREATE TABLE `datalog` ( `id` int(5) NOT NULL AUTO_INCREMENT, `vtgid` varchar(3) NOT NULL, `dattim` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP, `baro` decimal(6,2) DEFAULT '0.00', `temp` decimal(5,2) DEFAULT '0.00', `humi` decimal(5,2) DEFAULT '0.00', `wind` int(5) DEFAULT '0', `sun` int(5) DEFAULT NULL, `turb` int(5) DEFAULT '0', `gen` int(5) DEFAULT '0', `acv` double(8,2) DEFAULT '0.00', `acu` double(8,2) DEFAULT NULL, `act` double(8,2) DEFAULT NULL, `dcv` double(8,2) DEFAULT '0.00', `dca` double(8,2) DEFAULT '0.00', `gtmp` double(5,1) DEFAULT NULL, `brk` int(1) DEFAULT NULL, `par1` int(5) DEFAULT NULL, `par2` int(5) DEFAULT NULL, `par3` int(5) DEFAULT NULL, PRIMARY KEY (`id`,`vtgid`,`dattim`), KEY `timams` (`vtgid`) USING BTREE, KEY `timtim` (`dattim`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=60497 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of datalog -- ----------------------------