Page MenuHomePhabricator
Paste P13752

(An Untitled Masterwork)
ArchivedPublic
Actions

Authored by Kormat on Jan 13 2021, 10:34 AM.
Tags
None
Referenced Files
F33997632: raw-paste-data.txt
Jan 13 2021, 10:34 AM
Subscribers
None
MariaDB [test]> CREATE TABLE `revision_actor_temp` (
-> `revactor_rev` int(10) unsigned,
-> `revactor_actor` bigint(20) unsigned DEFAULT NULL,
-> `revactor_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
-> `revactor_page` int(10) unsigned NOT NULL
-> );
Query OK, 0 rows affected (0.016 sec)
MariaDB [test]> select TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,COLUMN_DEFAULT,IS_NULLABLE,DATA_TYPE from information_schema.columns where TABLE_NAME='revision_actor_temp';
+--------------+---------------------+--------------------+--------------------------------+-------------+-----------+
| TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE |
+--------------+---------------------+--------------------+--------------------------------+-------------+-----------+
| test | revision_actor_temp | revactor_rev | NULL | YES | int |
| test | revision_actor_temp | revactor_actor | NULL | YES | bigint |
| test | revision_actor_temp | revactor_timestamp | '\0\0\0\0\0\0\0\0\0\0\0\0\0\0' | NO | binary |
| test | revision_actor_temp | revactor_page | NULL | NO | int |
+--------------+---------------------+--------------------+--------------------------------+-------------+-----------+
4 rows in set (0.003 sec)
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL