-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathalt.php
71 lines (55 loc) · 3.37 KB
/
alt.php
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
<?php if(!$_SESSION['STAFF_ID'] && !$_SESSION['STUDENT_ID'] && (strpos($_SERVER['PHP_SELF'],'index.php'))===false)
{
header('Location: index.php');
exit;
}
?>
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
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);
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$