source:
trunk/html/install/sql/add/dtb_module_pgsql.sql
@
18562
| Revision 18562, 313 bytes checked in by kajiwara, 17 years ago (diff) | |
|---|---|
|
|
| Line | |
|---|---|
| 1 | CREATE TABLE dtb_module ( |
| 2 | module_id int NOT NULL UNIQUE, |
| 3 | module_code text NOT NULL, |
| 4 | module_name text NOT NULL, |
| 5 | sub_data text, |
| 6 | auto_update_flg int2 NOT NULL DEFAULT 0, |
| 7 | del_flg int2 NOT NULL DEFAULT 0, |
| 8 | create_date timestamp NOT NULL DEFAULT NOW(), |
| 9 | update_date timestamp NOT NULL |
| 10 | ); |
| 11 |
Note: See TracBrowser
for help on using the repository browser.
