CREATE TABLE `docs_invoice`

[Sasha462]

mysql> CREATE TABLE `docs_invoice` (
-> `id` int(11) NOT NULL auto_increment,
-> `date` date NOT NULL default '0000-00-00',
-> `customer` varchar(200) NOT NULL default '',
-> `phone` varchar(16) NOT NULL default '0',
-> `aid` smallint(6) unsigned NOT NULL default '0',
-> `uid` int(11) unsigned NOT NULL default '0',
-> `created` datetime NOT NULL default '0000-00-00 00:00:00',
-> `invoice_id` int(10) unsigned NOT NULL default '0',
-> `vat` double(5,2) unsigned NOT NULL default '0.00',
-> `by_proxy_seria` varchar(40) NOT NULL default '',
-> `by_proxy_person` varchar(15) NOT NULL default '',
`by_proxy_date` date NOT NULL default '0000-00-00',
`domain_id` smallint(6) unsigned not null default 0,
-> `by_proxy_date` date NOT NULL default '0000-00-00',
-> `domain_id` smallint(6) unsigned not null default 0,
-> `payment_id` int(11) unsigned NOT NULL default 0,
-> PRIMARY KEY (`id`),
-> KEY `payment_id` (`payment_id`),
-> KEY `domain_id` (`domain_id`)
-> ) COMMENT='Docs invoices';
ERROR 1050 (42S01): Table 'docs_invoice' already exists

от 05022013 обновление тотже результат ...

mysql> CREATE TABLE `docs_invoices` (
-> `id` int(11) unsigned NOT NULL auto_increment,
-> `date` date NOT NULL default '0000-00-00',
-> `created` datetime NOT NULL default '0000-00-00 00:00:00',
-> `customer` varchar(200) NOT NULL default '',
-> `phone` varchar(16) NOT NULL default '0',
-> `user` varchar(20) NOT NULL default '',
-> `invoice_num` int(10) unsigned NOT NULL default '0',
-> `uid` int(11) unsigned NOT NULL default '0',
-> `aid` smallint(6) unsigned NOT NULL default '0',
-> `vat` double(5,2) unsigned NOT NULL default '0.00',
`domain_id` smallint(6) unsigned not null default 0,.
`payment_id` int(11) unsigned NOT NULL default 0,
`deposit` double(1 -> `domain_id` smallint(6) unsigned not null default 0,.
-> `payment_id` int(11) unsigned NOT NULL default 0,
-> `deposit` double(15,6) NOT NULL default '0.000000',
-> `delivery_status` tinyint(2) unsigned NOT NULL default '0',
-> `exchange_rate` double(12,4) NOT NULL default '0.0000',
-> `currency` smallint unsigned NOT NULL default 0,..
-> PRIMARY KEY (`id`),
-> KEY `payment_id` (`payment_id`),
-> KEY `domain_id` (`domain_id`)
-> ) COMMENT='Docs Invoices' ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.
PRIMARY KEY (`id`),
KEY `payment_id` (`payment_id`),
KEY `domain_id` (`' at line 17

[Sasha462]

стоит модуль а апач ничево не показивает куда делось

@MODULES = ('Dv',
'Dhcphosts',
наново залил Dhcphosts.sql

апач перестартовал попа ))

[Sasha462]

стоит модуль а апач ничево не показивает куда делось

@MODULES = ('Dv',
'Dhcphosts',
наново залил Dhcphosts.sql

апач перестартовал попа ))

сори я админу права виставить надо