XQCiuaZy

1/*!40101 SET NAMES utf8 */;
2
3-- 
4-- Table structure for table `dadabik_item`
5-- 
6
7DROP TABLE IF EXISTS `dadabik_item`;
8CREATE TABLE `dadabik_item` (
9  `name_field` varchar(50) NOT NULL default '',
10  `label_field` varchar(255) NOT NULL default '',
11  `type_field` enum('text','textarea','rich_editor','password','insert_date','update_date','date','select_single','select_multiple','select_multiple_checkbox','generic_file','image_file','ID_user','unique_ID') NOT NULL default 'text',
12  `content_field` enum('alphabetic','alphanumeric','numeric','url','email','html','phone') NOT NULL default 'alphanumeric',
13  `present_search_form_field` enum('0','1') NOT NULL default '1',
14  `present_results_search_field` enum('0','1') NOT NULL default '1',
15  `present_details_form_field` enum('0','1') NOT NULL default '1',
16  `present_insert_form_field` enum('0','1') NOT NULL default '1',
17  `present_ext_update_form_field` enum('0','1') NOT NULL default '1',
18  `required_field` enum('0','1') NOT NULL default '0',
19  `check_duplicated_insert_field` enum('0','1') NOT NULL default '0',
20  `other_choices_field` enum('0','1') NOT NULL default '0',
21  `select_options_field` text NOT NULL,
22  `primary_key_field_field` varchar(255) NOT NULL,
23  `primary_key_table_field` varchar(255) NOT NULL,
24  `primary_key_db_field` varchar(50) NOT NULL,
25  `linked_fields_field` text NOT NULL,
26  `linked_fields_order_by_field` text NOT NULL,
27  `linked_fields_order_type_field` varchar(255) NOT NULL,
28  `linked_fields_extra_mysql` varchar(255) NOT NULL,
29  `select_type_field` varchar(100) NOT NULL default 'is_equal/contains/starts_with/ends_with/greater_than/less_then',
30  `prefix_field` text NOT NULL,
31  `default_value_field` text NOT NULL,
32  `width_field` varchar(5) NOT NULL,
33  `height_field` varchar(5) NOT NULL,
34  `maxlength_field` varchar(5) NOT NULL default '100',
35  `hint_insert_field` varchar(255) NOT NULL,
36  `order_form_field` smallint(6) NOT NULL,
37  `separator_field` varchar(2) NOT NULL default '~',
38  PRIMARY KEY  (`name_field`)
39) ENGINE=MyISAM DEFAULT CHARSET=utf8;
40
41-- 
42-- Dumping data for table `dadabik_item`
43-- 
44
45INSERT INTO `dadabik_item` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('ID', 'ID', 'text', 'numeric', '0', '0', '1', '0', '1', '0', '0', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', '', 1, '~');
46INSERT INTO `dadabik_item` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('Category', 'Category', 'select_single', 'alphanumeric', '1', '1', '1', '1', '1', '1', '0', '1', '~Antibody~Chemicals~Cleanliness~Computer-related~Electrical-electronic~Equipment-related~Glassware~Glyco~Misc.~Mol-bio~Non-culture-plasticware~Proteins-and-related~Radioactivity~Stationery~Tissue-culture~', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '30', '', 2, '~');
47INSERT INTO `dadabik_item` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('Name', 'Description', 'textarea', 'alphanumeric', '1', '1', '1', '1', '1', '1', '0', '1', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '30', '3', '', 'Keyword first, like ''Tips, 10-100ul''', 3, '~');
48INSERT INTO `dadabik_item` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('Size', 'Unit size', 'text', 'alphanumeric', '0', '0', '1', '1', '1', '0', '0', '1', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '30', 'case, 500/pk, each, 1ml, etc.', 4, '~');
49INSERT INTO `dadabik_item` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('Manufacturer', 'Manufacturer', 'text', 'alphanumeric', '1', '1', '1', '1', '1', '0', '0', '1', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '30', 'Optional', 9, '~');
50INSERT INTO `dadabik_item` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('Manufacturer_cat_no', 'Man. cat. no.', 'text', 'alphanumeric', '1', '1', '1', '1', '1', '0', '0', '1', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '30', 'Optional', 10, '~');
51INSERT INTO `dadabik_item` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('Vendor', 'Vendor', 'select_single', 'alphanumeric', '1', '1', '1', '1', '1', '1', '0', '0', '', 'Name', 'vendor', '', 'Name', 'Name', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '50', 'May differ from manufacturer', 5, '~');
52INSERT INTO `dadabik_item` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('Vendor_cat_no', 'Vendor cat. no.', 'text', 'alphanumeric', '1', '1', '1', '1', '1', '1', '0', '1', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '30', '', 6, '~');
53INSERT INTO `dadabik_item` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('Price', 'Price per unit size', 'text', 'numeric', '0', '0', '1', '1', '1', '0', '0', '1', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '10', 'Don''t type currency', 7, '~');
54INSERT INTO `dadabik_item` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('Extra', 'Any comment', 'textarea', 'alphanumeric', '0', '0', '1', '1', '1', '0', '0', '1', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '30', '3', '', '', 8, '~');
55INSERT INTO `dadabik_item` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('update_date', 'Updated', 'update_date', 'alphanumeric', '1', '1', '1', '0', '1', '0', '0', '1', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', '', 11, '~');
56INSERT INTO `dadabik_item` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('insert_date', 'Added', 'insert_date', 'alphanumeric', '1', '1', '1', '0', '1', '0', '0', '1', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', '', 12, '~');
57INSERT INTO `dadabik_item` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('order_date', 'Last ordered', 'text', 'alphanumeric', '1', '1', '1', '1', '1', '0', '0', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '0000-00-00', '10', '', '10', 'yyyy-mm-dd format', 13, '~');
58INSERT INTO `dadabik_item` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('ID_user', 'ID_user', 'ID_user', 'alphanumeric', '0', '0', '0', '0', '1', '0', '0', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', '', 25, '~');
59
60-- --------------------------------------------------------
61
62-- 
63-- Table structure for table `dadabik_order`
64-- 
65
66DROP TABLE IF EXISTS `dadabik_order`;
67CREATE TABLE `dadabik_order` (
68  `name_field` varchar(50) NOT NULL default '',
69  `label_field` varchar(255) NOT NULL default '',
70  `type_field` enum('text','textarea','rich_editor','password','insert_date','update_date','date','select_single','select_multiple','select_multiple_checkbox','generic_file','image_file','ID_user','unique_ID') NOT NULL default 'text',
71  `content_field` enum('alphabetic','alphanumeric','numeric','url','email','html','phone') NOT NULL default 'alphanumeric',
72  `present_search_form_field` enum('0','1') NOT NULL default '1',
73  `present_results_search_field` enum('0','1') NOT NULL default '1',
74  `present_details_form_field` enum('0','1') NOT NULL default '1',
75  `present_insert_form_field` enum('0','1') NOT NULL default '1',
76  `present_ext_update_form_field` enum('0','1') NOT NULL default '1',
77  `required_field` enum('0','1') NOT NULL default '0',
78  `check_duplicated_insert_field` enum('0','1') NOT NULL default '0',
79  `other_choices_field` enum('0','1') NOT NULL default '0',
80  `select_options_field` text NOT NULL,
81  `primary_key_field_field` varchar(255) NOT NULL default '',
82  `primary_key_table_field` varchar(255) NOT NULL default '',
83  `primary_key_db_field` varchar(50) NOT NULL default '',
84  `linked_fields_field` text NOT NULL,
85  `linked_fields_order_by_field` text NOT NULL,
86  `linked_fields_order_type_field` varchar(255) NOT NULL default '',
87  `linked_fields_extra_mysql` varchar(255) NOT NULL default '',
88  `select_type_field` varchar(100) NOT NULL default 'is_equal/contains/starts_with/ends_with/greater_than/less_then',
89  `prefix_field` text NOT NULL,
90  `default_value_field` text NOT NULL,
91  `width_field` varchar(5) NOT NULL default '',
92  `height_field` varchar(5) NOT NULL default '',
93  `maxlength_field` varchar(5) NOT NULL default '100',
94  `hint_insert_field` varchar(255) NOT NULL default '',
95  `order_form_field` smallint(6) NOT NULL default '0',
96  `separator_field` varchar(2) NOT NULL default '~',
97  PRIMARY KEY  (`name_field`)
98) ENGINE=MyISAM DEFAULT CHARSET=utf8;
99
100-- 
101-- Dumping data for table `dadabik_order`
102-- 
103
104INSERT INTO `dadabik_order` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('order_id', 'Order ID', 'text', 'numeric', '1', '1', '1', '0', '1', '0', '0', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', 'Database ID', 1, '~');
105INSERT INTO `dadabik_order` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('description', 'Order summary', 'textarea', 'alphanumeric', '1', '1', '1', '1', '1', '0', '0', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '50', '4', '', '', 2, '~');
106INSERT INTO `dadabik_order` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('total_amount', 'Total', 'text', 'numeric', '1', '1', '1', '1', '1', '0', '0', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', 'Do not type in currency (e.g., $)', 3, '~');
107INSERT INTO `dadabik_order` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('ordered_by', 'Ordered by', 'text', 'alphanumeric', '1', '1', '1', '1', '1', '0', '0', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', '', 5, '~');
108INSERT INTO `dadabik_order` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('comment', 'Comment', 'textarea', 'alphanumeric', '1', '1', '1', '1', '1', '0', '0', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '50', '3', '', '', 10, '~');
109INSERT INTO `dadabik_order` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('cost_reduce', '-ve cost adjustment', 'text', 'numeric', '1', '1', '1', '1', '1', '0', '0', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', 'Do not type currency (e.g., $)', 8, '~');
110INSERT INTO `dadabik_order` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('cost_add', '+ve cost adjustment', 'text', 'numeric', '1', '1', '1', '1', '1', '0', '0', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', 'Extra, for increased amount', 9, '~');
111INSERT INTO `dadabik_order` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('status', 'Status', 'select_single', 'alphanumeric', '1', '1', '1', '1', '1', '0', '0', '0', '~Ordered~Partly ordered/cancelled~Cancelled~On hold~', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', '', 6, '~');
112INSERT INTO `dadabik_order` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('modified_date', 'Modified date', 'update_date', 'alphanumeric', '1', '1', '1', '0', '1', '0', '0', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', '', 11, '~');
113INSERT INTO `dadabik_order` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('ordered_date', 'Date of order', 'insert_date', 'alphanumeric', '1', '1', '1', '0', '1', '0', '0', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', '', 4, '~');
114INSERT INTO `dadabik_order` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('reception_status', 'Reception status', 'select_single', 'alphanumeric', '1', '1', '1', '1', '1', '0', '0', '1', '~Received~Partly received~Not received~', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', '', 7, '~');
115INSERT INTO `dadabik_order` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('ID_user', 'ID_user', 'ID_user', 'alphanumeric', '0', '0', '0', '0', '1', '0', '0', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', '', 25, '~');
116
117-- --------------------------------------------------------
118
119-- 
120-- Table structure for table `dadabik_table_list`
121-- 
122
123DROP TABLE IF EXISTS `dadabik_table_list`;
124CREATE TABLE `dadabik_table_list` (
125  `name_table` varchar(255) NOT NULL default '',
126  `allowed_table` tinyint(4) NOT NULL default '0',
127  `enable_insert_table` varchar(5) NOT NULL default '',
128  `enable_edit_table` varchar(5) NOT NULL default '',
129  `enable_delete_table` varchar(5) NOT NULL default '',
130  `enable_details_table` varchar(5) NOT NULL default '',
131  PRIMARY KEY  (`name_table`)
132) ENGINE=MyISAM DEFAULT CHARSET=utf8;
133
134-- 
135-- Dumping data for table `dadabik_table_list`
136-- 
137
138INSERT INTO `dadabik_table_list` (`name_table`, `allowed_table`, `enable_insert_table`, `enable_edit_table`, `enable_delete_table`, `enable_details_table`) VALUES ('vendor', 1, '1', '1', '1', '1');
139INSERT INTO `dadabik_table_list` (`name_table`, `allowed_table`, `enable_insert_table`, `enable_edit_table`, `enable_delete_table`, `enable_details_table`) VALUES ('item', 1, '1', '1', '1', '1');
140INSERT INTO `dadabik_table_list` (`name_table`, `allowed_table`, `enable_insert_table`, `enable_edit_table`, `enable_delete_table`, `enable_details_table`) VALUES ('order', 1, '1', '1', '1', '1');
141INSERT INTO `dadabik_table_list` (`name_table`, `allowed_table`, `enable_insert_table`, `enable_edit_table`, `enable_delete_table`, `enable_details_table`) VALUES ('users', 1, '1', '1', '1', '1');
142
143-- --------------------------------------------------------
144
145-- 
146-- Table structure for table `dadabik_users`
147-- 
148
149DROP TABLE IF EXISTS `dadabik_users`;
150CREATE TABLE `dadabik_users` (
151  `name_field` varchar(50) NOT NULL default '',
152  `label_field` varchar(255) NOT NULL default '',
153  `type_field` enum('text','textarea','rich_editor','password','insert_date','update_date','date','select_single','select_multiple','select_multiple_checkbox','generic_file','image_file','ID_user','unique_ID') NOT NULL default 'text',
154  `content_field` enum('alphabetic','alphanumeric','numeric','url','email','html','phone') NOT NULL default 'alphanumeric',
155  `present_search_form_field` enum('0','1') NOT NULL default '1',
156  `present_results_search_field` enum('0','1') NOT NULL default '1',
157  `present_details_form_field` enum('0','1') NOT NULL default '1',
158  `present_insert_form_field` enum('0','1') NOT NULL default '1',
159  `present_ext_update_form_field` enum('0','1') NOT NULL default '1',
160  `required_field` enum('0','1') NOT NULL default '0',
161  `check_duplicated_insert_field` enum('0','1') NOT NULL default '0',
162  `other_choices_field` enum('0','1') NOT NULL default '0',
163  `select_options_field` text NOT NULL,
164  `primary_key_field_field` varchar(255) NOT NULL,
165  `primary_key_table_field` varchar(255) NOT NULL,
166  `primary_key_db_field` varchar(50) NOT NULL,
167  `linked_fields_field` text NOT NULL,
168  `linked_fields_order_by_field` text NOT NULL,
169  `linked_fields_order_type_field` varchar(255) NOT NULL,
170  `linked_fields_extra_mysql` varchar(255) NOT NULL,
171  `select_type_field` varchar(100) NOT NULL default 'is_equal/contains/starts_with/ends_with/greater_than/less_then',
172  `prefix_field` text NOT NULL,
173  `default_value_field` text NOT NULL,
174  `width_field` varchar(5) NOT NULL,
175  `height_field` varchar(5) NOT NULL,
176  `maxlength_field` varchar(5) NOT NULL default '100',
177  `hint_insert_field` varchar(255) NOT NULL,
178  `order_form_field` smallint(6) NOT NULL,
179  `separator_field` varchar(2) NOT NULL default '~',
180  PRIMARY KEY  (`name_field`)
181) ENGINE=MyISAM DEFAULT CHARSET=utf8;
182
183-- 
184-- Dumping data for table `dadabik_users`
185-- 
186
187INSERT INTO `dadabik_users` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('ID_user', 'Unique user ID', 'text', 'numeric', '0', '1', '1', '0', '1', '0', '0', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', '', 1, '~');
188INSERT INTO `dadabik_users` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('name', 'Full name (first, last)', 'text', 'alphanumeric', '1', '1', '1', '1', '1', '1', '1', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', '', 2, '~');
189INSERT INTO `dadabik_users` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('md5_password', 'Password (MD5 encrypted)', 'text', 'alphanumeric', '1', '1', '1', '1', '1', '1', '0', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', '<a href="javascript:void(generic_js_popup(''pwd.php'','''',400,300))">create MD5-hashed password</a>', 4, '~');
190INSERT INTO `dadabik_users` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('status', 'Past or current', 'select_single', 'alphanumeric', '1', '1', '1', '1', '1', '1', '0', '0', '~Current~Past~', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', 'choose one', 6, '~');
191INSERT INTO `dadabik_users` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('group', 'User group', 'select_single', 'alphanumeric', '0', '1', '1', '1', '1', '1', '0', '0', '~Normal~Administrator~', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', 'options here should match those in config.php', 5, '~');
192INSERT INTO `dadabik_users` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('comment', 'Comment', 'textarea', 'alphanumeric', '0', '1', '1', '1', '1', '0', '0', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '20', '3', '100', '', 7, '~');
193INSERT INTO `dadabik_users` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('username', 'Username for logging in', 'text', 'alphanumeric', '1', '1', '1', '1', '1', '1', '1', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', 'single word of 6-12 characters', 3, '~');
194
195-- --------------------------------------------------------
196
197-- 
198-- Table structure for table `dadabik_vendor`
199-- 
200
201DROP TABLE IF EXISTS `dadabik_vendor`;
202CREATE TABLE `dadabik_vendor` (
203  `name_field` varchar(50) NOT NULL default '',
204  `label_field` varchar(255) NOT NULL default '',
205  `type_field` enum('text','textarea','rich_editor','password','insert_date','update_date','date','select_single','select_multiple','select_multiple_checkbox','generic_file','image_file','ID_user','unique_ID') NOT NULL default 'text',
206  `content_field` enum('alphabetic','alphanumeric','numeric','url','email','html','phone') NOT NULL default 'alphanumeric',
207  `present_search_form_field` enum('0','1') NOT NULL default '1',
208  `present_results_search_field` enum('0','1') NOT NULL default '1',
209  `present_details_form_field` enum('0','1') NOT NULL default '1',
210  `present_insert_form_field` enum('0','1') NOT NULL default '1',
211  `present_ext_update_form_field` enum('0','1') NOT NULL default '1',
212  `required_field` enum('0','1') NOT NULL default '0',
213  `check_duplicated_insert_field` enum('0','1') NOT NULL default '0',
214  `other_choices_field` enum('0','1') NOT NULL default '0',
215  `select_options_field` text NOT NULL,
216  `primary_key_field_field` varchar(255) NOT NULL,
217  `primary_key_table_field` varchar(255) NOT NULL,
218  `primary_key_db_field` varchar(50) NOT NULL,
219  `linked_fields_field` text NOT NULL,
220  `linked_fields_order_by_field` text NOT NULL,
221  `linked_fields_order_type_field` varchar(255) NOT NULL,
222  `linked_fields_extra_mysql` varchar(255) NOT NULL,
223  `select_type_field` varchar(100) NOT NULL default 'is_equal/contains/starts_with/ends_with/greater_than/less_then',
224  `prefix_field` text NOT NULL,
225  `default_value_field` text NOT NULL,
226  `width_field` varchar(5) NOT NULL,
227  `height_field` varchar(5) NOT NULL,
228  `maxlength_field` varchar(5) NOT NULL default '100',
229  `hint_insert_field` varchar(255) NOT NULL,
230  `order_form_field` smallint(6) NOT NULL,
231  `separator_field` varchar(2) NOT NULL default '~',
232  PRIMARY KEY  (`name_field`)
233) ENGINE=MyISAM DEFAULT CHARSET=utf8;
234
235-- 
236-- Dumping data for table `dadabik_vendor`
237-- 
238
239INSERT INTO `dadabik_vendor` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('Vendor_ID', 'Vendor ID', 'text', 'numeric', '0', '0', '1', '0', '1', '0', '0', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', 'Database ID', 5, '~');
240INSERT INTO `dadabik_vendor` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('Name', 'Name of vendor', 'textarea', 'alphanumeric', '1', '1', '1', '1', '1', '0', '1', '1', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '50', '2', '', '', 1, '~');
241INSERT INTO `dadabik_vendor` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('Phone', 'Phone', 'text', 'alphanumeric', '1', '1', '1', '1', '1', '0', '0', '1', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '-', '', '', '50', '', 2, '~');
242INSERT INTO `dadabik_vendor` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('Fax', 'Fax', 'text', 'alphanumeric', '1', '1', '1', '1', '1', '0', '0', '1', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '-', '', '', '50', '', 3, '~');
243INSERT INTO `dadabik_vendor` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('Address', 'Address', 'textarea', 'alphanumeric', '1', '1', '1', '1', '1', '0', '0', '1', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '-', '50', '3', '', '', 4, '~');
244INSERT INTO `dadabik_vendor` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('update_date', 'Updated', 'update_date', 'alphanumeric', '1', '1', '1', '0', '1', '0', '0', '1', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', '', 6, '~');
245INSERT INTO `dadabik_vendor` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('insert_date', 'Added', 'insert_date', 'alphanumeric', '0', '0', '1', '0', '1', '0', '0', '1', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', '', 7, '~');
246INSERT INTO `dadabik_vendor` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('website', 'Website', 'text', 'alphanumeric', '0', '0', '1', '1', '1', '0', '0', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '40', '', '100', '', 8, '~');
247INSERT INTO `dadabik_vendor` (`name_field`, `label_field`, `type_field`, `content_field`, `present_search_form_field`, `present_results_search_field`, `present_details_form_field`, `present_insert_form_field`, `present_ext_update_form_field`, `required_field`, `check_duplicated_insert_field`, `other_choices_field`, `select_options_field`, `primary_key_field_field`, `primary_key_table_field`, `primary_key_db_field`, `linked_fields_field`, `linked_fields_order_by_field`, `linked_fields_order_type_field`, `linked_fields_extra_mysql`, `select_type_field`, `prefix_field`, `default_value_field`, `width_field`, `height_field`, `maxlength_field`, `hint_insert_field`, `order_form_field`, `separator_field`) VALUES ('ID_user', 'ID_user', 'ID_user', 'alphanumeric', '0', '0', '0', '0', '1', '0', '0', '0', '', '', '', '', '', '', '', '', 'is_equal/contains/starts_with/ends_with/greater_than/less_then', '', '', '', '', '100', '', 25, '~');
248
249-- --------------------------------------------------------
250
251-- 
252-- Table structure for table `item`
253-- 
254
255DROP TABLE IF EXISTS `item`;
256CREATE TABLE `item` (
257  `ID` int(11) NOT NULL auto_increment,
258  `Category` varchar(64) NOT NULL default 'Category',
259  `Name` varchar(255) NOT NULL default 'Name',
260  `Size` varchar(64) NOT NULL default 'Size',
261  `Manufacturer` varchar(128) NOT NULL default 'Manufacturer',
262  `Manufacturer_cat_no` varchar(32) NOT NULL default 'Man. cat. no.',
263  `Vendor` varchar(128) NOT NULL default 'Vendor',
264  `Vendor_cat_no` varchar(32) NOT NULL default 'Vendor cat. no.',
265  `Price` decimal(10,2) NOT NULL default '0.00',
266  `Extra` varchar(255) NOT NULL default 'Extra',
267  `update_date` date NOT NULL default '0000-00-00',
268  `insert_date` date NOT NULL default '0000-00-00',
269  `order_date` date NOT NULL default '0000-00-00',
270  `ID_user` varchar(64) NOT NULL,
271  PRIMARY KEY  (`ID`)
272) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Details on items' AUTO_INCREMENT=279 ;
273
274-- 
275-- Dumping data for table `item`
276-- 
277
278INSERT INTO `item` (`ID`, `Category`, `Name`, `Size`, `Manufacturer`, `Manufacturer_cat_no`, `Vendor`, `Vendor_cat_no`, `Price`, `Extra`, `update_date`, `insert_date`, `order_date`, `ID_user`) VALUES (1, 'Tissue-culture', 'Autoclave plastic bag sized 12 x 24 inches', 'Pk of 200', '', '', 'Fisher Scientific', '01-826A', '125.59', '', '2004-09-07', '2004-09-07', '2005-07-05', 0);
279
280-- --------------------------------------------------------
281
282-- 
283-- Table structure for table `order`
284-- 
285
286DROP TABLE IF EXISTS `order`;
287CREATE TABLE `order` (
288  `order_id` mediumint(10) NOT NULL auto_increment,
289  `description` text NOT NULL,
290  `total_amount` decimal(10,2) NOT NULL default '0.00',
291  `ordered_by` varchar(255) NOT NULL default '',
292  `comment` text NOT NULL,
293  `cost_reduce` decimal(10,2) NOT NULL default '0.00',
294  `cost_add` decimal(10,2) NOT NULL default '0.00',
295  `status` varchar(255) NOT NULL default '',
296  `modified_date` date NOT NULL default '0000-00-00',
297  `ordered_date` date NOT NULL default '0000-00-00',
298  `reception_status` varchar(255) NOT NULL default '',
299  `ID_user` varchar(64) NOT NULL,
300  PRIMARY KEY  (`order_id`)
301) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=48 ;
302
303-- 
304-- Dumping data for table `order`
305-- 
306
307INSERT INTO `order` (`order_id`, `description`, `total_amount`, `ordered_by`, `comment`, `cost_reduce`, `cost_add`, `status`, `modified_date`, `ordered_date`, `reception_status`, `ID_user`) VALUES (6, '1814443: Fugene 6 (1) @300.00 per 1 ml; VENDOR - Roche Applied Sciences; GRANT - ; COMMENT - from basement', '300.00', 'Wen', '', '0.00', '0.00', 'Ordered', '2005-08-29', '2005-08-28', 'Received', 0);
308
309-- --------------------------------------------------------
310
311-- 
312-- Table structure for table `users`
313-- 
314
315DROP TABLE IF EXISTS `users`;
316CREATE TABLE `users` (
317  `ID_user` int(11) NOT NULL auto_increment,
318  `name` varchar(64) NOT NULL default '',
319  `md5_password` varchar(32) NOT NULL,
320  `status` varchar(32) NOT NULL default '',
321  `group` varchar(64) NOT NULL default '',
322  `comment` varchar(255) NOT NULL default '',
323  `username` varchar(32) NOT NULL,
324  PRIMARY KEY  (`ID_user`)
325) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
326
327-- 
328-- Dumping data for table `users`
329-- 
330
331INSERT INTO `users` (`ID_user`, `name`, `md5_password`, `status`, `group`, `comment`, `username`) VALUES (1, 'Common Lab', 'c833584a58d05124ca69af49805e6c20', 'Current', 'Administrator', '', 'root');
332
333-- --------------------------------------------------------
334
335-- 
336-- Table structure for table `vendor`
337-- 
338
339DROP TABLE IF EXISTS `vendor`;
340CREATE TABLE `vendor` (
341  `Vendor_ID` int(11) NOT NULL auto_increment,
342  `Name` varchar(64) NOT NULL default 'Vendor',
343  `Phone` varchar(32) NOT NULL default 'Phone',
344  `Fax` varchar(32) NOT NULL default 'Fax',
345  `Address` varchar(255) NOT NULL default 'Address',
346  `update_date` date NOT NULL default '0000-00-00',
347  `insert_date` date NOT NULL default '0000-00-00',
348  `website` varchar(255) NOT NULL default '',
349  `ID_user` varchar(64) NOT NULL,
350  PRIMARY KEY  (`Vendor_ID`)
351) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Information on vendor to whom order is sent' AUTO_INCREMENT=100 ;
352
353-- 
354-- Dumping data for table `vendor`
355-- 
356
357INSERT INTO `vendor` (`Vendor_ID`, `Name`, `Phone`, `Fax`, `Address`, `update_date`, `insert_date`, `website`, `ID_user`) VALUES (1, 'Fisher Scientific', '1-800-766-7000', '1-800-926-1166', '-', '2004-10-29', '0000-00-00', 'http://www.fishersci.com', 0);