· 6 years ago · Jul 17, 2019, 01:14 AM
1
2DROP TABLE IF EXISTS `childdetails`;
3
4CREATE TABLE `childdetails` (
5 `no` int(11) NOT NULL AUTO_INCREMENT,
6 `id` varchar(30) DEFAULT NULL,
7 `name` varchar(50) DEFAULT NULL,
8 `age` int(4) DEFAULT NULL,
9 PRIMARY KEY (`no`)
10) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
11
12INSERT INTO `childdetails` VALUES (1,'C001','Dona',10),(2,'C001','John',11),(3,'C002','Tenga',18),(4,'C002','Joe',15),(5,'C003','Softsea',10);
13
14
15
16DROP TABLE IF EXISTS `customermaster`;
17
18CREATE TABLE `customermaster` (
19 `id` varchar(30) NOT NULL,
20 `name` varchar(50) NOT NULL,
21 `address` varchar(50) DEFAULT NULL,
22 `contact` varchar(30) DEFAULT NULL,
23 `age` int(11) DEFAULT NULL,
24 `email` varchar(30) DEFAULT NULL,
25 PRIMARY KEY (`id`)
26) ENGINE=InnoDB DEFAULT CHARSET=latin1;
27
28INSERT INTO `customermaster` VALUES ('C001','Mike','KL','1123',31,'mk@gmail.com'),('C002','Sonakai','Ampang','543222',38,'sona@gmail.com'),('C003','Jacky','Melaka','45321234',32,'jacky@sit.com'),('C004','Nuck','KL','1123',21,'uck@gmail.com'),('C005','Ahman','Ampang','543222323',41,'ahmp@gmail.com'),('C006','Loo','Melaka','6543234',31,'loo@sit.com'),('C007','Ninee','KL','8765432',21,'nieenee@gmail.com'),('C008','Lepase','PJ','543222323',21,'lepas@gmail.com'),('C009','Sembilan','N.Sembilan','6543245',21,'semb@hotmail.com'),('C010','Mike Mamba','KL','123456',21,'mike@domain.com'),('C011','Mikee Yoo','SA','123457',22,'mikee@domain.com'),('C012','Yueeno','ABC','1963663661',22,'yueeeon@domain.com'),('C013','Mike Mambus','KL','012344456',21,'mbus@domain.com'),('C014','Latei','KL','011345678',30,'lety@yahoo.com'),('C015','Nicee','PJ','0198765432',29,'nice@yahoo.com');
29
30
31DROP TABLE IF EXISTS `salesdetails`;
32
33CREATE TABLE `salesdetails` (
34 `salesid` varchar(30) NOT NULL,
35 `productid` varchar(45) DEFAULT NULL,
36 `unitprice` double DEFAULT NULL,
37 `quantity` int(11) DEFAULT NULL
38) ENGINE=InnoDB DEFAULT CHARSET=latin1;
39
40
41INSERT INTO `salesdetails` VALUES ('S001','Pen',10,5);
42
43
44
45DROP TABLE IF EXISTS `salesmaster`;
46
47CREATE TABLE `salesmaster` (
48 `salesid` varchar(30) NOT NULL,
49 `description` varchar(45) NOT NULL,
50 `total` double DEFAULT NULL,
51 `custid` varchar(30) DEFAULT NULL,
52 PRIMARY KEY (`salesid`)
53) ENGINE=InnoDB DEFAULT CHARSET=latin1;