forked from mehulsbhatt/opensis
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathalt.php
More file actions
65 lines (49 loc) · 3.13 KB
/
Copy pathalt.php
File metadata and controls
65 lines (49 loc) · 3.13 KB
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
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
ALTER TABLE address ADD bus_no character varying(50);
ALTER TABLE address ADD student_relation character varying(50);
ALTER TABLE address ADD student_relation1 character varying(50);
ALTER TABLE address ADD first_name character varying(100);
ALTER TABLE address ADD last_name character varying(100);
ALTER TABLE address ADD first_name2 character varying(100);
ALTER TABLE address ADD last_name2 character varying(100);
ALTER TABLE address ADD home_phone character varying(50);
ALTER TABLE address ADD home_phone2 character varying(50);
ALTER TABLE address ADD work_phone character varying(50);
ALTER TABLE address ADD work_phone2 character varying(50);
ALTER TABLE address ADD mobile_phone character varying(50);
ALTER TABLE address ADD mobile_phone2 character varying(50);
ALTER TABLE address ADD address1 character varying(100);
ALTER TABLE address ADD address2 character varying(100);
ALTER TABLE address ADD email character varying(100);
ALTER TABLE address ADD email2 character varying(100);
ALTER TABLE address ADD bus_pickup1 character varying(1);
ALTER TABLE address ADD street1 character varying(100);
ALTER TABLE address ADD bus_dropoff1 character varying(1);
ALTER TABLE address ADD city1 character varying(100);
ALTER TABLE address ADD zipcode1 character varying(50);
ALTER TABLE address ADD street2 character varying(100);
ALTER TABLE address ADD bus_dropoff2 character varying(1);
ALTER TABLE address ADD city2 character varying(50);
ALTER TABLE address ADD zipcode2 character varying(50);
ALTER TABLE address ADD state1 character varying(50);
ALTER TABLE address ADD state2 character varying(50);
ALTER TABLE address ADD bus_no2 character varying(50);
ALTER TABLE address ADD bus_pickup2 character varying(1);
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
ALTER TABLE students_join_people ADD home_phone character varying(50);
ALTER TABLE students_join_people ADD work_phone character varying(50);
ALTER TABLE students_join_people ADD mobile_phone character varying(50);
ALTER TABLE students_join_people ADD email character varying(50);
ALTER TABLE students_join_people ADD address1 character varying(100);
ALTER TABLE students_join_people ADD street1 character varying(100);
ALTER TABLE students_join_people ADD city1 character varying(50);
ALTER TABLE students_join_people ADD state1 character varying(50);
ALTER TABLE students_join_people ADD zipcode1 character varying(50);
ALTER TABLE students_join_people ADD bus_pickup1 character varying(1);
ALTER TABLE students_join_people ADD bus_dropoff1 character varying(1);
ALTER TABLE students_join_people ADD bus_no character varying(40);
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
ALTER TABLE students_join_address ADD bus_no character varying(50);
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$