Code: Select all
# MySQL-Front Dump 1.22
#
# Host: uniapp3 Database: purchise2005
#--------------------------------------------------------
# Server version 4.0.13-nt
#
# Table structure for table 'order_header'
#
CREATE TABLE /*!32300 IF NOT EXISTS*/ order_header (
order_id int(6) unsigned NOT NULL auto_increment,
date int(11) unsigned ,
done_date int(11) unsigned ,
vendor text ,
tel varchar(11) ,
fax varchar(11) ,
price_num varchar(10) ,
cont_person varchar(30) ,
firm_id tinyint(2) unsigned ,
dep_id tinyint(3) unsigned ,
aim_id tinyint(3) unsigned ,
user_name varchar(10) ,
payment_cond text ,
descr text ,
comment text ,
our_comment text ,
sum float ,
sum_invoice float ,
tax enum('1','0') DEFAULT '0' ,
budget_id int(6) unsigned NOT NULL DEFAULT '0' ,
budget_parent int(6) unsigned ,
acc_mankal enum('0','1','2') NOT NULL DEFAULT '0' ,
acc_hashav enum('0','1','2') NOT NULL DEFAULT '0' ,
acc_minahel enum('0','1','2') NOT NULL DEFAULT '0' ,
status int(4) unsigned NOT NULL DEFAULT '0' ,
cancell tinyint(1) unsigned zerofill NOT NULL DEFAULT '0' ,
send tinyint(1) unsigned zerofill NOT NULL DEFAULT '0' ,
closed enum('1','0') DEFAULT '0' ,
clause_owner varchar(10) ,
clause_parent_owner varchar(10) ,
lastapproved varchar(10) ,
PRIMARY KEY (order_id),
UNIQUE order_id (order_id),
INDEX order_id_2 (order_id)
);
#
# Table structure for table 'users'
#
CREATE TABLE /*!32300 IF NOT EXISTS*/ users (
user_id tinyint(3) unsigned NOT NULL auto_increment,
user_name varchar(10) ,
user_name_heb varchar(30) ,
user_pass varchar(10) ,
firm_list varchar(20) ,
level enum('1','0') NOT NULL DEFAULT '1' ,
is_mankal enum('1','0') DEFAULT '0' ,
is_hashav enum('1','0') DEFAULT '0' ,
dep_list text ,
signature varchar(20) ,
tel varchar(12) ,
tools varchar(50) ,
invoice_access enum('1','0') DEFAULT '0' ,
PRIMARY KEY (user_id),
UNIQUE user_id (user_id),
INDEX user_id_2 (user_id)
);