-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 12, 2007 at 09:32 AM
-- Server version: 4.0.27
-- PHP Version: 5.2.3


--
-- Table structure for table `articles_master`
--

CREATE TABLE `articles_master` (
  `articles_id` int(20) NOT NULL auto_increment,
  `title` varchar(60) NOT NULL default '',
  `photo1` varchar(60) NOT NULL default '',
  `description` text NOT NULL,
  `status` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`articles_id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

--
-- Dumping data for table `articles_master`
--

INSERT INTO `articles_master` VALUES(2, 'Education in Australia', '119737857603.jpg', 'This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message', '1');

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

--
-- Table structure for table `branch_master`
--

CREATE TABLE `branch_master` (
  `branch_id` int(20) NOT NULL auto_increment,
  `country_id` varchar(20) NOT NULL default '',
  `branch_name` varchar(100) NOT NULL default '',
  `photo1` varchar(60) NOT NULL default '',
  `branch_add` text NOT NULL,
  `phone` varchar(20) NOT NULL default '',
  `fax` varchar(20) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `inst_status` varchar(10) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`branch_id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

--
-- Dumping data for table `branch_master`
--

INSERT INTO `branch_master` VALUES(1, '', 'Path Ways', '', 'J-75, Sector 41\r\nNoida-201301', '0120-2454226', '', 'ardin@ardin.in', '', '1');
INSERT INTO `branch_master` VALUES(2, '', 'Ardin Avenues', '', 'F-12, Krishna Complex\r\nSector 31\r\nNoida-201303', '0120-2454116', '', 'info@ardin.in', '', '1');

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

--
-- Table structure for table `country_master`
--

CREATE TABLE `country_master` (
  `country_id` int(20) NOT NULL auto_increment,
  `country_name` varchar(60) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`country_id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

--
-- Dumping data for table `country_master`
--

INSERT INTO `country_master` VALUES(1, 'Australia', '1');
INSERT INTO `country_master` VALUES(2, 'New Zealand', '1');
INSERT INTO `country_master` VALUES(3, 'Italy', '1');

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

--
-- Table structure for table `institute_master`
--

CREATE TABLE `institute_master` (
  `ins_id` int(20) NOT NULL auto_increment,
  `ins_name` varchar(60) NOT NULL default '',
  `location` varchar(60) NOT NULL default '',
  `country` varchar(60) NOT NULL default '',
  `country_id` int(20) NOT NULL default '0',
  `course` varchar(60) NOT NULL default '',
  `eligibility` varchar(60) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`ins_id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

--
-- Dumping data for table `institute_master`
--

INSERT INTO `institute_master` VALUES(1, 'TAFE NSW', 'Albury\r\nArmidale\r\nBallina\r\nBankstown\r\nBathurst\r\nBaulkham Hil', '1', 0, '''Accidental'' Counselling - TAFE PLUS Statement\r\n2D Graphics', 'This course is no longer accepting new enrolments. However,', '1');
INSERT INTO `institute_master` VALUES(2, 'Northern Melbourne Institute of TAFE', '', '1', 0, '', '', '1');
INSERT INTO `institute_master` VALUES(3, 'Test1', 'Test1', 'New Zealand', 2, 'Test1', 'Test1', '1');
INSERT INTO `institute_master` VALUES(4, 'Test2', 'Test2', 'New Zealand', 2, 'Test2', 'Test2', '1');

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

--
-- Table structure for table `news_master`
--

CREATE TABLE `news_master` (
  `news_id` int(20) NOT NULL auto_increment,
  `title` varchar(60) NOT NULL default '',
  `photo` varchar(60) NOT NULL default '',
  `news_date` varchar(20) NOT NULL default '',
  `description` text NOT NULL,
  `status` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`news_id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

--
-- Dumping data for table `news_master`
--

INSERT INTO `news_master` VALUES(2, 'News1', '11973742861196673857main_img.gif', '10/10/2007', '<p>This is the testing</p>', '1');

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

--
-- Table structure for table `photos`
--

CREATE TABLE `photos` (
  `photo_id` int(20) NOT NULL auto_increment,
  `photo_title` varchar(60) NOT NULL default '',
  `photo` varchar(60) NOT NULL default '',
  `photo_detail` text NOT NULL,
  `press_clipping` varchar(20) NOT NULL default '',
  `status` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`photo_id`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;

--
-- Dumping data for table `photos`
--

INSERT INTO `photos` VALUES(1, '1', '119736880019165609.jpg', '', '', '1');
INSERT INTO `photos` VALUES(2, '2', '119736882919173428.jpg', '', '', '1');
INSERT INTO `photos` VALUES(3, '3', '119736885919173620.jpg', '', '', '1');
INSERT INTO `photos` VALUES(4, '4', '119736888119173636.jpg', '', '', '1');
INSERT INTO `photos` VALUES(5, '5', '11973690921457130501_7ea770edca_b.jpg', '', '1', '0');
INSERT INTO `photos` VALUES(6, '6', '11973691221457992026_31738d39b6_b.jpg', '', '1', '0');
INSERT INTO `photos` VALUES(7, '7', '1197370892189344219_0d06844c62_b.jpg', '', '1', '0');
INSERT INTO `photos` VALUES(8, '8', '1197371041682165550_54d58979d4_b.jpg', '', '1', '0');

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

--
-- Table structure for table `story_master`
--

CREATE TABLE `story_master` (
  `story_id` int(20) NOT NULL auto_increment,
  `title` varchar(60) NOT NULL default '',
  `photo` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `status` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`story_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

--
-- Dumping data for table `story_master`
--

INSERT INTO `story_master` VALUES(1, 'Arvind Vyas', '119737848604.jpg', 'This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message This is a test message', '1');

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

--
-- Table structure for table `tbladmin`
--

CREATE TABLE `tbladmin` (
  `ad_id` int(20) NOT NULL auto_increment,
  `username` varchar(60) NOT NULL default '',
  `password` varchar(60) NOT NULL default '',
  PRIMARY KEY  (`ad_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tbladmin`
--

INSERT INTO `tbladmin` VALUES(1, 'my', 'admin');