open localhost mysql database http://127.0.0.1:4001/phpmyadmin/index.php dbuser "root" dbpassword ""
create in database server2go table database
Hostname:localhost OR 127.0.0.1 OR 127.0.0.1:3306
Hostname:
Database:
test@127.0.0.1

test@127.0.0.1

ROWS33

Rsc
RscID (int)
RscMD5 (string[8])
RscTypeID (int)
RscName (string[127])
IsURL (int)
RscStateID (int)
InCache (int)
Size (int)

RscComp
RscCompID (int)
RscID (int)
RscCompTypeID (int)
Position (int)
Size (int)
Filename (string[255])

RscCompType
RscCompTypeID (int)
RscCompType (string[50])

RscCompView
RscCompViewID (int)
RscCompID (int)
req_date (timestamp)

RscFetch
RscFetchID (int)
RscID (int)
FetchDate (timestamp)
FetchSeconds (real)
FromCache (int)
Size (int)

RscMail
RscMailID (int)
RscMD5 (string[8])
Position (int)
RendID (int)
Mailfrom (string[127])
Mailto (string[127])
Comment (blob)
req_date (datetime)

RscType
RscTypeID (int)
RscType (string[50])

RscTypeRend
RscTypeRendID (int)
RscTypeID (int)
RendDefault (int)
RscTypeRend (string[50])
RendCmd (string[127])

address_book
username (string[255])
name (string[255])
number (string[255])
other_details (string[255])

code
id (int)
code (int)

config
name (string[255])
value (string[255])

credit
id (int)
duedate (string[100])
p_code (string[100])
paid (string[100])
creditpayable (string[100])
duepayable (string[100])
coverage (string[100])
nu_payment (string[100])
name (string[300])
purdate (string[100])

creditdatails
id (int)
amount (int)
datepayment (string[30])
memberid (string[10])
ornumber (string[10])

cuscode
id (int)
code (int)

customer
id (int)
name (string[60])
lname (string[100])
mname (string[100])
occupation (string[100])
ddate (string[100])
bday (string[100])
address (blob)
tel (string[11])
office (string[100])
mobile (string[100])
hostess (string[100])
email (string[100])
member_id (string[100])
code (string[30])
ds (string[100])
ns (string[100])
cs (string[100])
os (string[100])
aa (string[100])
ab (string[100])
pro (string[100])
proo (string[100])
ma (string[100])
mb (string[100])
mc (string[100])
md (string[100])
me (string[100])
mf (string[100])
ba (string[100])
bb (string[100])
bc (string[100])
bd (string[100])
be (string[100])
bf (string[100])
bg (string[100])
bh (string[100])
bi (string[100])
bj (string[100])
bk (string[100])
bl (string[100])
bm (string[100])
bn (string[100])
bo (string[100])
bp (string[100])
ca (string[100])
cb (string[100])
cc (string[100])
cd (string[100])
ce (string[100])
birthday (string[100])

delrep
id (int)
reportcode (string[255])
destinationnum (string[255])
reference (string[255])

list
id (int)
listorder (blob)

order_details
transaction_code (int)
name (string[100])
Firstname (string[100])
price (int)
qty (int)
total (int)
status (string[100])
modeofpayment (string[100])
action (string[100])
orderid (int)
productID (int)
memberID (int)

paycode
id (int)
code (string[10])

productlist
id (int)
pcode (string[100])
pname (string[100])
pdesc (string[100])
psold (string[100])
pleft (string[100])
pprice (string[100])

sales
id (int)
name (string[100])
qty (string[100])
total (string[100])
code (string[100])
date (string[100])
time (string[100])
PRICE (string[100])
pcode (string[100])

salessumarry
id (int)
date (string[30])
transactioncode (string[30])
total (string[30])
mode (string[30])
a (string[30])
b (string[30])
name (string[100])

sent_messages
id (int)
username (string[50])
wap_address (string[200])
originator (string[20])
message_type (string[20])
flash (string[6])
contents (string[160])
datetime (datetime)

socode
id (int)
code (int)

stockin
id (int)
name (string[100])
CODE (string[100])
qty (int)
total (int)
datepurchase (string[100])
transactioncode (string[100])
PRICE (int)
supplier (string[100])

stockinsumarry
id (int)
code (string[100])
totalqty (int)
total (string[100])
less (string[100])
vsales (string[100])
vat (string[100])
totalamountdue (string[100])
pdate (string[100])
supplier (string[100])

supplier
id (int)
company_name (string[100])
contact_name (string[100])
address (string[100])
contactno (string[100])
bday (string[100])

tb_member
Firstname (string[100])
Lastname (string[100])
Email (string[100])
Contact_Number (string[100])
Password (string[100])
address (string[100])
orderid (int)
productID (int)
memberID (int)

tb_products
productID (int)
name (string[30])
description (blob)
category (string[30])
originated (blob)
price (int)
quantity (int)
location (string[200])

tb_user
user_id (int)
username (string[100])
password (string[100])
firstname (string[100])
lastname (string[100])

test
id (int)
acqcode (string[255])

user
id (int)
username (string[30])
password (string[30])

users
username (string[50])
password (string[50])
name (string[50])
details (string[100])
add1 (string[100])
add2 (string[100])
add3 (string[100])
postcode (string[10])
email (string[100])
mobile (string[15])
landline (string[15])
pword_lock (string[6])
admin (string[6])
credits (int)
locked (string[6])

backup2 backup3 change this url

backup2 backup3 change this url