# phpMyAdmin SQL Dump
# version 2.5.4
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Jun 02, 2006 at 04:56 PM
# Server version: 4.0.16
# PHP Version: 4.3.4
# 
# Database : `report`
# 

# --------------------------------------------------------

#
# Table structure for table `cdr_profile_in`
#

CREATE TABLE `cdr_profile_in` (
  `kode` int(11) NOT NULL auto_increment,
  `MSCID` varchar(20) default NULL,
  `NETYPE` varchar(30) default NULL,
  `FILENAME` varchar(50) default NULL,
  `FILESIZE` varchar(50) default NULL,
  `TT_RECORD` varchar(50) default NULL,
  `TD_FR` varchar(50) default NULL,
  `TD_TO` varchar(50) default NULL,
  `TT_FR` time default NULL,
  `TT_TO` time default NULL,
  `TR_GROUP` varchar(50) default NULL,
  `PROCESS_DATE` varchar(50) default NULL,
  `PREPAID` varchar(50) default NULL,
  `POSTPAID` varchar(70) default NULL,
  `nama_file` varchar(50) default NULL,
  PRIMARY KEY  (`kode`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;

#
# Dumping data for table `cdr_profile_in`
#

INSERT INTO `cdr_profile_in` VALUES (1, 'SMG1', 'MSC', 'TI012378', '29353984', '152218', '20050417', '20050417', '21:26:03', '21:56:01', '21:00', '20050417', '', '', 'april12_17.txt');
INSERT INTO `cdr_profile_in` VALUES (2, 'BDG1', 'MSC', 'TI019048', '16777216', '86379', '20050411', '20050411', '22:01:11', '22:28:01', '22:00', '20050412\r\n', '', '', 'april12_17.txt');
INSERT INTO `cdr_profile_in` VALUES (3, 'BDG1', 'MSC', 'TI019049', '14835712', '76358', '20050411', '20050411', '22:26:33', '22:58:34', '22:00', '20050412\r\n', '', '', 'april12_17.txt');
INSERT INTO `cdr_profile_in` VALUES (4, 'BDG1', 'MSC', 'TI019050', '10686464', '55103', '20050411', '20050411', '22:58:35', '23:28:38', '22:30', '20050412\r\n', '', '', 'april12_17.txt');
INSERT INTO `cdr_profile_in` VALUES (5, 'BDG1', 'MSC', 'TI019051', '6920192', '36123', '20050411', '20050411', '23:26:19', '23:33:48', '23:00', '20050412\r\n', '', '', 'april12_17.txt');
INSERT INTO `cdr_profile_in` VALUES (6, 'BDG1', 'MSC', 'TI019052', '4739072', '24852', '20050411', '20050412', '23:58:41', '00:28:43', '23:30', '20050412\r\n', '', '', 'april12_17.txt');
INSERT INTO `cdr_profile_in` VALUES (7, 'BDG1', 'MSC', '0', '3100672', '16238', '20050412', '20050412', '00:28:43', '00:58:42', '00:00', '20050412\r\n', '', '', 'april12_17.txt');
INSERT INTO `cdr_profile_in` VALUES (8, 'BDG1', 'MSC', 'TI019054', '2250752', '11722', '20050412', '20050412', '00:58:42', '01:28:44', '00:30', '20050412\r\n', '', '', 'april12_17.txt');
INSERT INTO `cdr_profile_in` VALUES (9, 'BDG1', 'MSC', 'TI019055', '1830912', '9503', '20050412', '20050412', '01:28:44', '01:58:46', '01:00', '20050412\r\n', '', '', 'april12_17.txt');
INSERT INTO `cdr_profile_in` VALUES (10, 'BDG1', 'MSC', 'TI019056', '1159168', '6093', '20050412', '20050412', '01:58:46', '02:28:38', '01:30', '20050412\r\n', '', '', 'april12_17.txt');
INSERT INTO `cdr_profile_in` VALUES (11, 'BDG1', 'MSC', 'TI019057', '974848', '5073', '20050412', '20050412', '02:28:38', '02:58:50', '02:00', '20050412\r\n', '', '', 'april12_17.txt');
INSERT INTO `cdr_profile_in` VALUES (12, 'BDG1', 'MSC', 'TI019058', '829440', '4300', '20050412', '20050412', '02:58:51', '03:28:50', '02:30', '20050412', '', '', 'april12_17.txt');

# --------------------------------------------------------

#
# Table structure for table `file`
#

CREATE TABLE `file` (
  `no` int(11) NOT NULL auto_increment,
  `nama` text,
  `keterangan` text,
  PRIMARY KEY  (`no`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

#
# Dumping data for table `file`
#

INSERT INTO `file` VALUES (1, 'april12_17.txt', '');
INSERT INTO `file` VALUES (2, 'april12_17.txt', '');

# --------------------------------------------------------

#
# Table structure for table `user_login`
#

CREATE TABLE `user_login` (
  `id` int(11) NOT NULL auto_increment,
  `no` varchar(10) default NULL,
  `username` varchar(60) default NULL,
  `fullname` varchar(70) default NULL,
  `password` varchar(10) default NULL,
  `verify` varchar(10) default NULL,
  `division` varchar(50) NOT NULL default '',
  `grp` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

#
# Dumping data for table `user_login`
#

INSERT INTO `user_login` VALUES (1, NULL, 'blink', 'user', 'blink', 'blink', 'zero', '1');
    