Location: PHPKode > projects > WorkOrder TS > workorder-ts/setup_files/tables_values.php
<?PHP $_ILJ6l=array( 'Config'=> 'config','Customers'=> 'customers','CustomersDetail'=> 'customers_detail','Item'=> 'item','Ticket'=> 'ticket','TicketImages'=> 'ticket_images','Users'=> 'users','UsersLogin'=> 'users_login');$_jQ88L='config_name varchar(255) PRIMARY KEY,config_value varchar(255) null,config_value_text text null';$_jQt8f='ID int unsigned auto_increment PRIMARY KEY,BBus_name varchar(100) NULL,BBus_cont varchar(100) NULL,BBus_cont_title varchar(100) NULL,BBus_cont_alt varchar(100) NULL,BBus_cont_alt_title varchar(100) NULL,BTitle varchar(100) NULL,BName_first varchar(100) NULL,BName_last varchar(100) NULL,BAddress1 varchar(200) null,BAddress2 varchar(200) NULL,BAddress3 varchar(200) NULL,BCity varchar(100) NULL,BState varchar(20) NULL,BCountry varchar(50) NULL,BZip varchar(15),BPhone1 varchar(30) NULL,BPhone2 varchar(30) NULL,BMobile1 varchar(30) NULL,BMobile2 varchar(30) NULL,BOffice1 varchar(30) NULL,BOffice2 varchar(30) NULL,BFax1 varchar(30) NULL,BFax2 varchar(30) NULL,SBus_name varchar(100) NULL,SBus_cont varchar(100) NULL,SBus_cont_title varchar(100) NULL,SBus_cont_alt varchar(100) NULL,SBus_cont_alt_title varchar(100) NULL,STitle varchar(100) NULL,SName_first varchar(100) NULL,SName_last varchar(100) NULL,SAddress1 varchar(200) null,SAddress2 varchar(200) NULL,SAddress3 varchar(200) NULL,SCity varchar(100) NULL,SState varchar(20) NULL,SCountry varchar(50) NULL,SZip varchar(15),SPhone1 varchar(30) NULL,SPhone2 varchar(30) NULL,SMobile1 varchar(30) NULL,SMobile2 varchar(30) NULL,SOffice1 varchar(30) NULL,SOffice2 varchar(30) NULL,SFax1 varchar(30) NULL,SFax2 varchar(30) NULL,Email1  varchar(100) NULL,Email2 varchar(100) NULL,Web varchar(100) NULL,BeqS tinyint(1) default null,BackStop varchar(100) null,Date_edit timestamp';$_jQO6o='Detail_ID int unsigned auto_increment PRIMARY KEY,Customer_ID int unsigned, Details_Name varchar(255) null, Customer_Details text null,LastEdit timestamp';$_jQoJL='Item_ID int unsigned auto_increment PRIMARY KEY,Item_customer_id int unsigned not null,Item_make varchar(255) null,Item_model varchar(255) null,Item_accessories Text  null,Item_required_parts Text null,Item_ticket_id int unsigned null';$_jQo8C='ID int unsigned auto_increment PRIMARY KEY,Customer_ID int unsigned not null,Item_ID int unsigned NULL,Service_Type int unsigned not null,Service_Desc Text NULL,Service_Performed Text NULL,Tech_Notes Text NULL,CheckedIn datetime,CheckedInBy varchar(100) null,OnsiteScheduled datetime,OnsiteTechID int unsigned null,Timestamp timestamp,Call_cust1 DateTime,Call_cust1_notes varchar(255) NULL,Call_cust2 DateTime,Call_cust2_notes varchar(255) NULL,Call_cust3 DateTime,Call_cust3_notes varchar(255) NULL,Call_cust4 DateTime,Call_cust4_notes Text NULL,Call_cust5 DateTime,Custom_ticket_id varchar(255),Status_id int unsigned NULL,Invoice_nr int unsigned NULL,Store_id int unsigned NULL,Cust_un varchar(255) NULL,Cust_pw varchar(255) NULL,BackStop varchar(100) null,GuestKey varchar(15) NULL,FULLTEXT(Service_Desc,Service_Performed,Tech_Notes)';$_jQoCO='ID INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,FileDesc varchar(255) NULL,FileName varchar(255) NOT NULL,SubDir varchar(255) NOT NULL,TicketID INT UNSIGNED NOT NULL';$_jQCQ6='User_ID int unsigned auto_increment PRIMARY KEY,User_name varchar(255) not null UNIQUE,User_password varchar(35) not null,User_rights varchar(255) NULL,User_shop int unsigned null,User_temp_shop int null,User_temp_timeout datetime,User_active TINYINT(1) NULL,User_system TINYINT(1) UNSIGNED NULL,User_skills varchar(255),User_email varchar(255)';$_jQC66='Login_ID BIGINT UNSIGNED  AUTO_INCREMENT PRIMARY KEY,Login_USER_ID  INT UNSIGNED NOT NULL,Login_ssid varchar(200) NOT NULL,Login_ip varchar(200) NOT NULL,Login_time datetime NOT NULL';$_Il0tf='<p style=\"font-size: x-small\">    Exclusion of Liability for Data Loss and Component Conflicts    COMPANYNAME, shall have no liability with respect to    (1) data lost, regardless of the cause, (2) data recovery services,    data contained in any product in COMPANYNAME possession. COMPANYNAME has no obligation to pay for or reimburse for the recovering of    data. COMPANYNAME shall have no liability with respect to conflicts    between your software and components installed in and product placed in    COMPANYNAME possession, including but not limited to, upgrading    and/or adding components.    Warning: Any product left for more than thirty (30) days, after    reasonable attempts to notify you have been made, may be sold and    proceeds kept to cover monies due COMPANYNAME, for repair and/or    storage, including the cost of selling the product.    Notice of receipt of the above Liability Limitations and the acceptance    of the Limitations is acknowledges by the signature:</p>    <p style=\"font-size: small\">Signature:____________________________________________&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Date:________________<br>    By signing above, the person states that they have the proper authority    to approve any work requested to be done on the product left with    COMPANYNAME.</p>';$_ILlCO='<span style=\"font-weight: bold; font-size: small\">Instore-Rate:</span><span style=\"font-size: small\"> $ RATE/hour, $ RATE Desktop Diagnostic/Minimum, $ RATE Laptop Diagnostic/Minimum</span>';$_Il00j='<span style=\"font-weight: bold; font-size: small\">Onsite-Rate:</span><span style=\"font-size: small\"> $ RATE per hour, $ RATE minimum (no trip charge)</span>';$_ILlIL="./grfx/";?>
Return current item: WorkOrder TS