-- MySQL dump 10.11 -- -- Host: localhost Database: my_db_001 -- ------------------------------------------------------ -- Server version 5.0.37-community-nt /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `phpcg_help_data` -- DROP TABLE IF EXISTS `phpcg_help_data`; CREATE TABLE `phpcg_help_data` ( `hid` mediumint(6) NOT NULL auto_increment, `tb_name` varchar(50) NOT NULL default '', `fd_num` smallint(3) NOT NULL default '0', `fd_name` varchar(50) NOT NULL default '', `help_text` text NOT NULL, `deleted` tinyint(1) NOT NULL default '0', `updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`hid`), UNIQUE KEY `no_duplicates` (`tb_name`,`fd_name`) ) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1; -- -- Dumping data for table `phpcg_help_data` -- /*!40000 ALTER TABLE `phpcg_help_data` DISABLE KEYS */; INSERT INTO `phpcg_help_data` VALUES (1,'vs_content1a',20,'posted','This date is auto-assigned when a new page is entered into the database.',0,'2006-11-28 08:40:40'); INSERT INTO `phpcg_help_data` VALUES (2,'vs_content1a',5,'content','Website content is usually limited to 65,535 characters. HTML is recommended, but if no HTML tags are found, then the natural page breaks occurring in the data entry form will be transformed into break tags when content is rendered. PHP can be entered as content, however one must be certain to (1) flag the page as EVAL = Yes, and (2) if HTML is entered before any PHP code, immediatly escape out using ?>. In this event, you may need escape back the other way, at the end of the entry.',0,'2006-12-02 22:10:41'); INSERT INTO `phpcg_help_data` VALUES (3,'vs_content1a',6,'eval_content','If set to Yes (or 1) then page content will be processed using PHP\'s eval() command. When evaluated, PHP code is expected. Escape out immediately if HTML precedes the PHP code. See also \"content\".',0,'2006-12-02 22:07:21'); INSERT INTO `phpcg_help_data` VALUES (4,'vs_content1a',7,'meta_title','Text entered here will be used in a hidden Meta Title tag.',0,'2006-11-28 08:29:14'); INSERT INTO `phpcg_help_data` VALUES (5,'vs_content1a',8,'meta_desc','Meta Description will be used in hidden META tags. The data entry box holds about 950 characters.',0,'2006-12-02 19:31:09'); INSERT INTO `phpcg_help_data` VALUES (6,'vs_content1a',9,'meta_key','Meta Keywords will be used in a hidden META tag. The data entry box holds about 950 characters.',0,'2006-12-02 19:31:19'); INSERT INTO `phpcg_help_data` VALUES (7,'vs_content1a',10,'hidden','If Hidden is set to Yes (or 1) then the page will not be publicly displayed.',0,'2006-11-28 08:30:47'); INSERT INTO `phpcg_help_data` VALUES (8,'vs_content1a',11,'deleted','Instead of deleting records from the database, pages can instead be flagged as Deleted. Deleted pages could be eactivated by using phpMyAdmin to change the value of this field to No (or 0).',0,'2006-12-02 22:08:36'); INSERT INTO `phpcg_help_data` VALUES (9,'vs_content1a',12,'mli','If \"must log in\" is set to Yes (or 1) then users must be logged in before this page will be displayed.',0,'2006-12-02 19:31:53'); INSERT INTO `phpcg_help_data` VALUES (10,'vs_content1a',13,'https','If https is set to Yes (or 1) then navigation links will be generated using https:// instead of http://',0,'2006-11-28 08:33:38'); INSERT INTO `phpcg_help_data` VALUES (11,'vs_content1a',14,'nav','The value of the Nav field is not currently evaluated. In the future, this flag could facilitate changing the manner in which the content is displayed with respect to navigation links. Usage might be to alter the code in index.php to suppress side navigation links, or make other layout changes, based on the value of this field.',0,'2006-12-02 22:12:19'); INSERT INTO `phpcg_help_data` VALUES (12,'vs_content1a',15,'changefreq','This field is intended to be used in conjunction with the development of XML scripts for Google Sitemaps.',0,'2006-12-02 22:00:11'); INSERT INTO `phpcg_help_data` VALUES (13,'vs_content1a',16,'priority','This field is intended to be used in conjunction with the development of XML scripts for Google Sitemaps.',0,'2006-12-02 22:00:17'); INSERT INTO `phpcg_help_data` VALUES (14,'vs_content1a',17,'spider','If set to No (or 0) the META robots tag for this page will indicate noindex,nofollow.',0,'2006-12-02 19:32:45'); INSERT INTO `phpcg_help_data` VALUES (15,'vs_content1a',18,'html_1','This field offers a mechanism for displaying alternate HTML code in the page header. Additional configuration may be required.',0,'2006-11-28 08:39:59'); INSERT INTO `phpcg_help_data` VALUES (16,'vs_content1a',19,'html_2','This field offers a mechanism for displaying alternate HTML code in the page header. Additional configuration may be required.',0,'2006-11-28 08:40:04'); INSERT INTO `phpcg_help_data` VALUES (17,'vs_content1a',1,'snum','The website section number can be compared to the sequential numbering of chapters in a book. Navigation links are presented by sorting records first on the \"snum\" value, then the \"pnum\" value. The main page in each section, or chapter, should have it\'s \"pnum\" value set to 0.',0,'2006-12-02 19:20:11'); INSERT INTO `phpcg_help_data` VALUES (18,'vs_content1a',2,'pnum','The main page under each section of the website should be 0. The remaining \"pnum\" (page number) entries should be greater than 0 in order to control the order in which the public navigation links are displayed.',0,'2006-12-02 19:23:22'); INSERT INTO `phpcg_help_data` VALUES (19,'vs_content1a',3,'link','This text will be used to create the page navigation links and title arguments for A HREF tags.',0,'2006-12-02 22:05:04'); INSERT INTO `phpcg_help_data` VALUES (20,'vs_content1a',4,'heading','The page heading will be rendered in H3 tags above the page content. It may also be used elsewhere, such as in the title argument of A HREF tags.',0,'2006-12-02 19:25:35'); INSERT INTO `phpcg_help_data` VALUES (21,'vs_content1a',0,'id','This entry is the unique record ID number auto-assigned by the database. Usage is index.php?s=id where id is the numeric record number.',0,'2006-12-02 22:03:51'); /*!40000 ALTER TABLE `phpcg_help_data` ENABLE KEYS */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2008-01-20 16:25:22