My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
database  
Updated May 16, 2012 by archanak...@gmail.com

/ SQLyog Community Edition- MySQL GUI v6.07 Host - 4.1.22-community-nt : Database - airtel Server version : 4.1.22-community-nt /

/!40101 SET NAMES utf8 /;

/!40101 SET SQL_MODE=''/;

create database if not exists airtel;

USE airtel;

/!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /; /!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /;

/Table structure for table activationdetails /

DROP TABLE IF EXISTS activationdetails;

CREATE TABLE activationdetails (

id int(3) unsigned NOT NULL default '0', timestamp timestamp NOT NULL default '0000-00-00 00:00:00', outlet int(3) unsigned NOT NULL default '0', subscriber int(3) unsigned NOT NULL default '0', PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/Data for the table activationdetails /

insert into activationdetails(id,timestamp,outlet,subscriber) values (1,'2009-03-10 10:33:51',1,1),(2,'2009-03-10 17:35:01',1,2),(3,'2009-03-11 11:11:44',1,3),(4,'2009-03-11 13:11:47',1,4);

/Table structure for table activationdetails1 /

DROP TABLE IF EXISTS activationdetails1;

CREATE TABLE activationdetails1 (

id int(3) unsigned NOT NULL default '0', timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, outlet int(3) unsigned NOT NULL default '0', subscriber int(3) unsigned NOT NULL default '0', PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/Data for the table activationdetails1 /

/Table structure for table cardtype /

DROP TABLE IF EXISTS cardtype;

CREATE TABLE cardtype (

id int(3) unsigned NOT NULL default '0', cardType varchar(10) NOT NULL default '', amount int(5) unsigned NOT NULL default '0', distPrice int(5) unsigned NOT NULL default '0', PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/Data for the table cardtype /

insert into cardtype(id,cardType,amount,distPrice) values (1,'CD99',99,84),(2,'CD599',100,90),(3,'rc15',100,9),(4,'rc25',100,19),(5,'rc50',200,44),(6,'rc225',225,200),(7,'rc350',225,200),(8,'CD999',999,900),(9,'rc75',70,65),(10,'CD666',600,560),(11,'RC999',800,600),(12,'rc000',1000,950),(13,'CD777',650,600);

/Table structure for table category /

DROP TABLE IF EXISTS category;

CREATE TABLE category (

id int(3) unsigned NOT NULL default '0', name varchar(5) NOT NULL default '', slab varchar(8) NOT NULL default '', target int(4) unsigned NOT NULL default '0', insentives int(4) unsigned NOT NULL default '0', PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/Data for the table category /

insert into category(id,name,slab,target,insentives) values (1,'A','10-20',40,60),(2,'B','21-50',12,0),(3,'C','50-100',90,10),(4,'D','21-50',45,90);

/Table structure for table competative /

DROP TABLE IF EXISTS competative;

CREATE TABLE competative (

id int(3) unsigned NOT NULL default '0', timestamp timestamp NOT NULL default '0000-00-00 00:00:00', airtel int(5) unsigned default '0', idea int(5) unsigned default '0', hutch int(5) unsigned default '0', bsnl int(5) unsigned default '0', reliance int(5) unsigned default '0', indicom int(5) unsigned default '0', outlet int(3) unsigned NOT NULL default '0', PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/Data for the table competative /

insert into competative(id,timestamp,airtel,idea,hutch,bsnl,reliance,indicom,outlet) values (1,'2007-03-02 00:00:00',2,2,2,2,2,2,1),(2,'2007-03-02 00:00:00',2,2,2,3,3,3,2),(3,'2007-02-02 00:00:00',2,2,2,2,2,2,2),(4,'2007-11-11 00:00:00',1,1,1,1,1,1,3),(5,'2009-03-02 00:00:00',2,2,2,2,2,1,5),(6,'2009-02-09 00:00:00',1,4,6,8,6,7,6);

/Table structure for table distributor /

DROP TABLE IF EXISTS distributor;

CREATE TABLE distributor (

id int(3) unsigned NOT NULL default '0', code int(10) unsigned NOT NULL default '0', glcode int(10) unsigned default '0', address varchar(35) default '', region varchar(20) default '', district varchar(20) default '', hub varchar(15) default '', PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/Data for the table distributor /

insert into distributor(id,code,glcode,address,region,district,hub) values (1,1,101,'srnagar,Ameerpet','Hyderabad','Hyderabad','Hyderabad'),(2,0,10000,'1-3432/a\r\nPnajagutta,beside Central','Panjagutta','RangaReddy','Hitch Communica'),(3,1001,1002,'131234/a/c\r\nErragadda\r\nhyderabad','Erragadda','RangaReddy','Fast Communicat');

/Table structure for table documents /

DROP TABLE IF EXISTS documents;

CREATE TABLE documents (

id int(3) unsigned NOT NULL default '0', documentType varchar(25) NOT NULL default '', PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/Data for the table documents /

insert into documents(id,documentType) values (1,'Driving Licence'),(2,'Electrol ID'),(3,'Electricity Bill'),(4,'PassBook'),(5,'Passport'),(6,'Pancard'),(7,'Ration card');

/Table structure for table easysales /

DROP TABLE IF EXISTS easysales;

CREATE TABLE easysales (

id int(3) unsigned NOT NULL default '0', timestamp timestamp NOT NULL default '0000-00-00 00:00:00', amount int(8) unsigned NOT NULL default '0', outlet int(3) unsigned NOT NULL default '0', flag varchar(5) NOT NULL default '', PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/Data for the table easysales /

insert into easysales(id,timestamp,amount,outlet,flag) values (1,'2009-03-10 10:35:10',500,1,'false'),(2,'2009-03-10 10:52:52',100,1,'false'),(3,'2009-03-10 10:53:46',100,5,'false'),(4,'2009-03-10 13:26:59',10,2,'false'),(5,'2009-03-11 09:15:13',190,1,'false'),(6,'2009-03-11 09:15:20',100,4,'true'),(7,'2009-03-11 09:15:26',100,5,'false'),(8,'2009-03-11 09:15:39',1000,6,'true'),(9,'2009-03-11 09:19:32',290,1,'false'),(10,'2009-03-11 09:23:51',290,1,'false'),(11,'2009-03-11 09:30:40',290,1,'false'),(12,'2009-03-11 09:33:03',290,1,'false'),(13,'2009-03-11 09:34:12',290,1,'false'),(14,'2009-03-11 09:34:40',200,1,'false'),(15,'2009-03-11 09:37:34',290,3,'false'),(16,'2009-03-11 09:39:00',290,2,'false'),(17,'2009-03-11 09:40:36',290,1,'false'),(18,'2009-03-11 09:43:46',290,2,'false'),(19,'2009-03-11 09:45:45',290,1,'false'),(20,'2009-03-11 09:49:27',99680,1,'false'),(21,'2009-03-11 09:56:06',100,2,'false'),(22,'2009-03-11 10:32:15',200,1,'false'),(23,'2009-03-11 10:36:42',100,1,'false'),(24,'2009-03-11 10:36:49',100,1,'false'),(25,'2009-03-11 11:04:45',100,1,'false'),(26,'2009-03-11 11:05:46',100,1,'false'),(27,'2009-03-11 11:09:00',1100,1,'false'),(28,'2009-03-11 11:10:58',100,1,'false'),(29,'2009-03-11 11:15:40',100,1,'false'),(30,'2009-03-11 14:31:33',1000,1,'true');

/Table structure for table easystock /

DROP TABLE IF EXISTS easystock;

CREATE TABLE easystock (

id int(3) unsigned NOT NULL default '0', timestamp timestamp NOT NULL default '0000-00-00 00:00:00', amount int(10) unsigned NOT NULL default '0', tid int(10) unsigned NOT NULL default '0', ddno int(10) unsigned NOT NULL default '0', actuals int(10) unsigned NOT NULL default '0', PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/Data for the table easystock /

insert into easystock(id,timestamp,amount,tid,ddno,actuals) values (1,'2009-03-11 09:56:06',0,1100,112233,100),(2,'2009-03-11 11:04:45',0,1122,114455,100),(3,'2009-03-11 10:32:15',0,115566,223344,100),(4,'2009-03-11 11:05:46',0,114444,10001,100),(5,'2009-03-11 11:10:58',0,101,101,100),(6,'2009-03-11 11:09:00',0,201,201,1000),(7,'2009-03-11 11:15:40',0,1144,5544,100),(8,'2009-03-11 14:31:33',0,102,20021,1000);

/Table structure for table outletdetails /

DROP TABLE IF EXISTS outletdetails;

CREATE TABLE outletdetails (

id int(3) unsigned NOT NULL default '0', name varchar(25) NOT NULL default '', area varchar(20) NOT NULL default '', mobile varchar(11) NOT NULL default '', category int(10) unsigned NOT NULL default '0', payableAmount int(10) unsigned default '0', noOfActivations int(4) unsigned default '0', PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/Data for the table outletdetails /

insert into outletdetails(id,name,area,mobile,category,payableAmount,noOfActivations) values (1,'Ram Communications','Hyderabad','9247104156',1,0,5),(2,'Mobile World','Kakinada','9247845050',2,0,0),(3,'Hello World','Moosapet','9849098491',4,0,0),(4,'Nagesh','siddipet','9848998489',1,0,0),(5,'SaiCommunications','Srnagar','9988776655',1,0,0),(6,'Fast Comm','S.S Nagar','9848485848',2,0,0),(7,'Second','ESI','900011133',3,0,0);

/Table structure for table papersale /

DROP TABLE IF EXISTS papersale;

CREATE TABLE papersale (

id int(3) unsigned NOT NULL default '0', timestamp timestamp NOT NULL default '0000-00-00 00:00:00', count int(5) unsigned NOT NULL default '0', outlet int(3) unsigned NOT NULL default '0', cardType int(3) unsigned NOT NULL default '0', flag varchar(5) NOT NULL default '', PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/Data for the table papersale /

insert into papersale(id,timestamp,count,outlet,cardType,flag) values (1,'2009-02-04 13:44:48',10,1,3,'false'),(2,'2009-02-04 14:10:18',10,1,3,'false'),(3,'2009-03-10 10:36:01',50,1,5,'false'),(4,'2009-03-10 10:53:00',10,1,3,'false'),(5,'2009-03-10 10:53:06',100,1,3,'false'),(6,'2009-03-10 13:27:06',10,2,3,'false'),(7,'2009-03-10 17:44:54',20,3,6,'false'),(8,'2009-03-11 13:12:35',25,1,3,'false');

/Table structure for table paperstock /

DROP TABLE IF EXISTS paperstock;

CREATE TABLE paperstock (

id int(3) unsigned NOT NULL default '0', count int(5) unsigned NOT NULL default '0', cardType int(3) unsigned NOT NULL default '0', invoiceno varchar(15) NOT NULL default '', invoicedate timestamp NOT NULL default '0000-00-00 00:00:00', actuals int(10) unsigned NOT NULL default '0', PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/Data for the table paperstock /

insert into paperstock(id,count,cardType,invoiceno,invoicedate,actuals) values (1,100,3,'12','2007-02-02 00:00:00',100),(2,200,4,'566','2007-03-02 00:00:00',0),(3,180,3,'7878','2007-02-02 00:00:00',0),(4,300,4,'56','2007-03-02 00:00:00',0),(5,100,7,'121','2007-03-03 00:00:00',0),(6,125,7,'4545','2007-04-03 00:00:00',20),(7,79,6,'4545','2007-05-02 00:00:00',15),(8,26,3,'123','2007-02-02 00:00:00',102),(9,212,7,'123','2007-02-02 00:00:00',103),(10,50,5,'110011','2009-03-10 00:00:00',100),(11,20000,9,'5645778','2009-02-09 00:00:00',20000);

/Table structure for table simsale /

DROP TABLE IF EXISTS simsale;

CREATE TABLE simsale (

id int(3) unsigned NOT NULL default '0', timestamp timestamp NOT NULL default '0000-00-00 00:00:00', count int(5) unsigned NOT NULL default '0', outlet int(3) unsigned NOT NULL default '0', cardType int(3) unsigned NOT NULL default '0', flag varchar(5) NOT NULL default '', PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/Data for the table simsale /

insert into simsale(id,timestamp,count,outlet,cardType,flag) values (1,'2008-01-02 22:36:22',90,1,1,'false'),(2,'2008-01-02 22:40:15',10,1,1,'false'),(3,'2008-01-03 19:41:32',10,1,1,'false'),(4,'2008-01-03 20:29:18',1,1,1,'false'),(5,'2008-12-10 22:42:17',50,4,1,'false'),(6,'2009-02-04 13:24:12',10,2,1,'false'),(7,'2009-02-04 13:42:06',10,1,1,'false'),(8,'2009-02-04 14:41:10',10,1,1,'false'),(9,'2009-03-10 10:32:02',100,1,1,'false'),(10,'2009-03-10 10:52:42',10,1,1,'false'),(11,'2009-03-10 13:26:49',10,2,1,'false'),(12,'2009-03-10 17:24:37',150,1,1,'false'),(13,'2009-03-10 17:25:14',30,3,1,'false'),(14,'2009-03-10 17:26:36',100,4,2,'true'),(15,'2009-03-11 09:14:01',76,4,1,'true'),(16,'2009-03-11 09:14:35',76,1,2,'false'),(17,'2009-03-11 11:12:17',100000,1,8,'false'),(18,'2009-03-11 14:27:14',723,1,1,'false'),(19,'2009-03-11 14:29:37',100,6,1,'true');

/Table structure for table simstock /

DROP TABLE IF EXISTS simstock;

CREATE TABLE simstock (

id int(3) unsigned NOT NULL default '0', count int(5) unsigned NOT NULL default '0', cardType int(3) unsigned NOT NULL default '0', invoiceno char(20) NOT NULL default '', invoicedate timestamp NOT NULL default '0000-00-00 00:00:00', actuals int(10) unsigned NOT NULL default '0', PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;

/Data for the table simstock /

insert into simstock(id,count,cardType,invoiceno,invoicedate,actuals) values (1,10,1,'12','2007-02-02 00:00:00',10),(2,20,1,'23','2007-03-02 00:00:00',10),(3,50,2,'1212','2004-03-02 00:00:00',50),(4,65,2,'4545','2006-03-02 00:00:00',15),(5,120,1,'123','2007-02-02 00:00:00',100),(6,166,2,'123','2007-02-02 00:00:00',101),(7,29,1,'123','2007-10-26 00:00:00',100),(8,0,2,'7899','2008-12-01 00:00:00',10),(9,999,1,'44444','2008-12-10 00:00:00',1000),(10,0,1,'110011','2009-03-10 00:00:00',100),(11,0,8,'45843958','2009-02-09 00:00:00',100000),(12,0,1,'101','2009-03-11 00:00:00',100);

/Table structure for table subscriber /

DROP TABLE IF EXISTS subscriber;

CREATE TABLE subscriber (

id int(3) unsigned NOT NULL default '0', name varchar(20) NOT NULL default '', mobile varchar(11) NOT NULL default '', simCode varchar(25) NOT NULL default '', address varchar(35) default '', document int(3) unsigned NOT NULL default '0', PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/Data for the table subscriber /

insert into subscriber(id,name,mobile,simCode,address,document) values (1,'Ramesh','9988776655','554466','srnagar,hyderbad',1),(2,'Mohan','9000111222','14353479587349857908','1/2/3432/a,\r\nAmeerpet\r\nHyderabad',1),(3,'Ramki','3344556677','25464','fhdsfgsd',1),(4,'rajesh','9346962989','112233','hyd',2),(5,'Ram','9000222111','34345364745654','1312/w/s\r\nAmeerpet\r\nHyderabad',5);

/Table structure for table users /

DROP TABLE IF EXISTS users;

CREATE TABLE users (

id int(3) unsigned NOT NULL default '0', userName varchar(20) NOT NULL default '', password varchar(20) NOT NULL default '', first varchar(20) NOT NULL default '', last varchar(20) NOT NULL default '', mobile varchar(15) NOT NULL default '', salary int(6) unsigned NOT NULL default '0', authType int(3) unsigned NOT NULL default '0', PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/Data for the table users /

insert into users(id,userName,password,first,last,mobile,salary,authType) values (2,'ramesh','ramesh','ramesh','b','9247104156',5000,0),(3,'airtel','airtel','admin','admin','9849098490',5001,1),(4,'venkat','venkat','venkat','k','9988775544',5000,0),(5,'First','first','First','user','9867897623',4000,0);

/!40101 SET SQL_MODE=@OLD_SQL_MODE /; /!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;

Powered by Google Project Hosting