i4uAhYmB

1--
2-- website
3--
4CREATE TABLE IF NOT EXISTS `website` (
5  `name` varchar(126) NOT NULL,
6  `client_id` int(11) NOT NULL,
7  `date_created` timestamp NOT NULL default CURRENT_TIMESTAMP,
8  `notes` text NOT NULL,
9  `website_status` varchar(26) NOT NULL,
10  PRIMARY KEY  (`name`),
11  KEY `client_id` (`client_id`),
12  KEY `website_status` (`website_status`),
13) ENGINE=InnoDB DEFAULT CHARSET=latin1;
14
15--
16-- website_status
17--
18CREATE TABLE IF NOT EXISTS `website_status` (
19  `name` varchar(26) NOT NULL,
20  PRIMARY KEY  (`name`)
21) ENGINE=InnoDB DEFAULT CHARSET=latin1;
22INSERT INTO `website_status` (`name`) VALUES
23('demo'),
24('disabled'),
25('live'),
26('purchased'),
27('transfered');
28
29--
30-- client
31--
32CREATE TABLE IF NOT EXISTS `client` (
33  `id` int(11) NOT NULL auto_increment,
34  `date_created` timestamp NOT NULL default CURRENT_TIMESTAMP,
35  `client_status` varchar(26) NOT NULL,
36  `firstname` varchar(26) NOT NULL,
37  `lastname` varchar(46) NOT NULL,
38  `address` varchar(78) NOT NULL,
39  `city` varchar(56) NOT NULL,
40  `state` varchar(2) NOT NULL,
41  `zip` int(11) NOT NULL,
42  `country` varchar(3) NOT NULL,
43  `phone` text NOT NULL,
44  `email` varchar(78) NOT NULL,
45  `notes` text NOT NULL,
46  PRIMARY KEY  (`id`),
47  KEY `client_status` (`client_status`)
48) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
49
50--
51-- client_status
52---
53CREATE TABLE IF NOT EXISTS `client_status` (
54  `name` varchar(26) NOT NULL,
55  PRIMARY KEY  (`name`)
56) ENGINE=InnoDB DEFAULT CHARSET=latin1;
57
58INSERT INTO `client_status` (`name`) VALUES
59('affiliate'),
60('customer'),
61('demo'),
62('disabled'),
63('reseller');