DIR : /home/kozerus/public_html/ko_center/sql/schema_defrag.sql

/home/kozerus/public_html/ko_center/sql

CREATE TABLE dbs ( dbs_id INTEGER PRIMARY KEY DESC, role VARCHAR, dbcode VARCHAR, dbfile VARCHAR, tbl_name VARCHAR, col_name VARCHAR, col_index VARCHAR, col_width VARCHAR, col_sorttype VARCHAR, col_editable VARCHAR, col_editrules VARCHAR, col_hidden VARCHAR, col_display VARCHAR, col_misc VARCHAR, notes VARCHAR);
CREATE TABLE defrag_plan ( oldrowname text,cab text,upos text,fld04 text,network text,model text,cpumem text,hrctag text,sn text,franksid text,purchased text,enddate text,amps text,rpdu_bank text,rpdu_outlets text,switch text,port text,connection text,pmm text,circuit text,panel text,breaker text,feed text,fld24 text, temp text );
CREATE TABLE defrag_plansum ( cabc text,f2 text,f3 text,cabd text,f5 text,f6 text,fld07 text, temp text );
CREATE TABLE fp (fp_id INTEGER PRIMARY KEY, code VARCHAR, status VARCHAR, label VARCHAR, title VARCHAR, width VARCHAR, height VARCHAR, dttm VARCHAR, comment VARCHAR, unique_id VARCHAR);
CREATE TABLE grid (grid_id INTEGER PRIMARY KEY, code VARCHAR, status VARCHAR, x VARCHAR, y VARCHAR, org VARCHAR, name VARCHAR, phone VARCHAR, email VARCHAR, dttm VARCHAR, comment VARCHAR, unique_id VARCHAR );
CREATE TABLE hrc_datacenters_equipment ( f1 text,f2 text,machine text,cab text,position text,fld06 text,network text,model text,cpumem text,bluetag text,hrcnum text,sn text,franksid text,purchased text,enddate text,amps text,rpdu_bank text,rpdu_outlets text,switch text,port text,connection text,pmm text,circuit text,panel text,breaker text,feed text, temp text );
CREATE TABLE hrc_datacenters_equipment_defrag ( oldrowname text,cab text,upos text,f1 text,network text,model text,cpumem text,hrcnum text,sn text,franksid text,purchased text,enddate text,amps text,rpdu_bank text,rpdu_outlets text,switch text,port text,connection text,pmm text,circuit text,panel text,breaker text,feed text,fld24 text, temp text );
CREATE TABLE hrc_dc_1307comm ( machine text,cab text,pos text,fld04 text,model text,bluetag text,amps text, temp text );
CREATE TABLE hrc_dc_1307unix ( machine text,cab text,upos text,f4 text,model text,bluetag text,sn text, temp text );
CREATE TABLE hrc_dc_1307win ( machine text,cab text,upos text,fld04 text,model text,amps text, temp text );
CREATE TABLE hrc_dc_btu ( f1 text,f2 text,machine text,cab text,pos text,f6 text,network text,model text,cpumem text,bluetag text,hrcnum text,sn text,franksid text,purchased text,enddate text,amps text,rpdu_bank text,rpdu_outlets text,switch text,port text,connection text,pmm text,circuit text,panel text,breaker text,feed text, temp text );
CREATE TABLE hrc_dc_comm ( nge text,machine text,cab text,position text,f8 text,network text,model text,bluetag text,hrcnum text,sn text,franksid text,amps text,rpdu_bank text,rpdu_outlets text,pmm text,circuit text,panel text,breaker text,feed text,fld20 text,fld21 text,fld22 text,fld23 text,fld24 text,fld25 text,fld26 text,fld27 text, temp text );
CREATE TABLE hrc_dc_explain ( rpdu_bank text,nc text,not_connected text, temp text );
CREATE TABLE hrc_dc_hrc ( servers text,switches text,storage text,other text,f8 text,oldrowname text,cab text,upos text,f9 text,network text,model text,cpumem text,hrcnum text,sn text,amps text,rpdu_bank text,rpdu_outlets text,switch text,port text,connection text,ppm text,circuit text,panel text,breaker text,feed text,fld26 text,fld27 text,fld28 text,fld29 text,fld30 text,fld31 text,fld32 text,fld33 text, temp text );
CREATE TABLE hrc_dc_indy138k ( servers text,switches text,storage text,other text,f1 text,machine text,cab text,upos text,fld09 text,network text,model text,cpumem text,bluetag text,hrcnum text,sn text,franksid text,purchased text,enddate text,amps text,rpdu_bank text,rpdu_outlets text,switch text,port text,connection text,pmm text,circuit text,panel text,breaker text,feed text,f2 text,btudev text,btucab text, temp text );
CREATE TABLE hrc_dc_indy139k ( servers text,switches text,storage text,other text,f1 text,machine text,cab text,upos text,f2 text,network text,model text,cpumem text,bluetag text,hrcnum text,sn text,franksid text,purchased text,enddate text,amps text,rpdu_bank text,rpdu_outlets text,switch text,port text,connection text,pmm text,circuit text,panel text,breaker text,feed text,f3 text,btudev text,btucab text, temp text );
CREATE TABLE hrc_dc_ports ( port text,connto text,port2 text,connto2 text, temp text );
CREATE TABLE hrc_dc_power ( machine text,cab text,pos text,fld04 text,network text,model text,amps text,rpdu_bank text,rpdu_outlets text,flaga text,flagb text,flagall text, temp text );
CREATE TABLE hrc_dc_unix ( f1 text,f2 text,machine text,cab text,upos text,fld06 text,network text,model text,cpumem text,bluetag text,hrcnum text,sn text,franksid text,purchased text,enddate text,amps text,rpdu_bank text,rpdu_outlets text,switch text,port text,connection text,pmm text,circuit text,panel text,breaker text,feed text, temp text );
CREATE TABLE hrc_dc_win ( f1 text,f2 text,sn text,machine text,cab text,upos text,f3 text,network text,model text,cpumem text,bluetag text,hrcnum text,franksid text,amps text,purchased text,enddate text,rpdu_bank text,rpdu_outlets text,switch text,port text,connection text,pmm text,circuit text,panel text,breaker text,feed text,f4 text,fld28 text, temp text );
CREATE TABLE hw ( servers text,switches text,storage text,other text,fld05 text,old_rowname text,cab text,u_position text,fld09 text,network text,model text,cpumem text,hrc_tag text,sn text,amps text,rpdu_bank text,rpdu_outlet text,switch text,port text,connection text,pmm text,circuit text,panel text,breaker text,feed text, temp text );
CREATE TABLE hw_chi ( loc text,cab text,slot text,item text,sn text,asset text,fld07 text,fld08 text, temp text );
CREATE TABLE leds ( led_id INTEGER PRIMARY KEY, led_status VARCHAR, led_code VARCHAR, led_name VARCHAR, led_dttm VARCHAR, led_color VARCHAR, led_speed VARCHAR, led_type VARCHAR, led_date VARCHAR, led_cmd VARCHAR, led_cmdout VARCHAR, led_desc VARCHAR, led_misc VARCHAR, led_city VARCHAR, led_bldg VARCHAR, led_loc_code VARCHAR, led_floor VARCHAR, led_group VARCHAR, led_orgs VARCHAR, led_title VARCHAR, led_published VARCHAR, led_width VARCHAR, led_height VARCHAR, led_comment VARCHAR, led_filename VARCHAR, led_user VARCHAR, led_user_ip VARCHAR, led_referer VARCHAR, led_remote_port VARCHAR, led_viewrole VARCHAR, led_user_agent VARCHAR, led_unique_id VARCHAR, led_err VARCHAR, led_fix VARCHAR, led_os );
CREATE TABLE menus ( menus_id INTEGER PRIMARY KEY DESC, role VARCHAR, url VARCHAR, levels VARCHAR);
CREATE TABLE moveplan_details ( cab text,zone text,grp text,vendor text,item text,cab1 text,zone1 text,grp1 text,btu text,watts text,amps text,vac text,height text,width text,depth text,weight text,spectext text, temp text );
CREATE TABLE n11 (n11_id INTEGER PRIMARY KEY, code VARCHAR, status VARCHAR, x VARCHAR, y VARCHAR, grp VARCHAR, name VARCHAR, phone VARCHAR, email VARCHAR, ip VARCHAR, dttm VARCHAR, comment VARCHAR, unique_id VARCHAR );
CREATE TABLE nodes ( node_id INTEGER PRIMARY KEY, node_status VARCHAR, node_code VARCHAR, node_name VARCHAR, node_dttm VARCHAR, node_color VARCHAR, node_speed VARCHAR, node_city VARCHAR, node_bldg VARCHAR, node_loc_code VARCHAR, node_floor VARCHAR, node_group VARCHAR, node_orgs VARCHAR, node_title VARCHAR, node_published VARCHAR, node_width VARCHAR, node_height VARCHAR, node_comment VARCHAR, node_filename VARCHAR, node_user VARCHAR, node_user_ip VARCHAR, node_referer VARCHAR, node_remote_port VARCHAR, node_viewrole VARCHAR, node_user_agent VARCHAR, node_unique_id VARCHAR );
CREATE TABLE obj ( obj_id INTEGER PRIMARY KEY, filename VARCHAR, width VARCHAR, height VARCHAR, nhor VARCHAR, nvert VARCHAR, title VARCHAR, desc VARCHAR );
CREATE TABLE pano ( pano_id INTEGER PRIMARY KEY, filename VARCHAR, width VARCHAR, height VARCHAR, nhor VARCHAR, nvert VARCHAR, title VARCHAR, desc VARCHAR );
CREATE TABLE periods ( 	
	yyyy text,
	fy text,
	p text,
	q text,
	wk text,
	begdt text,
	begday text,
	enddt text,
	endday text,
	oy text,
	est text,
	f3 text,
	f4 text,
	f5 text,
	f6 text,
	status text,
	desc text
 );
CREATE TABLE roles (role_id INTEGER PRIMARY KEY, role_code VARCHAR, role_status VARCHAR, role_comment VARCHAR );
CREATE TABLE rpts (
	rptnum text,
	rptcode text,
	rptdesc text,
	rptsql text,
	dbfile text,
	sqlfile text,
	outfile text,
	status text
	);
CREATE TABLE shelves(
cab text,
zone text,
grp text,
vendor text,
item text, 
cab1 text,
zone1 text,
grp1 text,
btu text, 
watts text, 
amps text,
vac text, 
height text,
width text,
depth text,
weight text,
spectext text
	);
CREATE TABLE us (us_id INTEGER PRIMARY KEY, code VARCHAR, status VARCHAR, x VARCHAR, y VARCHAR, grp VARCHAR, name VARCHAR, phone VARCHAR, email VARCHAR, dttm VARCHAR, comment VARCHAR, unique_id VARCHAR );
CREATE TABLE users (user_id INTEGER PRIMARY KEY, user_code VARCHAR, user_status VARCHAR, user_pass VARCHAR, user_role VARCHAR, user_group VARCHAR, user_name VARCHAR, user_phone VARCHAR, user_email VARCHAR, user_dttm VARCHAR, user_comment VARCHAR, user_pagelines VARCHAR user_unique_id VARCHAR );
CREATE TABLE zoom ( zoom_id INTEGER PRIMARY KEY, code VARCHAR, name VARCHAR, status VARCHAR, dttm VARCHAR, color VARCHAR, speed VARCHAR, city VARCHAR, bldg VARCHAR, loc VARCHAR, floor VARCHAR, groups VARCHAR, orgs VARCHAR, title VARCHAR, published VARCHAR, comment VARCHAR, filename VARCHAR, width VARCHAR, height VARCHAR, autoloop VARCHAR, choicelist VARCHAR, listsource VARCHAR, initialvisibility VARCHAR, minscale VARCHAR, maxscale

 VARCHAR );
CREATE TABLE zoomxml ( zoomxml_id INTEGER PRIMARY KEY, code VARCHAR, type VARCHAR, hs_id VARCHAR, name VARCHAR, desc VARCHAR, loc VARCHAR, org VARCHAR, email VARCHAR, phone VARCHAR, sn VARCHAR, ip VARCHAR, caption VARCHAR, x VARCHAR, y VARCHAR, zoom VARCHAR, media VARCHAR, url VARCHAR, mediatype VARCHAR, urltarget VARCHAR, transition VARCHAR, interval VARCHAR, duration
 VARCHAR );