aa.sql ( File view )

  • By zhao 2014-04-27
  • View(s):102
  • Download(s):8
  • Point(s): 2
			prompt PL/SQL Developer import file
prompt Created on 2009年5月31日 by HP
set feedback off
set define off
prompt Dropping FUNS...
drop table FUNS cascade constraints;
prompt Dropping IDENTABLES...
drop table IDENTABLES cascade constraints;
prompt Dropping IDENTABLESFUNS...
drop table IDENTABLESFUNS cascade constraints;
prompt Dropping LOCKTABLES...
drop table LOCKTABLES cascade constraints;
prompt Dropping MERCHANDISETYPE...
drop table MERCHANDISETYPE cascade constraints;
prompt Dropping MESSAGE...
drop table MESSAGE cascade constraints;
prompt Dropping SALEESTATE...
drop table SALEESTATE cascade constraints;
prompt Dropping USERS...
drop table USERS cascade constraints;
prompt Dropping MYSALE...
drop table MYSALE cascade constraints;
prompt Dropping SESTATE...
drop table SESTATE cascade constraints;
prompt Dropping MYSHOPPING...
drop table MYSHOPPING cascade constraints;
prompt Creating FUNS...
create table FUNS
(
  ID        VARCHAR2(30 CHAR) not null,
  NAME      VARCHAR2(30 CHAR),
  CONNURL   VARCHAR2(30 CHAR),
  ISMENU    VARCHAR2(30 CHAR),
  FATHER_ID VARCHAR2(30 CHAR)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table FUNS
  add primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating IDENTABLES...
create table IDENTABLES
(
  ID    VARCHAR2(30 CHAR) not null,
  TYPES VARCHAR2(30 CHAR)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table IDENTABLES
  add primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating IDENTABLESFUNS...
create table IDENTABLESFUNS
(
  IDENTABLES_ID VARCHAR2(30 CHAR) not null,
  FUNS_ID       VARCHAR2(30 CHAR) not null
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table IDENTABLESFUNS
  add primary key (IDENTABLES_ID, FUNS_ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table IDENTABLESFUNS
  add constraint FKF7EDD4BD1B9804F8 foreign key (IDENTABLES_ID)
  references IDENTABLES (ID);
alter table IDENTABLESFUNS
  add constraint FKF7EDD4BDE9946798 foreign key (FUNS_ID)
  references FUNS (ID);

prompt Creating LOCKTABLES...
create table LOCKTABLES
(
  ID   VARCHAR2(30 CHAR) not null,
  TYPE VARCHAR2(30 CHAR)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table LOCKTABLES
  add primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating MERCHANDISETYPE...
create table MERCHANDISETYPE
(
  ID   VARCHAR2(255 CHAR) not null,
  TYPE VARCHAR2(255 CHAR)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table MERCHANDISETYPE
  add primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating MESSAGE...
create table MESSAGE
(
  MSGID    VARCHAR2(30 CHAR) not null,
  MYSALEID VARCHAR2(30 CHAR),
  AUTHOR   VARCHAR2(30 CHAR),
  CONTENT  VARCHAR2(4000 CHAR),
  TIME     VARCHAR2(30 CHAR),
  STATUS   VARCHAR2(30 CHAR)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table MESSAGE
  add primary key (MSGID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table MESSAGE
  add constraint FK63B68BE723B5FD45 foreign key (MSGID)
  references MESSAGE (MSGID);

prompt Creating SALEESTATE...
create table SALEESTATE
(
  ID   VARCHAR2(128 CHAR) not null,
  TYPE VARCHAR2(30 CHAR)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table SALEESTATE
  add primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating USERS...
create table USERS
(
  ID        VARCHAR2(128 CHAR) not null,
  LOADUSER  VARCHAR2(30 CHAR),
  PASSWORD  VARCHAR2(30 CHAR),
  NAME      VARCHAR2(30 CHAR),
  SEX       VARCHAR2(30 CHAR),
  IDCARDS   VARCHAR2(30 CHAR),
  EMAIL     VARCHAR2(30 CHAR),
  LOCKS     VARCHAR2(30 CHAR),
  SPECIALTY VARCHAR2(30 CHAR),
  CLASS     VARCHAR2(30 CHAR),
  IDENTITYS VARCHAR2(30 CHAR)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table USERS
  add primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table USERS
  add constraint FK4D495E8C4AE9BC foreign key (IDENTITYS)
  references IDENTABLES (ID);

prompt Creating MYSALE...
create table MYSALE
(
  ID              VARCHAR2(128 CHAR) not null,
  MERCHANDISENAME VARCHAR2(30 CHAR),
  CONTENT         VARCHAR2(30 CHAR),
  HUE             VARCHAR2(30 CHAR),
  PRICE           VARCHAR2(30 CHAR),
  TEMP            VARCHAR2(128 CHAR),
  USERS           VARCHAR2(128 CHAR),
  SALEESTATE      VARCHAR2(128 CHAR),
  MYSALEID        VARCHAR2(255 CHAR)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table MYSALE
  add primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table MYSALE
  add constraint FK8A4404136A8954CD foreign key (MYSALEID)
  references MERCHANDISETYPE (ID);
alter table MYSALE
  add constraint FK8A440413D0BCD8A4 foreign key (SALEESTATE)
  references SALEESTATE (ID);
alter table MYSALE
  add constraint FK8A440413FD4A1172 foreign key (USERS)
  references USERS (ID);

prompt Creating SESTATE...
create table SESTATE
(
  ID   VARCHAR2(128 CHAR) not null,
  TYPE VARCHAR2(30 CHAR)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table SESTATE
  add primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating MYSHOPPING...
create table MYSHOPPING
(
  ID              VARCHAR2(128 CHAR) not null,
  MERCHANDISENAME VARCHAR2(30 CHAR),
  CONTENT         VARCHAR2(30 CHAR),
  NARRATE         VARCHAR2(30 CHAR),
  USERS           VARCHAR2(128 CHAR),
  SESTATE         VARCHAR2(128 CHAR),
  MYSHOPPINGID    VARCHAR2(255 CHAR)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table MYSHOPPING
  add primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table MYSHOPPING
  add constraint FK7DC1D354D136D7E0 foreign key (SESTATE)
  references SESTATE (ID);
alter table MYSHOPPING
  add constraint FK7DC1D354F90D8BAE foreign key (MYSHOPPINGID)
  references MERCHANDISETYPE (ID);
alter table MYSHOPPING
  add constraint FK7DC1D354FD4A1172 foreign key (USERS)
  references USERS (ID);

prompt Disabling triggers for FUNS...
alter table FUNS disable all triggers;
prompt Disabling triggers for IDENTABLES...
alter table IDENTABLES disable all triggers;
prompt Disabling triggers for IDENTABLESFUNS...
alter table IDENTABLESFUNS disable all triggers;
prompt Disabling triggers for LOCKTABLES...
alter table LOCKTABLES disable all triggers;
prompt Disabling triggers for MERCHANDISETYPE...
alter table MERCHANDISETYPE disable all triggers;
prompt Disabling triggers for MESSAGE...
alter table MESSAGE disable all triggers;
prompt Disabling triggers for SALEESTATE...
alter table SALEESTATE disable all triggers;
prompt Disabling triggers for USERS...
alter table USERS disable all triggers;
prompt Disabling triggers for MYSALE...
alter table MYSALE disable all triggers;
prompt Disabling triggers for SESTATE...
alter table SESTATE disable all triggers;
prompt Disabling triggers for MYSHOPPING...
alter table MYSHOPPING disable all triggers;
prompt Disabling foreign key constraints for IDENTABLESFUNS...
alter table IDENTABLESFUNS disable constraint FKF7EDD4BD1B9804F8;
alter table IDENTABLESFUNS disable constraint FKF7EDD4BDE9946798;
prompt Disabling foreign key constraints for MESSAGE...
alter table MESSAGE disable constraint FK63B68BE723B5FD45;
prompt Disabling foreign key constraints for USERS...
alter table USERS disable constraint FK4D495E8C4AE9BC;
prompt Disabling foreign key constraints for MYSALE...
alter table MYSALE disable constraint FK8A4404136A8954CD;
alter table MYSALE disable constraint FK8A440413D0BCD8A4;
alter table MYSALE disable constraint FK8A440413FD4A1172;
prompt Disabling foreign key constraints for MYSHOPPING...
alter table MYSHOPPING disable constraint FK7DC1D354D136D7E0;
alter table MYSHOPPING disable constraint FK7DC1D354F90D8BAE;
alter 
...
...
(Not finished, please download and read the complete file)
			
...
Expand> <Close

Want complete source code? Download it here

Point(s): 2

Download
0 lines left, continue to read

File list

Tips: You can preview the content of files by clicking file names^_^
Name Size Date
aa.sql18.71 kB31-05-09|10:17
Web校园二手交易系统6.doc1.08 MB06-06-09|16:12
zwbysjs.rar4.40 MB31-05-09|10:21
使用说明.txt31.00 B28-04-14|01:36
校园二手系统设计0.00 B23-04-14|15:16
...

aa.sql (5.06 MB)

Need 2 point
Your Point(s)

Your Point isn't enough.

Get point immediately by PayPal

More(Debit card / Credit card / PayPal Credit / Online Banking)

Submit your source codes. Get more point

LOGIN

Don't have an account? Register now
Need any help?
Mail to: support@codeforge.com

切换到中文版?

CodeForge Chinese Version
CodeForge English Version

Where are you going?

^_^"Oops ...

Sorry!This guy is mysterious, its blog hasn't been opened, try another, please!
OK

Warm tip!

CodeForge to FavoriteFavorite by Ctrl+D