installsql.php

来自「一款基于PHP的网络日记程序。WikyBlog支持：多用户的 BLOG」· PHP 代码 · 共 25 行

<?php
//
//		WikyBlog Generated File
//		package version 1.3
//		adminPluginSQL.php
//		********************************************************************************************************
//		This file contains a serialized array used to create/alter database tables used by the WikyBlog software
//		Don't edit anything in this file!
//

defined('WikyBlog') or die('Not an entry point...');

$dbData = 'a:1:{s:8:"skeleton";a:6:{s:6:"Engine";s:6:"MyISAM";s:9:"Collation";s:15:"utf8_general_ci";s:15:"Default_charset";s:20:"DEFAULT CHARSET=utf8";s:6:"create";s:385:"CREATE TABLE `&tablePrefix&skeleton` (
  `file_id` int(8) unsigned NOT NULL default \'0\',
  `owner` varchar(20) NOT NULL default \'\',
  `title` varchar(40) NOT NULL default \'\',
  `content` text NOT NULL,
  `summary` varchar(200) default NULL,
  `hitcounter` mediumint(8) unsigned NOT NULL default \'0\',
  PRIMARY KEY  (`owner`,`title`),
  UNIQUE KEY `file_id` (`file_id`)
) ENGINE=MyISAM ";s:7:"columns";a:6:{s:7:"file_id";s:35:"`file_id` int(8) unsigned NOT NULL ";s:5:"owner";s:29:"`owner` varchar(20) NOT NULL ";s:5:"title";s:29:"`title` varchar(40) NOT NULL ";s:7:"content";s:24:"`content` text NOT NULL ";s:7:"summary";s:37:"`summary` varchar(200) DEFAULT NULL  ";s:10:"hitcounter";s:44:"`hitcounter` mediumint(8) unsigned NOT NULL ";}s:4:"keys";a:2:{s:7:"PRIMARY";s:30:"PRIMARY KEY (`owner`, `title`)";s:7:"file_id";s:18:"UNIQUE (`file_id`)";}}}';