phpwax / wildfire
watch download tarball
public
Forks0Right
Watchers10Right
Description: Wilfire CMS - Plugin for the PHP-Wax Framework
Homepage: http://wildfirecms.com/
Clone URL: git://github.com/phpwax/wildfire.git
wildfire / migrate / ContentTableMigrate.php
100755 29 lines (25 sloc) 1.04 kb
raw blame history 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

<?php
 
class ContentTableMigrate extends WXMigrate {
  
  public function up() {
    $this->create_column("title", "string");
    $this->create_column("excerpt", "text");
    $this->create_column("content", "text");
    $this->create_column("status", "integer");
    $this->create_column("author_id", "integer");
    $this->create_column("published", "DATETIME");
		$this->create_column("expires", "DATETIME");
		$this->create_column("date_modified", "TIMESTAMP");
		$this->create_column("date_created", "DATETIME");			
    $this->create_column("cms_section_id", "integer");
    $this->create_column("sort", "integer");
    $this->create_column("url", "string");
    $this->create_table("cms_content");
    $this->add_column("cms_content", "pageviews", "integer", "11", false, "0");
    $this->add_column("cms_content", "date_created", "DATETIME");
  }
  
  public function down() {
    $this->drop_table("cms_content");
    $this->remove_column("cms_content", "pageviews");
    $this->remove_column("cms_content", "date_created");
  }
  
}