This is a static copy of the main wikispot.org site, preserved for historical purposes only. Please see this page for more information.

How to Migrate from MoinMoin/Database

InfoInfo
Search:    

[WWW]http://macdet.homelinux.net:8080/index.cgi/User_Preferences?new_user=1 — I have to closed the firewall :)

mysql> show tables;
+------------------------+
| Tables_in_wiki         |
+------------------------+
| allPages               |
| curPages               |
| currentImageChanges    |
| currentMapChanges      |
| deletedImageChanges    |
| deletedMapChanges      |
| eventChanges           |
| events                 |
| imageCaptions          |
| images                 |
| links                  |
| mapCategoryDefinitions |
| mapPointCategories     |
| mapPoints              |
| metadata               |
| oldImageChanges        |
| oldImages              |
| oldMapChanges          |
| oldMapPointCategories  |
| oldMapPoints           |
| pageChanges            |
| pageDependencies       |
| thumbnails             |
| userFavorites          |
| userSessions           |
| users                  |
+------------------------+
26 rows in set (0.00 sec)

mysql> describe curPages;
+------------------+--------------+------+-----+---------+-------+
| Field            | Type         | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| name             | varchar(100) | NO   | PRI | NULL    |       |
| text             | mediumtext   | YES  |     | NULL    |       |
| cachedText       | mediumblob   | YES  |     | NULL    |       |
| editTime         | double       | YES  |     | NULL    |       |
| cachedTime       | double       | YES  |     | NULL    |       |
| userEdited       | char(20)     | YES  | MUL | NULL    |       |
| propercased_name | varchar(100) | NO   |     | NULL    |       |
+------------------+--------------+------+-----+---------+-------+
7 rows in set (0.00 sec)

why it not enough to loop and too write the

mysql> describe allPages;
+------------------+--------------+------+-----+---------+-------+
| Field            | Type         | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| name             | varchar(100) | NO   | PRI | NULL    |       |
| text             | mediumtext   | YES  |     | NULL    |       |
| editTime         | double       | NO   | PRI | 0       |       |
| userEdited       | char(20)     | YES  | MUL | NULL    |       |
| editType         | char(30)     | YES  |     | NULL    |       |
| comment          | varchar(194) | YES  |     | NULL    |       |
| userIP           | char(16)     | YES  | MUL | NULL    |       |
| propercased_name | varchar(100) | NO   |     | NULL    |       |
+------------------+--------------+------+-----+---------+-------+
8 rows in set (0.00 sec)

The reason for curPages vs allPages is pragmatic. All information for long-term use is in allPages, but curPages is the data that is most likely to be accessed. When a user visits a page, curPages is used. allPages is used far less often because it is the 'archive' data. Say we had columns 'cachedText' and 'cachedTime' in allPages. Then it would be NULL in most all values. It is, as they say, a 'summary' table for the most frequently accessed data as well as the cached data for the current page. It also provides the answer to "does this page currently exist?"


Is there a data-definition?

This is a Wiki Spot wiki. Wiki Spot is a 501(c)3 non-profit organization that helps communities collaborate via wikis.