SQLize Online / PHPize Online  /  SQLtest Online

ALTER TABLE inquiries2024 DROP COLUMN web_id; ALTER TABLE inquiries2025 DROP COLUMN web_id; CREATE TABLE attachments2025 ( id integer NOT NULL PRIMARY KEY AUTOINCREMENT, inquiry_id integer NOT NULL, filename varchar(250) NOT NULL, description varchar(250) ); CREATE TABLE attachments2026 ( id integer NOT NULL PRIMARY KEY AUTOINCREMENT, inquiry_id integer NOT NULL, filename varchar(250) NOT NULL, description varchar(250) ); CREATE TABLE documents2026 ( id integer NOT NULL PRIMARY KEY AUTOINCREMENT, fund_num varchar(25) NOT NULL, fund_name varchar(250), opis varchar(50), unit varchar(50), lists varchar(50), inquiry_id smallint NOT NULL ); CREATE TABLE inquiries2026 ( id integer NOT NULL PRIMARY KEY AUTOINCREMENT, reg_id integer NOT NULL, reg_date date NOT NULL, inquiry_type integer NOT NULL DEFAULT 1, source_id integer NOT NULL DEFAULT 1, subject varchar(255) NOT NULL, year_birth varchar(50), topic_id integer NOT NULL, content varchar(500), declarant varchar(255) NOT NULL, declarant_contact varchar(255), status_id integer NOT NULL, out_num varchar(50), out_date date, address varchar(255), phone varchar(50), notes varchar(255), control integer NOT NULL DEFAULT 0, due_days integer DEFAULT NULL, result_id integer NOT NULL DEFAULT 0, result_date date, user_id integer, sentby_id integer, price numeric(10,2), docs_count integer, used_count integer, copies_count integer, lists_count integer, registar_id smallint, "count" smallint NOT NULL DEFAULT 1, notified smallint NOT NULL DEFAULT 0, template_id smallint, prepaid numeric(9,2), due_date date NOT NULL, state_part smallint NOT NULL DEFAULT 0, division_code varchar(25) DEFAULT NULL, ex_note varchar(250) ); CREATE TABLE attachments2027 ( id integer NOT NULL PRIMARY KEY AUTOINCREMENT, inquiry_id integer NOT NULL, filename varchar(250) NOT NULL, description varchar(250) ); CREATE TABLE documents2027 ( id integer NOT NULL PRIMARY KEY AUTOINCREMENT, fund_num varchar(25) NOT NULL, fund_name varchar(250), opis varchar(50), unit varchar(50), lists varchar(50), inquiry_id smallint NOT NULL ); CREATE TABLE inquiries2027 ( id integer NOT NULL PRIMARY KEY AUTOINCREMENT, reg_id integer NOT NULL, reg_date date NOT NULL, inquiry_type integer NOT NULL DEFAULT 1, source_id integer NOT NULL DEFAULT 1, subject varchar(255) NOT NULL, year_birth varchar(50), topic_id integer NOT NULL, content varchar(500), declarant varchar(255) NOT NULL, declarant_contact varchar(255), status_id integer NOT NULL, out_num varchar(50), out_date date, address varchar(255), phone varchar(50), notes varchar(255), control integer NOT NULL DEFAULT 0, due_days integer DEFAULT NULL, result_id integer NOT NULL DEFAULT 0, result_date date, user_id integer, sentby_id integer, price numeric(10,2), docs_count integer, used_count integer, copies_count integer, lists_count integer, registar_id smallint, "count" smallint NOT NULL DEFAULT 1, notified smallint NOT NULL DEFAULT 0, template_id smallint, prepaid numeric(9,2), due_date date NOT NULL, state_part smallint NOT NULL DEFAULT 0, division_code varchar(25) DEFAULT NULL, ex_note varchar(250) );