代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/428850/1953174
sql structure.sql
-- 修改友情链接名称字段长度为 255
ALTER TABLE `ecs_friend_link` CHANGE `link_name` `link_name` VARCHAR( 255 ) NOT NULL;
www.eeworm.com/read/428850/1953176
sql data.sql
--增加文章标题的长度设置
INSERT INTO `ecs_shop_config` ( `id` , `parent_id` , `code` , `type` , `store_range` , `store_dir` , `value` )
VALUES (
'325', '3', 'article_title_length', 'text', '', '', '30'
);
www.eeworm.com/read/428850/1953179
sql structure.sql
ALTER TABLE `ecs_activity`
CHANGE `name` `name` VARCHAR( 120 ) NOT NULL;
ALTER TABLE `ecs_ad`
CHANGE `position_id` `position_id` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
CHANGE `ad_link`
www.eeworm.com/read/428850/1953186
sql data.sql
-- 增加排行统计时间的选项设置
INSERT INTO `ecs_shop_config` ( `id` , `parent_id` , `code` , `type` , `store_range` , `store_dir` , `value` )
VALUES (
'222', '2', 'top10_time', 'select', '0,1,2,3,4', '', '0'
);
www.eeworm.com/read/428850/1953188
sql structure.sql
-- 增加Feed记录表
DROP TABLE IF EXISTS `ecs_user_feed`;
CREATE TABLE `ecs_user_feed` (
`feed_id` mediumint(8) unsigned NOT NULL auto_increment,
`user_id` mediumint(8) unsigned NOT NULL default '0',
`
www.eeworm.com/read/428850/1953194
sql structure.sql
-- 修改 sessions 表
DROP TABLE IF EXISTS `ecs_sessions`;
CREATE TABLE `ecs_sessions` (
`sesskey` char(32) binary NOT NULL default '',
`expiry` int(10) unsigned NOT NULL default '0',
`userid` m
www.eeworm.com/read/428850/1953204
sql structure.sql
ALTER TABLE `ecs_activity`
CHANGE `activity_id` `activity_id` smallint(5) unsigned NOT NULL auto_increment,
CHANGE `start_time` `start_time` int(10) unsigned NOT NULL default '0',
CHANGE `
www.eeworm.com/read/428850/1953215
sql structure.sql
ALTER TABLE `ecs_category`
CHANGE `cat_id` `cat_id` smallint(6) unsigned NOT NULL auto_increment;
ALTER TABLE `ecs_order_info`
CHANGE `from_ad` `from_ad` SMALLINT( 5 ) NOT NULL DEFAULT '0';
www.eeworm.com/read/428850/1953216
sql data.sql
REPLACE INTO `ecs_shop_config` ( `id` , `parent_id` , `code` , `type` , `store_range` , `store_dir` , `value` )
VALUES (
506, 5, 'mail_charset', 'select', 'UTF8,GB2312,BIG5', '', 'UTF8'
);
REP
www.eeworm.com/read/428850/1953219
sql structure.sql
-- 修改 cart 表
ALTER TABLE `ecs_cart` CHANGE `goods_attr_id` `goods_attr_id` VARCHAR( 60 ) NOT NULL DEFAULT '';
-- 增加商品批量购买优惠价格表
DROP TABLE IF EXISTS `ecs_volume_price`;
CREATE TABLE IF NOT EXISTS