Menu
▾
▴
[xoops-svn] SF.net SVN: xoops-svn:[12529] XoopsModules
|
From: <be...@us...> - 2014-05-13 09:47:37
|
Revision: 12529
http://sourceforge.net/p/xoops/svn/12529
Author: beckmi
Date: 2014-05-13 09:47:33 +0000 (Tue, 13 May 2014)
Log Message:
-----------
removing "default" for text fields
Modified Paths:
--------------
XoopsModules/dms/releases/1.91/sql/mysql.sql
XoopsModules/mediawiki/trunk/mediawiki/maintenance/archives/patch-restructure.sql
XoopsModules/mediawiki/trunk/mediawiki/maintenance/archives/patch-searchindex.sql
XoopsModules/mediawiki/trunk/mediawiki/maintenance/mysql5/tables.sql
XoopsModules/mediawiki/trunk/mediawiki/maintenance/tables.sql
XoopsModules/modulepacks/basicmodulepack/trunk/modules/xoopsheadline/sql/mysql.sql
XoopsModules/modulepacks/x257basicmodulepack/trunk/modules/xoopsheadline/sql/mysql.sql
XoopsModules/modulepacks/x257basicmodulepack/trunk/modules/xoopspoll/sql/mysql.sql
XoopsModules/mytube/releases/1.04/mytube/sql/xoopstube.sql
XoopsModules/umfrage/trunk/umfrage/sql/mysql.sql
XoopsModules/wfdownloads/branches/luciorota/wfdownloads/sql/wfdownloads.sql
XoopsModules/wfdownloads/branches/mamba/wfdownloads/sql/mysql.sql
XoopsModules/wfdownloads/trunk/wfdownloads/sql/mysql.sql
XoopsModules/wflink/trunk/htdocs/modules/wflinks/sql/wflinks.sql
XoopsModules/xoalbum/trunk/xoalbum/sql/mysql.sql
XoopsModules/xoopsheadline/branches/ZySpec/xoopsheadline/sql/mysql.sql
XoopsModules/xoopsheadline/trunk/xoopsheadline/sql/mysql.sql
XoopsModules/xoopspoll/branches/zyspec/sql/mysql.sql
XoopsModules/xoopstube/trunk/xoopstube/sql/xoopstube.sql
Modified: XoopsModules/dms/releases/1.91/sql/mysql.sql
===================================================================
--- XoopsModules/dms/releases/1.91/sql/mysql.sql 2014-05-12 14:20:13 UTC (rev 12528)
+++ XoopsModules/dms/releases/1.91/sql/mysql.sql 2014-05-13 09:47:33 UTC (rev 12529)
@@ -247,7 +247,7 @@
CREATE TABLE dms_object_version_comments (
row_id bigint(14) unsigned NOT NULL auto_increment,
dov_row_id bigint(14) unsigned NOT NULL default '0',
- comment text NOT NULL default '',
+ comment text NOT NULL,
PRIMARY KEY (row_id)
) TYPE=MyISAM;
@@ -373,7 +373,7 @@
CREATE TABLE dms_groups (
group_id bigint(14) unsigned NOT NULL auto_increment,
group_name varchar(50) NOT NULL default '',
- group_description text NOT NULL default '',
+ group_description text NOT NULL,
group_type varchar(10) NOT NULL default 'PERMS',
PRIMARY KEY (group_id)
) TYPE=MyISAM;
Modified: XoopsModules/mediawiki/trunk/mediawiki/maintenance/archives/patch-restructure.sql
===================================================================
--- XoopsModules/mediawiki/trunk/mediawiki/maintenance/archives/patch-restructure.sql 2014-05-12 14:20:13 UTC (rev 12528)
+++ XoopsModules/mediawiki/trunk/mediawiki/maintenance/archives/patch-restructure.sql 2014-05-13 09:47:33 UTC (rev 12529)
@@ -51,7 +51,7 @@
--
-- CREATE TABLE /*$wgDBprefix*/text (
-- old_id int(8) unsigned NOT NULL auto_increment,
--- old_text mediumtext NOT NULL default '',
+-- old_text mediumtext NOT NULL,
-- old_flags tinyblob NOT NULL default '',
--
-- PRIMARY KEY old_id (old_id)
Modified: XoopsModules/mediawiki/trunk/mediawiki/maintenance/archives/patch-searchindex.sql
===================================================================
--- XoopsModules/mediawiki/trunk/mediawiki/maintenance/archives/patch-searchindex.sql 2014-05-12 14:20:13 UTC (rev 12528)
+++ XoopsModules/mediawiki/trunk/mediawiki/maintenance/archives/patch-searchindex.sql 2014-05-13 09:47:33 UTC (rev 12529)
@@ -15,7 +15,7 @@
si_title varchar(255) NOT NULL default '',
-- Munged version of body text
- si_text mediumtext NOT NULL default '',
+ si_text mediumtext NOT NULL,
UNIQUE KEY (si_page)
Modified: XoopsModules/mediawiki/trunk/mediawiki/maintenance/mysql5/tables.sql
===================================================================
--- XoopsModules/mediawiki/trunk/mediawiki/maintenance/mysql5/tables.sql 2014-05-12 14:20:13 UTC (rev 12528)
+++ XoopsModules/mediawiki/trunk/mediawiki/maintenance/mysql5/tables.sql 2014-05-13 09:47:33 UTC (rev 12529)
@@ -89,7 +89,7 @@
-- Note: email should be restricted, not public info.
-- Same with passwords.
- user_email tinytext NOT NULL default '',
+ user_email tinytext NOT NULL,
-- Newline-separated list of name=value defining the user
-- preferences
@@ -862,7 +862,7 @@
si_title varchar(255) NOT NULL default '',
-- Munged version of body text
- si_text mediumtext NOT NULL default '',
+ si_text mediumtext NOT NULL,
UNIQUE KEY (si_page),
FULLTEXT si_title (si_title),
Modified: XoopsModules/mediawiki/trunk/mediawiki/maintenance/tables.sql
===================================================================
--- XoopsModules/mediawiki/trunk/mediawiki/maintenance/tables.sql 2014-05-12 14:20:13 UTC (rev 12528)
+++ XoopsModules/mediawiki/trunk/mediawiki/maintenance/tables.sql 2014-05-13 09:47:33 UTC (rev 12529)
@@ -76,7 +76,7 @@
-- Note: email should be restricted, not public info.
-- Same with passwords.
- user_email tinytext NOT NULL default '',
+ user_email tinytext NOT NULL,
-- Newline-separated list of name=value defining the user
-- preferences
@@ -848,7 +848,7 @@
si_title varchar(255) NOT NULL default '',
-- Munged version of body text
- si_text mediumtext NOT NULL default '',
+ si_text mediumtext NOT NULL,
UNIQUE KEY (si_page),
FULLTEXT si_title (si_title),
Modified: XoopsModules/modulepacks/basicmodulepack/trunk/modules/xoopsheadline/sql/mysql.sql
===================================================================
--- XoopsModules/modulepacks/basicmodulepack/trunk/modules/xoopsheadline/sql/mysql.sql 2014-05-12 14:20:13 UTC (rev 12528)
+++ XoopsModules/modulepacks/basicmodulepack/trunk/modules/xoopsheadline/sql/mysql.sql 2014-05-13 09:47:33 UTC (rev 12529)
@@ -13,7 +13,7 @@
headline_mainmax tinyint(2) unsigned NOT NULL default '10',
headline_blockimg tinyint(1) unsigned NOT NULL default '0',
headline_blockmax tinyint(2) unsigned NOT NULL default '10',
- headline_xml text NOT NULL default '',
+ headline_xml text NOT NULL,
headline_updated int(10) NOT NULL default'0',
PRIMARY KEY (headline_id)
) ENGINE=MyISAM;
Modified: XoopsModules/modulepacks/x257basicmodulepack/trunk/modules/xoopsheadline/sql/mysql.sql
===================================================================
--- XoopsModules/modulepacks/x257basicmodulepack/trunk/modules/xoopsheadline/sql/mysql.sql 2014-05-12 14:20:13 UTC (rev 12528)
+++ XoopsModules/modulepacks/x257basicmodulepack/trunk/modules/xoopsheadline/sql/mysql.sql 2014-05-13 09:47:33 UTC (rev 12529)
@@ -13,7 +13,7 @@
headline_mainmax tinyint(2) unsigned NOT NULL default '10',
headline_blockimg tinyint(1) unsigned NOT NULL default '0',
headline_blockmax tinyint(2) unsigned NOT NULL default '10',
- headline_xml text NOT NULL default '',
+ headline_xml text NOT NULL,
headline_updated int(10) NOT NULL default'0',
PRIMARY KEY (headline_id)
) ENGINE=MyISAM;
Modified: XoopsModules/modulepacks/x257basicmodulepack/trunk/modules/xoopspoll/sql/mysql.sql
===================================================================
--- XoopsModules/modulepacks/x257basicmodulepack/trunk/modules/xoopspoll/sql/mysql.sql 2014-05-12 14:20:13 UTC (rev 12528)
+++ XoopsModules/modulepacks/x257basicmodulepack/trunk/modules/xoopspoll/sql/mysql.sql 2014-05-13 09:47:33 UTC (rev 12529)
@@ -21,7 +21,7 @@
CREATE TABLE mod_xoopspoll_desc (
poll_id mediumint(8) unsigned NOT null auto_increment,
question varchar(255) NOT null default '',
- description tinytext NOT null default '',
+ description tinytext NOT NULL,
user_id int(5) unsigned NOT null default '0',
start_time int(10) unsigned NOT null default '0',
end_time int(10) unsigned NOT null default '0',
Modified: XoopsModules/mytube/releases/1.04/mytube/sql/xoopstube.sql
===================================================================
--- XoopsModules/mytube/releases/1.04/mytube/sql/xoopstube.sql 2014-05-12 14:20:13 UTC (rev 12528)
+++ XoopsModules/mytube/releases/1.04/mytube/sql/xoopstube.sql 2014-05-13 09:47:33 UTC (rev 12529)
@@ -114,8 +114,8 @@
`vidrating` tinyint(1) NOT NULL default '0',
`time` varchar(7) NOT NULL default '0:00:00',
`keywords` varchar(255) NOT NULL default '',
- `item_tag` text NOT NULL default '',
- `picurl` text NOT NULL default '',
+ `item_tag` text NOT NULL,
+ `picurl` text NOT NULL,
PRIMARY KEY (`requestid`)
) ENGINE=MyISAM COMMENT='MyTube by McDonald' AUTO_INCREMENT=1 ;
@@ -149,8 +149,8 @@
`vidrating` tinyint(1) NOT NULL default '0',
`time` varchar(7) NOT NULL default '0:00:00',
`keywords` varchar(255) NOT NULL default '',
- `item_tag` text NOT NULL default '',
- `picurl` text NOT NULL default '',
+ `item_tag` text NOT NULL,
+ `picurl` text NOT NULL,
PRIMARY KEY (`lid`),
KEY `cid` (`cid`),
KEY `status` (`status`),
Modified: XoopsModules/umfrage/trunk/umfrage/sql/mysql.sql
===================================================================
--- XoopsModules/umfrage/trunk/umfrage/sql/mysql.sql 2014-05-12 14:20:13 UTC (rev 12528)
+++ XoopsModules/umfrage/trunk/umfrage/sql/mysql.sql 2014-05-13 09:47:33 UTC (rev 12529)
@@ -27,7 +27,7 @@
CREATE TABLE umfrage_desc (
poll_id mediumint(8) unsigned NOT NULL auto_increment,
question varchar(255) NOT NULL default '',
- description tinytext NOT NULL default '',
+ description tinytext NOT NULL,
user_id int(5) unsigned NOT NULL default '0',
start_time int(10) unsigned NOT NULL default '0',
end_time int(10) unsigned NOT NULL default '0',
Modified: XoopsModules/wfdownloads/branches/luciorota/wfdownloads/sql/wfdownloads.sql
===================================================================
--- XoopsModules/wfdownloads/branches/luciorota/wfdownloads/sql/wfdownloads.sql 2014-05-12 14:20:13 UTC (rev 12528)
+++ XoopsModules/wfdownloads/branches/luciorota/wfdownloads/sql/wfdownloads.sql 2014-05-13 09:47:33 UTC (rev 12529)
@@ -32,7 +32,7 @@
pid int(5) unsigned NOT NULL default '0',
title varchar(255) NOT NULL default '',
imgurl varchar(255) NOT NULL default '',
- description text NOT NULL default '',
+ description text NOT NULL,
total int(11) NOT NULL default '0',
summary text NOT NULL,
spotlighttop int(11) NOT NULL default '0',
Modified: XoopsModules/wfdownloads/branches/mamba/wfdownloads/sql/mysql.sql
===================================================================
--- XoopsModules/wfdownloads/branches/mamba/wfdownloads/sql/mysql.sql 2014-05-12 14:20:13 UTC (rev 12528)
+++ XoopsModules/wfdownloads/branches/mamba/wfdownloads/sql/mysql.sql 2014-05-13 09:47:33 UTC (rev 12529)
@@ -32,7 +32,7 @@
pid int(5) unsigned NOT NULL default '0',
title varchar(255) NOT NULL default '',
imgurl varchar(255) NOT NULL default '',
- description text NOT NULL default '',
+ description text NOT NULL,
total int(11) NOT NULL default '0',
summary text NOT NULL,
spotlighttop int(11) NOT NULL default '0',
@@ -101,7 +101,7 @@
ipaddress varchar(120) NOT NULL default '0',
notifypub int(1) NOT NULL default '0',
formulize_idreq int(5) NOT NULL default '0',
- screenshots text NOT NULL default '',
+ screenshots text NOT NULL,
dohtml tinyint(1) NOT NULL default '0',
dosmiley tinyint(1) NOT NULL default '1',
doxcode tinyint(1) NOT NULL default '1',
Modified: XoopsModules/wfdownloads/trunk/wfdownloads/sql/mysql.sql
===================================================================
--- XoopsModules/wfdownloads/trunk/wfdownloads/sql/mysql.sql 2014-05-12 14:20:13 UTC (rev 12528)
+++ XoopsModules/wfdownloads/trunk/wfdownloads/sql/mysql.sql 2014-05-13 09:47:33 UTC (rev 12529)
@@ -32,7 +32,7 @@
pid int(5) unsigned NOT NULL default '0',
title varchar(255) NOT NULL default '',
imgurl varchar(255) NOT NULL default '',
- description text NOT NULL default '',
+ description text NOT NULL,
total int(11) NOT NULL default '0',
summary text NOT NULL,
spotlighttop int(11) NOT NULL default '0',
@@ -101,7 +101,7 @@
ipaddress varchar(120) NOT NULL default '0',
notifypub int(1) NOT NULL default '0',
formulize_idreq int(5) NOT NULL default '0',
- screenshots text NOT NULL default '',
+ screenshots text NOT NULL,
dohtml tinyint(1) NOT NULL default '0',
dosmiley tinyint(1) NOT NULL default '1',
doxcode tinyint(1) NOT NULL default '1',
Modified: XoopsModules/wflink/trunk/htdocs/modules/wflinks/sql/wflinks.sql
===================================================================
--- XoopsModules/wflink/trunk/htdocs/modules/wflinks/sql/wflinks.sql 2014-05-12 14:20:13 UTC (rev 12528)
+++ XoopsModules/wflink/trunk/htdocs/modules/wflinks/sql/wflinks.sql 2014-05-13 09:47:33 UTC (rev 12529)
@@ -167,7 +167,7 @@
`requestdate` int(11) NOT NULL default '0',
`urlrating` tinyint(1) NOT NULL default '0',
`country` varchar(5) NOT NULL default '',
- `keywords` text NOT NULL default '',
+ `keywords` text NOT NULL,
`item_tag` text NOT NULL,
`googlemap` text NOT NULL,
`yahoomap` text NOT NULL,
Modified: XoopsModules/xoalbum/trunk/xoalbum/sql/mysql.sql
===================================================================
--- XoopsModules/xoalbum/trunk/xoalbum/sql/mysql.sql 2014-05-12 14:20:13 UTC (rev 12528)
+++ XoopsModules/xoalbum/trunk/xoalbum/sql/mysql.sql 2014-05-13 09:47:33 UTC (rev 12529)
@@ -1,54 +1,58 @@
-CREATE TABLE `album_album` (
- `album_id` int(8) NOT NULL auto_increment,
- `cat_id` smallint(6) NOT NULL,
- `uid` int(8) NOT NULL,
- `album_name` varchar(64) NOT NULL,
- `album_desc` varchar(255) NOT NULL,
- `album_total` smallint(6) NOT NULL,
- `album_cover` varchar(255) NOT NULL,
- `album_views` smallint(6) NOT NULL,
- `album_status` tinyint(1) NOT NULL,
- `album_dateline` int(10) NOT NULL,
- PRIMARY KEY (`album_id`),
+CREATE TABLE `album` (
+ `album_id` INT(8) NOT NULL AUTO_INCREMENT,
+ `cat_id` SMALLINT(6) NOT NULL,
+ `uid` INT(8) NOT NULL,
+ `album_name` VARCHAR(64) NOT NULL,
+ `album_desc` VARCHAR(255) NOT NULL,
+ `album_total` SMALLINT(6) NOT NULL,
+ `album_cover` VARCHAR(255) NOT NULL,
+ `album_views` SMALLINT(6) NOT NULL,
+ `album_status` TINYINT(1) NOT NULL,
+ `album_dateline` INT(10) NOT NULL,
+ PRIMARY KEY (`album_id`),
KEY `cat_id` (`cat_id`),
KEY `uid` (`uid`)
-) ENGINE=MyISAM ;
+)
+ ENGINE =MyISAM;
-CREATE TABLE `album_category` (
- `cat_id` smallint(6) NOT NULL auto_increment,
- `cat_name` varchar(32) NOT NULL,
- `cat_total` int(8) NOT NULL,
- `cat_order` smallint(6) NOT NULL,
- `cat_dateline` int(10) NOT NULL,
- PRIMARY KEY (`cat_id`)
-) ENGINE=MyISAM ;
+CREATE TABLE `category` (
+ `cat_id` SMALLINT(6) NOT NULL AUTO_INCREMENT,
+ `cat_name` VARCHAR(32) NOT NULL,
+ `cat_total` INT(8) NOT NULL,
+ `cat_order` SMALLINT(6) NOT NULL,
+ `cat_dateline` INT(10) NOT NULL,
+ PRIMARY KEY (`cat_id`)
+)
+ ENGINE =MyISAM;
-CREATE TABLE `album_grid` (
- `grid_id` int(8) NOT NULL auto_increment,
- `uid` int(8) NOT NULL,
- `pic_id` int(8) NOT NULL,
- `grid_title` varchar(120) NOT NULL,
- `grid_data` varchar(255) NOT NULL,
- `grid_date` int(10) NOT NULL,
- PRIMARY KEY (`grid_id`),
- KEY `uid` (`uid`,`pic_id`)
-) ENGINE=MyISAM ;
+CREATE TABLE `grid` (
+ `grid_id` INT(8) NOT NULL AUTO_INCREMENT,
+ `uid` INT(8) NOT NULL,
+ `pic_id` INT(8) NOT NULL,
+ `grid_title` VARCHAR(120) NOT NULL,
+ `grid_data` VARCHAR(255) NOT NULL,
+ `grid_date` INT(10) NOT NULL,
+ PRIMARY KEY (`grid_id`),
+ KEY `uid` (`uid`, `pic_id`)
+)
+ ENGINE =MyISAM;
-CREATE TABLE `album_picture` (
- `pic_id` int(8) NOT NULL auto_increment,
- `uid` int(8) NOT NULL,
- `album_id` int(8) NOT NULL,
- `pic_name` varchar(32) NOT NULL,
- `pic_desc` varchar(255) NOT NULL,
- `pic_filename` varchar(255) NOT NULL,
- `pic_filetype` varchar(64) NOT NULL,
- `pic_thumbfirst` varchar(255) NOT NULL,
- `pic_thumbsecond` varchar(255) NOT NULL,
- `pic_size` int(8) NOT NULL,
- `pic_dateline` int(10) NOT NULL,
- `pic_comments` smallint(6) NOT NULL,
- `pic_downloads` smallint(6) NOT NULL,
- PRIMARY KEY (`pic_id`),
+CREATE TABLE `picture` (
+ `pic_id` INT(8) NOT NULL AUTO_INCREMENT,
+ `uid` INT(8) NOT NULL,
+ `album_id` INT(8) NOT NULL,
+ `pic_name` VARCHAR(32) NOT NULL,
+ `pic_desc` VARCHAR(255) NOT NULL,
+ `pic_filename` VARCHAR(255) NOT NULL,
+ `pic_filetype` VARCHAR(64) NOT NULL,
+ `pic_thumbfirst` VARCHAR(255) NOT NULL,
+ `pic_thumbsecond` VARCHAR(255) NOT NULL,
+ `pic_size` INT(8) NOT NULL,
+ `pic_dateline` INT(10) NOT NULL,
+ `pic_comments` SMALLINT(6) NOT NULL,
+ `pic_downloads` SMALLINT(6) NOT NULL,
+ PRIMARY KEY (`pic_id`),
KEY `album_id` (`album_id`),
KEY `uid` (`uid`)
-) ENGINE=MyISAM;
\ No newline at end of file
+)
+ ENGINE =MyISAM;
Modified: XoopsModules/xoopsheadline/branches/ZySpec/xoopsheadline/sql/mysql.sql
===================================================================
--- XoopsModules/xoopsheadline/branches/ZySpec/xoopsheadline/sql/mysql.sql 2014-05-12 14:20:13 UTC (rev 12528)
+++ XoopsModules/xoopsheadline/branches/ZySpec/xoopsheadline/sql/mysql.sql 2014-05-13 09:47:33 UTC (rev 12529)
@@ -13,7 +13,7 @@
headline_mainmax tinyint(2) unsigned NOT NULL default '10',
headline_blockimg tinyint(1) unsigned NOT NULL default '0',
headline_blockmax tinyint(2) unsigned NOT NULL default '10',
- headline_xml text NOT NULL default '',
+ headline_xml text NOT NULL,
headline_updated int(10) NOT NULL default'0',
PRIMARY KEY (headline_id)
) ENGINE=MyISAM;
Modified: XoopsModules/xoopsheadline/trunk/xoopsheadline/sql/mysql.sql
===================================================================
--- XoopsModules/xoopsheadline/trunk/xoopsheadline/sql/mysql.sql 2014-05-12 14:20:13 UTC (rev 12528)
+++ XoopsModules/xoopsheadline/trunk/xoopsheadline/sql/mysql.sql 2014-05-13 09:47:33 UTC (rev 12529)
@@ -13,7 +13,7 @@
headline_mainmax tinyint(2) unsigned NOT NULL default '10',
headline_blockimg tinyint(1) unsigned NOT NULL default '0',
headline_blockmax tinyint(2) unsigned NOT NULL default '10',
- headline_xml text NOT NULL default '',
+ headline_xml text NOT NULL,
headline_updated int(10) NOT NULL default'0',
PRIMARY KEY (headline_id)
) ENGINE=MyISAM;
Modified: XoopsModules/xoopspoll/branches/zyspec/sql/mysql.sql
===================================================================
--- XoopsModules/xoopspoll/branches/zyspec/sql/mysql.sql 2014-05-12 14:20:13 UTC (rev 12528)
+++ XoopsModules/xoopspoll/branches/zyspec/sql/mysql.sql 2014-05-13 09:47:33 UTC (rev 12529)
@@ -21,7 +21,7 @@
CREATE TABLE mod_xoopspoll_desc (
poll_id mediumint(8) unsigned NOT null auto_increment,
question varchar(255) NOT null default '',
- description tinytext NOT null default '',
+ description tinytext NOT NULL,
user_id int(5) unsigned NOT null default '0',
start_time int(10) unsigned NOT null default '0',
end_time int(10) unsigned NOT null default '0',
Modified: XoopsModules/xoopstube/trunk/xoopstube/sql/xoopstube.sql
===================================================================
--- XoopsModules/xoopstube/trunk/xoopstube/sql/xoopstube.sql 2014-05-12 14:20:13 UTC (rev 12528)
+++ XoopsModules/xoopstube/trunk/xoopstube/sql/xoopstube.sql 2014-05-13 09:47:33 UTC (rev 12529)
@@ -114,8 +114,8 @@
`vidrating` tinyint(1) NOT NULL default '0',
`time` varchar(7) NOT NULL default '0:00:00',
`keywords` varchar(255) NOT NULL default '',
- `item_tag` text NOT NULL default '',
- `picurl` text NOT NULL default '',
+ `item_tag` text NOT NULL,
+ `picurl` text NOT NULL,
PRIMARY KEY (`requestid`)
) ENGINE=MyISAM COMMENT='XoopsTube by McDonald' AUTO_INCREMENT=1 ;
@@ -149,8 +149,8 @@
`vidrating` tinyint(1) NOT NULL default '0',
`time` varchar(7) NOT NULL default '0:00:00',
`keywords` varchar(255) NOT NULL default '',
- `item_tag` text NOT NULL default '',
- `picurl` text NOT NULL default '',
+ `item_tag` text NOT NULL,
+ `picurl` text NOT NULL,
PRIMARY KEY (`lid`),
KEY `cid` (`cid`),
KEY `status` (`status`),
|
