Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE IF EXISTS `power`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `power` (
- `id` INT(6) UNSIGNED NOT NULL AUTO_INCREMENT,
- `power` VARCHAR(6) NOT NULL,
- `voltage` VARCHAR(6) NOT NULL,
- `kVA` VARCHAR(6) NOT NULL,
- `timedate` VARCHAR(10) NOT NULL,
- `add_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`),
- UNIQUE KEY `timedate` (`timedate`)
- ) ENGINE=InnoDB AUTO_INCREMENT=69319 DEFAULT CHARSET=latin1;
- DROP TABLE IF EXISTS `temperature`;
- CREATE TABLE `temperature` (
- `id` INT(6) UNSIGNED NOT NULL AUTO_INCREMENT,
- `inside` VARCHAR(6) NOT NULL,
- `outside` VARCHAR(6) NOT NULL,
- `setting` VARCHAR(6) NOT NULL,
- `timedate` VARCHAR(10) NOT NULL,
- `add_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`),
- UNIQUE KEY `timedate` (`timedate`)
- ) ENGINE=InnoDB AUTO_INCREMENT=69319 DEFAULT CHARSET=latin1;
Advertisement
Add Comment
Please, Sign In to add comment