-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathSQL Script.txt
40 lines (33 loc) · 6.49 KB
/
SQL Script.txt
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
INSERT INTO USERACCOUNT (Id, Password, Role, Account_Status) VALUES ('[email protected]', 'password', 0, 0);
INSERT INTO USERACCOUNT (Id, Password, Role, Account_Status) VALUES ('[email protected]', 'password', 1, 0),('[email protected]', 'password', 1, 0),('[email protected]', 'password', 1, 0),('[email protected]', 'password', 1, 0),('[email protected]', 'password', 1, 0);
INSERT INTO USERACCOUNT (Id, Password, Role, Account_Status) VALUES ('[email protected]', 'password', 2, 0),('[email protected]', 'password', 2, 0),('[email protected]', 'password', 2, 0),('[email protected]', 'password', 2, 0),('[email protected]', 'password', 2, 0),('[email protected]', 'password', 2, 0),('[email protected]', 'password', 2, 0),('[email protected]', 'password', 2, 0),('[email protected]', 'password', 2, 0),('[email protected]', 'password', 2, 0);
INSERT INTO USERACCOUNT (Id, Password, Role, Account_Status) VALUES ('[email protected]', 'password', 2, 0),('[email protected]', 'password', 2, 0),('[email protected]', 'password', 2, 0),('[email protected]', 'password', 2, 0),('[email protected]', 'password', 2, 0),('[email protected]', 'password', 2, 0),('[email protected]', 'password', 2, 0),('[email protected]', 'password', 2, 0),('[email protected]', 'password', 2, 0),('[email protected]', 'password', 2, 0);
INSERT INTO MINISTRYSTAFF (id, name, account_id, nric_no, gender, date_of_birth, contact_no, address_street, address_city, address_state, address_postcode, address_country) VALUES (2, 'Ministry of Health Admin 2', '[email protected]', '780414-10-3133', 0, '1978-04-14', '0123456789', 'Jalan Teknologi 5', 'Taman Teknologi Malaysia', 'W.P. Kuala Lumpur', '57000', 'Malaysia');
INSERT INTO CLINICSTAFF (id, name, account_id, nric_no, gender, date_of_birth, contact_no, clinic_name, vaccination_capacity, address_street, address_city, address_state, address_postcode, address_country) VALUES
(1, 'Clinic Staff 1', '[email protected]', '990812-10-8964', 0, '1999-09-12', '0123456789', 'Sungai Buloh Health Clinic', 5, 'Jalan Kampung Melayu Bt 13', 'Kampung Melayu Batu 13', 'Selangor', '47000', 'Malaysia'),
(2, 'Clinic Staff 2', '[email protected]', '840213-12-8964', 0, '1984-02-13', '0123456789', 'Axiata Arena Bukit Jalil', 8, 'Enterprise 4, Technology Park Malaysia', 'Lebuhraya Bukit Jalil', 'W.P. Kuala Lumpur', '57000', 'Malaysia'),
(3, 'Clinic Staff 3', '[email protected]', '820922-12-8964', 1, '1982-09-22', '0123456789', 'Desaru Coast Conference Centre (DCCC)', 3, 'No. 4, Jalan Pantai 3', 'Desaru Coast', 'Johor', '81930', 'Malaysia'),
(4, 'Clinic Staff 4', '[email protected]', '691222-12-8964', 0, '1969-12-22', '0123456789', 'Dewan Profesional UITM', 4, 'Taman Desa Sri Putra', 'Wakaf Bharu', 'Kelantan', '16210', 'Malaysia'),
(5, 'Clinic Staff 5', '[email protected]', '860412-12-8964', 0, '1986-04-12', '0123456789', 'Hospital Putrajaya', 3, 'Jalan P9', 'Presint 7', 'W.P. Putrajaya', '62250', 'Malaysia');
INSERT INTO PUBLICUSER (id, name, account_id, nric_no, gender, date_of_birth, contact_no, address_street, address_city, address_state, address_postcode, address_country) VALUES
(1, 'Public User 1', '[email protected]', '691222-12-8964', 0, '1969-12-22', '0123465794', 'No 1, Jalan Besar', 'Taman Mewar', 'Selangor', '15632', 'Malaysia'),
(2, 'Public User 2', '[email protected]', '840524-08-1651', 1, '1984-05-24', '0115641654', 'No 12, Jalan Gitar 23/3', 'Seksyen 23 Elite', 'Perlis', '86544', 'Malaysia'),
(3, 'Public User 3', '[email protected]', '871124-07-8972', 2, '1987-11-24', '011561165', '31 Jln 4/34B', 'Jln Kepong Sri Edaran Industrial Park', 'Penang', '48981', 'Malaysia'),
(4, 'Public User 4', '[email protected]', '941217-12-9595', 2, '1994-12-17', '012143256', 'Jalan SS 26/8', 'Taman Mayang Jaya', 'Kedah', '16513', 'Malaysia'),
(5, 'Public User 5', '[email protected]', '650619-10-4651', 1, '1965-06-19', '01215611', '3 Jln Pjs 11/20', 'Taman Bandar Sunway', 'Perak', '15615', 'Malaysia'),
(6, 'Public User 6', '[email protected]', '991123-12-7985', 0, '1999-11-23', '0121561311', 'Jalan PSK 6', 'Seri Kembangan', 'Kelantan', '46320', 'Malaysia'),
(7, 'Public User 7', '[email protected]', '920622-12-7985', 0, '1992-06-22', '0184664164', '7 Jln Kilang Kawasan Perindustrian', 'Taman Dato Onn', 'Terengganu', '45613', 'Malaysia'),
(8, 'Public User 8', '[email protected]', '000814-12-7985', 0, '2000-08-14', '0156464654', 'Lot G-71 Pertama Complex', 'Jalan Tunku Abdul Rahman', 'Pahang', '45500', 'Malaysia'),
(9, 'Public User 9', '[email protected]', '001117-12-7985', 1, '2000-11-17', '01646874341', 'No. 19 Jln Jujur 2', 'Kuala Lumpur', 'W.P. Kuala Lumpur', '56000', 'Malaysia'),
(10, 'Public User 10', '[email protected]', '910619-12-7985', 1, '1991-06-19', '01646547816', '3 10 Jln Ss2/67 Ss2 Petaling Jaya', 'Butterworth', 'Negeri Sembilan', '46130', 'Malaysia');
INSERT INTO PUBLICUSER (id, name, account_id, nric_no, gender, date_of_birth, contact_no, address_street, address_city, address_state, address_postcode, address_country) VALUES
(11, 'Public User 11', '[email protected]', '640623-12-1651', 0, '1964-06-23', '0126516133', 'No 1, Jalan Besar', 'Taman Mewar', 'Melaka', '15632', 'Malaysia'),
(12, 'Public User 12', '[email protected]', '841024-08-9623', 1, '1984-10-24', '0114896116', 'No 12, Jalan Gitar 23/3', 'Seksyen 23 Elite', 'Johor', '86544', 'Malaysia'),
(13, 'Public User 13', '[email protected]', '940115-07-0864', 2, '1994-11-15', '0118946155', '31 Jln 4/34B', 'Jln Kepong Sri Edaran Industrial Park', 'Sabah', '48981', 'Malaysia'),
(14, 'Public User 14', '[email protected]', '890721-12-9650', 2, '1989-07-21', '0122962030', 'Jalan SS 26/8', 'Taman Mayang Jaya', 'Sarawak', '16513', 'Malaysia'),
(15, 'Public User 15', '[email protected]', '890915-04-8941', 1, '1989-09-15', '0128946475', '3 Jln Pjs 11/20', 'Taman Bandar Sunway', 'W.P. Putrajaya', '15615', 'Malaysia'),
(16, 'Public User 16', '[email protected]', '011215-12-1561', 0, '2001-12-15', '0128956102', 'Jalan PSK 6', 'Seri Kembangan', 'W.P. Labuan', '46320', 'Malaysia'),
(17, 'Public User 17', '[email protected]', '890515-08-8494', 0, '1989-05-15', '0189456102', '7 Jln Kilang Kawasan Perindustrian', 'Taman Dato Onn', 'Selangor', '45613', 'Malaysia'),
(18, 'Public User 18', '[email protected]', '560316-12-0561', 0, '1956-03-16', '0198465120', 'Lot G-71 Pertama Complex', 'Jalan Tunku Abdul Rahman', 'W.P. Kuala Lumpur', '45500', 'Malaysia'),
(19, 'Public User 19', '[email protected]', '981231-02-1561', 1, '1998-12-31', '0189465102', 'No. 19 Jln Jujur 2', 'Kuala Lumpur', 'W.P. Kuala Lumpur', '56000', 'Malaysia'),
(20, 'Public User 20', '[email protected]', '960816-10-0561', 1, '1996-08-16', '0169864517', '3 10 Jln Ss2/67 Ss2 Petaling Jaya', 'Butterworth', 'Selangor', '46130', 'Malaysia');