代码搜索:pointbase
找到约 89 项符合「pointbase」的源代码
代码结果 89
www.eeworm.com/read/216514/15005051
sql createdb_pointbase.sql
drop table catagory;
create table category(
categoryid number(16) primary key,
name varchar2(16) not null,
description varchar2(100)
);
insert into category values
www.eeworm.com/read/245478/4503111
sql pointbase.createstoragebin.sql
drop table storagebin;
drop table widget;
create table widget
(widgetid varchar(3) constraint pk_widget primary key,
description varchar(50),
price decimal (10,2));
insert into widget
values ('876',
www.eeworm.com/read/245478/4503112
sql pointbase.dropstoragebin.sql
drop table storagebin;
drop table widget;
www.eeworm.com/read/245478/4503135
sql pointbase.createsimplebank.sql
drop table customer1;
create table customer1 (
SSN varchar2(9),
lastNAme varchar2(20),
firstname varchar2(20),
address1 varchar2 (20),
address2 varchar2(20),
city varchar2(10),
st
www.eeworm.com/read/245478/4503148
sql pointbase.drop.sql
ALTER TABLE ADDRESSBEAN DROP CONSTRAINT FK_THISRELATIONSHIPFIELDWASGENERATEDBYTHENAMEMAPPER1
;
ALTER TABLE CUSTOMERBEANSUBSCRIPTIONBEAN DROP CONSTRAINT FK_SUBSCRIPTIONS
;
ALTER TABLE CUSTOMERBEANSUBSC
www.eeworm.com/read/245478/4503149
sql pointbase.create.sql
CREATE TABLE ADDRESSBEAN (
ADDRESSID VARCHAR(256) NOT NULL,
STREET VARCHAR(256) NULL,
STATE VARCHAR(256) NULL,
ZIP VARCHAR(256) NULL,
CITY VARCHAR(256) NULL,
CUSTOMERBEAN_CUSTOMERID VARCHAR(256) NULL,
www.eeworm.com/read/245478/4503235
sql pointbase.warehouse.sql
-- ========================================================
--copyright
www.eeworm.com/read/245478/4503431
sql pointbase.createuser.sql
DROP USER BOOKSTORE;
CREATE USER BOOKSTORE PASSWORD BOOKSTORE;
CREATE SCHEMA BOOKSTORE AUTHORIZATION BOOKSTORE;
www.eeworm.com/read/245478/4503432
sql pointbase.bookstore.sql
DROP TABLE books;
CREATE TABLE books
(id VARCHAR(8)
CONSTRAINT pk_books PRIMARY KEY,
surname VARCHAR(24),
first_name VARCHAR(24),
title VARCHAR(96),
price FLOAT,
yr INT,
description VARCHAR(30),
inv