Show
Ignore:
Timestamp:
06/06/10 02:49:52 (2 years ago)
Author:
ort
Message:

fix

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • trunk/plugins/page/dump.sql

    r872 r934  
    1111  `page_seo_description` varchar(250) DEFAULT NULL, 
    1212  `page_active` tinyint(1) unsigned NOT NULL DEFAULT '1', 
     13  `page_main` tinyint(1) unsigned NOT NULL DEFAULT '0', 
     14  `page_sort` int(11) NOT NULL, 
    1315  PRIMARY KEY (`page_id`), 
    1416  KEY `page_pid` (`page_pid`), 
    1517  KEY `page_url_full` (`page_url_full`,`page_active`), 
    16   KEY `page_title` (`page_title`) 
     18  KEY `page_title` (`page_title`), 
     19  KEY `page_sort` (`page_sort`), 
     20  KEY `page_main` (`page_main`) 
    1721) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; 
    1822 
    1923 
    20 INSERT INTO `prefix_page` (`page_id`, `page_pid`, `page_url`, `page_url_full`, `page_title`, `page_text`, `page_date_add`, `page_date_edit`, `page_seo_keywords`, `page_seo_description`, `page_active`) VALUES 
    21 (1, NULL, 'about', 'about', 'About', 'edit this page http://yousite/page/admin/', '2008-11-05 01:03:46', NULL, '', '', 1); 
     24INSERT INTO `prefix_page` (`page_id`, `page_pid`, `page_url`, `page_url_full`, `page_title`, `page_text`, `page_date_add`, `page_date_edit`, `page_seo_keywords`, `page_seo_description`, `page_active`, `page_main`, `page_sort`) VALUES 
     25(1, NULL, 'about', 'about', 'about', 'edit this page http://yousite/page/admin/', '2010-06-06 02:29:28', NULL, '', '', 1, 1, 1);