代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/416749/2118483
sql rss.sql
CREATE TABLE `plugin_rss`
( `id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`url` varchar(200) NOT NULL,
`title` varchar(20) NOT NULL,
PRIMARY KEY (`id`))
ENGINE=MyISAM DEFAULT CHARSET=u
www.eeworm.com/read/416749/2118525
sql tagclouds.sql
CREATE TABLE `tag_words` (
`id` int(10) NOT NULL,
`tag` varchar(100) default NULL,
PRIMARY KEY (`id`))
ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `document_tags
www.eeworm.com/read/416749/2118550
sql workflow.sql
ALTER TABLE `workflow_states` ADD COLUMN `inform_descriptor_id` int(11) default NULL;
ALTER TABLE `workflow_transitions` CHANGE COLUMN `guard_permission_id` `guard_permission_id` int(11) default '0';
www.eeworm.com/read/416749/2118551
sql transactions.sql
ALTER TABLE `document_transaction_types_lookup` ADD `namespace` VARCHAR(250) NOT NULL;
ALTER TABLE `document_transaction_types_lookup` ADD INDEX (`namespace`);
UPDATE `document_transaction_types_looku
www.eeworm.com/read/416749/2118565
sql 1.2.1.sql
ALTER TABLE folders ADD COLUMN inherit_parent_folder_permission BIT;
UPDATE folders SET inherit_parent_folder_permission = 1;
UPDATE documents set status_id = 1;
UPDATE system_settings SET value="1.2.
www.eeworm.com/read/416749/2118630
sql nestedgroups.sql
CREATE TABLE `groups_groups_link` (
`id` int(11) NOT NULL default '0',
`parent_group_id` int(11) NOT NULL default '0',
`member_group_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYP
www.eeworm.com/read/416749/2118631
sql permissions.sql
ALTER TABLE `documents` ADD COLUMN `permission_object_id` int(11) default NULL;
ALTER TABLE `documents` ADD COLUMN `permission_lookup_id` int(11) default NULL;
ALTER TABLE `documents` ADD INDEX `permi
www.eeworm.com/read/416749/2118707
sql discussion.sql
ALTER TABLE `discussion_threads` ADD COLUMN `close_reason` text NOT NULL;
ALTER TABLE `discussion_threads` ADD COLUMN `close_metadata_version` int(11) NOT NULL default '0';
ALTER TABLE `discussion_thr
www.eeworm.com/read/416749/2118748
sql permission.sql
SELECT @permid:=id FROM `zseq_permissions`;
INSERT INTO `permissions` VALUES (@permid+1, 'ktcore.permissions.folder_rename', 'Rename Folder', 1);
TRUNCATE `zseq_permissions`;
INSERT INTO `zseq_permis
www.eeworm.com/read/416749/2118885
sql fieldsets.sql
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE `document_fieldsets`;
DROP TABLE `zseq_document_fieldsets`;
ALTER TABLE `document_type_fieldsets_link` DROP COLUMN `is_mandatory`; # was tinyint(1) NOT NULL defa