-- http://www.phpmyadmin.net
--




--
-- Database: `servicemanager`
--

-- --------------------------------------------------------

--
-- Table structure for table `app_store`
--



CREATE TABLE IF NOT EXISTS `app_store` (
  `App_Id` int(10) NOT NULL AUTO_INCREMENT,
  `App_Name` varchar(255) NOT NULL,
  `App_Description` varchar(40) NOT NULL,
  
`App_Cost` int(10) NOT NULL,
  `download_Link` text NOT NULL,
  `application` varchar(20) NOT NULL,
  `source_link` varchar(255) NOT NULL,
  PRIMARY KEY (`App_Id`)
) 
ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;



--
-- Dumping data for table `app_store`
--


INSERT INTO `app_store` (`App_Id`, `App_Name`, `App_Description`, `App_Cost`, `download_Link`, `application`, `source_link`) 
VALUES
(1, 'Subway ', 'An amazing adventure game ', 5, '', 'Games', 'http://localhost/webbasemobileapplication/img/Subway_Surfer.jpg'),

      (2, 'dont bite the dck', 'This just a ringtone', 2, '', 'Ringtones', 'http://localhost/webbasemobileapplication/audio/dont_bite_the_dck.mp3'),

      (3, 'What make you beautifull', 'One direction band song', 2, '', 'Ringtones', 'http://localhost/webbasemobileapplication/audio/one-direction-what-makes-you-beautiful.mp3');



-- --------------------------------------------------------

--
-- Table structure for table `credit_cards`
--



CREATE TABLE IF NOT EXISTS `credit_cards` (
  `Serial_num` bigint(20) NOT NULL,
  `Card_num` bigint(20) NOT NULL,
  `Card_Credit` int(10) NOT NULL,
  `Validity` tinyint(1) NOT NULL,
  PRIMARY KEY (`Serial_num`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


--
-- Dumping data for table `credit_cards`


--

INSERT INTO `credit_cards` 
(`Serial_num`, `Card_num`, `Card_Credit`, `Validity`) 
VALUES
(1112040523185196, 2306757136047612, 10, 1),

(1112040551165056, 2242296305600851, 10, 1),

(1201120507147157, 2983490103556839, 10, 1),

(1201120521157673, 2623061704392016, 10, 1),

(1201129514184828, 2972980674526017, 5, 1),

(1201130506188828, 2131968374765566, 10, 1),

(1201130529117439, 2799773039979282, 10, 1),

(1201130545181147, 2826365685531722, 5, 1),

(1201130563157065, 2191810130533131, 5, 1),

(1201130588148328, 2025800071319821, 5, 0),

(1201200556198506, 2548252068584038, 5, 1),

(1201210557142217, 2078519433086571, 5, 1),

(1201220559129125, 2093404393730903, 5, 1),

(1212060503189884, 2865164818060597, 5, 1),

(1212060546104233, 2982911620649892, 5, 1),

(1212060574196941, 2171435566358488, 5, 1);



-- --------------------------------------------------------

--
-- Table structure for table `services`
--


CREATE TABLE IF NOT EXISTS `services` (
  `Service_id` int(10) NOT NULL,
  `Service_name` varchar(20) NOT NULL,
  `Description` varchar(40) NOT NULL,
  `Cost` int(10) NOT NULL,
  `Period` int(11) NOT NULL,
  `Service` varchar(30) NOT NULL,
  `image_link` text NOT NULL,
  PRIMARY KEY (`Service_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



--
-- Dumping data for table `services`
--


INSERT INTO `services` (`Service_id`, `Service_name`, `Description`, `Cost`, `Period`, `Service`, `image_link`) 
VALUES
(1, 'News', 'SMS News', 1, 86400, 'sms', 'http://localhost/webbasemobileapplication/img/sms_news.jpg'),

(2, 'Sport', 'SMS Sport', 1, 86400, 'sms', 'http://localhost/webbasemobileapplication/img/sms_sport.jpg'),

(3, 'Entertainment', 'SMS Entertainment', 2, 86400, 'sms', 'http://localhost/webbasemobileapplication/img/sms_Entertainment.jpg'),

(4, 'News', 'MMS News', 2, 0, 'mms', 'http://localhost/webbasemobileapplication/img/mms_news.png'),

(5, 'Sport', 'MMS Sport', 2, 0, 'mms', 'http://localhost/webbasemobileapplication/img/mms_sport.jpg'),

(6, 'Entertainment', 'MMS Entertainment', 5, 0, 'mms', 'http://localhost/webbasemobileapplication/img/mms_Entertainment.jpg'),

(7, 'Daily_service', 'Discounts In The Internet For a Day', 1, 1, 'internet', 'http://localhost/webbasemobileapplication/img/daily_service.jpg'),

(8, 'Weekly_service', 'Discounts In The Internet For a Week', 5, 5, 'internet', 'http://localhost/webbasemobileapplication/img/weekly_service.jpg'),

(9, 'monthly_service', 'Discounts In The Internet For a Month', 25, 30, 'internet', 'http://localhost/webbasemobileapplication/img/monthly_service.jpg');



-- --------------------------------------------------------

--
-- Table structure for table `ser_trace`
--


CREATE TABLE IF NOT EXISTS `ser_trace` (
  `Cus_num` int(10) NOT NULL,
  `Service_id` int(10) NOT NULL,
  `From` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `To` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`Cus_num`,`Service_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



--
-- Dumping data for table `ser_trace`
--


INSERT INTO `ser_trace` (`Cus_num`, `Service_id`, `From`, `To`) 
VALUES
(922683731, 1, '2013-06-21 00:27:52', '2013-06-22 09:27:52'),

(922683731, 3, '2013-06-20 23:55:20', '2013-06-22 08:55:20'),

(923559088, 1, '2013-06-19 21:05:52', '2013-06-23 18:04:40'),

(923559088, 2, '2013-06-20 23:15:58', '2013-06-22 08:15:58'),

(923559088, 3, '2013-06-20 23:22:56', '2013-06-22 08:22:56'),

(926762624, 1, '2013-06-23 09:37:08', '2013-06-24 18:37:08'),

(926762624, 2, '2013-06-20 22:58:26', '2013-06-22 19:58:26'),

(926762624, 3, '2013-06-20 22:58:57', '2013-06-22 19:58:57');









