API tools faq
paste
Guest User

www.ird.gov.np by Ñãpstêr Bð

a guest
Aug 1st, 2013
188
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 12.38 KB | None | 0 0
raw download clone embed print report
  1. Inland Revenue Department Nepal
  2.  
  3. Target Site: www.ird.gov.np
  4.  
  5. Server operating system: Linux CentOS 5
  6. web application technology: Apache 2.2.3
  7. back-END DBMS: MySQL 5.0
  8.  
  9. DATABASES[2]:                                                                              
  10.  information_schema
  11.  irdgov_ird
  12.  
  13. DATABASE:irdgov_ird                                                       [23 TABLES]
  14.  category                  
  15.  categoryadmin            
  16.  COUNT                    
  17.  document                  
  18.  home                      
  19.  ird_category              
  20.  ird_content              
  21.  ird_document              
  22.  ird_document1            
  23.  ird_news                  
  24.  ird_newsletter            
  25.  ird_newsletter_subscriber
  26.  ird_nonfiler              
  27.  ird_user                  
  28.  news                      
  29.  owner                    
  30.  ownercategory            
  31.  subcategory              
  32.  subcategoryadmin          
  33.  tblNewsletter            
  34.  tblemail                  
  35.  tblnewsletter            
  36.  tblnonfiler              
  37.  
  38. DATABASE:irdgov_ird                                                      
  39.  
  40. TABLE: subcategory
  41. [5 COLUMNS]
  42. +----------------+--------------+
  43. | COLUMN         | TYPE         |
  44. +----------------+--------------+
  45. | cat_name       | VARCHAR(30)  |
  46. | subcat_id      | VARCHAR(4)   |
  47. | subcat_link    | VARCHAR(100) |
  48. | subcat_name    | VARCHAR(30)  |
  49. | subcat_up_date | VARCHAR(11)  |
  50. +----------------+--------------+
  51.  
  52. DATABASE: irdgov_ird
  53. TABLE: tblemail
  54. [2 COLUMNS]
  55. +--------+--------------+
  56. | COLUMN | TYPE         |
  57. +--------+--------------+
  58. | email  | VARCHAR(100) |
  59. | id     | INT(11)      |
  60. +--------+--------------+
  61.  
  62. DATABASE: irdgov_ird
  63. TABLE: owner
  64. [5 COLUMNS]
  65. +--------------+--------------+
  66. | COLUMN       | TYPE         |
  67. +--------------+--------------+
  68. | home_sno     | INT(5)       |
  69. | own_add_date | VARCHAR(11)  |
  70. | own_name     | VARCHAR(20)  |
  71. | own_pwd      | VARCHAR(255) |
  72. | own_unit     | VARCHAR(20)  |
  73. +--------------+--------------+
  74.  
  75. DATABASE: irdgov_ird
  76. TABLE: home
  77. [4 COLUMNS]
  78. +----------------+--------+
  79. | COLUMN         | TYPE   |
  80. +----------------+--------+
  81. | botinformation | text   |
  82. | highlight      | text   |
  83. | home_sno       | INT(5) |
  84. | midinformation | text   |
  85. +----------------+--------+
  86.  
  87. DATABASE: irdgov_ird
  88. TABLE: tblNewsletter
  89. [4 COLUMNS]
  90. +--------------+--------------+
  91. | COLUMN       | TYPE         |
  92. +--------------+--------------+
  93. | content      | text         |
  94. | newsletterID | INT(11)      |
  95. | STATUS       | VARCHAR(50)  |
  96. | subject      | VARCHAR(255) |
  97. +--------------+--------------+
  98.  
  99. DATABASE: irdgov_ird
  100. TABLE: ird_newsletter
  101. [6 COLUMNS]
  102. +-----------------+--------------+
  103. | COLUMN          | TYPE         |
  104. +-----------------+--------------+
  105. | detail          | text         |
  106. | newsletter_file | VARCHAR(100) |
  107. | newsletter_id   | INT(11)      |
  108. | posted_date     | DATE         |
  109. | STATUS          | tinyint(4)   |
  110. | title           | VARCHAR(255) |
  111. +-----------------+--------------+
  112.  
  113. DATABASE: irdgov_ird
  114. TABLE: category
  115. [7 COLUMNS]
  116. +-------------+--------------+
  117. | COLUMN      | TYPE         |
  118. +-------------+--------------+
  119. | cat_body    | longtext     |
  120. | cat_id      | INT(2)       |
  121. | cat_link    | VARCHAR(100) |
  122. | cat_name    | VARCHAR(30)  |
  123. | cat_sno     | INT(11)      |
  124. | cat_up_date | VARCHAR(11)  |
  125. | home_sno    | INT(5)       |
  126. +-------------+--------------+
  127.  
  128. DATABASE: irdgov_ird
  129. TABLE: ird_category
  130. [8 COLUMNS]
  131. +---------------+--------------+
  132. | COLUMN        | TYPE         |
  133. +---------------+--------------+
  134. | category_id   | INT(11)      |
  135. | category_name | VARCHAR(255) |
  136. | ordering      | SMALLINT(6)  |
  137. | parent_id     | INT(11)      |
  138. | POSITION      | tinyint(4)   |
  139. | posted_date   | DATE         |
  140. | STATUS        | tinyint(1)   |
  141. | TYPE          | CHAR(2)      |
  142. +---------------+--------------+
  143.  
  144. DATABASE: irdgov_ird
  145. TABLE: tblnonfiler
  146. [11 COLUMNS]
  147. +----------------------+--------------+
  148. | COLUMN               | TYPE         |
  149. +----------------------+--------------+
  150. | CITY_NAME            | VARCHAR(75)  |
  151. | FULL_NAME            | VARCHAR(100) |
  152. | LAST_UNFILED_PERIOD  | VARCHAR(25)  |
  153. | OFFCODE              | VARCHAR(5)   |
  154. | PAN                  | VARCHAR(15)  |
  155. | START_DATE           | VARCHAR(25)  |
  156. | STREET_NAME          | VARCHAR(100) |
  157. | TELEPHONE            | VARCHAR(20)  |
  158. | TOTAL_UNFILED_RETURN | VARCHAR(25)  |
  159. | TRADE_NAME           | VARCHAR(150) |
  160. | WARD                 | VARCHAR(5)   |
  161. +----------------------+--------------+
  162.  
  163. DATABASE: irdgov_ird
  164. TABLE: ird_document
  165. [18 COLUMNS]
  166. +-----------------+--------------+
  167. | COLUMN          | TYPE         |
  168. +-----------------+--------------+
  169. | cat_name        | VARCHAR(30)  |
  170. | category_id     | INT(11)      |
  171. | doc_file        | longblob     |
  172. | doc_format      | VARCHAR(50)  |
  173. | doc_heading     | VARCHAR(50)  |
  174. | doc_id          | BIGINT(20)   |
  175. | doc_name        | VARCHAR(255) |
  176. | doc_size        | INT(11)      |
  177. | doc_subcategory | VARCHAR(30)  |
  178. | doc_up_date     | DATE         |
  179. | LANGUAGE        | CHAR(2)      |
  180. | posted_by       | VARCHAR(50)  |
  181. | posted_date     | DATE         |
  182. | STATUS          | tinyint(1)   |
  183. | title           | VARCHAR(255) |
  184. | updated_by      | VARCHAR(50)  |
  185. | updated_date    | DATE         |
  186. | YEAR            | VARCHAR(10)  |
  187. +-----------------+--------------+
  188.  
  189. DATABASE: irdgov_ird
  190. TABLE: ird_nonfiler
  191. [12 COLUMNS]
  192. +----------------------+--------------+
  193. | COLUMN               | TYPE         |
  194. +----------------------+--------------+
  195. | CITY_NAME            | VARCHAR(75)  |
  196. | FULL_NAME            | VARCHAR(100) |
  197. | LAST_UNFILED_PERIOD  | VARCHAR(25)  |
  198. | nonfiler_id          | INT(11)      |
  199. | OFFCODE              | VARCHAR(5)   |
  200. | PAN                  | VARCHAR(15)  |
  201. | START_DATE           | VARCHAR(25)  |
  202. | STREET_NAME          | VARCHAR(100) |
  203. | TELEPHONE            | VARCHAR(20)  |
  204. | TOTAL_UNFILED_RETURN | VARCHAR(25)  |
  205. | TRADE_NAME           | VARCHAR(150) |
  206. | WARD                 | VARCHAR(5)   |
  207. +----------------------+--------------+
  208.  
  209. DATABASE: irdgov_ird
  210. TABLE: tblnewsletter
  211. [5 COLUMNS]
  212. +--------------+---------------+
  213. | COLUMN       | TYPE          |
  214. +--------------+---------------+
  215. | content      | text          |
  216. | filename     | VARCHAR(150)  |
  217. | newsletterID | INT(11)       |
  218. | STATUS       | enum('Y','N') |
  219. | subject      | VARCHAR(150)  |
  220. +--------------+---------------+
  221.  
  222. DATABASE: irdgov_ird
  223. TABLE: ird_news
  224. [8 COLUMNS]
  225. +-------------+--------------+
  226. | COLUMN      | TYPE         |
  227. +-------------+--------------+
  228. | detail      | text         |
  229. | link        | VARCHAR(255) |
  230. | news_file   | VARCHAR(50)  |
  231. | news_id     | INT(11)      |
  232. | posted_date | DATE         |
  233. | STATUS      | SMALLINT(1)  |
  234. | title       | VARCHAR(255) |
  235. | TYPE        | CHAR(1)      |
  236. +-------------+--------------+
  237.  
  238. DATABASE: irdgov_ird
  239. TABLE: ird_content
  240. [12 COLUMNS]
  241. +--------------+--------------+
  242. | COLUMN       | TYPE         |
  243. +--------------+--------------+
  244. | author       | VARCHAR(255) |
  245. | category_id  | INT(11)      |
  246. | content_id   | BIGINT(20)   |
  247. | detail       | text         |
  248. | ordering     | INT(11)      |
  249. | posted_by    | VARCHAR(50)  |
  250. | posted_date  | DATE         |
  251. | STATUS       | tinyint(1)   |
  252. | title        | VARCHAR(255) |
  253. | top_image    | VARCHAR(50)  |
  254. | updated_by   | VARCHAR(50)  |
  255. | updated_date | DATE         |
  256. +--------------+--------------+
  257.  
  258. DATABASE: irdgov_ird
  259. TABLE: ird_user
  260. [7 COLUMNS]
  261. +------------+-------------+
  262. | COLUMN     | TYPE        |
  263. +------------+-------------+
  264. | activation | tinyint(1)  |
  265. | first_name | VARCHAR(50) |
  266. | last_name  | VARCHAR(50) |
  267. | password   | VARCHAR(50) |
  268. | user_id    | BIGINT(20)  |
  269. | user_name  | VARCHAR(16) |
  270. | user_type  | VARCHAR(20) |
  271. +------------+-------------+
  272.  
  273. DATABASE: irdgov_ird
  274. TABLE: subcategoryadmin
  275. [5 COLUMNS]
  276. +-----------------+--------------+
  277. | COLUMN          | TYPE         |
  278. +-----------------+--------------+
  279. | acat_name       | VARCHAR(30)  |
  280. | asubcat_id      | CHAR(3)      |
  281. | asubcat_link    | VARCHAR(100) |
  282. | asubcat_name    | VARCHAR(30)  |
  283. | asubcat_up_date | VARCHAR(11)  |
  284. +-----------------+--------------+
  285.  
  286. DATABASE: irdgov_ird
  287. TABLE: ownercategory
  288. [2 COLUMNS]
  289. +----------+--------------+
  290. | COLUMN   | TYPE         |
  291. +----------+--------------+
  292. | cat_name | VARCHAR(100) |
  293. | own_name | VARCHAR(20)  |
  294. +----------+--------------+
  295.  
  296. DATABASE: irdgov_ird
  297. TABLE: ird_document1
  298. [11 COLUMNS]
  299. +--------------+--------------+
  300. | COLUMN       | TYPE         |
  301. +--------------+--------------+
  302. | category_id  | INT(11)      |
  303. | doc_file     | VARCHAR(50)  |
  304. | doc_id       | BIGINT(20)   |
  305. | LANGUAGE     | VARCHAR(4)   |
  306. | posted_by    | VARCHAR(50)  |
  307. | posted_date  | DATE         |
  308. | STATUS       | tinyint(1)   |
  309. | title        | VARCHAR(255) |
  310. | updated_by   | VARCHAR(50)  |
  311. | updated_date | DATE         |
  312. | YEAR         | VARCHAR(10)  |
  313. +--------------+--------------+
  314.  
  315. DATABASE: irdgov_ird
  316. TABLE: news
  317. [4 COLUMNS]
  318. +---------+--------------+
  319. | COLUMN  | TYPE         |
  320. +---------+--------------+
  321. | datum   | VARCHAR(20)  |
  322. | id      | tinyint(3)   |
  323. | subject | VARCHAR(150) |
  324. | text    | text         |
  325. +---------+--------------+
  326.  
  327. DATABASE: irdgov_ird
  328. TABLE: COUNT
  329. [4 COLUMNS]
  330. +--------+-------------+
  331. | COLUMN | TYPE        |
  332. +--------+-------------+
  333. | COUNT  | INT(255)    |
  334. | DATE   | VARCHAR(20) |
  335. | host   | VARCHAR(40) |
  336. | ip     | VARCHAR(40) |
  337. +--------+-------------+
  338.  
  339. DATABASE: irdgov_ird
  340. TABLE: document
  341. [12 COLUMNS]
  342. +-----------------+--------------+
  343. | COLUMN          | TYPE         |
  344. +-----------------+--------------+
  345. | cat_name        | VARCHAR(30)  |
  346. | doc_format      | VARCHAR(5)   |
  347. | doc_heading     | VARCHAR(50)  |
  348. | doc_lang        | VARCHAR(11)  |
  349. | doc_subcategory | VARCHAR(30)  |
  350. | doc_title       | VARCHAR(150) |
  351. | doc_up_date     | DATE         |
  352. | doc_year        | INT(4)       |
  353. | document        | longblob     |
  354. | filename        | VARCHAR(50)  |
  355. | filesize        | INT(11)      |
  356. | filetype        | VARCHAR(50)  |
  357. +-----------------+--------------+
  358.  
  359. DATABASE: irdgov_ird
  360. TABLE: ird_newsletter_subscriber
  361. [5 COLUMNS]
  362. +-----------------+--------------+
  363. | COLUMN          | TYPE         |
  364. +-----------------+--------------+
  365. | email           | VARCHAR(255) |
  366. | name            | VARCHAR(255) |
  367. | STATUS          | tinyint(1)   |
  368. | subscribed_date | DATE         |
  369. | subscriber_id   | BIGINT(20)   |
  370. +-----------------+--------------+
  371.  
  372. DATABASE: irdgov_ird
  373. TABLE: categoryadmin
  374. [5 COLUMNS]
  375. +--------------+--------------+
  376. | COLUMN       | TYPE         |
  377. +--------------+--------------+
  378. | acat_body    | longtext     |
  379. | acat_id      | INT(2)       |
  380. | acat_link    | VARCHAR(100) |
  381. | acat_name    | VARCHAR(30)  |
  382. | acat_up_date | VARCHAR(11)  |
  383. +--------------+--------------+
  384.  
  385. DATABASE: irdgov_ird
  386. TABLE: owner
  387. [11 entries]
  388. +----------------------------------+------------------+----------+---------------------+--------------+
  389. | own_pwd                          | own_name         | home_sno | own_unit            | own_add_date |
  390. +----------------------------------+------------------+----------+---------------------+--------------+
  391. | 508c75c8507a2ae5223dfd2faeb98122 | news             | 0        | IRD                 | 16-Oct-03    |
  392. | 3b948bd152e89c741213a2b41fd85f67 | mof              | 0        | MOF                 | 21-Oct-05    |
  393. | 7a2ccce9642fe8539673002dd6660ba2 | ird              | 0        | IRD                 | 21-Oct-05    |
  394. | 2d5278b057566a696ccff8d31ae5895b | doc              | 0        | IRD                 | 05-Dec-05    |
  395. | b8e39ec0d54d1b883544640fa0beb869 | finance          | 0        | MOF                 | 21-Oct-05    |
  396. | 6f8f57715090da2632453988d9a1501b | Manish Bhattarai | 0        | IRD                 | 22-Feb-05    |
  397. | 21232f297a57a5a743894a0e4a801fc3 | ict              | 0        | IRD                 | 21-Oct-05    |
  398. | 06801a58f33e45e77dd6728fc200f46f | Mishra           | 0        | IRD                 | 21-Oct-05    |
  399. | dri_admin                        | ird_admin        | 0        | Created BY Narendra | 2007.06.26   |
  400. | ird.gov.np                       | administrator    | 0        | IRD                 | <blank>      |
  401. | 92ebe651637abc35d187bcfe7f4e8350 | spectrum         | 0        | IRD                 | Test         |
  402. +----------------------------------+------------------+----------+---------------------+--------------+
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!