Host: localhost
Database: boatsite
Generation Time: Oct 23, 2008 at 02:38 PM
Generated by: phpMyAdmin 2.11.6 / MySQL 5.0.21
SQL query: show create table `site_users` ;
Rows: 1
| Table | Create Table |
|---|---|
| site_users | CREATE TABLE `site_users` (\n `id` bigint(20) NOT NULL auto_increment,\n `username` varchar(150) default NULL COMMENT 'M',\n `password` varchar(40) default NULL COMMENT 'M(encrypted format)',\n `trading_as` varchar(60) default NULL COMMENT '{Company,Partnership,Sole Trader,Other}',\n `trading_as_other` varchar(100) NOT NULL default '' COMMENT 'any value upto 100 characters',\n `business_name` varchar(255) default NULL,\n `abn` varchar(50) NOT NULL default '' COMMENT 'if a company registers and they are Australian they must provide an ABN',\n `acn` varchar(50) NOT NULL default '',\n `business_registration_number` varchar(50) NOT NULL default '',\n `business_licence_number` varchar(50) NOT NULL default '',\n `trading_name1` varchar(150) NOT NULL default '',\n `trading_name2` varchar(150) NOT NULL default '',\n `trading_name3` varchar(150) NOT NULL default '',\n `trading_name4` varchar(150) NOT NULL default '',\n `trading_name5` varchar(150) NOT NULL default '',\n `trading_name6` varchar(150) NOT NULL default '',\n `post_address1` varchar(255) NOT NULL default '',\n `post_address2` varchar(255) NOT NULL default '',\n `post_city` varchar(255) NOT NULL default '',\n `post_country` mediumint(255) NOT NULL default '0' COMMENT 'Reference from country table',\n `post_state` mediumint(2) NOT NULL default '0' COMMENT 'Reference from state table',\n `other_post_state` varchar(50) NOT NULL default '' COMMENT 'if country is other than Australia',\n `post_postcode` varchar(6) NOT NULL default '',\n `phy1_outlet1` varchar(150) NOT NULL default '',\n `phy1_address1` varchar(255) NOT NULL default '',\n `phy1_address2` varchar(255) NOT NULL default '',\n `phy1_city` varchar(255) NOT NULL default '',\n `phy1_country` mediumint(2) NOT NULL default '0' COMMENT 'Reference from country table',\n `phy1_state` mediumint(2) NOT NULL default '0' COMMENT 'Reference from state table',\n `other_phy1_state` varchar(50) NOT NULL default '' COMMENT 'if country is other than Australia',\n `phy1_postcode` varchar(6) NOT NULL default '',\n `phy2_outlet1` varchar(150) NOT NULL default '',\n `phy2_address1` varchar(255) NOT NULL default '',\n `phy2_address2` varchar(255) NOT NULL default '',\n `phy2_city` varchar(255) NOT NULL default '',\n `phy2_country` mediumint(2) NOT NULL default '0',\n `phy2_state` mediumint(2) NOT NULL default '0',\n `other_phy2_state` varchar(50) NOT NULL default '' COMMENT 'if country is other than Australia',\n `phy2_postcode` varchar(6) NOT NULL default '',\n `gen_email` varchar(150) NOT NULL default '',\n `gen_phone` varchar(15) NOT NULL default '',\n `gen_fax` varchar(20) NOT NULL default '',\n `bus_pri_firstname` varchar(50) NOT NULL default '',\n `bus_pri_surname` varchar(50) NOT NULL default '',\n `bus_pri_company_position` varchar(150) NOT NULL default '',\n `bus_pri_phone` varchar(15) NOT NULL default '',\n `bus_pri_mobile` varchar(15) NOT NULL default '',\n `bus_pri_email` varchar(150) NOT NULL default '',\n `bus_pri_fax` varchar(20) NOT NULL default '',\n `bus_sec_firstname` varchar(50) NOT NULL default '',\n `bus_sec_surname` varchar(50) NOT NULL default '',\n `bus_sec_company_position` varchar(150) NOT NULL default '',\n `bus_sec_phone` varchar(15) NOT NULL default '',\n `bus_sec_mobile` varchar(15) NOT NULL default '',\n `bus_sec_email` varchar(150) NOT NULL default '',\n `website` varchar(255) default NULL,\n `description` text NOT NULL,\n `user_type` enum('0','1','2','3','4') NOT NULL default '0' COMMENT '0->not set,1->retailer,2->Distributor,3->Both,4->Individual',\n `distributor_expiry` datetime NOT NULL default '0000-00-00 00:00:00' COMMENT 'distributor login expiry added by admin',\n `approval_date` datetime default NULL COMMENT 'this will be the date when admin will approve or deny the request for any user.',\n `approval_modify_date` datetime default NULL,\n `total_boats` mediumint(2) NOT NULL default '0',\n `total_motors` mediumint(2) NOT NULL default '0',\n `total_services` mediumint(2) NOT NULL default '0',\n `total_accessories` mediumint(2) NOT NULL default '0',\n `total_marinas` mediumint(2) NOT NULL default '0',\n `total_charters` mediumint(2) NOT NULL default '0',\n `distributor_boat` enum('0','1') NOT NULL default '0' COMMENT '{0->Not a distributor, 1->Distributor',\n `distributor_motor` enum('0','1') NOT NULL default '0' COMMENT '{0->Not a distributor, 1->Distributor',\n `retailor_accessory` enum('0','1') NOT NULL default '0' COMMENT '{0->Not a dealer, 1->Dealer',\n `retailor_marina` enum('0','1') NOT NULL default '0' COMMENT '{0->Not a dealer, 1->Dealer{0->Not a dealer, 1->Dealer',\n `retailor_service` enum('0','1') NOT NULL default '0' COMMENT '{0->Not a dealer, 1->Dealer',\n `retailor_charter` enum('0','1') NOT NULL default '0' COMMENT '{0->Not a dealer, 1->Dealer',\n `approved` mediumint(2) NOT NULL default '2' COMMENT '{2->pending,1->Approved,0->Deny}Default Value should be 2 and after admin approval user will able to login.',\n `active_status` mediumint(2) NOT NULL default '1' COMMENT '{1->active,0->Inactive}',\n `save_flag` enum('0','1') NOT NULL default '0' COMMENT '1->Final Save,0->into the cart nao saved',\n `date_added` datetime default NULL,\n `registration_system_ip` varchar(16) NOT NULL default '' COMMENT 'Client system IP',\n `is_registered` mediumint(9) NOT NULL default '1' COMMENT '1->Registered, 0->Not Registerd',\n `distributor_id` bigint(20) default NULL COMMENT 'It will be user/distributor id who added this retailer.',\n PRIMARY KEY (`id`),\n KEY `post_state` (`post_state`),\n KEY `post_country` (`post_country`),\n KEY `post_city` (`post_city`),\n KEY `trading_name1` (`trading_name1`),\n KEY `post_postcode` (`post_postcode`)\n) ENGINE=InnoDB DEFAULT CHARSET=latin1 |