suyK66MF

1# --------------------------------------------------------
2# Host:                         127.0.0.1
3# Database:                     khmersongs
4# Server version:               5.1.41
5# Server OS:                    Win32
6# HeidiSQL version:             5.0.0.3272
7# Date/time:                    2010-10-16 16:35:35
8# --------------------------------------------------------
9
10/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
11/*!40101 SET NAMES utf8 */;
12/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14
15# Dumping structure for table khmersongs.tbl_production
16CREATE TABLE IF NOT EXISTS `tbl_production` (
17  `pid` int(10) NOT NULL AUTO_INCREMENT,
18  `pname` varchar(250) DEFAULT NULL,
19  `desc` varchar(250) DEFAULT NULL,
20  PRIMARY KEY (`pid`)
21) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
22
23# Dumping data for table khmersongs.tbl_production: 2 rows
24/*!40000 ALTER TABLE `tbl_production` DISABLE KEYS */;
25INSERT INTO `tbl_production` (`pid`, `pname`, `desc`) VALUES (1, 'Hang Meas', 'HM'), (2, 'Bing Man', 'BM');
26/*!40000 ALTER TABLE `tbl_production` ENABLE KEYS */;
27
28
29# Dumping structure for table khmersongs.tbl_songs
30CREATE TABLE IF NOT EXISTS `tbl_songs` (
31  `sid` int(10) NOT NULL AUTO_INCREMENT,
32  `pid` int(10) DEFAULT NULL,
33  `vid` int(10) DEFAULT NULL,
34  `song_title` varchar(250) DEFAULT NULL,
35  PRIMARY KEY (`sid`)
36) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
37
38# Dumping data for table khmersongs.tbl_songs: 10 rows
39/*!40000 ALTER TABLE `tbl_songs` DISABLE KEYS */;
40INSERT INTO `tbl_songs` (`sid`, `pid`, `vid`, `song_title`) VALUES (1, 1, 1, 'Hang Meas Vol 1 , Song 1'), (2, 1, 1, 'Hang Meas Vol 1 , Song 2'), (3, 1, 1, 'Hang Meas Vol 1 , Song 3'), (4, 1, 2, 'Hang Meas Vol 2 , Song 1'), (5, 1, 2, 'Hang Meas Vol 2 , Song 2'), (6, 1, 2, 'Hang Meas Vol 3 , Song 3'), (7, 2, 1, 'Big Man Vol 1, Song 1'), (8, 2, 1, 'Big Man Vol 1, Song 2'), (9, 2, 2, 'Big Man Vol 2, Song 1'), (10, 2, 3, 'Hang Meas Vol 3 , Song 1');
41/*!40000 ALTER TABLE `tbl_songs` ENABLE KEYS */;
42
43
44# Dumping structure for table khmersongs.tbl_volume
45CREATE TABLE IF NOT EXISTS `tbl_volume` (
46  `vid` int(10) NOT NULL AUTO_INCREMENT,
47  `pid` int(10) DEFAULT NULL,
48  `volume_num` int(10) DEFAULT NULL,
49  PRIMARY KEY (`vid`)
50) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
51
52# Dumping data for table khmersongs.tbl_volume: 5 rows
53/*!40000 ALTER TABLE `tbl_volume` DISABLE KEYS */;
54INSERT INTO `tbl_volume` (`vid`, `pid`, `volume_num`) VALUES (1, 1, 1), (2, 1, 2), (3, 2, 1), (4, 2, 2), (5, 1, 3);
55/*!40000 ALTER TABLE `tbl_volume` ENABLE KEYS */;
56/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
57/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
58/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;