13 lines
406 B
SQL
13 lines
406 B
SQL
|
|
CREATE TABLE `co_solleciti` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`idscadenza` int(11) NOT NULL,
|
|
`idanagrafica` int(11) NOT NULL,
|
|
`numero` varchar(50) NOT NULL,
|
|
`datasoll` datetime NOT NULL,
|
|
`datadoc` datetime NOT NULL,
|
|
`da_pagare` decimal(12,4) DEFAULT NULL,
|
|
`mailsoll` varchar(255) NOT NULL,
|
|
`tipomail` text ,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |