Page MenuHomePhabricator
Paste P13752

(An Untitled Masterwork)
ArchivedPublic

Authored by Kormat on Wed, Jan 13, 10:34 AM.
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)

Event Timeline

Kormat created this paste.Wed, Jan 13, 10:34 AM
Kormat archived this paste.Thu, Jan 14, 9:49 AM