Flitig postare
|
|
Reg.datum: Sep 2007
Inlägg: 391
|
|
Flitig postare
Reg.datum: Sep 2007
Inlägg: 391
|
Customers:
Citat:
CREATE TABLE IF NOT EXISTS `web_customers` (
`co-number` varchar(10) NOT NULL,
`pnumber` varchar(10) NOT NULL,
`firstname` varchar(250) NOT NULL,
`lastname` varchar(250) NOT NULL,
`address` varchar(250) NOT NULL,
`postcode` varchar(5) NOT NULL,
`city` varchar(250) NOT NULL,
`email` varchar(250) NOT NULL,
`cellphone` varchar(15) NOT NULL,
`homephone` varchar(15) NOT NULL,
`password` varchar(32) NOT NULL,
`registered` varchar(100) NOT NULL,
`package` varchar(1) NOT NULL,
`active` varchar(1) NOT NULL,
PRIMARY KEY (`co-number`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
Logg
Citat:
CREATE TABLE IF NOT EXISTS `Logg` (
`co-number` varchar(10) NOT NULL,
`time` varchar(100) NOT NULL,
`action` varchar(500) NOT NULL,
`ip` varchar(100) NOT NULL,
PRIMARY KEY (`co-number`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|