DIR : /home/kozerus/public_html/ko/ko.schema

/home/kozerus/public_html/ko

CREATE TABLE cfg (
	fld varchar,
	val varchar,
	desc varchar
	);
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 varchar
       );
CREATE TABLE leds_ai (
       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 varchar,
       id varchar,
       model varchar,
       created varchar,
       context_length varchar,
       pricing_prompt varchar,
       pricing_completion varchar,
       tool_calling varchar,
       structured_outputs varchar,
       reasoning varchar,
       response_format varchar,
       web_search varchar,
       vendor varchar,
       type varchar,
       status varchar,
       img varchar,
       tn varchar,
       zn varchar,
       tmp varchar
       );
CREATE TABLE leds_us (        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 varchar,
       id varchar,
       gender varchar,
       title varchar,
       fname varchar,
       lname varchar,
       str_no varchar,
       str_name varchar,
       city varchar,
       state varchar,
       country varchar,
       zip varchar,
       coord_lat varchar,
       coord_long varchar,
       tz_offset varchar,
       tz_descr varchar,
       email varchar,
       login_uuid varchar,
       login_user varchar,
       login_pass varchar,
       login_salt varchar,
       login_md5 varchar,
       login_sha1 varchar,
       login_sha256 varchar,
       dob_date varchar,
       dob_age varchar,
       reg_dt varchar,
       reg_age varchar,
       phn varchar,
       cell varchar,
       id_name varchar,
       id_val varchar,
       img varchar,
       tn varchar,
       zn varchar,
       nat varchar,
       tmp varchar
       );
CREATE TABLE menus ( menus_id INTEGER PRIMARY KEY DESC, role varchar, url varchar, levels 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 roles (role_id INTEGER PRIMARY KEY, role_code varchar, role_status varchar, role_comment 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 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 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 hw (hw_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 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 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);