joris

Database

Apr 11th, 2012
148
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.41 KB | None | 0 0
  1. # MySQL-Front 5.0  (Build 1.191)
  2.  
  3. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
  4. /*!40101 SET SQL_MODE='' */;
  5. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
  6. /*!40103 SET SQL_NOTES='ON' */;
  7. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */;
  8. /*!40014 SET UNIQUE_CHECKS=0 */;
  9. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS */;
  10. /*!40014 SET FOREIGN_KEY_CHECKS=0 */;
  11.  
  12.  
  13. # Host: localhost    DATABASE: db_channel
  14. # ------------------------------------------------------
  15. # Server version 5.1.30-community
  16.  
  17. #
  18. # TABLE Objects FOR TABLE t_channel_1
  19. #
  20.  
  21. CREATE TABLE `t_channel_1` (
  22.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  23.   `channel` VARCHAR(50) DEFAULT NULL,
  24.   `jam_tayang` TIME DEFAULT NULL,
  25.   `durasi` INT(11) DEFAULT NULL,
  26.   `ditujukan` VARCHAR(100) DEFAULT NULL,
  27.   `tipe_channel` VARCHAR(100) DEFAULT NULL,
  28.   `keterangan` text,
  29.   PRIMARY KEY (`id`)
  30. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  31.  
  32. #
  33. # Dumping DATA FOR TABLE t_channel_1
  34. #
  35. LOCK TABLES `t_channel_1` WRITE;
  36. /*!40000 ALTER TABLE `t_channel_1` DISABLE KEYS */;
  37.  
  38. INSERT INTO `t_channel_1` VALUES (1,'Metro','01:00:00',60,'Semua Umur','berita','Berita untuk semua kalangan');
  39. /*!40000 ALTER TABLE `t_channel_1` ENABLE KEYS */;
  40. UNLOCK TABLES;
  41.  
  42. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  43. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  44. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  45. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
Advertisement
Add Comment
Please, Sign In to add comment