Powerful and easy to use cms to build websites, blogs or ecommerce stores.
HTML backendblogblog-engineblog-platformbloggingcmscontent-managementcontent-management-systemecommerceecommerce-platformno-codepage-builderphpphp-cmsphp7php8self-hostedshopping-cartweb-applicationwebsite-builder
DROP TABLE IF EXISTS media;
-- DROP SEQUENCE IF EXISTS media_media_id_seq;
-- CREATE SEQUENCE media_media_id_seq;
-- SELECT setval('media_media_id_seq', 14, true); -- last inserted id by sample data
CREATE TABLE media (
"media_id" int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, -- SERIAL PRIMARY KEY
"file" varchar(191) NOT NULL,
"type" varchar(30) NOT NULL default 'image/png',
"meta" TEXT
-- PRIMARY KEY("media_id")
);
CREATE INDEX "file_media_id" ON media ("file", "media_id");