-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathexample-database.sql
More file actions
30 lines (29 loc) · 3.65 KB
/
example-database.sql
File metadata and controls
30 lines (29 loc) · 3.65 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
CREATE TABLE IF NOT EXISTS `schools` (
`id` varchar(3) CHARACTER SET utf8 NOT NULL,
`name` varchar(50) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `wp_school` (`id`, `name`,`description`,`image`) VALUES
('1', 'Chinmaya Vidyalaya','Education is fruitless and mere labor if it fails to inculcate noble virtues in students- believes Pujya Gurudev Swami Chinmayananda, the founder of Chinmaya Vidyalaya.','localhost/wordpress/wp-content/plugins/schools/uploads/dist/images/School-Building-1.jpg'),
('2', 'St.Thomas School','Education is fruitless and mere labor if it fails to inculcate noble virtues in students- believes Pujya Gurudev Swami Chinmayananda, the founder of Chinmaya Vidyalaya.','localhost/wordpress/wp-content/plugins/schools/uploads/dist/images/2022-08-14.jpg
'),
('3', 'Vasant Valley School','Education is fruitless and mere labor if it fails to inculcate noble virtues in students- believes Pujya Gurudev Swami Chinmayananda, the founder of Chinmaya Vidyalaya.','localhost/wordpress/wp-content/plugins/schools/uploads/dist/images/2019-12-12.jpg
'),
('4', ' Sardar Patel Vidyalaya','Education is fruitless and mere labor if it fails to inculcate noble virtues in students- believes Pujya Gurudev Swami Chinmayananda, the founder of Chinmaya Vidyalaya.','localhost/wordpress/wp-content/plugins/schools/uploads/dist/images/2022-02-03.jpg
'),
('5', 'Mount Carmel School','Education is fruitless and mere labor if it fails to inculcate noble virtues in students- believes Pujya Gurudev Swami Chinmayananda, the founder of Chinmaya Vidyalaya.','localhost/wordpress/wp-content/plugins/schools/uploads/dist/images/2018-03-30.jpg
'),
('6', 'Modern School','Education is fruitless and mere labor if it fails to inculcate noble virtues in students- believes Pujya Gurudev Swami Chinmayananda, the founder of Chinmaya Vidyalaya.','localhost/wordpress/wp-content/plugins/schools/uploads/dist/images/2022-09-02.jpg
'),
('7', 'OPG World School ','Education is fruitless and mere labor if it fails to inculcate noble virtues in students- believes Pujya Gurudev Swami Chinmayananda, the founder of Chinmaya Vidyalaya.','localhost/wordpress/wp-content/plugins/schools/uploads/dist/images/unnamed.jpg
'),
('8', 'Bal Bharati Public School ','Education is fruitless and mere labor if it fails to inculcate noble virtues in students- believes Pujya Gurudev Swami Chinmayananda, the founder of Chinmaya Vidyalaya.','localhost/wordpress/wp-content/plugins/schools/uploads/dist/images/IMG_20170805_161541481.jpg
'),
('9', 'Apeejay School','Education is fruitless and mere labor if it fails to inculcate noble virtues in students- believes Pujya Gurudev Swami Chinmayananda, the founder of Chinmaya Vidyalaya.','localhost/wordpress/wp-content/plugins/schools/uploads/dist/images/IMG_20170325_141338148_HDR.jpg
'),
('10', ' Doon Public School','Education is fruitless and mere labor if it fails to inculcate noble virtues in students- believes Pujya Gurudev Swami Chinmayananda, the founder of Chinmaya Vidyalaya.','localhost/wordpress/wp-content/plugins/schools/uploads/dist/images/IMG20220626092608.jpg
'),
('11', 'Springdales School','Education is fruitless and mere labor if it fails to inculcate noble virtues in students- believes Pujya Gurudev Swami Chinmayananda, the founder of Chinmaya Vidyalaya.','localhost/wordpress/wp-content/plugins/schools/uploads/dist/images/2022-10-09.jpg
'),
('12', 'G.D. Goenka Public School','Education is fruitless and mere labor if it fails to inculcate noble virtues in students- believes Pujya Gurudev Swami Chinmayananda, the founder of Chinmaya Vidyalaya.','localhost/wordpress/wp-content/plugins/schools/uploads/dist/images/2015-11-28-1.jpg
');