schema.sql

mysql> select * from batches;
+----+----------------+-----------+---------------------+---------------------+-----------+------------+
| id | name           | course_id | start_date          | end_date            | is_active | is_deleted |
+----+----------------+-----------+---------------------+---------------------+-----------+------------+
|  1 | 11 A Bio group |         1 | 2011-04-13 00:00:00 | 2012-04-13 00:00:00 |         1 |          0 |
+----+----------------+-----------+---------------------+---------------------+-----------+------------+
1 row in set (0.03 sec)

mysql> select * from subjects;
+----+--------------------+------+----------+----------+--------------------+-------------------+------------+---------------------+---------------------+
| id | name               | code | batch_id | no_exams | max_weekly_classes | elective_group_id | is_deleted | created_at          | updated_at          |
+----+--------------------+------+----------+----------+--------------------+-------------------+------------+---------------------+---------------------+
|  1 | ENGLISH            | E11  |        1 |        0 |                  4 |              NULL |          0 | 2011-04-13 17:18:10 | 2011-04-13 17:18:10 |
|  2 | PHYSICS            | P11  |        1 |        0 |                  5 |              NULL |          0 | 2011-04-13 17:18:39 | 2011-04-13 17:18:39 |
|  3 | CHEMISTRY          | C11  |        1 |        0 |                  5 |              NULL |          0 | 2011-04-13 17:18:56 | 2011-04-13 17:18:56 |
|  4 | MATHS              | M11  |        1 |        0 |                  5 |              NULL |          0 | 2011-04-13 17:19:12 | 2011-04-13 17:19:12 |
|  5 | BIOLOGY            | B11  |        1 |        0 |                  5 |              NULL |          0 | 2011-04-13 17:20:36 | 2011-04-13 17:20:36 |
|  6 | PHYSICAL EDUCATION | PT11 |        1 |        1 |                  1 |              NULL |          0 | 2011-04-13 17:21:10 | 2011-04-13 17:21:10 |
|  7 | TAMIL              | T11  |        1 |        0 |                  5 |                 1 |          0 | 2011-04-13 17:21:39 | 2011-04-13 17:21:39 |
|  8 | FRENCH             | F11  |        1 |        0 |                  5 |                 2 |          0 | 2011-04-13 17:22:15 | 2011-04-13 17:22:15 |
+----+--------------------+------+----------+----------+--------------------+-------------------+------------+---------------------+---------------------+
8 rows in set (0.00 sec)