| |
1 |
|
ALTER TABLE cr_news ADD COLUMN lead varchar(4000); |
| |
|
1 |
ALTER TABLE cr_news MODIFY lead varchar(4000); |
| |
2 |
2 |
|
| |
3 |
3 |
declare |
| |
4 |
4 |
attr_id acs_attributes.attribute_id%TYPE; |
| |
5 |
5 |
begin |
| |
6 |
6 |
|
| |
7 |
7 |
attr_id := content_type.create_attribute ( |
| |
8 |
8 |
content_type => 'news', |
| |
9 |
9 |
attribute_name => 'lead', |
| |
10 |
10 |
datatype => 'text', |
| |
11 |
11 |
pretty_name => 'Lead', |
| |
12 |
12 |
pretty_plural => 'Leads', |
| |
13 |
13 |
column_spec => 'varchar(1000)' |
| |
14 |
14 |
); |
| |
15 |
15 |
end; |
| |
16 |
16 |
/ |
| |
17 |
17 |
show errors |
| |
18 |
18 |
|
| |
19 |
19 |
create or replace package news |
| |
20 |
20 |
as |
| |
21 |
21 |
function new ( |
