Forum LAMS for Tech-Heads - General Forum: LAMS Groups in the MYSQL Database


 
You may request notification for LAMS Groups in the MYSQL Database.
Search: 

1: LAMS Groups in the MYSQL Database
03/07/11 09:55 PM
[ Reply | Forward ]
I cannot for the life of me figure out where in the lams mysql database (lams2) the groups are stored.

I've added a few test groups and have been trying to find the table that stores them in the lams2 database.

I see the table lams_group but this only seems to store the default playpen information.

Can someone shed some light on this please?

Thanks

Posted by Mike Partridge

2: Re: LAMS Groups in the MYSQL Database
In response to 1 03/07/11 10:00 PM
[ Reply | Forward ] 
mysql> desc lams_organisation;
+--------------------------+--------------+------+-----+---------+----------------+
| Field                    | Type         | Null | Key | Default | Extra          |
+--------------------------+--------------+------+-----+---------+----------------+
| organisation_id          | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| name                     | varchar(250) | NO   |     | NULL    |                |
| code                     | varchar(20)  | YES  |     | NULL    |                |
| description              | varchar(250) | YES  |     | NULL    |                |
| parent_organisation_id   | bigint(20)   | YES  | MUL | NULL    |                |
| organisation_type_id     | int(3)       | NO   | MUL | 0       |                |
| create_date              | datetime     | NO   |     | NULL    |                |
| created_by               | bigint(20)   | NO   |     | NULL    |                |
| workspace_id             | bigint(20)   | YES  | MUL | NULL    |                |
| organisation_state_id    | int(3)       | NO   | MUL | NULL    |                |
| admin_add_new_users      | tinyint(1)   | NO   |     | 0       |                |
| admin_browse_all_users   | tinyint(1)   | NO   |     | 0       |                |
| admin_change_status      | tinyint(1)   | NO   |     | 0       |                |
| admin_create_guest       | tinyint(1)   | NO   |     | 0       |                |
| enable_monitor_gradebook | tinyint(1)   | NO   |     | 0       |                |
| enable_learner_gradebook | tinyint(1)   | NO   |     | 0       |                |
| locale_id                | int(11)      | YES  | MUL | NULL    |                |
| archived_date            | datetime     | YES  |     | NULL    |                |
| ordered_lesson_ids       | text         | YES  |     | NULL    |                |
+--------------------------+--------------+------+-----+---------+----------------+
19 rows in set (0.05 sec)

Posted by Ernie Ghiglione

3: Re: LAMS Groups in the MYSQL Database
In response to 1 03/08/11 06:39 PM
[ Reply | Forward ]
Thanks for that Ernie, works a charm.

Posted by Mike Partridge

Reply to first post on this page
Back to LAMS for Tech-Heads - General Forum
.LRN Home