API tools faq
paste
Advertisement
Guest User

CAPROJ

a guest
Oct 2nd, 2017
464
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.59 KB | None | 0 0
raw download clone embed print report
  1. USE [CAPROJ]
  2. GO
  3. /****** Object: Table [dbo].[md_administration] Script Date: 9/30/2017 10:17:55 AM ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8. SET ANSI_PADDING ON
  9. GO
  10. CREATE TABLE [dbo].[md_administration](
  11. [Admin_ID] [int] IDENTITY(1,1) NOT NULL,
  12. [first_name] [varchar](50) NOT NULL,
  13. [last_name] [varchar](50) NOT NULL,
  14. [department] [varchar](10) NOT NULL,
  15. [username] [varchar](10) NOT NULL,
  16. [password] [varchar](100) NOT NULL,
  17. [ch_group_access] [char](3) NULL,
  18. CONSTRAINT [PK_md_administration] PRIMARY KEY CLUSTERED
  19. (
  20. [Admin_ID] ASC
  21. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  22. ) ON [PRIMARY]
  23.  
  24. GO
  25. SET ANSI_PADDING OFF
  26. GO
  27. /****** Object: Table [dbo].[md_customer] Script Date: 9/30/2017 10:17:55 AM ******/
  28. SET ANSI_NULLS ON
  29. GO
  30. SET QUOTED_IDENTIFIER ON
  31. GO
  32. SET ANSI_PADDING ON
  33. GO
  34. CREATE TABLE [dbo].[md_customer](
  35. [Customer_ID] [int] IDENTITY(1,1) NOT NULL,
  36. [customer_name] [varchar](50) NOT NULL,
  37. [type] [varchar](50) NOT NULL,
  38. [address] [varchar](50) NOT NULL,
  39. [city] [varchar](50) NOT NULL,
  40. [province] [varchar](50) NOT NULL,
  41. [zipcode] [int] NOT NULL,
  42. [email] [varchar](254) NOT NULL,
  43. [contact_person] [varchar](50) NOT NULL,
  44. [telephone_no] [int] NOT NULL,
  45. [mobile_no] [varchar](13) NOT NULL,
  46. CONSTRAINT [PK_md_customer] PRIMARY KEY CLUSTERED
  47. (
  48. [Customer_ID] ASC
  49. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  50. ) ON [PRIMARY]
  51.  
  52. GO
  53. SET ANSI_PADDING OFF
  54. GO
  55. /****** Object: Table [dbo].[md_customer_payment] Script Date: 9/30/2017 10:17:55 AM ******/
  56. SET ANSI_NULLS ON
  57. GO
  58. SET QUOTED_IDENTIFIER ON
  59. GO
  60. SET ANSI_PADDING ON
  61. GO
  62. CREATE TABLE [dbo].[md_customer_payment](
  63. [Customer_ID] [int] IDENTITY(1,1) NOT NULL,
  64. [payment_option] [varchar](50) NOT NULL,
  65. [payment_terms] [varchar](50) NOT NULL,
  66. [discount] [float] NULL,
  67. CONSTRAINT [PK_md_customer_payment] PRIMARY KEY CLUSTERED
  68. (
  69. [Customer_ID] ASC
  70. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  71. ) ON [PRIMARY]
  72.  
  73. GO
  74. SET ANSI_PADDING OFF
  75. GO
  76. /****** Object: Table [dbo].[md_finished_goods] Script Date: 9/30/2017 10:17:55 AM ******/
  77. SET ANSI_NULLS ON
  78. GO
  79. SET QUOTED_IDENTIFIER ON
  80. GO
  81. SET ANSI_PADDING ON
  82. GO
  83. CREATE TABLE [dbo].[md_finished_goods](
  84. [Goods_ID] [int] IDENTITY(1,1) NOT NULL,
  85. [goods_name] [varchar](50) NOT NULL,
  86. [onhand_quantity] [int] NOT NULL,
  87. [max_quantity] [int] NOT NULL,
  88. [reorder_level] [int] NOT NULL,
  89. CONSTRAINT [PK_md_finished_goods] PRIMARY KEY CLUSTERED
  90. (
  91. [Goods_ID] ASC
  92. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  93. ) ON [PRIMARY]
  94.  
  95. GO
  96. SET ANSI_PADDING OFF
  97. GO
  98. /****** Object: Table [dbo].[md_menu_group] Script Date: 9/30/2017 10:17:55 AM ******/
  99. SET ANSI_NULLS ON
  100. GO
  101. SET QUOTED_IDENTIFIER ON
  102. GO
  103. SET ANSI_PADDING ON
  104. GO
  105. CREATE TABLE [dbo].[md_menu_group](
  106. [ch_group_access] [char](3) NOT NULL,
  107. [vc_group_name] [varchar](100) NOT NULL,
  108. [vc_default_page] [varchar](100) NOT NULL
  109. ) ON [PRIMARY]
  110.  
  111. GO
  112. SET ANSI_PADDING OFF
  113. GO
  114. /****** Object: Table [dbo].[md_menus] Script Date: 9/30/2017 10:17:55 AM ******/
  115. SET ANSI_NULLS ON
  116. GO
  117. SET QUOTED_IDENTIFIER ON
  118. GO
  119. SET ANSI_PADDING ON
  120. GO
  121. CREATE TABLE [dbo].[md_menus](
  122. [int_menu_index] [int] NOT NULL,
  123. [ch_menu_id] [char](3) NOT NULL,
  124. [ch_menu_name] [char](50) NULL,
  125. [ch_menu_link] [nvarchar](500) NULL,
  126. [ch_menu_icon] [char](50) NULL,
  127. [ch_group_access] [char](3) NOT NULL,
  128. [bt_isactive] [bit] NOT NULL,
  129. [bt_hasSubMenu] [bit] NOT NULL,
  130. [bt_isVisible] [bit] NULL
  131. ) ON [PRIMARY]
  132.  
  133. GO
  134. SET ANSI_PADDING OFF
  135. GO
  136. /****** Object: Table [dbo].[md_raw_materials] Script Date: 9/30/2017 10:17:55 AM ******/
  137. SET ANSI_NULLS ON
  138. GO
  139. SET QUOTED_IDENTIFIER ON
  140. GO
  141. SET ANSI_PADDING ON
  142. GO
  143. CREATE TABLE [dbo].[md_raw_materials](
  144. [Material_ID] [int] IDENTITY(1,1) NOT NULL,
  145. [material_name] [varchar](50) NOT NULL,
  146. [onhand_quantity] [int] NOT NULL,
  147. [max_quantity] [int] NOT NULL,
  148. [reorder_level] [int] NOT NULL,
  149. CONSTRAINT [PK_md_raw_materials] PRIMARY KEY CLUSTERED
  150. (
  151. [Material_ID] ASC
  152. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  153. ) ON [PRIMARY]
  154.  
  155. GO
  156. SET ANSI_PADDING OFF
  157. GO
  158. /****** Object: Table [dbo].[md_sub_menus] Script Date: 9/30/2017 10:17:55 AM ******/
  159. SET ANSI_NULLS ON
  160. GO
  161. SET QUOTED_IDENTIFIER ON
  162. GO
  163. SET ANSI_PADDING ON
  164. GO
  165. CREATE TABLE [dbo].[md_sub_menus](
  166. [ch_menu_id] [char](3) NULL,
  167. [int_submenu_index] [int] NOT NULL,
  168. [ch_submenu_name] [char](50) NULL,
  169. [ch_submenu_link] [nvarchar](500) NULL,
  170. [ch_submenu_icon] [char](50) NULL,
  171. [ch_group_access] [char](3) NOT NULL,
  172. [bt_isactive] [bit] NULL,
  173. [bt_isVisible] [bit] NULL
  174. ) ON [PRIMARY]
  175.  
  176. GO
  177. SET ANSI_PADDING OFF
  178. GO
  179. /****** Object: Table [dbo].[md_supplier] Script Date: 9/30/2017 10:17:55 AM ******/
  180. SET ANSI_NULLS ON
  181. GO
  182. SET QUOTED_IDENTIFIER ON
  183. GO
  184. SET ANSI_PADDING ON
  185. GO
  186. CREATE TABLE [dbo].[md_supplier](
  187. [Supplier_ID] [int] IDENTITY(1,1) NOT NULL,
  188. [supplier_name] [varchar](50) NOT NULL,
  189. [category] [varchar](50) NOT NULL,
  190. [business_partner_type] [varchar](50) NOT NULL,
  191. [address] [varchar](50) NOT NULL,
  192. [city] [varchar](50) NOT NULL,
  193. [province] [varchar](50) NOT NULL,
  194. [zipcode] [int] NOT NULL,
  195. [email] [varchar](254) NOT NULL,
  196. [contact_person] [varchar](50) NOT NULL,
  197. [telephone_no] [int] NOT NULL,
  198. [mobile_no] [varchar](13) NOT NULL,
  199. CONSTRAINT [PK_md_supplier] PRIMARY KEY CLUSTERED
  200. (
  201. [Supplier_ID] ASC
  202. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  203. ) ON [PRIMARY]
  204.  
  205. GO
  206. SET ANSI_PADDING OFF
  207. GO
  208. /****** Object: Table [dbo].[md_supplier_payment] Script Date: 9/30/2017 10:17:55 AM ******/
  209. SET ANSI_NULLS ON
  210. GO
  211. SET QUOTED_IDENTIFIER ON
  212. GO
  213. SET ANSI_PADDING ON
  214. GO
  215. CREATE TABLE [dbo].[md_supplier_payment](
  216. [Supplier_ID] [int] IDENTITY(1,1) NOT NULL,
  217. [payment_option] [varchar](50) NOT NULL,
  218. [payment_terms] [varchar](50) NOT NULL,
  219. [discount] [float] NULL,
  220. CONSTRAINT [PK_md_supplier_payment] PRIMARY KEY CLUSTERED
  221. (
  222. [Supplier_ID] ASC
  223. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  224. ) ON [PRIMARY]
  225.  
  226. GO
  227. SET ANSI_PADDING OFF
  228. GO
  229. /****** Object: Table [dbo].[md_supplier_products] Script Date: 9/30/2017 10:17:55 AM ******/
  230. SET ANSI_NULLS ON
  231. GO
  232. SET QUOTED_IDENTIFIER ON
  233. GO
  234. SET ANSI_PADDING ON
  235. GO
  236. CREATE TABLE [dbo].[md_supplier_products](
  237. [Supplier_ID] [int] NOT NULL,
  238. [product_name] [varchar](50) NOT NULL,
  239. [price] [money] NOT NULL,
  240. [lead_time] [varchar](50) NOT NULL
  241. ) ON [PRIMARY]
  242.  
  243. GO
  244. SET ANSI_PADDING OFF
  245. GO
  246. /****** Object: View [dbo].[md_customer_master_data] Script Date: 9/30/2017 10:17:55 AM ******/
  247. SET ANSI_NULLS ON
  248. GO
  249. SET QUOTED_IDENTIFIER ON
  250. GO
  251.  
  252. CREATE VIEW [dbo].[md_customer_master_data]
  253. AS
  254. select a.customer_name,[address]=a.address + ' ' + a.city + ', ' + a.province,contact_no=a.mobile_no,b.discount,revenue='',past_orders=''
  255. from md_customer a
  256. inner join md_customer_payment b on a.customer_ID = b.customer_ID
  257.  
  258.  
  259. GO
  260. /****** Object: View [dbo].[md_supplier_master_data] Script Date: 9/30/2017 10:17:55 AM ******/
  261. SET ANSI_NULLS ON
  262. GO
  263. SET QUOTED_IDENTIFIER ON
  264. GO
  265. CREATE VIEW [dbo].[md_supplier_master_data]
  266. AS
  267. select a.supplier_name,[address]=a.address + ' ' + a.city + ', ' + a.province,contact_no=a.mobile_no,b.discount,c.lead_time,c.price,past_orders=''
  268. from md_supplier a
  269. inner join md_supplier_payment b on a.Supplier_ID = b.Supplier_ID
  270. inner join md_supplier_products c on a.Supplier_ID = c.Supplier_ID
  271.  
  272. GO
  273. SET IDENTITY_INSERT [dbo].[md_administration] ON
  274.  
  275. INSERT [dbo].[md_administration] ([Admin_ID], [first_name], [last_name], [department], [username], [password], [ch_group_access]) VALUES (1, N'purchasing', N'admin', N'ICT', N'purchasing', N'Nr7HhBeAElPsb13kFlEWlQ==', N'001')
  276. INSERT [dbo].[md_administration] ([Admin_ID], [first_name], [last_name], [department], [username], [password], [ch_group_access]) VALUES (2, N'Sales', N'Engineer', N'sales', N'sales', N'JRGKWvN1g8Gd0X3r98+s+A==', N'002')
  277. SET IDENTITY_INSERT [dbo].[md_administration] OFF
  278. SET IDENTITY_INSERT [dbo].[md_customer] ON
  279.  
  280. INSERT [dbo].[md_customer] ([Customer_ID], [customer_name], [type], [address], [city], [province], [zipcode], [email], [contact_person], [telephone_no], [mobile_no]) VALUES (2, N'Joel Cruz hardware', N'Retailer', N'Unit 404', N'Paranaque City', N'NCR', 5608, N'haroldrizaldo@gmail.com', N'Maine Mendoza', 12124, N'+639199546331')
  281. INSERT [dbo].[md_customer] ([Customer_ID], [customer_name], [type], [address], [city], [province], [zipcode], [email], [contact_person], [telephone_no], [mobile_no]) VALUES (3, N'Harold Rizaldo', N'Reseller', N'138', N'Quezon City', N'NCR', 4220, N'haroldrizaldo@gmail.com', N'alejohn ramirez', 123412, N'+639199546331')
  282. SET IDENTITY_INSERT [dbo].[md_customer] OFF
  283. SET IDENTITY_INSERT [dbo].[md_customer_payment] ON
  284.  
  285. INSERT [dbo].[md_customer_payment] ([Customer_ID], [payment_option], [payment_terms], [discount]) VALUES (2, N'Cash', N'30 days', 30)
  286. INSERT [dbo].[md_customer_payment] ([Customer_ID], [payment_option], [payment_terms], [discount]) VALUES (3, N'Check', N'15 Days', 20)
  287. SET IDENTITY_INSERT [dbo].[md_customer_payment] OFF
  288. SET IDENTITY_INSERT [dbo].[md_finished_goods] ON
  289.  
  290. INSERT [dbo].[md_finished_goods] ([Goods_ID], [goods_name], [onhand_quantity], [max_quantity], [reorder_level]) VALUES (1, N'Windows', 50, 100, 250)
  291. SET IDENTITY_INSERT [dbo].[md_finished_goods] OFF
  292. INSERT [dbo].[md_menu_group] ([ch_group_access], [vc_group_name], [vc_default_page]) VALUES (N'001', N'Purchasing Admin', N'Supplier.aspx')
  293. INSERT [dbo].[md_menu_group] ([ch_group_access], [vc_group_name], [vc_default_page]) VALUES (N'002', N'Sales Engineer Admin', N'Customer.aspx')
  294. INSERT [dbo].[md_menus] ([int_menu_index], [ch_menu_id], [ch_menu_name], [ch_menu_link], [ch_menu_icon], [ch_group_access], [bt_isactive], [bt_hasSubMenu], [bt_isVisible]) VALUES (4, N'004', N'Customer ', N'#', N'fa fa-user ', N'002', 1, 1, 1)
  295. INSERT [dbo].[md_menus] ([int_menu_index], [ch_menu_id], [ch_menu_name], [ch_menu_link], [ch_menu_icon], [ch_group_access], [bt_isactive], [bt_hasSubMenu], [bt_isVisible]) VALUES (5, N'005', N'Sales ', N'#', N'fa fa-shopping-cart ', N'002', 0, 1, 1)
  296. INSERT [dbo].[md_menus] ([int_menu_index], [ch_menu_id], [ch_menu_name], [ch_menu_link], [ch_menu_icon], [ch_group_access], [bt_isactive], [bt_hasSubMenu], [bt_isVisible]) VALUES (1, N'001', N'Supplier ', N'#', N'fa fa-user ', N'001', 1, 1, 1)
  297. INSERT [dbo].[md_menus] ([int_menu_index], [ch_menu_id], [ch_menu_name], [ch_menu_link], [ch_menu_icon], [ch_group_access], [bt_isactive], [bt_hasSubMenu], [bt_isVisible]) VALUES (2, N'002', N'Purchasing ', N'#', N'fa fa-shopping-cart ', N'001', 0, 1, 1)
  298. INSERT [dbo].[md_menus] ([int_menu_index], [ch_menu_id], [ch_menu_name], [ch_menu_link], [ch_menu_icon], [ch_group_access], [bt_isactive], [bt_hasSubMenu], [bt_isVisible]) VALUES (3, N'003', N'Inventory ', N'#', N'fa fa-archive ', N'001', 0, 1, 1)
  299. SET IDENTITY_INSERT [dbo].[md_raw_materials] ON
  300.  
  301. INSERT [dbo].[md_raw_materials] ([Material_ID], [material_name], [onhand_quantity], [max_quantity], [reorder_level]) VALUES (1, N'Glass', 50, 100, 250)
  302. INSERT [dbo].[md_raw_materials] ([Material_ID], [material_name], [onhand_quantity], [max_quantity], [reorder_level]) VALUES (2, N'Tiles', 30, 40, 340)
  303. SET IDENTITY_INSERT [dbo].[md_raw_materials] OFF
  304. INSERT [dbo].[md_sub_menus] ([ch_menu_id], [int_submenu_index], [ch_submenu_name], [ch_submenu_link], [ch_submenu_icon], [ch_group_access], [bt_isactive], [bt_isVisible]) VALUES (N'002', 3, N'Goods Return ', N'GoodsReturn.aspx', N'fa fa-list ', N'001', 1, 1)
  305. INSERT [dbo].[md_sub_menus] ([ch_menu_id], [int_submenu_index], [ch_submenu_name], [ch_submenu_link], [ch_submenu_icon], [ch_group_access], [bt_isactive], [bt_isVisible]) VALUES (N'003', 1, N'Raw Materials ', N'Materials.aspx', N'fa fa-list ', N'001', 1, 1)
  306. INSERT [dbo].[md_sub_menus] ([ch_menu_id], [int_submenu_index], [ch_submenu_name], [ch_submenu_link], [ch_submenu_icon], [ch_group_access], [bt_isactive], [bt_isVisible]) VALUES (N'003', 2, N'Finished Goods ', N'Goods.aspx', N'fa fa-list ', N'001', 1, 1)
  307. INSERT [dbo].[md_sub_menus] ([ch_menu_id], [int_submenu_index], [ch_submenu_name], [ch_submenu_link], [ch_submenu_icon], [ch_group_access], [bt_isactive], [bt_isVisible]) VALUES (N'005', 1, N'Sales Order ', N'SalesOrder.aspx', N'fa fa-list ', N'002', 1, 1)
  308. INSERT [dbo].[md_sub_menus] ([ch_menu_id], [int_submenu_index], [ch_submenu_name], [ch_submenu_link], [ch_submenu_icon], [ch_group_access], [bt_isactive], [bt_isVisible]) VALUES (N'005', 2, N'Delivery Receipt ', N'DeliveryReceipt.aspx', N'fa fa-list ', N'002', 1, 1)
  309. INSERT [dbo].[md_sub_menus] ([ch_menu_id], [int_submenu_index], [ch_submenu_name], [ch_submenu_link], [ch_submenu_icon], [ch_group_access], [bt_isactive], [bt_isVisible]) VALUES (N'005', 3, N'Customer Return ', N'CustomerReturn.aspx', N'fa fa-list ', N'002', 1, 1)
  310. INSERT [dbo].[md_sub_menus] ([ch_menu_id], [int_submenu_index], [ch_submenu_name], [ch_submenu_link], [ch_submenu_icon], [ch_group_access], [bt_isactive], [bt_isVisible]) VALUES (N'001', 1, N'Supplier Master Data ', N'Supplier.aspx', N'fa fa-list ', N'001', 1, 1)
  311. INSERT [dbo].[md_sub_menus] ([ch_menu_id], [int_submenu_index], [ch_submenu_name], [ch_submenu_link], [ch_submenu_icon], [ch_group_access], [bt_isactive], [bt_isVisible]) VALUES (N'001', 2, N'Supplier Master Data List ', N'SupplierList.aspx', N'fa fa-list ', N'001', 1, 1)
  312. INSERT [dbo].[md_sub_menus] ([ch_menu_id], [int_submenu_index], [ch_submenu_name], [ch_submenu_link], [ch_submenu_icon], [ch_group_access], [bt_isactive], [bt_isVisible]) VALUES (N'002', 1, N'Purchase order ', N'PurchaseOrder.aspx', N'fa fa-list ', N'001', 1, 1)
  313. INSERT [dbo].[md_sub_menus] ([ch_menu_id], [int_submenu_index], [ch_submenu_name], [ch_submenu_link], [ch_submenu_icon], [ch_group_access], [bt_isactive], [bt_isVisible]) VALUES (N'002', 2, N'Goods Receipt ', N'GoodsReceipt.aspx', N'fa fa-list ', N'001', 1, 1)
  314. INSERT [dbo].[md_sub_menus] ([ch_menu_id], [int_submenu_index], [ch_submenu_name], [ch_submenu_link], [ch_submenu_icon], [ch_group_access], [bt_isactive], [bt_isVisible]) VALUES (N'004', 1, N'Customer Master Data ', N'Customer.aspx', N'fa fa-list ', N'002', 1, 1)
  315. INSERT [dbo].[md_sub_menus] ([ch_menu_id], [int_submenu_index], [ch_submenu_name], [ch_submenu_link], [ch_submenu_icon], [ch_group_access], [bt_isactive], [bt_isVisible]) VALUES (N'004', 2, N'Customer Master Data List ', N'CustomerList.aspx', N'fa fa-list ', N'002', 1, 1)
  316. SET IDENTITY_INSERT [dbo].[md_supplier] ON
  317.  
  318. INSERT [dbo].[md_supplier] ([Supplier_ID], [supplier_name], [category], [business_partner_type], [address], [city], [province], [zipcode], [email], [contact_person], [telephone_no], [mobile_no]) VALUES (2, N'Glass Chain Supply', N'Glass', N'Retailer', N'420', N'Talisay', N'Batangas', 4220, N'haroldrizaldo@gmail.com', N'Harold Rizaldo', 12312, N'+639199546331')
  319. INSERT [dbo].[md_supplier] ([Supplier_ID], [supplier_name], [category], [business_partner_type], [address], [city], [province], [zipcode], [email], [contact_person], [telephone_no], [mobile_no]) VALUES (3, N'Supplier 1', N'Supplier', N'Customer', N'qc', N'qc', N'qc', 4220, N'haroldrizaldo@gmail.com', N'alejohn ramirez', 12312, N'+639199546331')
  320. SET IDENTITY_INSERT [dbo].[md_supplier] OFF
  321. SET IDENTITY_INSERT [dbo].[md_supplier_payment] ON
  322.  
  323. INSERT [dbo].[md_supplier_payment] ([Supplier_ID], [payment_option], [payment_terms], [discount]) VALUES (2, N'Cash', N'30 days', 30)
  324. INSERT [dbo].[md_supplier_payment] ([Supplier_ID], [payment_option], [payment_terms], [discount]) VALUES (3, N'Check', N'30 days', 30)
  325. SET IDENTITY_INSERT [dbo].[md_supplier_payment] OFF
  326. INSERT [dbo].[md_supplier_products] ([Supplier_ID], [product_name], [price], [lead_time]) VALUES (2, N'Product 1', 1000.0000, N'2 weeks')
  327. INSERT [dbo].[md_supplier_products] ([Supplier_ID], [product_name], [price], [lead_time]) VALUES (2, N'Product 2', 2400.0000, N'4 weeks')
  328. INSERT [dbo].[md_supplier_products] ([Supplier_ID], [product_name], [price], [lead_time]) VALUES (3, N'Programming', 5000.0000, N'1 month')
  329. INSERT [dbo].[md_supplier_products] ([Supplier_ID], [product_name], [price], [lead_time]) VALUES (3, N'Services', 6000.0000, N'3 weeks')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!