Home
last modified time | relevance | path

Searched refs:MODIFY (Results 1 – 25 of 6627) sorted by relevance

12345678910>>...266

/dports/net-mgmt/icinga2/icinga2-2.13.2/lib/db_ido_mysql/schema/upgrade/
H A D2.6.0.sql15 MODIFY COLUMN entry_time timestamp NULL,
16 MODIFY COLUMN end_time timestamp NULL;
19 MODIFY COLUMN entry_time timestamp NULL,
20 MODIFY COLUMN comment_time timestamp NULL,
25 MODIFY COLUMN entry_time timestamp NULL,
37 MODIFY COLUMN start_time timestamp NULL,
38 MODIFY COLUMN end_time timestamp NULL;
41 MODIFY COLUMN start_time timestamp NULL,
42 MODIFY COLUMN end_time timestamp NULL;
66 MODIFY COLUMN end_time timestamp NULL;
[all …]
/dports/games/cockatrice/Cockatrice-2021-01-26-Release-2.8.0/servatrice/migrations/
H A Dservatrice_0025_to_0026.sql14 ALTER TABLE cockatrice_users MODIFY COLUMN `admin` tinyint(1) NOT NULL AFTER `id`;
15 ALTER TABLE cockatrice_users MODIFY COLUMN `name` varchar(35) NOT NULL AFTER `admin`;
17 ALTER TABLE cockatrice_users MODIFY COLUMN `gender` char(1) NOT NULL AFTER `realname`;
20 ALTER TABLE cockatrice_users MODIFY COLUMN `country` char(2) NOT NULL AFTER `email`;
21 ALTER TABLE cockatrice_users MODIFY COLUMN `avatar_bmp` blob NOT NULL AFTER `country`;
24 ALTER TABLE cockatrice_users MODIFY COLUMN `token` binary(16) AFTER `active`;
49 ALTER TABLE cockatrice_rooms MODIFY COLUMN `name` varchar(50) NOT NULL AFTER `id`;
86 ALTER TABLE cockatrice_servers MODIFY COLUMN `ssl_cert` text NOT NULL AFTER `id`;
97 ALTER TABLE cockatrice_uptime MODIFY COLUMN `mods_list` TEXT AFTER `mods_count`;
115 ALTER TABLE cockatrice_bans MODIFY COLUMN `user_name` varchar(35) NOT NULL FIRST;
[all …]
/dports/databases/mysql55-client/mysql-5.5.62/scripts/
H A Dmysql_system_tables_fix.sql238 MODIFY thread_id INTEGER NOT NULL,
249 MODIFY query_time TIME NOT NULL,
250 MODIFY lock_time TIME NOT NULL,
253 MODIFY db VARCHAR(512) NOT NULL,
374 MODIFY Routine_name char(64)
399 MODIFY sql_mode
438 ALTER TABLE proc MODIFY db
440 MODIFY definer
442 MODIFY comment
498 ALTER TABLE proc MODIFY comment
[all …]
/dports/databases/mariadb103-client/mariadb-10.3.34/scripts/
H A Dmysql_system_tables_fix.sql259 MODIFY thread_id INTEGER NOT NULL,
275 MODIFY query_time TIME(6) NOT NULL,
276 MODIFY lock_time TIME(6) NOT NULL,
277 MODIFY rows_sent INTEGER NOT NULL,
279 MODIFY db VARCHAR(512) NOT NULL,
281 MODIFY insert_id INTEGER NOT NULL,
404 MODIFY Routine_name char(64)
429 MODIFY sql_mode
517 ALTER TABLE proc MODIFY db_collation
537 ALTER TABLE proc MODIFY comment
[all …]
/dports/databases/mariadb103-server/mariadb-10.3.34/scripts/
H A Dmysql_system_tables_fix.sql259 MODIFY thread_id INTEGER NOT NULL,
275 MODIFY query_time TIME(6) NOT NULL,
276 MODIFY lock_time TIME(6) NOT NULL,
277 MODIFY rows_sent INTEGER NOT NULL,
279 MODIFY db VARCHAR(512) NOT NULL,
281 MODIFY insert_id INTEGER NOT NULL,
404 MODIFY Routine_name char(64)
429 MODIFY sql_mode
517 ALTER TABLE proc MODIFY db_collation
537 ALTER TABLE proc MODIFY comment
[all …]
/dports/databases/percona56-server/percona-server-5.6.51-91.0/scripts/
H A Dmysql_system_tables_fix.sql224 MODIFY thread_id INTEGER NOT NULL,
237 MODIFY query_time TIME NOT NULL,
238 MODIFY lock_time TIME NOT NULL,
241 MODIFY db VARCHAR(512) NOT NULL,
350 MODIFY Routine_name char(64)
375 MODIFY sql_mode
414 ALTER TABLE proc MODIFY db
416 MODIFY definer
418 MODIFY comment
474 ALTER TABLE proc MODIFY comment
[all …]
/dports/databases/percona56-client/percona-server-5.6.51-91.0/scripts/
H A Dmysql_system_tables_fix.sql224 MODIFY thread_id INTEGER NOT NULL,
237 MODIFY query_time TIME NOT NULL,
238 MODIFY lock_time TIME NOT NULL,
241 MODIFY db VARCHAR(512) NOT NULL,
350 MODIFY Routine_name char(64)
375 MODIFY sql_mode
414 ALTER TABLE proc MODIFY db
416 MODIFY definer
418 MODIFY comment
474 ALTER TABLE proc MODIFY comment
[all …]
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/scripts/
H A Dmysql_system_tables_fix.sql224 MODIFY thread_id INTEGER NOT NULL,
237 MODIFY query_time TIME NOT NULL,
238 MODIFY lock_time TIME NOT NULL,
241 MODIFY db VARCHAR(512) NOT NULL,
350 MODIFY Routine_name char(64)
375 MODIFY sql_mode
414 ALTER TABLE proc MODIFY db
416 MODIFY definer
418 MODIFY comment
474 ALTER TABLE proc MODIFY comment
[all …]
/dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/scripts/
H A Dmysql_system_tables_fix.sql224 MODIFY thread_id INTEGER NOT NULL,
237 MODIFY query_time TIME NOT NULL,
238 MODIFY lock_time TIME NOT NULL,
241 MODIFY db VARCHAR(512) NOT NULL,
350 MODIFY Routine_name char(64)
375 MODIFY sql_mode
414 ALTER TABLE proc MODIFY db
416 MODIFY definer
418 MODIFY comment
474 ALTER TABLE proc MODIFY comment
[all …]
/dports/databases/mysql56-client/mysql-5.6.51/scripts/
H A Dmysql_system_tables_fix.sql224 MODIFY thread_id INTEGER NOT NULL,
237 MODIFY query_time TIME NOT NULL,
238 MODIFY lock_time TIME NOT NULL,
241 MODIFY db VARCHAR(512) NOT NULL,
350 MODIFY Routine_name char(64)
375 MODIFY sql_mode
414 ALTER TABLE proc MODIFY db
416 MODIFY definer
418 MODIFY comment
474 ALTER TABLE proc MODIFY comment
[all …]
/dports/net-mgmt/librenms/librenms-21.5.1/sql-schema/
H A D256.sql1 …MODIFY `ifInUcastPkts` BIGINT UNSIGNED, MODIFY `ifInUcastPkts_prev` BIGINT UNSIGNED, MODIFY `ifInU…
/dports/databases/mariadb105-client/mariadb-10.5.15/scripts/
H A Dmysql_system_tables_fix.sql242 MODIFY thread_id INTEGER NOT NULL,
245 MODIFY argument MEDIUMTEXT NOT NULL,
258 MODIFY query_time TIME(6) NOT NULL,
259 MODIFY lock_time TIME(6) NOT NULL,
260 MODIFY rows_sent INTEGER NOT NULL,
262 MODIFY db VARCHAR(512) NOT NULL,
264 MODIFY insert_id INTEGER NOT NULL,
372 MODIFY Routine_name char(64)
397 MODIFY sql_mode
486 ALTER TABLE proc MODIFY db_collation
[all …]
/dports/databases/mariadb104-server/mariadb-10.4.24/scripts/
H A Dmysql_system_tables_fix.sql242 MODIFY thread_id INTEGER NOT NULL,
245 MODIFY argument MEDIUMTEXT NOT NULL,
258 MODIFY query_time TIME(6) NOT NULL,
259 MODIFY lock_time TIME(6) NOT NULL,
260 MODIFY rows_sent INTEGER NOT NULL,
262 MODIFY db VARCHAR(512) NOT NULL,
264 MODIFY insert_id INTEGER NOT NULL,
372 MODIFY Routine_name char(64)
397 MODIFY sql_mode
486 ALTER TABLE proc MODIFY db_collation
[all …]
/dports/databases/mariadb104-client/mariadb-10.4.24/scripts/
H A Dmysql_system_tables_fix.sql242 MODIFY thread_id INTEGER NOT NULL,
245 MODIFY argument MEDIUMTEXT NOT NULL,
258 MODIFY query_time TIME(6) NOT NULL,
259 MODIFY lock_time TIME(6) NOT NULL,
260 MODIFY rows_sent INTEGER NOT NULL,
262 MODIFY db VARCHAR(512) NOT NULL,
264 MODIFY insert_id INTEGER NOT NULL,
372 MODIFY Routine_name char(64)
397 MODIFY sql_mode
486 ALTER TABLE proc MODIFY db_collation
[all …]
/dports/databases/mariadb105-server/mariadb-10.5.15/scripts/
H A Dmysql_system_tables_fix.sql242 MODIFY thread_id INTEGER NOT NULL,
245 MODIFY argument MEDIUMTEXT NOT NULL,
258 MODIFY query_time TIME(6) NOT NULL,
259 MODIFY lock_time TIME(6) NOT NULL,
260 MODIFY rows_sent INTEGER NOT NULL,
262 MODIFY db VARCHAR(512) NOT NULL,
264 MODIFY insert_id INTEGER NOT NULL,
372 MODIFY Routine_name char(64)
397 MODIFY sql_mode
486 ALTER TABLE proc MODIFY db_collation
[all …]
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/scripts/
H A Dmysql_system_tables_fix.sql293 MODIFY thread_id INTEGER NOT NULL,
307 MODIFY lock_time TIME(6) NOT NULL,
308 MODIFY rows_sent INTEGER NOT NULL,
310 MODIFY db VARCHAR(512) NOT NULL,
312 MODIFY insert_id INTEGER NOT NULL,
420 MODIFY Routine_name char(64)
447 MODIFY sql_mode
486 ALTER TABLE proc MODIFY db
488 MODIFY definer
490 MODIFY comment
[all …]
/dports/databases/percona57-server/percona-server-5.7.36-39/scripts/
H A Dmysql_system_tables_fix.sql293 MODIFY thread_id INTEGER NOT NULL,
307 MODIFY lock_time TIME(6) NOT NULL,
308 MODIFY rows_sent INTEGER NOT NULL,
310 MODIFY db VARCHAR(512) NOT NULL,
312 MODIFY insert_id INTEGER NOT NULL,
420 MODIFY Routine_name char(64)
447 MODIFY sql_mode
486 ALTER TABLE proc MODIFY db
488 MODIFY definer
490 MODIFY comment
[all …]
/dports/databases/percona57-client/percona-server-5.7.36-39/scripts/
H A Dmysql_system_tables_fix.sql293 MODIFY thread_id INTEGER NOT NULL,
307 MODIFY lock_time TIME(6) NOT NULL,
308 MODIFY rows_sent INTEGER NOT NULL,
310 MODIFY db VARCHAR(512) NOT NULL,
312 MODIFY insert_id INTEGER NOT NULL,
420 MODIFY Routine_name char(64)
447 MODIFY sql_mode
486 ALTER TABLE proc MODIFY db
488 MODIFY definer
490 MODIFY comment
[all …]
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/scripts/
H A Dmysql_system_tables_fix.sql293 MODIFY thread_id INTEGER NOT NULL,
307 MODIFY lock_time TIME(6) NOT NULL,
308 MODIFY rows_sent INTEGER NOT NULL,
310 MODIFY db VARCHAR(512) NOT NULL,
312 MODIFY insert_id INTEGER NOT NULL,
420 MODIFY Routine_name char(64)
447 MODIFY sql_mode
486 ALTER TABLE proc MODIFY db
488 MODIFY definer
490 MODIFY comment
[all …]
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/scripts/
H A Dmysql_system_tables_fix.sql293 MODIFY thread_id INTEGER NOT NULL,
307 MODIFY lock_time TIME(6) NOT NULL,
308 MODIFY rows_sent INTEGER NOT NULL,
310 MODIFY db VARCHAR(512) NOT NULL,
312 MODIFY insert_id INTEGER NOT NULL,
420 MODIFY Routine_name char(64)
447 MODIFY sql_mode
486 ALTER TABLE proc MODIFY db
488 MODIFY definer
490 MODIFY comment
[all …]
/dports/databases/mysql57-client/mysql-5.7.36/scripts/
H A Dmysql_system_tables_fix.sql293 MODIFY thread_id INTEGER NOT NULL,
307 MODIFY lock_time TIME(6) NOT NULL,
308 MODIFY rows_sent INTEGER NOT NULL,
310 MODIFY db VARCHAR(512) NOT NULL,
312 MODIFY insert_id INTEGER NOT NULL,
420 MODIFY Routine_name char(64)
447 MODIFY sql_mode
486 ALTER TABLE proc MODIFY db
488 MODIFY definer
490 MODIFY comment
[all …]
/dports/www/seahub/seahub-8.0.7-server/sql/
H A Doracle.sql2183 ALTER TABLE "POST_OFFICE_LOG" MODIFY ("ID" NOT NULL ENABLE);
2208 ALTER TABLE "API2_TOKEN" MODIFY ("CREATED" NOT NULL ENABLE);
2209 ALTER TABLE "API2_TOKEN" MODIFY ("KEY" NOT NULL ENABLE);
2224 ALTER TABLE "AVATAR_AVATAR" MODIFY ("ID" NOT NULL ENABLE);
2250 ALTER TABLE "BASE_FILECOMMENT" MODIFY ("ID" NOT NULL ENABLE);
2306 ALTER TABLE "SHARE_FILESHARE" MODIFY ("ID" NOT NULL ENABLE);
2314 ALTER TABLE "WIKI_GROUPWIKI" MODIFY ("ID" NOT NULL ENABLE);
2339 ALTER TABLE "CONSTANCE_CONFIG" MODIFY ("ID" NOT NULL ENABLE);
2397 ALTER TABLE "BASE_INNERPUBMSG" MODIFY ("ID" NOT NULL ENABLE);
2605 ALTER TABLE "PROFILE_PROFILE" MODIFY ("ID" NOT NULL ENABLE);
[all …]
/dports/www/joomla3/joomla3-3.9.24/administrator/components/com_admin/sql/updates/mysql/
H A D3.7.0-2017-01-08.sql2 ALTER TABLE `#__ucm_content` MODIFY `core_title` varchar(400) NOT NULL DEFAULT '';
4 ALTER TABLE `#__ucm_content` MODIFY `core_body` mediumtext;
6 ALTER TABLE `#__ucm_content` MODIFY `core_params` text;
8 ALTER TABLE `#__ucm_content` MODIFY `core_language` char(7) NOT NULL DEFAULT '';
9 ALTER TABLE `#__ucm_content` MODIFY `core_publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:0…
10 ALTER TABLE `#__ucm_content` MODIFY `core_publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00…
13 ALTER TABLE `#__ucm_content` MODIFY `core_images` text;
14 ALTER TABLE `#__ucm_content` MODIFY `core_urls` text;
15 ALTER TABLE `#__ucm_content` MODIFY `core_metakey` text;
16 ALTER TABLE `#__ucm_content` MODIFY `core_metadesc` text;
[all …]
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/scripts/
H A Dmysql_system_tables_fix.sql240 MODIFY user_host MEDIUMTEXT NOT NULL,
241 MODIFY thread_id INTEGER NOT NULL,
244 MODIFY argument MEDIUMBLOB NOT NULL;
253 MODIFY user_host MEDIUMTEXT NOT NULL,
254 MODIFY query_time TIME(6) NOT NULL,
255 MODIFY lock_time TIME(6) NOT NULL,
256 MODIFY rows_sent INTEGER NOT NULL,
258 MODIFY db VARCHAR(512) NOT NULL,
260 MODIFY insert_id INTEGER NOT NULL,
262 MODIFY sql_text MEDIUMBLOB NOT NULL;
[all …]
/dports/textproc/refdb/refdb-0.9.9-1/scripts/
H A Dmigrate_mysql_0.9.56 ALTER TABLE t_author MODIFY author_id BIGINT NOT NULL AUTO_INCREMENT;
7 ALTER TABLE t_keyword MODIFY keyword_id BIGINT NOT NULL AUTO_INCREMENT;
8 ALTER TABLE t_note MODIFY note_id BIGINT NOT NULL AUTO_INCREMENT, MODIFY note_user_id BIGINT;
9 ALTER TABLE t_periodical MODIFY periodical_id BIGINT NOT NULL AUTO_INCREMENT;
10 ALTER TABLE t_refdb MODIFY refdb_id BIGINT NOT NULL AUTO_INCREMENT, MODIFY refdb_periodical_id BIGI…
11 ALTER TABLE t_user MODIFY user_id BIGINT NOT NULL AUTO_INCREMENT;
12 ALTER TABLE t_xauthor MODIFY xauthor_id BIGINT NOT NULL AUTO_INCREMENT, MODIFY author_id BIGINT NOT…
13 ALTER TABLE t_xkeyword MODIFY xkeyword_id BIGINT NOT NULL AUTO_INCREMENT, MODIFY keyword_id BIGINT …
14 ALTER TABLE t_xnote MODIFY xnote_id BIGINT NOT NULL AUTO_INCREMENT, MODIFY note_id BIGINT NOT NULL,…
15 ALTER TABLE t_xuser MODIFY xuser_id BIGINT NOT NULL AUTO_INCREMENT, MODIFY user_id BIGINT NOT NULL,…

12345678910>>...266