· 8 years ago · Jul 04, 2018, 12:54 AM
1
2CREATE TABLE IF NOT EXISTS `url` (
3 `url_ip` varchar(150) DEFAULT NULL,
4 `url_link` varchar(150) DEFAULT NULL,
5 `url_title` varchar(150) DEFAULT NULL,
6 `url_desc` text CHARACTER SET utf8,
7 `url_refresh` varchar(3) DEFAULT NULL,
8 `url_theme` varchar(50) DEFAULT NULL,
9 `url_system` varchar(50) DEFAULT NULL,
10 `url_type` varchar(8) DEFAULT NULL,
11 `url_function` tinyint(2) NOT NULL,
12 `appli` varchar(1) NOT NULL,
13 `app_userbase_pub` varchar(15) NOT NULL,
14 `app_userbase_ops` varchar(15) NOT NULL,
15 `app_userbase_bps` varchar(15) DEFAULT NULL,
16 `app_launch_m` tinyint(2) NOT NULL,
17 `app_launch_y` smallint(4) NOT NULL,
18 `app_review_m` tinyint(2) NOT NULL,
19 `app_review_y` smallint(4) NOT NULL,
20 `app_platform` varchar(255) NOT NULL,
21 `app_delivery` varchar(12) NOT NULL,
22 `app_cost_build` int(8) NOT NULL,
23 `app_cost_yearly` int(8) NOT NULL,
24 `app_revenue` int(8) NOT NULL,
25 `url_host` varchar(50) CHARACTER SET utf8 NOT NULL,
26 `server_type` varchar(200) DEFAULT NULL,
27 `url_servername` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
28 `url_logfilepath` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
29 `site_owner` varchar(200) DEFAULT NULL,
30 `content_contact` varchar(200) DEFAULT NULL,
31 `technical_contact` varchar(200) DEFAULT NULL,
32 `min_cord` varchar(150) DEFAULT NULL,
33 `clust_cord` varchar(150) DEFAULT NULL,
34 `Cluster` varchar(150) DEFAULT NULL,
35 `Ministry` varchar(150) DEFAULT NULL,
36 `url_id` int(8) NOT NULL AUTO_INCREMENT,
37 `min_id` tinyint(2) NOT NULL,
38 `cc_id` int(3) NOT NULL,
39 `note` text CHARACTER SET utf8 COMMENT 'Used to write any additional information on the website record',
40 `page_rank` tinyint(4) DEFAULT NULL,
41 `site_size` int(11) DEFAULT NULL,
42 `clf` varchar(5) DEFAULT NULL,
43 `category_id` tinyint(4) DEFAULT NULL,
44 `url_date` varchar(20) CHARACTER SET utf8 NOT NULL,
45 `archive` text,
46 `url_status` varchar(20) NOT NULL,
47 `keyword` text CHARACTER SET utf8 NOT NULL,
48 `agency` varchar(30) NOT NULL DEFAULT 'n/a',
49 `oda` varchar(20) CHARACTER SET utf8 NOT NULL,
50 `oda_notes` text CHARACTER SET utf8 NOT NULL,
51 `url_dbtype` varchar(20) CHARACTER SET utf8 NOT NULL,
52 `url_lang` varchar(20) CHARACTER SET utf8 NOT NULL,
53 `url_cms` varchar(20) CHARACTER SET utf8 NOT NULL,
54 `url_webmod` varchar(11) CHARACTER SET utf8 NOT NULL,
55 `url_webmod_status` varchar(11) CHARACTER SET utf8 NOT NULL,
56 `webmod_fte` decimal(5,2) NOT NULL,
57 `webmod_total` decimal(9,2) NOT NULL,
58 `webmod_completion` varchar(13) NOT NULL,
59 `webmod_completion_m` tinyint(2) NOT NULL,
60 `webmod_completion_y` smallint(4) NOT NULL,
61 `webmod_comments` longtext,
62 `url_launch` varchar(20) NOT NULL,
63 `url_launch_date` date DEFAULT NULL,
64 `url_creator` varchar(100) NOT NULL,
65 `url_sitecost` int(8) NOT NULL,
66 `url_hostingcost` int(7) NOT NULL,
67 `url_annualcost` int(8) DEFAULT NULL,
68 `url_traffic` int(7) NOT NULL,
69 `url_modby` varchar(100) NOT NULL,
70 `sm_type` varchar(50) DEFAULT NULL,
71 `sm_lang` varchar(9) DEFAULT NULL,
72 `sm_aim_marketing` char(1) DEFAULT NULL,
73 `sm_aim_stakeholder` char(1) DEFAULT NULL,
74 `sm_aim_edu` char(1) DEFAULT NULL,
75 `sm_aim_customer` char(1) DEFAULT NULL,
76 `sm_aim_news` char(1) DEFAULT NULL,
77 PRIMARY KEY (`url_id`)
78) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1286 ;