Sharing Aplikasi CI+YUI sistem inventaris barang
Selasa, 24 Januari 2012 by ewepaksa
top custom html 3Hallo Teman-teman semuanya... Kali ini saya ingin distribution aplikasi codeigniter(CI) sistem inventaris barang yang dikolaborasikan dengan YUI (Yahoo UI). Silahkan klik disini: http://kenalanwar[dot]co[dot]cc/source-code/elektro-pnj.zip Ganti [dot] dengan titik (.) Enjoy... Salam, Nur Cholikul Anwar www.jaringankantor.com FOR DATABASE (POSTGRESQL): Code: CREATE DATABASE db_inventaris_elektro CREATE TABLE t_list_barang ( f_id program NOT NULL, f_kode case varying(50) NOT NULL, f_nama_barang case varying(100) NOT NULL, f_tipe_barang case varying(100), f_jumlah case varying(15) NOT NULL, ref_master_lokasi_f_id number NOT NULL, f_jumlah_kondisi_baik case varying(15) NOT NULL, f_tanggal_masuk fellow NOT NULL, f_status_hapus boolean NOT NULL DEFAULT false, CONSTRAINT t_list_barang_pkey PRIMARY KEY (f_id), CONSTRAINT t_list_barang_ref_master_lokasi_f_id_fkey FOREIGN KEY (ref_master_lokasi_f_id) REFERENCES t_master_lokasi (f_id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT ) CREATE TABLE t_master_lokasi ( f_id program NOT NULL, f_kode_lokasi case varying(15) NOT NULL, f_nama_lokasi case varying(50) NOT NULL, CONSTRAINT t_master_lokasi_pkey PRIMARY KEY (f_id), CONSTRAINT t_master_lokasi_f_kode_lokasi_key UNIQUE (f_kode_lokasi), CONSTRAINT t_master_lokasi_f_nama_lokasi_key UNIQUE (f_nama_lokasi) ) CREATE TABLE t_session ( session_id case varying(40) NOT NULL DEFAULT 0, ip_address case varying(16) NOT NULL DEFAULT 0, user_agent case varying(120) NOT NULL, last_activity number NOT NULL DEFAULT 0, user_data book NOT NULL DEFAULT ''::text, CONSTRAINT ci_sessions_pkey PRIMARY KEY (session_id) ) CREATE TABLE t_user ( f_id program NOT NULL, f_username case varying(20) NOT NULL, f_password case varying(50) NOT NULL, f_nama case varying(50), CONSTRAINT t_user_pkey PRIMARY KEY (f_id), CONSTRAINT t_user_f_username_key UNIQUE (f_username) ) bottom custom html 1
Yahoo
Yahoo
Posting Komentar