| Server IP : 180.180.241.3 / Your IP : 216.73.216.252 Web Server : Microsoft-IIS/7.5 System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.3.28 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /AppServ/www/news/tmp/install_5333cea8259e5/admin/install/ |
Upload File : |
CREATE TABLE "#__xmap_sitemap" (
"id" serial NOT NULL,
"title" character varying(255) DEFAULT NULL,
"alias" character varying(255) DEFAULT NULL,
"introtext" text DEFAULT NULL,
"metadesc" text DEFAULT NULL,
"metakey" text DEFAULT NULL,
"attribs" text DEFAULT NULL,
"selections" text DEFAULT NULL,
"excluded_items" text DEFAULT NULL,
"is_default" integer DEFAULT 0,
"state" integer DEFAULT NULL,
"access" integer DEFAULT NULL,
"created" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL,
"count_xml" integer DEFAULT NULL,
"count_html" integer DEFAULT NULL,
"views_xml" integer DEFAULT NULL,
"views_html" integer DEFAULT NULL,
"lastvisit_xml" integer DEFAULT NULL,
"lastvisit_html" integer DEFAULT NULL,
PRIMARY KEY ("id")
);
CREATE TABLE "#__xmap_items" (
"uid" character varying(100) NOT NULL,
"itemid" integer NOT NULL,
"view" character varying(10) NOT NULL,
"sitemap_id" integer NOT NULL,
"properties" varchar(300) DEFAULT NULL,
PRIMARY KEY ("uid","itemid","view","sitemap_id")
);
CREATE INDEX "#__xmap_items_idx_uid" on "#__xmap_items" ("uid", "itemid");
CREATE INDEX "#__xmap_items_idx_view" on "#__xmap_items" ("view");