User Tools

Site Tools


res:tools:spbimporter:spb-db

Considerations around SimplePhpBlog and its storing system

SimplePHPBlog flat "db" structure

    [$content]
        |
        |-- [$year] // two-digit year ID (05 stands for 2005)
        |       |
        |       |-- [$month]  //two-digit month ID (01 stands for January)
	|               |
	|               |-- entryYYMMDD-HHMMSS.txt
	|               |-- [entryYYMMDD-HHMMSS]
	|	                    |
	|			    |-- rating.txt
	|			    |-- view_counter.txt
	|			    |-- [comments]
	|			             |
	|				     |-- commentYYMMDD-HHMMSS.txt
	|
	|-- [static]
	        |
		|-- $filename.txt

Due to its nature of name of a file, entryYYMMDD-HHMMSS.txt must be univocal, and therefore it can be considered as the ID field of a DB table.

Comment DBs are associated to the entries using the file name (ID) of the entry, deprived of its extension (.txt) as the name of the directory which will contain them.

res/tools/spbimporter/spb-db.txt ยท Last modified: by arvid

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki