| | |
| | | `sys_perm_other` varchar(5) default NULL, |
| | | `company_name` varchar(64) default NULL, |
| | | `contact_name` varchar(64) default NULL, |
| | | `customer_no` varchar(64) default NULL, |
| | | `vat_id` varchar(64) default NULL, |
| | | `street` varchar(255) default NULL, |
| | | `zip` varchar(32) default NULL, |
| | | `city` varchar(64) default NULL, |
| | |
| | | `package_type` enum('ispconfig','app','web') NOT NULL default 'app', |
| | | `package_installable` enum('yes','no','key') NOT NULL default 'yes', |
| | | `package_requires_db` enum('no','mysql') NOT NULL default 'no', |
| | | `package_remote_functions` text, |
| | | `package_key` varchar(255) NOT NULL, |
| | | `package_config` text, |
| | | PRIMARY KEY (`package_id`), |
| | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Table structure for table `sys_session` |
| | | -- |
| | | |
| | | CREATE TABLE `sys_session` ( |
| | | `session_id` varchar(32) NOT NULL default '', |
| | | `date_created` datetime NOT NULL default '0000-00-00 00:00:00', |
| | | `last_updated` datetime NOT NULL default '0000-00-00 00:00:00', |
| | | `session_data` longtext, |
| | | PRIMARY KEY (`session_id`), |
| | | KEY `last_updated` (`last_updated`) |
| | | ) ENGINE=MyISAM; |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Table structure for table `web_domain` |
| | | -- |
| | | |