-
Notifications
You must be signed in to change notification settings - Fork 0
/
Table_Values.sql
121 lines (109 loc) · 8.24 KB
/
Table_Values.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
INSERT INTO USERS VALUES(234689327403,'SAI',24,190,'Countryside Drive','Pheonix','AZ',72730,1,0,0,1);
INSERT INTO USERS VALUES(234789317404,'SHREY',26,204,'Blue Hills Drive','Nashville','TX',37214,1,0,0,0);
INSERT INTO USERS VALUES(234889307405,'SARTHAK',29,200,'Redwood Road','Nashville','TX',60401,1,0,0,0);
INSERT INTO USERS VALUES(234989297406,'MICHEAL',31,187,'Elmwood Drive','Panama','FL',31407,1,0,0,0);
INSERT INTO USERS VALUES(235089287407,'RACHEAL',54,711,'North 51st Avenue','Pheonix','AZ',85301,0,1,0,0);
INSERT INTO USERS VALUES(235189277408,'KHUSHI',24,154,'Boca Lagoon Drive','Panama','FL',32408,0,1,0,0);
INSERT INTO USERS VALUES(235289267409,'PARTHVI',27,125,'John Street','Medford','CA',95060,0,1,0,0);
INSERT INTO USERS VALUES(235389257410,'LUCIFER',38,105,'Park Avenue','Panama','FL',32401,0,1,1,0);
INSERT INTO USERS VALUES(235489247411,'SHIRLEY',63,111,'1st Street Northwest','Pheonix','AZ',20001,0,1,1,0);
INSERT INTO USERS VALUES(235589237412,'LAUREN',45,444,'Hansen Avenue','Medford','CA',94536,0,1,1,0);
INSERT INTO USERS VALUES(235689227413,'MARTHA',57,176,'Albacore Drive','Panama','FL',36117,1,1,0,0);
INSERT INTO USERS VALUES(235789217414,'JEREMY',43,152,'55th Avenue','Medford','CA',94621,1,1,0,0);
INSERT INTO USERS VALUES(235889207415,'GABRIEL',49,788,'Hillcrest Road','Medford','CA',36109,1,0,1,0);
INSERT INTO USERS VALUES(235989197416,'SOPHIA',42,424,'Edgewood Street','Medford','CA',94538,1,1,1,0);
INSERT INTO USER_PHONE VALUES(234689327403,9302759832);
INSERT INTO USER_PHONE VALUES(234789317404,9342739830);
INSERT INTO USER_PHONE VALUES(234889307405,9382719828);
INSERT INTO USER_PHONE VALUES(234989297406,9422699826);
INSERT INTO USER_PHONE VALUES(235089287407,9462679824);
INSERT INTO USER_PHONE VALUES(235189277408,9502659822);
INSERT INTO USER_PHONE VALUES(235289267409,9542639820);
INSERT INTO USER_PHONE VALUES(235389257410,9582619818);
INSERT INTO USER_PHONE VALUES(235489247411,9622599816);
INSERT INTO USER_PHONE VALUES(235589237412,9662579814);
INSERT INTO USER_PHONE VALUES(235689227413,9702559812);
INSERT INTO USER_PHONE VALUES(235789217414,9742539810);
INSERT INTO USER_PHONE VALUES(235889207415,9782519808);
INSERT INTO USER_PHONE VALUES(235989197416,9822499806);
INSERT INTO LOGIN VALUES(234689327403,'SAI','MAN123');
INSERT INTO LOGIN VALUES(234789317404,'SHREY','ACH123');
INSERT INTO LOGIN VALUES(234889307405,'SARTHAK','SAR123');
INSERT INTO LOGIN VALUES(234989297406,'MICHEAL','MIC456');
INSERT INTO LOGIN VALUES(235089287407,'RACHEAL','RAC456');
INSERT INTO LOGIN VALUES(235189277408,'KHUSHI','KHU456');
INSERT INTO LOGIN VALUES(235289267409,'PARTHVI','PAR789');
INSERT INTO LOGIN VALUES(235389257410,'LUCIFER','LUC789');
INSERT INTO LOGIN VALUES(235489247411,'SHIRLEY','SHI789');
INSERT INTO LOGIN VALUES(235589237412,'LAUREN','LAU012');
INSERT INTO LOGIN VALUES(235689227413,'MARTHA','MAR012');
INSERT INTO LOGIN VALUES(235789217414,'JEREMY','JER012');
INSERT INTO LOGIN VALUES(235889207415,'GABRIEL','GAB345');
INSERT INTO LOGIN VALUES(235989197416,'SOPHIA','SOP345');
INSERT INTO PROPERTY VALUES(103895,1,1035,932,1980,190,'Countryside Drive','Pheonix','AZ',72730,8,450,'RES',2);
INSERT INTO PROPERTY VALUES(104892,2,2070,1863,1987,204,'Blue Hills Drive','Nashville','TX',37214,6,1080,'RES',3);
INSERT INTO PROPERTY VALUES(105889,1,1035,932,1999,200,'Redwood Road','Nashville','TX',60401,8,450,'RES',1);
INSERT INTO PROPERTY VALUES(106886,1,1035,932,2001,187,'Elmwood Drive','Panama','FL',31407,10,870,'RES',1);
INSERT INTO PROPERTY VALUES(107883,1,1035,932,1979,711,'North 51st Avenue','Pheonix','AZ',85301,13,450,'RES',2);
INSERT INTO PROPERTY VALUES(108880,1,1035,932,2008,154,'Boca Lagoon Drive','Panama','FL',32408,10,450,'RES',2);
INSERT INTO PROPERTY VALUES(109877,1,1035,932,2004,125,'John Street','Medford','CA',95060,12,450,'RES',1);
INSERT INTO PROPERTY VALUES(110874,1,1035,932,2003,105,'Park Avenue','Panama','FL',32401,7,870,'RES',2);
INSERT INTO PROPERTY VALUES(111871,2,2070,1863,2006,111,'1st Street Northwest','Pheonix','AZ',20001,10,1080,'RES',5);
INSERT INTO PROPERTY VALUES(112868,1,1035,932,1990,444,'Hansen Avenue','Medford','CA',94536,5,870,'RES',3);
INSERT INTO PROPERTY VALUES(113865,1,1035,932,1993,176,'Albacore Drive','Panama','FL',36117,8,450,'RES',4);
INSERT INTO PROPERTY VALUES(114862,3,3105,2795,2010,152,'55th Avenue','Medford','CA',94621,9,2700,'RES',7);
INSERT INTO PROPERTY VALUES(115859,2,2070,1863,2009,788,'Hillcrest Road','Medford','CA',36109,10,1500,'RES',4);
INSERT INTO PROPERTY VALUES(116856,1,1035,932,2001,424,'Edgewood Street','Medford','CA',94538,8,870,'RES',3);
INSERT INTO PROPERTY VALUES(117853,2,2070,1863,1992,364,'Boultier Street','Nashville','TX',31419,5,1080,'RES',3);
INSERT INTO PROPERTY VALUES(118850,2,2070,1863,2006,215,'West 66th Place','Nashville','TX',32404,6,1500,'COM',0);
INSERT INTO PROPERTY VALUES(119847,3,3105,2795,2019,481,'Lilly Street', 'Pheonix','AZ',21144,8,2400,'RES',8);
INSERT INTO PROPERTY VALUES(120844,2,2070,1863,2009,691,'Stemson Way','Panama','FL',72703,12,1500,'RES',4);
INSERT INTO PROPERTY VALUES(121841,2,2070,1863,1999,219,'East 18th Avenue','Pheonix','AZ',31410,14,1080,'RES',5);
INSERT INTO PROPERTY VALUES(122838,5,5175,4658,2015,130,'Old Route 103','Nashville','TX',50143,9,7000,'COM',0);
INSERT INTO PROP_OWNED VALUES(234689327403,103895);
INSERT INTO PROP_OWNED VALUES(234789317404,104892);
INSERT INTO PROP_OWNED VALUES(234789317404,113865);
INSERT INTO PROP_OWNED VALUES(234789317404,114862);
INSERT INTO PROP_OWNED VALUES(234889307405,105889);
INSERT INTO PROP_OWNED VALUES(234889307405,116856);
INSERT INTO PROP_OWNED VALUES(234889307405,117853);
INSERT INTO PROP_OWNED VALUES(234989297406,106886);
INSERT INTO PROP_OWNED VALUES(234989297406,118850);
INSERT INTO PROP_OWNED VALUES(234989297406,119847);
INSERT INTO PROP_OWNED VALUES(235689227413,107883);
INSERT INTO PROP_OWNED VALUES(235689227413,108880);
INSERT INTO PROP_OWNED VALUES(235789217414,109877);
INSERT INTO PROP_OWNED VALUES(235789217414,110874);
INSERT INTO PROP_OWNED VALUES(235789217414,111871);
INSERT INTO PROP_OWNED VALUES(235889207415,115859);
INSERT INTO PROP_OWNED VALUES(235889207415,120844);
INSERT INTO PROP_OWNED VALUES(235889207415,121841);
INSERT INTO PROP_OWNED VALUES(235989197416,112868);
INSERT INTO PROP_OWNED VALUES(235989197416,122838);
INSERT INTO PROP_RENTED VALUES(235689227413,122838,'12-Jan-23','23-Apr-23',2);
INSERT INTO PROP_RENTED VALUES(235389257410,122838,'06-Jul-22','12-Jan-23',2);
INSERT INTO PROP_RENTED VALUES(235789217414,121841,'12-Jan-23','23-Apr-23',1);
INSERT INTO PROP_RENTED VALUES(235489247411,121841,'06-Jul-22','12-Jan-23',1);
INSERT INTO PROP_RENTED VALUES(235989197416,120844,'12-Jan-23','23-Apr-23',7);
INSERT INTO PROP_RENTED VALUES(235589237412,120844,'06-Jul-22','12-Jan-23',7);
INSERT INTO PROP_RENTED VALUES(235089287407,119847,'12-Jan-23','23-Apr-23',6);
INSERT INTO PROP_RENTED VALUES(235189277408,118850,'12-Jan-23','23-Apr-23',8);
INSERT INTO PROP_RENTED VALUES(235289267409,117853,'12-Jan-23','23-Apr-23',9);
INSERT INTO PROP_RENTED VALUES(235989197416,116856,'23-Apr-23','02-Oct-23',4);
INSERT INTO PROP_RENTED VALUES(235389257410,116856,'12-Jan-23','23-Apr-23',4);
INSERT INTO PROP_RENTED VALUES(235789217414,114862,'23-Apr-23','02-Oct-23',4);
INSERT INTO PROP_RENTED VALUES(235489247411,114862,'12-Jan-23','23-Apr-23',4);
INSERT INTO PROP_RENTED VALUES(235689227413,113865,'23-Apr-23','02-Oct-23',7);
INSERT INTO PROP_RENTED VALUES(235589237412,113865,'12-Jan-23','23-Apr-23',7);
INSERT INTO PROP_RENTED VALUES(235589237412,112868,'23-Apr-23','02-Oct-23',6);
INSERT INTO PROP_RENTED VALUES(235689227413,112868,'06-Jul-22','12-Jan-23',5);
INSERT INTO PROP_RENTED VALUES(235489247411,111871,'23-Apr-23','02-Oct-23',3);
INSERT INTO PROP_RENTED VALUES(235789217414,111871,'06-Jul-22','12-Jan-23',10);
INSERT INTO PROP_RENTED VALUES(235389257410,110874,'23-Apr-23','02-Oct-23',1);
INSERT INTO PROP_RENTED VALUES(235989197416,110874,'06-Jul-22','12-Jan-23',1);
INSERT INTO PROP_RENTED VALUES(235289267409,109877,'23-Apr-23','02-Oct-23',8);
INSERT INTO PROP_RENTED VALUES(235089287407,109877,'06-Jul-22','12-Jan-23',8);
INSERT INTO PROP_RENTED VALUES(235189277408,108880,'23-Apr-23','02-Oct-23',6);
INSERT INTO PROP_RENTED VALUES(235189277408,108880,'06-Jul-22','12-Jan-23',2);
INSERT INTO PROP_RENTED VALUES(235089287407,107883,'23-Apr-23','02-Oct-23',2);
INSERT INTO PROP_RENTED VALUES(235289267409,107883,'06-Jul-22','12-Jan-23',4);