PHP Classes

File: sql/mysql.sql

Recommend this page to a friend!
  Classes of Michael Beck   XOOPS PHP About Page   sql/mysql.sql   Download  
File: sql/mysql.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: XOOPS PHP About Page
Show the about page in a site managed using XOOPS
Author: By
Last change:
Date: 2 years ago
Size: 1,146 bytes
 

Contents

Class file image Download 
CREATE TABLE `about_page` (
  `page_id`          INT(11)      NOT NULL AUTO_INCREMENT,
  `page_pid`         INT(4)       NOT NULL DEFAULT '0',
  `page_title`       VARCHAR(255) NOT NULL DEFAULT '',
  `page_menu_title`  VARCHAR(255) NOT NULL DEFAULT '',
  `page_image`       VARCHAR(255) NOT NULL DEFAULT '',
  `page_text`        TEXT,
  `page_author`      VARCHAR(255) NOT NULL DEFAULT '',
  `page_pushtime`    INT(10)               DEFAULT '0',
  `page_blank`       INT(1)       NOT NULL DEFAULT '0',
  `page_menu_status` INT(1)       NOT NULL DEFAULT '0',
  `page_type`        INT(1)       NOT NULL DEFAULT '0',
  `page_status`      INT(1)       NOT NULL DEFAULT '0',
  `page_order`       INT(2)       NOT NULL DEFAULT '0',
  `page_index`       INT(1)       NOT NULL DEFAULT '0',
  `page_tpl`         VARCHAR(255) NOT NULL DEFAULT '',
  `dohtml`           TINYINT(1)   NOT NULL DEFAULT '1',
  `dosmiley`         TINYINT(1)   NOT NULL DEFAULT '0',
  `doxcode`          TINYINT(1)   NOT NULL DEFAULT '0',
  `doimage`          TINYINT(1)   NOT NULL DEFAULT '0',
  `dobr`             TINYINT(1)   NOT NULL DEFAULT '0',
  PRIMARY KEY (`page_id`)
);