[pLog-svn] r3289 - plog/trunk/install
mark at devel.lifetype.net
mark at devel.lifetype.net
Thu Apr 27 19:49:40 GMT 2006
Author: mark
Date: 2006-04-27 19:49:39 +0000 (Thu, 27 Apr 2006)
New Revision: 3289
Modified:
plog/trunk/install/dbschemas.properties.php
Log:
We can not use "X" to represent the "TTEXT" in mysql. If we use the X, the NOTNULL will not take any effect. So, I just change it to TEXT.
Another thing is I1 means "TINYINT", we have to set the length, for example I1(1). If we just use I1 without length information, we will get length = 4 automatically.
Modified: plog/trunk/install/dbschemas.properties.php
===================================================================
--- plog/trunk/install/dbschemas.properties.php 2006-04-27 19:15:17 UTC (rev 3288)
+++ plog/trunk/install/dbschemas.properties.php 2006-04-27 19:49:39 UTC (rev 3289)
@@ -9,14 +9,14 @@
blog_id I(10) UNSIGNED NOTNULL DEFAULT '0',
status I(5) NOTNULL DEFAULT 1,
num_reads I(10) DEFAULT '0',
- properties X NOTNULL DEFAULT '',
- slug C(255) NOTNULL,
+ properties TEXT NOTNULL DEFAULT '',
+ slug C(255) NOTNULL DEFAULT '',
num_comments I(10) NOTNULL DEFAULT '0',
num_nonspam_comments I(10) NOTNULL DEFAULT '0',
num_trackbacks I(10) NOTNULL DEFAULT '0',
num_nonspam_trackbacks I(10) NOTNULL DEFAULT '0',
global_category_id I(10) NOTNULL DEFAULT '0',
- in_summary_page I1 NOTNULL DEFAULT '1',
+ in_summary_page I1(1) NOTNULL DEFAULT '1',
INDEX num_reads (num_reads),
INDEX category_id (category_id),
INDEX blog_id (blog_id),
@@ -34,10 +34,10 @@
url C(255) NOTNULL DEFAULT '',
blog_id I(10) UNSIGNED NOTNULL DEFAULT '0',
last_modification T(14) NOTNULL,
- in_main_page I1 NOTNULL DEFAULT '1',
+ in_main_page I1(1) NOTNULL DEFAULT '1',
parent_id I(10) NOTNULL DEFAULT '0',
- description X NOTNULL DEFAULT '',
- properties X NOTNULL DEFAULT '',
+ description TEXT NOTNULL DEFAULT '',
+ properties TEXT NOTNULL DEFAULT '',
mangled_name C(255) NOTNULL DEFAULT '',
num_articles I(10) NOTNULL DEFAULT 0,
num_published_articles I(10) NOTNULL DEFAULT 0
@@ -52,7 +52,7 @@
id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
article_id I(10) UNSIGNED NOTNULL DEFAULT 0,
blog_id I(10) UNSIGNED NOTNULL DEFAULT 0,
- topic X NOTNULL,
+ topic TEXT NOTNULL,
text X,
date T(14) NOTNULL,
user_email C(255) DEFAULT '',
@@ -60,12 +60,12 @@
user_name C(255) NOTNULL DEFAULT Anonymous,
parent_id I(10) UNSIGNED DEFAULT '0',
client_ip varchar(15) DEFAULT 0.0.0.0,
- send_notification I1 DEFAULT '0',
+ send_notification I1(1) DEFAULT '0',
status I1(2) DEFAULT '1',
spam_rate float DEFAULT '0',
- properties X NOTNULL DEFAULT '',
- normalized_text X NOTNULL DEFAULT '',
- normalized_topic X NOTNULL DEFAULT '',
+ properties TEXT NOTNULL DEFAULT '',
+ normalized_text TEXT NOTNULL DEFAULT '',
+ normalized_topic TEXT NOTNULL DEFAULT '',
type I(3) NOTNULL DEFAULT '1',
INDEX parent_id (parent_id),
INDEX article_id (article_id),
@@ -94,7 +94,7 @@
owner_id I(10) UNSIGNED NOTNULL DEFAULT '0',
blog_category_id I(10) UNSIGNED NOTNULL DEFAULT '0',
about X,
- settings X NOTNULL,
+ settings TEXT NOTNULL,
mangled_blog varchar(50) NOTNULL DEFAULT '',
status I(4) NOTNULL DEFAULT '1',
show_in_summary I(4) NOTNULL DEFAULT '1',
@@ -116,11 +116,11 @@
category_id I(10) UNSIGNED NOTNULL DEFAULT '0',
url C(255) NOTNULL DEFAULT '',
name varchar(100) DEFAULT '',
- description X NOTNULL,
+ description TEXT NOTNULL,
blog_id I(10) UNSIGNED NOTNULL DEFAULT '0',
rss_feed C(255) NOTNULL DEFAULT '',
date T(14) NOTNULL,
- properties X NOTNULL DEFAULT '',
+ properties TEXT NOTNULL DEFAULT '',
INDEX blog_id (blog_id),
INDEX category_id (category_id)
";
@@ -131,7 +131,7 @@
name varchar(100) NOTNULL DEFAULT '',
blog_id I(10) NOTNULL DEFAULT '0',
last_modification T(14) NOTNULL,
- properties X NOTNULL DEFAULT '',
+ properties TEXT NOTNULL DEFAULT '',
num_links I(10) NOTNULL DEFAULT '0',
INDEX blog_id (blog_id)
";
@@ -146,7 +146,7 @@
$Tables["referers"]["schema"] = "
id I(10) NOTNULL AUTOINCREMENT PRIMARY,
- url X NOTNULL,
+ url TEXT NOTNULL,
article_id I(10) NOTNULL DEFAULT '0',
blog_id I(10) NOTNULL DEFAULT '0',
hits I(10) DEFAULT '1',
@@ -164,7 +164,7 @@
email C(255) NOTNULL DEFAULT '',
full_name C(255) NOTNULL DEFAULT '',
about X,
- properties X NOTNULL DEFAULT '',
+ properties TEXT NOTNULL DEFAULT '',
status I(4) NOTNULL DEFAULT 1,
resource_picture_id I(10) NOTNULL DEFAULT 0,
site_admin I(10) NOTNULL DEFAULT '0',
@@ -186,7 +186,7 @@
$Tables["config"]["schema"] = "
id I(10) NOTNULL AUTOINCREMENT PRIMARY,
config_key C(255) NOTNULL DEFAULT '' PRIMARY,
- config_value X NOTNULL,
+ config_value TEXT NOTNULL,
value_type I(3) DEFAULT '0'
";
$Tables["config"]["options"] = "TYPE=MyISAM";
@@ -227,8 +227,8 @@
file_size I(20) NOTNULL DEFAULT 0,
metadata X,
thumbnail_format varchar(4) NOTNULL DEFAULT 'same',
- normalized_description X NOTNULL DEFAULT '',
- properties X NOTNULL DEFAULT '',
+ normalized_description TEXT NOTNULL DEFAULT '',
+ properties TEXT NOTNULL DEFAULT '',
INDEX album_id (album_id),
INDEX owner_id (owner_id),
INDEX file_name (file_name),
@@ -241,14 +241,14 @@
$Tables["gallery_albums"]["schema"] = "
id I(10) NOTNULL AUTOINCREMENT PRIMARY,
owner_id I(10) NOTNULL DEFAULT '0',
- description X NOTNULL,
+ description TEXT NOTNULL,
name C(255) NOTNULL DEFAULT '',
flags I(10) NOTNULL DEFAULT '0',
parent_id I(10) NOTNULL DEFAULT '0',
date T(14) NOTNULL,
- properties X NOTNULL DEFAULT '',
- show_album I1 DEFAULT 1,
- normalized_description X NOTNULL DEFAULT '',
+ properties TEXT NOTNULL DEFAULT '',
+ show_album I1(1) DEFAULT 1,
+ normalized_description TEXT NOTNULL DEFAULT '',
normalized_name C(255) NOTNULL DEFAULT '',
mangled_name C(255) NOTNULL DEFAULT '',
num_resources I(10) NOTNULL DEFAULT '0',
@@ -293,12 +293,12 @@
$Tables["custom_fields_definition"]["schema"] = "
id I(10) NOTNULL AUTOINCREMENT PRIMARY,
field_name C(255) NOTNULL DEFAULT '' PRIMARY,
- field_description X NOTNULL,
+ field_description TEXT NOTNULL,
field_type I(2) NOTNULL DEFAULT '1',
blog_id I(10) NOTNULL DEFAULT '0',
date T(14),
- searchable I1 DEFAULT 1,
- hidden I1 DEFAULT 1,
+ searchable I1(1) DEFAULT 1,
+ hidden I1(1) DEFAULT 1,
INDEX blog_id (blog_id)
";
$Tables["custom_fields_definition"]["options"] = "TYPE=MyISAM";
@@ -306,8 +306,8 @@
$Tables["custom_fields_values"]["schema"] = "
id I(10) NOTNULL AUTOINCREMENT PRIMARY,
field_id I(10) NOTNULL DEFAULT '0',
- field_value X NOTNULL,
- normalized_value X NOTNULL,
+ field_value TEXT NOTNULL,
+ normalized_value TEXT NOTNULL,
blog_id I(10) DEFAULT NULL,
article_id I(10) DEFAULT NULL,
FULLTEXT normalized_value (normalized_value),
@@ -321,11 +321,11 @@
$Tables["articles_text"]["schema"] = "
id I(10) NOTNULL AUTOINCREMENT PRIMARY,
article_id I(10) NOTNULL DEFAULT 0,
- text X NOTNULL DEFAULT '',
- topic X NOTNULL DEFAULT '',
- normalized_text X NOTNULL DEFAULT '',
- normalized_topic X NOTNULL DEFAULT '',
- mangled_topic X NOTNULL,
+ text TEXT NOTNULL DEFAULT '',
+ topic TEXT NOTNULL DEFAULT '',
+ normalized_text TEXT NOTNULL DEFAULT '',
+ normalized_topic TEXT NOTNULL DEFAULT '',
+ mangled_topic TEXT NOTNULL,
INDEX article_id (article_id),
FULLTEXT normalized_text (normalized_text),
FULLTEXT normalized_topic (normalized_topic),
@@ -338,7 +338,7 @@
phpbb_id I(10) UNSIGNED NOTNULL,
full_name C(255) NOTNULL DEFAULT '',
about X,
- properties X NOTNULL DEFAULT '',
+ properties TEXT NOTNULL DEFAULT '',
resource_picture_id I(10) NOTNULL DEFAULT 0,
status I(10) NOTNULL DEFAULT 0,
UNIQUE phpbb_id(phpbb_id)
@@ -350,7 +350,7 @@
name C(255) NOTNULL DEFAULT '',
description C(255) NOTNULL DEFAULT '',
mangled_name C(255) NOTNULL DEFAULT '',
- properties X NOTNULL DEFAULT '',
+ properties TEXT NOTNULL DEFAULT '',
num_blogs I(10) NOTNULL DEFAULT '0',
num_active_blogs I(10) NOTNULL DEFAULT '0',
INDEX mangled_name(mangled_name)
@@ -362,7 +362,7 @@
name C(255) NOTNULL DEFAULT '',
description C(255) NOTNULL DEFAULT '',
mangled_name C(255) NOTNULL DEFAULT '',
- properties X NOTNULL DEFAULT '',
+ properties TEXT NOTNULL DEFAULT '',
num_articles I(10) NOTNULL DEFAULT '0',
num_active_articles I(10) NOTNULL DEFAULT '0',
INDEX mangled_name(mangled_name)
More information about the pLog-svn
mailing list