You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
paopao-ce/scripts/migration/sqlite3/0016_site_settings.up.sql

25 lines
1.1 KiB

CREATE TABLE "p_site_settings" (
"id" integer NOT NULL DEFAULT 1,
"use_friendship" integer NOT NULL DEFAULT 0,
"enable_trends_bar" integer NOT NULL DEFAULT 0,
"enable_wallet" integer NOT NULL DEFAULT 0,
"allow_tweet_attachment" integer NOT NULL DEFAULT 0,
"allow_tweet_attachment_price" integer NOT NULL DEFAULT 0,
"allow_tweet_video" integer NOT NULL DEFAULT 0,
"default_tweet_max_length" integer NOT NULL DEFAULT 2000,
"tweet_web_ellipsis_size" integer NOT NULL DEFAULT 400,
"tweet_mobile_ellipsis_size" integer NOT NULL DEFAULT 300,
"default_tweet_visibility" text(32) NOT NULL DEFAULT 'friend',
"default_msg_loop_interval" integer NOT NULL DEFAULT 5000,
"copyright_top" text(255) NOT NULL DEFAULT '',
"copyright_left" text(255) NOT NULL DEFAULT '',
"copyright_left_link" text(255) NOT NULL DEFAULT '',
"copyright_right" text(255) NOT NULL DEFAULT '',
"copyright_right_link" text(255) NOT NULL DEFAULT '',
"created_on" integer NOT NULL DEFAULT 0,
"modified_on" integer NOT NULL DEFAULT 0,
"deleted_on" integer NOT NULL DEFAULT 0,
"is_del" integer NOT NULL DEFAULT 0,
PRIMARY KEY ("id")
);