/
githubmirror
/
joomla-cms
Обзор
Документация
Войти
/
githubmirror
/
joomla-cms
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
5.4-dev
tests/Integration/datasets/pgsql/testtable.sql
15 строк
524 B
Richard Fath
[4.0] Remove display widths for integer data types from SQL scripts for MySQL and MariaDB databases (#32608)
03 май 2021, 01:16
Не верифицирован
03 май 2021, 01:16
b9ae1ca
Код
Авторство
О чём код?
DROP TABLE IF EXISTS "#__testtable"; CREATE TABLE IF NOT EXISTS "#__testtable" ( "id" serial NOT NULL, "title" varchar(100) NOT NULL, "asset_id" bigint NOT NULL DEFAULT 0, "hits" bigint NOT NULL DEFAULT 0, "checked_out" integer, "checked_out_time" timestamp without time zone, "published" smallint DEFAULT 0 NOT NULL, "publish_up" timestamp without time zone, "publish_down" timestamp without time zone, "ordering" bigint NOT NULL DEFAULT 0, "params" text NOT NULL, PRIMARY KEY ("id") );