Robin Nixon's "Robin's Nest" unexpected tables created
Posted: Sat Mar 26, 2011 4:33 pm
Hi,
I have been learning PHP/MySQL and JavaScript from Robin Nixon's book on the subject. I studied the code from the last chapter to create a rudimentary social network. I have worked through all of the code, and I find it very easy to understand. However, just out of curiosity, I went to the MySQL command line to have a look at the tables I created. I was only expecting the four tables created with the "rnsetup.php" document, but I found that there are a whole list of tables that have been created, and I'm not sure where they are coming from (e.g. sessions, short_cut_set, node, node_access, field_config, etc. there are probably about 50 tables).
I'm familiar (intermediate level) with database design, but I was not expecting these tables to be created, and I'm not sure how it happened. I didn't download any SQL scripts to create the schema, so as far as I know, I should only have the four tables I created in the setup.php script.
Does anyone know where these other tables are coming from? I have a feeling they were somehow created by PHP session functions or something like that in the process of using running, but I am just not sure. It is also possible that they were created by NetBeans (The IDE I'm using).
Can anyone explain why these tables showed up, and why I need them? Is there a resource out there that describes their presence?
Thanks
Tom
I have been learning PHP/MySQL and JavaScript from Robin Nixon's book on the subject. I studied the code from the last chapter to create a rudimentary social network. I have worked through all of the code, and I find it very easy to understand. However, just out of curiosity, I went to the MySQL command line to have a look at the tables I created. I was only expecting the four tables created with the "rnsetup.php" document, but I found that there are a whole list of tables that have been created, and I'm not sure where they are coming from (e.g. sessions, short_cut_set, node, node_access, field_config, etc. there are probably about 50 tables).
I'm familiar (intermediate level) with database design, but I was not expecting these tables to be created, and I'm not sure how it happened. I didn't download any SQL scripts to create the schema, so as far as I know, I should only have the four tables I created in the setup.php script.
Does anyone know where these other tables are coming from? I have a feeling they were somehow created by PHP session functions or something like that in the process of using running, but I am just not sure. It is also possible that they were created by NetBeans (The IDE I'm using).
Can anyone explain why these tables showed up, and why I need them? Is there a resource out there that describes their presence?
Thanks
Tom