liskl

measurement db schema's

Mar 11th, 2015
196
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.00 KB | None | 0 0
  1. DROP TABLE IF EXISTS `power`;
  2. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  3. /*!40101 SET character_set_client = utf8 */;
  4. CREATE TABLE `power` (
  5.   `id` INT(6) UNSIGNED NOT NULL AUTO_INCREMENT,
  6.   `power` VARCHAR(6) NOT NULL,
  7.   `voltage` VARCHAR(6) NOT NULL,
  8.   `kVA` VARCHAR(6) NOT NULL,
  9.   `timedate` VARCHAR(10) NOT NULL,
  10.   `add_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  11.   PRIMARY KEY (`id`),
  12.   UNIQUE KEY `timedate` (`timedate`)
  13. ) ENGINE=InnoDB AUTO_INCREMENT=69319 DEFAULT CHARSET=latin1;
  14.  
  15.  
  16. DROP TABLE IF EXISTS `temperature`;
  17. CREATE TABLE `temperature` (
  18.   `id` INT(6) UNSIGNED NOT NULL AUTO_INCREMENT,
  19.   `inside` VARCHAR(6) NOT NULL,
  20.   `outside` VARCHAR(6) NOT NULL,
  21.   `setting` VARCHAR(6) NOT NULL,
  22.   `timedate` VARCHAR(10) NOT NULL,
  23.   `add_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  24.   PRIMARY KEY (`id`),
  25.   UNIQUE KEY `timedate` (`timedate`)
  26. ) ENGINE=InnoDB AUTO_INCREMENT=69319 DEFAULT CHARSET=latin1;
Advertisement
Add Comment
Please, Sign In to add comment